Posted by ernie.bornheimer on 01/10/07 06:52

Thank you both, these suggestions were just what I needed.

Ernie

"Sarel" <sarel.w@gmail.com> wrote in message
news:1168197662.488440.142000@i15g2000cwa.googlegroups.com...
> You can also try... mysql_fetch_assoc - this will give you an array of
> the values, where the keys of the array would be associative. For
> instance, it'll have for a table that's got the fileds "Name" and
> "Surname" the following array:
> array {
> [Name] => peter
> [Surname] => pan
> }
>
> Andy Hassall wrote:
>> On Sun, 7 Jan 2007 09:39:17 -0800, "ernie.bornheimer"
>> <ernie.bornheimer@gmail.com> wrote:
>>
>> >Okay, I know how to:
>> > - construct a SQL query and get a result set
>> > - loop through the result set and echo the fields I need
>> >
>> >But what I really need to do is get a value from a field and put it in a
>> >variable, and I can't seem to get it to work, because then the variable
>> >just
>> >holds "resource id#"
>> >So the query I'm using returns only one row, since I'm filering on the
>> >primary key, and I can test for one row returned. If one row is
>> >returned,
>> >how do I pull out the value of one field and put it in a variable?
>>
>> mysql_result or mysql_fetch_array.
>>
>> --
>> Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
>> http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
>

[Back to original message]