Hi PFMaBiSmAd, oh rite so what I am trying to do is, I have made a visual basic program were when the member log s in it sends a value "1" to the mysql n wen the member logs out it sends a value "0" to the mysql.
So im using this php and mysql to connect to databse so when user log s in, the php will pik up on the databse and the value wil be"1" it will show a red image in the php, then when user logs out it that value in mysql change to "0" then the colours goes green in the php, this is what im trting to do but not working this is the code I got so far, please let me know. i dont think the "mysql_num_rows()" will work for what I am trying to do.
<?php
$con = mysql_connect("*****","*****","*****");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("table");
$query = mysql_query("SELECT * FROM 'people' WHERE 'Access'='1'");
if ($query)
{
echo'<img src="red.jpg">';
}
else
{
echo'<img src="green.jpg">';
}
?>