Nothing displays from DB which has data

phplearner

Nuts. This sure looks correct, but nothing displays (and there IS data in the tables):

<?php
// pagehits.php

?>
<HTML>
<HEAD>
<TITLE>PAGE HITS</TITLE>
<link href="styles/default.css" rel="stylesheet" type="text/css">
</HEAD>
<BODY>
<CENTER><img src="mylogo.gif"></CENTER>
<CENTER>
<table class=tablemain width="400" border="0" cellspacing="0" cellpadding="0">
   <TR>
   <TD colspan="8">
   <CENTER><font class=pagetitle>PAGE HITS</font></CENTER>
   </TD>
   </TR>
   <TR>
   <TD>
   <table>
<?php
$db = mysql_connect("localhost", "me", "" ); 
mysql_select_db("mydb",$db); 
$result = mysql_query("SELECT * FROM cc_pagehits WHERE 1",$db) or die(mysql_error());
while ($row = mysql_fetch_array($result,$db)) {
	$page = $row['ccpage'];
	$hits = $row['cchits'];
	echo "<tr>";
	echo "<td>" . "$page" . "</td>";
	echo "<td>" . "$hits" . "</td>";
	echo "</tr>";
}
$result = mysql_query("SELECT * FROM cc_refsource WHERE 1",$db) or die(mysql_error());
while ($row = mysql_fetch_array($result,$db)) {
	$hitdate = $row['refdate'];
	$hiturl = $row['refip'];
	$hitname = $row['refname'];
echo "<tr>";
echo "<td>" . "$hitdate" . "</td>";
echo "<td>" . "$hiturl" . "</td>";
echo "<td>" . "$hitname" . "</td";
echo "</tr>";
}
echo "</table>";
mysql_close($db);
?>
</TD>
</TR>
</table>
</CENTER>
</body>
</html>
<?php
?>

Sure would appreciate anyhelp in finding out why nothing displays. Very frustrating, since I can see the data via phpMyAdmin!!!

cc_pagehits columns: ccpage,cchits
cc_refsource columns: ID,refip,refname,refdate

Running PHP4.3.2 'Register_globals OFF'

Thanks.

Natty_Dreadlock

hi,
what's this "WHERE 1" at the end of your sql queries?? leave em out, then it should work... btw, u output your vars like this:

echo "<td>" . "$page" . "</td>";

i think better and easier to type is:

echo "<td>$page</td>";

hth

phplearner

Natty_Dreadlock questioned:

what's this "WHERE 1" at the end of your sql queries??

Umh, I duplicated the query which works in phpMyAdmin & have seen in several books!

I took it out of both sections, but still not getting data to display.

BTW, tnx for the tip on the easier typing.

Natty_Dreadlock

ok, i dound the problem - i hope:
from the docu:

array mysql_fetch_array ( resource result [, int result_type])

u pass the db connections as the second parameter which is reserved for selecting the array type (associative or standard, default is both), so it does not work... just write $row = mysql_fetch_array($result)) instead of $row = mysql_fetch_array($result,$db)) .... hth

phplearner

Thank You, Thank You, Thank You !!!!!!!

I spent several hours going absolutely nutso with no success, and finally dropped into bed at 2:30AM exhausted.

You're great 😃

Natty_Dreadlock

not a problem sometimes the simple things r those u forget...