[PHP-DB] mysql_fetch_assoc question

2002-09-04 Thread Graeme McLaren 

Hey all,

I managed to find that if I do:

$MemberID = mysql_query(SELECT ID FROM SiteMember WHERE Username =
'$valid_user');
$array = mysql_fetch_assoc($MemberID);
print_r($array);

this will produce:

Array ( [ID] = 3 )

All I want is the value 3 so that I can go ahead and insert that into the
Lookup table.

Any ideas how I can just extract this value?  I'm also not 100% clear on
what mysql_fetch_assoc does, can anyone explain it?


Cheers in advance,

Graeme :)


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysql_fetch_assoc question

2002-09-04 Thread DL Neil 

Hey Graeme,

 $MemberID = mysql_query(SELECT ID FROM SiteMember WHERE Username =
 '$valid_user');
 $array = mysql_fetch_assoc($MemberID);
 print_r($array);
 this will produce:
 Array ( [ID] = 3 )

 All I want is the value 3 so that I can go ahead and insert that into the
 Lookup table.
 Any ideas how I can just extract this value?  I'm also not 100% clear on
 what mysql_fetch_assoc does, can anyone explain it?


mysql_fetch_assoc() takes the response from MySQL (the query resultset) and
hands it to PHP as an associative array. This array only consists of one
element: $array['ID'] - which in your example has the value 3. So echo
$array['ID']; or similar use will give you what you seem to be asking for.

Please read the manual:
mysql_fetch_assoc() and the whole appendix on MySQL functions
array processing and associative arrays

Of course if you are resolving the value (3) in order to submit that to
another query (Lookup table), then you should be looking at relational
database methodology and table joins!

Regards,
=dn



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php