[SOLVED] mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource

Andrew Cade · #1 (**permalink**) 05-04-09, 06:03 AM

PHP Code:


			
<?

include('connect.php');

$query = "SELECT body, title, DATE_FORMAT(date,'%D %M %Y') AS date FROM site_notams WHERE notamid = {$_GET['id']}";

$result_notam = mysql_query($query);

$row_notam = mysql_fetch_assoc($result_notam);

?>

<html>

<h4>NOTAMs</h4>

<?php do { ?>

    <h3>NOTAM <?php echo $row_notam['title']; ?> <?php echo $row_notam['date']; ?></h3>

    <div class="content-list"><?php echo $row_notam['body']; ?></div>

    <p align="center">[<a href="notams.html">View all NOTAMs</a>]</p>

    <?php } while ($row_notam = mysql_fetch_assoc($result_notam)); ?>

</html>

Can you help me please, I am not sure what is wrong here.
EDIT: Would this give me an error 500??

Site: oman-ivao.net/atc

Nico · #2 (**permalink**) 05-04-09, 06:31 AM

Are you sure it's actually this script that causes the 500 error, and not an htaccess file?

If you're sure, try using the FULL opening tags for PHP, <?php, rather than the short tags (<?).

Andrew Cade · #3 (**permalink**) 05-04-09, 06:51 AM

Quote:

Originally Posted by Nico

Are you sure it's actually this script that causes the 500 error, and not an htaccess file?

If you're sure, try using the FULL opening tags for PHP, <?php, rather than the short tags (<?).

There is no htaccess file, how do I go about making one?