Re: Problems getting data out from the database

Is it displaying the no. of rows from the line echo "$numOfRows <br>";//return num of rows 2ndly try using this: echo $row['choice']; ///or it may be echo $row['ans.choice']; 3rdly you should also use if($numoflRows>0) { //print the data } else {

          echo "no records ";

} i hope this wil help u out regards umeed Micah Stevens wrote:

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