Invalid Reesource

[jedney]

I am tyring to do some PHP code, and I have run into an error.  The code looks fine, but I am new to PHP.  Any help?

 

<?    // DISPLAY NAVIGATION INFORMATION 
    $query = "SELECT * FROM news LIMIT 5 DESC"; 
    $result = mysql_query($query); 
    while ($row = mysql_fetch_array($result)) {
    echo "". $row["url"] .""; echo "</td>";
      echo "</tr>";
      echo "<tr>";
        echo "<td class=\"copyright\">Posted on ". $row["date"] ." at ". $row["time"] ." by ". $row["author"] ."</td>";
      echo "</tr>";
      echo "<tr>";
        echo "<td class=\"norm\">". $row["content"] ."</td>"; }
	?>

 

The error is this line:

while ($row = mysql_fetch_array($result)) {

 

Thank you!!

 

-Jon

[mpharo]

try this and see if you get an error...

 

I am tyring to do some PHP code, and I have run into an error.  The code looks fine, but I am new to PHP.  Any help?

 

<?    // DISPLAY NAVIGATION INFORMATION 
    $query = "SELECT * FROM news LIMIT 5 DESC"; 
    $result = mysql_query($query) or die(mysql_error()); 
    while ($row = mysql_fetch_array($result)) {
    echo "". $row["url"] .""; echo "</td>";
      echo "</tr>";
      echo "<tr>";
        echo "<td class=\"copyright\">Posted on ". $row["date"] ." at ". $row["time"] ." by ". $row["author"] ."</td>";
      echo "</tr>";
      echo "<tr>";
        echo "<td class=\"norm\">". $row["content"] ."</td>"; }
	?>

 

The error is this line:

while ($row = mysql_fetch_array($result)) {

 

Thank you!!

 

-Jon

[rhodesa]

The problem is DESC. Are you trying to order it? Which field are you trying to order by? It should look something like this:

SELECT * FROM news ORDER BY myfield DESC LIMIT 5

[DyslexicDog]

Do you create a connection to the database somewhere else in the code because I don't see it here?

[jedney]

Thank you, that line was the problem.

 

Yes, the connection is elsewhere in the document.

 

Thank you,

-Jon