[RESOLVED] mysql to tables

rbblue8

Hey everyone...

Looking to do something that may be kind of hard. I have no idea where to start here. But hopfully you guys can get me going.

Basically I'm looking to a roster section of my site but looking to do it with the back of mysql.

On the front end I'm looking to store a picture and a munch of txt. All seperated out into a table Lets say 2 rows with 2 coloms in the first row and one big one on the bottom.

On the back end (where the user logs in with there user name and password I'm looking for them to be able to modfy just there section of output on the front end. (this I know how to do... just make a sql query for that user only ... Duh)

But my problem is... I do not know how many users i'm going to be having so i can not prodect the amount of rows ahead of time. basically when the user goes to create there profile I need it show up in a table format on a different page.

So what I;m really looking for is a tid bit of code that will take data from one table (multi rows), create a table, and populate data into that table on the fly.

To hard?

NFClimber

I think it sounds pretty simple...you're code should look something like this...

$query = "SELECT column1, column2, column3 FROM table";
$result = mysql_query($query);
$row = mysql_fetch_array($result);

This way you'll get everything into an array. Then you can print the table for the roster using a while statement.

echo '<table><tr><td>Name</td><td>Rank</td><td>Serial Number</td></tr>';

WHILE ($row) {

echo "<tr><td>' . $row[1] . '</td><td>' . $row[2] . '</td><td>' . $row[3] . '</td></tr>";

};
echo '</table>';

The while loop will print off your records until there is nothing left from the mySQL query, therefor you won't need to know how many. If you only want a certain amount, you can adjust the query and it should be fine. I didn't check the code offhand, but it should take care of what you need.

Was this what you were looking for?

rbblue8

kind off..

but i have a problem with this.

echo "<tr><td>' . $row[1] . '</td><td>' . $row[2] . '</td><td>' . $row[3] . '</td></tr>";

does that mean that only three rows will be posted?

I need something that will go from 1 to whatever

DanielLiljeberg

No $row will keep the all the fields of a row and 1, 2, 3 would be the names ofthe fields. So if you named the fields 'name', 'rank', 'serialnumber' it would be row['name'], row['rank
] etc

On closer inspection I think that the previous post doesn't realy do what you want. Also change the while-loop to retrive one row each iteration instead of retreiving the array before it. That should do it.

NFClimber

That's just poor variable naming on my part. The $row[x] variables represent the values within the array of the array. For instance, $row[1] may represent the person's name, $row[2] may represent the person's age, etc. A better name for the variable would have been column[x] I suppose.

Using the code I gave you, it would output a table like this:

Name Rank Serial Number
John 1st Class 00445566
James 2nd Class 22334455
.... ...... ....

And would continuing to output the data until there is none left. I assumed in your roster, you would be using multiple column variables, like name, age, etc.

Did that help?

Installer

NFC: Your code will echo only one result row. I think what you meant was more like this:

$query = "SELECT column1, column2, column3 FROM table";
$result = mysql_query($query);
echo '<table><tr><td>Name</td><td>Rank</td><td>Serial Number</td></tr>';
while ($row = mysql_fetch_array($result)) {
    echo '<tr><td>' . $row[0] . '</td><td>' . $row[1] . '</td><td>' . $row[2] . '</td></tr>';
};

Edit: Also, the row indexes should start at 0.
Another edit: To correct quotation mark usage in second echo.

rbblue8

Thanks guys!

Here is my script that is takan from what you guys gave me and it works just fine

<?php
include 'mysql.php';

$query='SELECT username, rank, picture_file, about_me from website';
$result=mysql_query($query, $db);
if(!$result)die('unable to process the request, please let the site administration know :' .mysql_error());

while ($row = mysql_fetch_array($result)) {
echo  '<table width="690" border="1" cellpadding="0" cellspacing="0" align="center">';
echo  '<tr>';
echo  '<td width="139" rowspan="2" valign="top">'.$row[2].'</td>';
echo  '<td width="276" height="35" valign="top">Name: ' .$row[0].' </td>';
print '<td width="275" valign="top">Rank: ' .$row[1].' </td>';
echo  '</tr>';
echo  '<tr>';
echo  '<td height="102" colspan="2" valign="top">' .$row[3].' </td>';
echo  '</tr>';
echo  '<tr>';
echo  '<td height="1"></td>';
echo  '<td></td>';
echo  '<td></td>';
echo  '</tr>';
echo  '</table>';
echo  '<p>&nbsp;</p>';

}

mysql_close($db);
?>

Thanks