Displaying all results of MySQL DB omits first entry

H3mp

When I try to display the results of my database, I end up getting everything except my first relevant entry.

ie: showing all rows whos variable "case_status" equals "active" will show all but the first active entry.

This happens for all of my files no matter what the code snippet, and is irritating as hell. I am trying to get this program up-and-running and ready for a controlled release in my office within a week, but now this little bug is jamming up all of the custom displays (displaying only inactive cases, displaying only those who owe us money, etc).

Any help would be greatly appreciated. Here is an example of one of the codes giving me the problem.

<?php
mysql_connect ("localhost","USERNAME","PASSWORD") or die ('Could not connect to the MySQL Database because : ' . mysql_error());
mysql_select_db ("bail_bail") or die(mysql_error());



$result = mysql_query( "SELECT * FROM bailfiles WHERE status='active'" );
$info = mysql_fetch_array( $result ); 
while($info = mysql_fetch_array( $result )) 
{
echo "<b>Name: </b>".$info['name']."<br />"; 
Print "<b>Bail Amount: </b>".$info['bailamount']."<br />";
Print "<b>County: </b>".$info['county']."<br />";
Print "<b>Date: </b>".$info['date'] . " <br />"; 
Print "<b>Docket: </b>".$info['docket']."<br />";
Print "<b>OTN: </b>".$info['otn']."<br />";
Print "<b>Power: </b>".$info['power']."<br />";
Print "<b>Security: </b>".$info['security']."<br />";
Print "<b>Addition Information: </b>".$info['info']."<br />

<br /><br />";
}


?>

Derokorian

$info = mysql_fetch_array( $result );
This line fetches the first result row.

while($info = mysql_fetch_array( $result ))
This line creates a loop to keep fetching rows until there are none left. However since you already fetched the first row (and did nothing with it) it will be missing. Simply remove the first line in my post and you should be golden.

H3mp

I haven't had a chance to come on and thank you for your help due to my state getting flooded over the weekend. It worked like a charm, thank you very much.