Retrieving DB field values

Anon

Okay, I have the following query set up:

$query = "SELECT FieldName FROM TableName WHERE OtherFieldName='SpecificValue'";

I would like to get the value of FieldName from the result...

How would I go about doing this?

Any method i've tried so far won't work and a search for a mysql command in php for this function has brought up only a way to get the FIELD names, not the values...

Any help would be most appreciated..

Thanks.

rbenfield

It is

mysql_fetch_row($result);

Hope that helps,
Richard

Anon

I'm a genius!

I did it...

$FieldValues = array();

$FieldValues = @mysql_fetch_array($the_query);

echo $FieldValues["FieldName"];

This also means i can cache my DB values into session values so i don't have to continously access the db just to get static values...

Oh the brilliance of it all.

Anon

Would this be a preferable method than that which i mentioned?

Wait.. prehaps for a single row... But for multiple field values the array would work better..

Maybe..

right...?

rbenfield

The only real difference between mysql_fetch_row and mysql_fetch_array is that mysql_fetch_array allows you to retrieve the value using either the index or the fieldname. for example based on what you wrote you could do either of the following.

echo $FieldValues["FieldName1"];
echo $FieldValues["FieldName2"];
or
echo $FieldValues[0];
echo $FieldValues[1];

while using mysql_fetch_row you would have to use the index.

echo $FieldValues[0];
echo $FieldValues[1];

using the array method consumes additional server resources, however these are negligable and therefore not a real factor in the decision. If you have no plans or interest in using the actual field names then "row" is probably the best practice. However if there is anychance you may use the field name then go ahead and use "array".

Hope that helps,
Richard

thedefunct

Ah, I am enlightened.

While i've started coding using array, due to the fact its easier to remember fieldnames than the number, hence order fields are in the db. Its still good to have the option and knowledge of mysql_fetch_row. While server resources shouldn't be an issue, its good to have another option and i'll certainly try it in the future.

Thank you for your help.

...once again...