Re: [PHP-DB] MySQL: How to properly extract fields from retrieved single record ???

2003-09-22 Thread Peter Beckman
On Mon, 22 Sep 2003, -{ Rene Brehmer }- wrote: $result = mysql_query($query); replace with: $result = mysql_query($query) or die(MySQL Error: .mysql_error().\nbr/SQL: .$query); If the query fails, you will see why the query failed, and be able to view the query itself. Maybe

RE: [PHP-DB] MySQL: How to properly extract fields from retrieved single record ???

2003-09-22 Thread Jacob A. van Zanen
Hi, I think this is what you are trying to do. You get a record back that has seveal fields and you want to reference those fields indiviually. This is what I do in this example (which shows people information) and present in HTML table

Re: [PHP-DB] MySQL: How to properly extract fields from retrieved single record ???

2003-09-22 Thread Ignatius Reilly
read the PHP manual and examples under the function mysql_fetch_array(). I find the MySQL manual is very well done and helpful. I've been using it as a reference for 2 years. Take a harder look! Ignatius _ - Original Message - From: -{ Rene Brehmer }- [EMAIL

Re: [PHP-DB] MySQL: How to properly extract fields from retrieved single record ???

2003-09-22 Thread George Patterson
On Mon, 22 Sep 2003 13:06:37 +0200 Ignatius Reilly [EMAIL PROTECTED] wrote: read the PHP manual and examples under the function mysql_fetch_array(). I find the MySQL manual is very well done and helpful. I've been using it as a reference for 2 years. Take a harder look! I think Ignatius