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!


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

Reply via email to