Jump to content

Looping, first value is being omitted


dink87522

Recommended Posts

$date = time();

$query = "SELECT * FROM experience_process"; 
$result = mysql_query($query) or die("Error: Could not be completed." . mysql_error());
$process = mysql_fetch_assoc($result);
$count = mysql_num_rows($result);

echo("<br />date: $date");
echo("<br />Count: $count");

do { // Keeps getting the next row until there are no more to get
$user = $row['user_name'];
echo("<br />User: $user");
} while ($row = mysql_fetch_assoc($result)); 

 

I want to loop through all the users (and echo their name). The above code does not get the first result from the table (so I stopped using a loop and tried a do loop, although same thing), what do I need to do to change this?

Link to comment
https://forums.phpfreaks.com/topic/208386-looping-first-value-is-being-omitted/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.