Re: Problems getting data out from the database
| From: | Micah Stevens | Date: | Wed, 17 Aug 2005 01:47:24 +0000 |
| Subject: | Re: Problems getting data out from the database | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-40090@lists.php.net to get a copy of this message | ||
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"];
> ?>