Jump to content

sql error, someone point me in the right direction?


jesushax

Recommended Posts

hi below is my code

 

<?php
$max = 10; //amount of articles per page. change to what to want
$p = @$_GET['p'];
if(empty($p))
{
$p = 1;
}
$limits = ($p - 1) * $max; 

//view all the news articles in rows
$NotesQuery = mysql_query("SELECT * FROM tblCompanyNotes WHERE md5(UserID)='".$ID."' ORDERBY NotesDate DESC LIMIT ".$limits.",$max") or die(mysql_error());
//the total rows in the table
$totalres = mysql_result(mysql_query("SELECT COUNT(NotesID) AS tot FROM tblCompanyNotes"),0);	
//the total number of pages (calculated result), math stuff...
$totalpages = ceil($totalres / $max); 
?>

 

and  get error

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDERBY NotesDate DESC LIMIT 0,10' at line 1

 

any ideas as why?

 

thanks

 

<?php
$NotesQuery = mysql_query("SELECT * FROM tblCompanyNotes WHERE md5(UserID)='".$ID."' ORDER BY NotesDate DESC LIMIT ".$limits.",$max") or die(mysql_error());

?>

 

 

Isn't the correct syntax ORDER BY?, if that's not it, check the md5 encrypte, otherwise I don't know, don't see any other obvious errors.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.