[Resolved] MySQL Queries

ofSHIZ

Hi, I have items stored in my MySQL Database, (a memberlist) and I want them to be displayed on my site in a table. I've tried doing this but i didn't know how to display them into the table. You can make any table, with any MySQL structure.
I use http://www.tripod.lycos.co.uk/ as my server. (Just so you know.)
All help is greatly appreaciated

leatherback

In general:


Create the table:

$output = ",table><tr><td>";

// create query:

$query = "select * from database";
  $result = mysql_query($query);

//  grap results one by one, and place them on output var:

while($row =@ mysql_fetch_array($result))
 {
  $output .= "$row[someColumName]</td><td>$row[someOtherColumName]</td></tr>";
 }

$output .= "</table>";

echo $output;

ofSHIZ

I would have like more then one user in my memberlist, would it display them each in a different table cell if I did that? A tutorial would be greatly aprreciated also.

Pig

It is inefficient to create/reassign variables needlessly. You are better off without the $output stuff:

$result = mysql_query("SELECT * FROM table_name");
if( mysql_num_rows($result) == 0 )
     { ehco("There is no data to display"); }
else
     {
     echo("
          <table>
               <tr>
                    <td>first name</td>
                    <td>last name</td>
               </tr>
          ");
     while( $row = mysql_fetch_array($result) )
          {
          echo("
               <tr>
                    <td>$row[first_name]</td>
                    <td>$row[last_name]</td>
               </tr>
               ");
          }
     echo("</table>");
     }

That displays each person in a different row, within the same table. There are gobs of tutorials on this. check out webmonkey and sitepoint.

ofSHIZ

Wow, thanks..
Your one smart kid, huh?

Pig

Kid? heheh.