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
