Not getting first piece of data in query HELP!!
Posted: Tue Jun 01, 2004 8:45 am
In my while loop it is not getting the first person in the query
here is my connnection string also
here is my connnection string also
Code: Select all
<?php require_once('Connections/mid_state_prd_cat.php'); ?>
<?php
mysql_select_db($database_mid_state_prd_cat, $mid_state_prd_cat);
$query_gaylord = "SELECT location, FirstName, LastName, Title, email FROM location_contacts WHERE location = 'gaylord'";
$gaylord = mysql_query($query_gaylord, $mid_state_prd_cat) or die(mysql_error());
$row_gaylord = mysql_fetch_assoc($gaylord);
$totalRows_gaylord = mysql_num_rows($gaylord);
?>Code: Select all
while($row_gaylord = mysql_fetch_assoc($gaylord))
{
echo ("<tr>");
echo $row_gaylordї'FirstName'];
echo ("</tr>");
}