Listing Rows in MySQL ?

Anon

Does anybody know how to list the rows in a table in a certain way?

I have this html and I want to be able to list the username, password, URL and email in the correct field.

Thanks

<p align="center"><b><font face="Arial" size="3">Member Site Administrator for <? echo $cwsuser ?></font></b></p>

<p><font face="Arial"><b><font color="#008000"><a href="http://users.cystrix.co.uk/msa/main.php">Main</a>
</font>> <font color="#008000"><a href="siteman.php?page=main">Site Manager</a></font> <font color="#800000">
</font><font color="#000000">></font> </b><font color="#800000"><b>Edit
existing Machine Names</b></font></font></p>
<p><form action="<? echo $pagename ?>?page=domach" method="POST">
<div align="left">
<table border="1" cellspacing="0" bordercolorlight="#C0C0C0" bordercolordark="#C0C0C0" cellpadding="2">
<tr>
<td align="center"><font size="2" face="Arial" color="#000080"><b> User
ID  </b></font></td>
<td align="center"><font size="2" face="Arial" color="#000080"><b>Password
</b></font></td>
<td align="center"><font size="2" face="Arial" color="#000080"><b> Machine
Name  </b></font></td>
<td align="center"><font size="2" face="Arial" color="#000080"><b>Action
</b></font></td>
</tr>
<tr>
<td align="center"><? echo $cwsuser ?></td>
<td align="center">
<b><font size="2" face="Arial" color="#008000"><input type="text" name="inputpassword" size="10">
</font></b><font size="2" face="Arial" color="#008000"><input type="submit" value="Save">
</font></td>
<td align="center"><? echo $olddomain ?></td>
<td align="center"><font size="2" face="Arial" color="#008000"><input type="submit" value="Delete">
</font></td>
</tr>
</table>
</div>
</form><b><font face="Arial" color="#000080" size="2"><br>
</font></b>

</body>

Anon

mysql_connect("server", "name", "pass");
mysql_select_db("yourdb");

$query = mysql_query("select username,password,email,url from table WHERE username='$cwsuser'");

$data = mysql_fetch_array($query);

echo $data[username];
echo $data[password];
echo $data[email];
echo $data[url];

Hope that helps, I am guessing the name of your fields in the database as username,password,email and url.

Anon

Thanks, that has solved a problem in another part of my site!!

For this part though I need to do the following:
Open table $cwsuser then get all the data out and display it so that each new row in the MySQL table also prints out a new row in the html table.

Is this possible?

Thanks

Anon

<?php
mysql_connect ($host, $user, $password);
$result = mysql_db_query ("database","select * from table");
echo "<table>\n";
while ($row = mysql_fetch_array ($result)) {
echo "<tr>";
echo "<td>" . $row["user_id"] "</td>";
echo "<td>" . $row["fullname"] . "</td>";
echo "</tr>\n";
}
echo "</table>\n";
mysql_free_result ($result);
?>

Anon

Thanks a lot!

Its working perfectly! 🙂