mysql_fetch_array(): supplied argument is not a valid MySQL

[radian]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\WebServer\www\tests\index.php

 

getting this error with

<?php
mysql_connect("localhost", "root", "");
mysql_select_db("news");
$return = mysql_query('SELECT * FROM news ORDER BY id DESC LIMIT 0, 10');
while ($data = mysql_fetch_array($return))
{
?>
<div class="news">
    <h3>
        <?php echo $data['title']; ?>
        <em> - <?php echo date('m/d/Y H\hi', $data['timestamp']); ?></em>
    </h3>
    
    <p>
    <?php
    $content = nl2br(stripslashes($data['content']));
    echo $content;
    ?>
    </p>
</div>
<?php
}
?>

[sklein99]

Looks OK to me... does the query run OK when you do it directly in the DB (e.g. go to PHPMyAdmin or whatever you use and run the exact query in SQL)?

 

You can also use mysql_error to troubleshoot.

[radian]

The SQL query was fine. after checking the database, i realised I had put "it" as a field and not "id".

 

Such a simple mistake.

 

Thanks anyway