Hi Jonni!
You should consider wrapping mysql_fetch_*() functions into a
personalized function which also takes care of errors - at least for
debugging. Your problem is typical - your query has some problems and
mysql_run_query() returns a null result, which is indeed not a valid
MySQL result resource. What you should do is to run something like
$result=mysql_run_query(<your SQL here>);
if (!$result) {
echo("<B>MySQL query error in query </B><I>".
<your SQL here>."</I><BR />\n");
echo(mysql_error());
}
and debug the SQL. Now that's tedious to write for every, and that's why
I was suggesting wrapping the thing into a function - but that's
obviously not mandatory as long as you can debug it, right? :-)
Another idea while I'm on the topic, if you do create a wrapper, you may
also consider sending yourself an e-mail if an error occurs after
everything works right - that way you'll be able to track errors quickly
- and impress your customers!
HTH
Bogdan
Jonni wrote:
> 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
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
