Re: Retrieve data from MySQL
| From: | Rasmus Lerdorf | Date: | Wed, 26 Jul 2000 05:27:15 +0000 |
| Subject: | Re: Retrieve data from MySQL | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-1321@lists.php.net to get a copy of this message | ||
> <?
> 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????
while($numguest = mysql_fetch_array($numguests)) {
echo $numguest['first_name'];
}
-Rasmus