Re: 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 the result and with what > parameters? > > (I have tried many most of the functions but I don't get the correct > result, and the manual is not helping me :) > > Regards, > Sumarlidi Einar Dadason If id is an integer type field, you will not get a result using the query you show. Remove the single quotes around $id as they indicate a text type value. 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"); Then you can use mysql_fetch_array to get row[s] containing an array of all the fields (one!) in your query, and then use extract to put the field values in a variable named as the field. (The example for mysql_fetch_array shows another way of displaying the fetched values.) So: $row = mysql_fetch_array($result); extract($row); echo $islname; -- David Robley | WEBMASTER & Mail List Admin RESEARCH CENTRE FOR INJURY STUDIES | http://www.nisu.flinders.edu.au/ AusEinet | http://auseinet.flinders.edu.au/ Flinders University, ADELAIDE, SOUTH AUSTRALIA