Re: [PHP] Simple PHP 4 and MySQL question about query

To follow on, one thing this newbie learned is that it is usually best to build the query string and then pass it to the mysql_query funcion. i had some odd results when I had several ( ) in there for my where clause I made it a separate string and presto it works every time. chris On Tue,

RE: [PHP] Simple PHP 4 and MySQL question about query - Problem solved!

Thank you all for your replies. The following solved my problem (from David Robley): -- Also you shouldn't need single quotes around islname - so your query might look more like: $result = mysql_query("SELECT islname FROM $table WHERE id=$id");

RE: [PHP] Simple PHP 4 and MySQL question about query

tried using echo $islname; ?? -Original Message- From: SED [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 1:15 PM To: [EMAIL PROTECTED] Subject: [PHP] Simple PHP 4 and MySQL question about query Hi, I'm trying to get a result from the following query: $result = mysq

Re: [PHP] Simple PHP 4 and MySQL question about query

On Tue, 20 Mar 2001 12:45, SED wrote: > Hi, > > I'm trying to get a result from the following query: > > $result = mysql_query("SELECT 'islname' FROM $table WHERE id='$id'"); > > Because "id" is a unique key in my table, I know it has only one value. > What mysql_funtion should I use to echo

Re: [PHP] Simple PHP 4 and MySQL question about query

try somethin' like this... $result = mysql_query("SELECT 'islname' FROM $table WHERE id='$id'"); // For one row.. use a zero $islname = mysql_result($result, 0, "islname"); // Otherwise, loop through $islname=mysql_result($result, $i, "islname"); At 02:15 AM 3/20/2001 -, you wrote: >Hi,