RE: [PHP] [NEWMAN] Collecting information from a my sql table.
| From: | Martin Towell | Date: | Sun, 24 Feb 2002 23:22:21 +0000 |
| Subject: | RE: [PHP] [NEWMAN] Collecting information from a my sql table. | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-86027@lists.php.net to get a copy of this message | ||
how about ?
$row = mysql_fetch_array($sql_result);
$pub_id = $row["pub_id"];
$pub_headline = $row["pub_headline"];
$pub_dateline = $row["pub_dateline"];
$pub_info = $row["pub_info"];
$pub_image = $row["pub_image"];
-----Original Message-----
From: Philip J. Newman [mailto:newmanpj@philipsdomain.com]
Sent: Monday, February 25, 2002 10:16 AM
To: php-general@lists.php.net
Subject: [PHP] [NEWMAN] Collecting information from a my sql table.
<?php
$sql = "SELECT * FROM
publisher WHERE 1 AND pub_id = $pub_id LIMIT
1";
$sql_result = mysql_query($sql, $connection) or die ("Could not get Query");
while ($row = mysql_fetch_array($sql_result)) {
$pub_id = $row["pub_id"];
$pub_headline = $row["pub_headline"];
$pub_dateline = $row["pub_dateline"];
$pub_info = $row["pub_info"];
$pub_image = $row["pub_image"];
}
?>
When I want to get just one record is there an easyer way than using the
while loop that I have been using?
Philip J. Newman
Philip's Domain - Internet Project.
http://www.philipsdomain.com/
info@philipsdomain.com
Phone: +64 25 6144012