[SOLVED] Display multiple db rows

[forumnz]

How does that work?

 

Sya I have 10 users and want to display them all, how can I code something that places all 10 (say username and location) in rows as output. I know how to do the html part etc, and also how can I make it so that every odd number row has light grey and every even has darker?

 

Thanks a lot,

Sam.

[darkfreaks]

<?php
echo"<table><tr><td> $row[username];$row[location]; </td></tr></table>";?>

[forumnz]

So if I have 10 users and I select them all from bd then I just write the equiv. of that, it will/should work?

[darkfreaks]

actually uou need

 

$link= mysql connect or die mysql error

$result = mysql_query("SELECT * FROM table", $link);

 

 

$num_rows = mysql_num_rows($result);

 

echo "<font face=Verdana size=1 color=484077> $num_rows </font>";

 

 

 

 

[trq]

Something like....

 

<?php

 // connect to db.

 $sql = "SELECT uname,location FROM users";
 if ($result = mysql_query($sql)) {
   if (mysql_num_rows($result)) {
     $i = 1;
     echo "<table>";
     while ($row = mysql_fetch_assoc($result)) {
       $color = ($i % 2) ? 'light' : 'dark';
       echo "  <tr class='$color'>";
       echo "    <td>{$row['uname']}</td>";
       echo "    <td>{$row['location']}</td>";
       echo "  </tr>";
       $i++;
     }
     echo "</table>";
   } else {
     echo "No results found";
   }
 } else {
   echo "Query failed " . mysql_error() . "<br />$sql";
 }

?>

[forumnz]

Why does this not work (thanks thorpe)? It displays all of it on the same line.

 

<?php


//Connect to mysql server
$link=mysql_connect("localhost","sss","sss");
if(!$link) {
	die('Failed to connect to server: ' . mysql_error());
}
//Select database
$db=mysql_select_db("bbmembers");
if(!$db) {
	die("Unable to select database");

}
else{

  $sql = "SELECT * FROM auctions";
  if ($result = mysql_query($sql)) {
    if (mysql_num_rows($result)) {
      $i = 1;
      echo "<table>";
      while ($row = mysql_fetch_assoc($result)) {
        $color = ($i % 2) ? 'light' : 'dark';
        echo "  <td class='$color'>";
        echo "    <tr>{$row['uan']}</tr>";
        echo "    <tr>{$row['title']}</tr>";
        echo "  </td>";
        $i++;
      }
      echo "</table>";
    } else {
      echo "No results found";
    }
  } else {
    echo "Query failed " . mysql_error() . "<br />$sql";
  }
  }

?>

[darkfreaks]

name and location need to be in seperate td and tr's

[forumnz]

But the next thing is after the</td>?

[darkfreaks]

while ($row = mysql_fetch_assoc($result)) {
        $color = ($i % 2) ? 'light' : 'dark';
        echo "  <tr class='$color'>";
        echo "    <td>{$row['uname']}</td>";
        echo "    <td>{$row['location']}</td>";
        echo "  </tr>";
        $i++;

[forumnz]

Thanks, what did you do?

[darkfreaks]

absolutely nothing? you copied his code wrong LOL

[forumnz]

Oh I see... haha.... One other thing, how can I change the order ...ie asc or desc? I wrote ORDER BY asc in the select part but i got an error:

Query failed You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc LIMIT 3' at line 1
SELECT * FROM auctions ORDER BY desc LIMIT 3

[darkfreaks]

DESC LIMIT 3