<?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/ [EMAIL PROTECTED] Phone: +64 25 6144012