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!

ECTED] Homepage:www.sed.is <- New Homepage! -- -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 tryi

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: $r

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,

[PHP] Simple PHP 4 and MySQL question about query

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 the result and with what parameters? (I have tr