hi everyone! i'm new here (and new to php) and have a question. i'm trying
to run a simple blogger type script but am running into a problem i can't
seem to troubleshoot. first, the three items i put into the database aren't
showing up on my page and then when i try to go to the archive for the
month, i get the following:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result
resource in /home/blar/public_html/inc/main_inc.php on line 11
here's a part of my code of main_inc (first line is line 11):
function showPosts($result,$page)
{
if ($myrow = mysql_fetch_array($result))
{
do
{
$rawdate = $myrow["postDate"];
$formdate = date("l, F j, Y",
(strtotime(ereg_replace('([0-9]*)-([0-9]*)-([0-9]*)','\2/\3/\1',
$rawdate))));
if ($date != $formdate)
{
$date = $formdate;
?>
<!-- Formatting for date -->
<b><?=$formdate;?></b><br>
<br>
<?
}
if ($page == 1)
{
showArchivePost($myrow);
}
else
{
showMainPost($myrow);
}
}
while ($myrow = mysql_fetch_array($result));
}
}
/code
thank in advance for any help. :)
jonni b.
http://blar.org
http://uglypropaganda.com