Do you get error messages? Try this: <? $host='localhost'; $username='root'; $password='asd'; $connection = mysql_connect($host,$username,$password) or die(mysql_error()); mysql_select_db("testing") or die(mysql_error()); $ans = mysql_query ("select ans.choice from ans, info where info.choice=ans.value;") or die(mysql_error()); $numOfRows = mysql_num_rows ($ans); $row = mysql_fetch_array($ans); echo "$numOfRows <br>";//return num of rows echo $row["ans.choice"]; ?> On Wednesday 17 August 2005 1:40 am, 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"]; > ?> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php