Posted by Matthew Fonda on 03/26/05 19:18

Chances are you are not connected to the database, or you have a MySQL error
somewhere along the lines. Try using mysql_error() to help find whats going
on.

<MIKEYTF@aol.com> wrote in message news:1de.38096c99.2f76df7c@aol.com...
> I get this error: Warning: mysql_fetch_row(): supplied argument is not a
> valid MySQL result resource in /home/helljump/public_html/php/index.php on
line 39
>
> and I am connecting to the database!
>
> Here is line 39:
>
> <?php
>
> $query=mysql_query("SELECT
> boardid,boardname,boardcaption,topics,messages,views FROM boards ORDER BY
id ASC");
> while($row=mysql_fetch_row($query)) echo '<tr ',shading(),'><td><a
>
href="http://subzer0.net/php/topics.php?board='.$row[0].'">'.$row[1].'</a></
td><td>
> '.$row[2].'</td><td>'.$row[3].'</td><td>'.$row[4].'</td></tr>';
>
> echo '<tr class="cell1"><td align="center" colspan="10"><b>User
Options</b><
> /td></tr><tr ',shading(),'><td>Use your <a
href="/php/board_manager.php">board
> manager</a> to add or remove boards from the index.</td></tr><tr
',shading(),'>
> <td><a href="/php/meta_mod.php">Meta-Moderate</a> to give feedback to the
> staff of '.$config['sitename'].'</td></tr>';
>
> ?>
>
>
>

[Back to original message]