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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
