Re: Help!
| From: | Matthew Fonda | Date: | Sat, 26 Mar 2005 17:18:43 +0000 |
| Subject: | Re: Help! | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-211621@lists.php.net to get a copy of this message | ||
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>';
>
> ?>
>
>
>