Re: Problems getting data out from the database

On Wed, 17 Aug 2005, Chin Yan Yan wrote:

I had try using the fetch arrays things or the fetch rows but it nv show anything out. The ans and info are two different table but in the same database. Below is the coding. <? $host='localhost'; $username='root'; $password='asd'; $connection = mysql_connect($host,$username,$password); mysql_select_db("testing"); $ans = mysql_query ("select ans.choice from ans, info where info.choice=ans.value;"); $numOfRows = mysql_num_rows ($ans); $row = mysql_fetch_array($ans);

echo "$numOfRows <br>";//return num of rows echo $row["ans.choice"];

echo $row[0] ; this might work i guess .. just type print_r($row) and check out how are the variables mapped

?>

-- ********************************************************************************************* You wouldn't know an OS if it hit you in the face ... Linux Baby ! *********************************************************************************************