[Webdev] Re: [PHP] - Quick question

[Martin]

> $id = "22"
> $query = mysql("SELECT * from database where id='$id'");
> if (mysql_num_rows($query) > 0)
>         {
>         while($row = mysql_fetch_array($query))
>                 {
>                 do
>                         {
>                         printf("%s", $row["field1"]);
>                         }
>                 }
> else
>         {
>         printf("Sorry nothing found");
>         }
> 
> But I keep getting ": parse error, expecting `T_WHILE' in ..."
> 

Make sure there's a ; at the end of the first line:

$id = "22";

hey, you never know :-)

and change the while loop to this:

         while($row = mysql_fetch_array($query))
                 {
                 printf("%s", $row["field1"]);
                 }


Minor aside.
The mysql() call is there for backwards compatability. Might be
an idea to change that call to mysql_query() instead.

Martin.
 -- 
"If it looks like a duck, and quacks like a duck, we have at least to
consider the possibility that we have a small aquatic bird of the family
anatidae on our hands". <?>