Re: Retrieve data from MySQL
| From: | Dmeles | Date: | Wed, 26 Jul 2000 01:51:21 +0000 |
| Subject: | Re: Retrieve data from MySQL | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-1314@lists.php.net to get a copy of this message | ||
Hi folks;
I'm new in using PHP. I'm a Cold Fusion developer, and I'm trying to move to
PHP.
Please, I'm in a trouble, I'm trying to retrieve data from a table using the
code above:
<?
mysql_pconnect("localhost")
or die("Unable to connect to SQL server");
mysql_select_db("test") or die("Unable to select database");
$query = "SELECT * FROM guests";
$numguests = mysql_query($query) or die("Select Failed!");
$numguest = mysql_fetch_array($numguests);
?>
But, $numguest, only retrieve one record from the table, what should I have
to do , to get all records from the table????
Thank you very much;
Danilo Meles