Displaying MySQL results

esiason14

SELECT first_name, last_name, picture, user_points
FROM .......
WHERE ...
ORDER BY used_points DESC;

What I want to do is display this in a table.

For the first row I want to show:

picture --- first_name --- last_name

for all other results I only want to show

first_name --- last_name

How can I determine the first row of a result set?

Piranha

$result = something...;
$firstrow = true;
for ($row = mysql_fetch_row($result)) {
  if ($firstrow) {
    $firstrow = false;
    // Do what you want on the first row
  }
  // Either have an else statement to do other things on the next rows, or do the same on the first and next rows.
}

jkurrle

I didn't know you could use a for() loop that way.

I would have written the code a little differently, to wit:

$select = "SELECT first_name, last_name, picture, user_points
FROM .......
WHERE ...
ORDER BY used_points DESC";

//make a database connection, then...

$result=mysql_query($select)
  or die("Select from XYZ table had errors - ".mysql_error());

//assuming your connection was named $connection
mysql_close($connection);

while($row=msyql_fetch_array($result,MYSQL_ASSOC))
  {
  extract ($row);
  //do whatever you want to do with $first_name, $last_name, $picture, $user_points
  }

To each their own flavors...

Piranha

It might be that you are right jkurrle, that you can't use a for-loop. I haven't programmed in PHP the last 6 months, and such things is the first that you forget.