|
|
Posted by Sarel on 01/07/07 19:21
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
Navigation:
[Reply to this message]
|