sql result into table

Anon

Hi!
I'm learning at a starting stage. Have problem with getting sql results into table. Can anyone please point me into the right direction? (code below)
Also, what is the best way to study PHP. I got some books, but to me they are'nt helpful. There's some theory explained, thats fine, but real coding isn't there or it is given with no explanation.

Thank you in advance!
<BODY>
<?php
if(!$co)
{
php?>
<FORM METHOD="POST">
<INPUT TYPE="text" NAME="co">
<INPUT TYPE="SUBMIT" NAME="SUBMIT" VALUE="SUBMIT">
</FORM>
echo "Write here what you are looking for";
<?php
exit;

$db ="picture_source";
$table = "binary_data";

$connect = mysql($db, "select * from $table where description like '%$co%'");
$num = mysql_numrows($connect);
echo "There is $num records in this table for $co";
echo "<p>";

<table border="1" frame="border" rules="all">
<TR>
<TH> Your Results:
$i=0;
while ($i < $num)
{
$username = mysql_result($connect,$i,description);
$pic = mysql_result($connect,$i,bin_data);
$i++;
<TR>
<TD allign center> echo $pic
</table>

    //echo $username;
    echo "<p>";
    //echo $pic;
    //echo "<p>";

}
exit;
php?>

crislewis

Hmm, this looks way off the mark.

In simple terms:

connect to the mysel server
select your database
run your select query

then:

while ($row_data = mysql_fetch_array($result)){ //$result = mysql query result id

<?
} // end of while
?>

</table>

Notes:

mysql_fetch_array returns one row at a time into an associative array with the indexes set to the field names. You can use mysql_fetch_row if you just want an ordinary array and you use $row_data[0] for the first field in the row.

I learned PHP from just one book 'Begining PHP4' by WROX press. After this book I just used it with the PHP manual and searchiung relevant forums when I had a problem.

Cheers,

Cris