Couple Questions

bimmer528

echo "
<table width='75%' border='0' align='center'>
<tr bgcolor='#000000'>
<td><div align='center'><strong>Mysql Id</strong></div></td>
<td><div align='center'><strong>Player Name</strong></div></td>
<td><div align='center'><strong>Ip Address</strong></div></td>
<td><div align='center'><strong>Reason</strong></div></td>
<td><div align='center'><strong>Hack</strong></div></td>
</tr>
<tr>
<td><div align='center'>$id</div></td>
<td><div align='center'>$name</div></td>
<td><div align='center'>$ip</div></td>
<td><div align='center'>$reason</div></td>
<td><div align='center'>$hack</div></td>
</tr>
</table>
";

Couple things

How can I have each query display, without repeating the names of the fields in the table

For example

Mysql ID
1
2
3

instead of

mysqlid
1
mysqlid
2
ect..

Also...

How can I add just a delete string in there?

Mysql Delete
1 yes=Deletes the row.

saronoff

<---------------- Do ONE query that gets all the records. And insert a loop here.

echo "
<tr>
<td><div align='center'>$id</div></td>
<td><div align='center'>$name</div></td>
<td><div align='center'>$ip</div></td>
<td><div align='center'>$reason</div></td>
<td><div align='center'>$hack</div></td>
</tr>";

<-------------- end loop here.

echo "</table>";

To insert the delete do it inside the loop after hack. That will make it appear for each row.

Also, I would use print instead of echo. Print is a higher level construct and easier to work with.

bimmer528

Thx man, but there still lies 1 problem.. Although serveral rows in the database, it is only returing the *last row

echo "
<table width='75%' border='0' align='center'>
<tr bgcolor='#000000'>
<td><div align='center'><strong>Mysql Id</strong></div></td>
<td><div align='center'><strong>Player Name</strong></div></td>
<td><div align='center'><strong>Ip Address</strong></div></td>
<td><div align='center'><strong>Reason</strong></div></td>
<td><div align='center'><strong>Hack</strong></div></td>
<td><div align='center'><strong>Posted By</strong></div></td>
<td><div align='center'><strong>Delete</strong></div></td>
</tr>";

$result = mysql_query("select * from xoops_cheaters order by id");
while($r=mysql_fetch_array($result))
{
$id=$r["id"];
$name=$r["name"];
$ips=$r["ips"];
$reason=$r["reason"];
$hack=$r["hack"];
$posted=$r["posted"];

}
echo "
<tr>
<td><div align='center'>$id</div></td>
<td><div align='center'>$name</div></td>
<td><div align='center'>$ips</div></td>
<td><div align='center'>$reason</div></td>
<td><div align='center'>$hack</div></td>
<td><div align='center'>$posted</div></td>
<td><a href='delete.php?id=$id'>Do it!</a>
</tr>";

echo "</table>";

stratguitar

I believe you ended your loop too soon. If you want the 'Do It!' hyperlink next to each row (I assume you do) and want to display all the rows you've selected in your query, then...

Put the closing loop bracket

}

right before the

echo "</table>";

(and obviously, don't forget to close your PHP code...

then close your HTML

Hope this helps...
StratGuitar