Re: [PHP-DB] Help With Getting Values Please!

2001-05-24 Thread Russ Michell
mysql_result() is used when you know the row number of the item you want to retrive from your table. mysql_query() is used to get all results from a query, so you can loop thru an array of them or something. Russ On Wed, 23 May 2001 18:47:22 +0200 Johannes Janson <[EMAIL PROTECTED]> wrote:

Re: [PHP-DB] Help With Getting Values Please!

2001-05-23 Thread Johannes Janson
Hi, >$sql2 = "SELECT ServiceDes FROM ServiceTypes WHERE ServiceID = $serviceid"; put single quotes around $serviceid. >$service_type = mysql_result($sql2, 1); I might be perpetuating the spreading of rumors but I've heard and read somewhere that mysql_query() is supposed to be better in the pe

[PHP-DB] Help With Getting Values Please!

2001-05-23 Thread DanielW
Greetings. I'm trying to get a value for a single cell out of a table and into a variable. I receive the following error message: Warning: Supplied argument is not a valid MySQL result resource in /home/etc My code (abbreviated) is as follows: $sql2 = "SELECT ServiceDes FROM ServiceTypes