DaniWeb Forum Index > Web Development > PHP

how do i solve the below error

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jun 2007

Posts: 2

Reputation: dumisibanda is an unknown quantity at this point

Solved Threads: 0

dumisibanda dumisibanda is offline

Offline

Newbie Poster

how do i solve the below error

Jun 24th, 2007

Warning: mysql_fetch_assoc(): 3 is not a valid MySQL result resource in C:\Inetpub\wwwroot\BMF\Web\news.php on line 63

Records 1 to 2 of 2

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<table width="355" height="50" border="0" align="left">
  <tr>
    <td><strong>Date</strong></td>
    <td><strong>Subject</strong></td>
  </tr>
  <?php do { ?>
  <tr>
    <td> <a href="details.php?recordID=<?php echo $row_news['id']; ?>"> <?php echo $row_news['date']; ?>&nbsp; </a> </td>
    <td> <?php echo $row_news['subject']; ?>&nbsp; </td>
  </tr>
  <?php } while ($row_news = mysql_fetch_assoc($news)); ?> //line 63
</table>
<table width="355" height="50" border="0" align="left">
  <tr>
    <td><strong>Date</strong></td>
    <td><strong>Subject</strong></td>
  </tr>
  <?php do { ?>
  <tr>
    <td> <a href="details.php?recordID=<?php echo $row_news['id']; ?>"> <?php echo $row_news['date']; ?>&nbsp; </a> </td>
    <td> <?php echo $row_news['subject']; ?>&nbsp; </td>
  </tr>
  <?php } while ($row_news = mysql_fetch_assoc($news)); ?> //line 63
</table>

•

Join Date: May 2006

Posts: 1,422

Reputation: stymiee is on a distinguished road

Solved Threads: 35

stymiee

Offline

He's No Good To Me Dead

Re: how do i solve the below error

Jun 24th, 2007

That most likely means your query failed. You need to verify your query is correct. Echo it out to the screen and run it from the command line or echo out mysql_error() to see what the problem is.

John Conde
Brainyminds | Merchant Account Services | I Love Code
IT'S HERE: Merchant Accounts 101 Everything you need to know about merchant accounts!