[NEWMAN] Collecting information from a my sql table.
| From: | Philip J. Newman | Date: | Sun, 24 Feb 2002 23:15:36 +0000 |
| Subject: | [NEWMAN] Collecting information from a my sql table. | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-86026@lists.php.net to get a copy of this message | ||
<?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