reading records from MySQL

[bryson]

Any ideas why this doesn't work?

<?php
mysql_connect("localhost","root","password");
mysql_select_db('main');

$query = "SELECT * FROM usr_table";
$result = mysql_query($query);
$num = mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $num) {
$usr = mysql_result($result,$i,"usr");
$pwd = mysql_result($result,$i,"pwd");

echo "<TR>
<TD>$usr</TD>
<TD><FORM NAME='$usr'><INPUT TYPE=password NAME=pwd VALUE='$pwd'></TD>
<TD><INPUT TYPE=submit VALUE=Update></TD>
<TD><INPUT TYPE=button VALUE=Delete onClick='del_f(this.form.name)'></TD>
<INPUT TYPE=hidden NAME=usr VALUE='$usr'>
<INPUT TYPE=hidden NAME=update_flag VALUE=1>
</FORM>";
++$i;
}
?>

[crosbystillsnas]

$num = mysql_numrows($result);

mysql_num_rows()

[bryson]

ooops, thanks. Fixed that.... still blank page...no output, no errors.

[sdjensen]

Hi

Don't close the mysql before to the end of your script

mysql_close(); 

[bryson]

Revised...still not working... dammit! Yeah, I read somewhere that you don't even have to close it.

<?php
mysql_connect("localhost","root","buster");
mysql_select_db('main');

$query = "SELECT * FROM usr_table";
$result = mysql_query($query);
$num = mysql_num_rows($result);

$i=0;
while ($i < $num) {
$usr = mysql_result($result,$i,"usr");
$pwd = mysql_result($result,$i,"pwd");

echo "
<TD>$usr</TD>
<TD><FORM NAME='$usr'><INPUT TYPE=password NAME=pwd VALUE='$pwd'></TD>
<TD><INPUT TYPE=submit VALUE=Update></TD>
<TD><INPUT TYPE=button VALUE=Delete onClick='del_f(this.form.name)'></TD>
<INPUT TYPE=hidden NAME=usr VALUE='$usr'>
<INPUT TYPE=hidden NAME=update_flag VALUE=1>
</FORM>";
++$i;
}
?>

[sdjensen]

Try to do a echo of $num so see if there actually are any data in your table

[bryson]

yeah...$num is blank...
Database was configured wrong

Thank you sir