[thelist] sql query php layout

[Andrew Maynes]

Thanks Rudy, the cream is working a little bit :)

So far I am not making too muck progress on this :( the query I have is this:

// Send the Query to the Server, to get the list of books
if (!($result = mysql_db_query($DB,"SELECT * FROM book_shop")))
{
   DisplayErrMsg(sprintf("internal error %d:%s\n",
      mysql_errno(), mysql_error()));
   return 0 ;
}

// Display the Items
while(($row = mysql_fetch_array($result)))
{

followed by this:

<?php
   echo $row["title"];
   echo "<BR>";
   echo $row["image"];
   echo "<BR>";
   echo $row["author"];
   echo "<BR>";

?>


which is just spitting the records out in a nice long list!

Andrew