Re: [PHP-DB] A bit of help with a query needed.

2001-04-17 Thread Johannes Janson
Hi, > $result2 = mysql_query("SELECT * FROM convicts WHERE ship = > '$id' ORDER BY convict",$db); > $row = mysql_fetch_array($result2) // ! you are missing a ";" this is where you get the parse error from! > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe,

RE: [PHP-DB] A bit of help with a query needed.

2001-04-17 Thread Howard Picken
Thanks for that. I've cleaned up things a bit for the time being. I'm still getting an error though. Parse error: parse error in c:\usr\local\www\pages/ships.php on line 30 Line 30 turns out to be $convict = $row["convict"]; so I'm assuming that it's having trouble with the array. I've tried

Re: [PHP-DB] A bit of help with a query needed.

2001-04-17 Thread Johannes Janson
Hi, which part is not working? Put a "or die(mysql_error())" behind your queries to see which one produces an error. like this: $result = mysql_query("SELECT * FROM ships ORDER BY ship",$db) or die(mysql_error()); > > while ($row = mysql_fetch_array($result)) { > > If ($result) { >