Problems getting data out from the database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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"]; 
?>

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux