Returning Values from MYSQL QUERIES

[fuzz01]

Guys,

I hope someone can help me out there.
Is there any references for returning values from mysql queries through php commands.

For example :

if(!mysql_connect($Hostname)) {
exit();
} else {
mysql_select_db($Databasename);
$query = "select username from

clinician where username

= '$Create_username';";
$result = mysql_query($query);
}

if the query was successful what would be stored in the $result variable. whenever I run this script and echo to the screen I get the following : RESULT = Resource id #2
regardless if the result is true or not.

Many Thanks

Fuzz

[Anon]

There are a few functions you'll need (look them up in the manual), as follows:

mysql_fetch_row or mysql_fetch_array
Optional:
mysql_num_rows
print_r

Basically you run mysql_num_rows to see if you got any data back from the query (if a select query returns true that only means there wasn't an error. it does not mean it returned any rows).

If you did, use a loop of mysql_fetch_row (I prefer a foreach loop, usually) to get the data.

For debug purposes, you can use print_r on the resulting array from mysql_fetch_row to see exactly what data was returned.

Hope that answers all your questions.