jesushax Posted March 12, 2008 Share Posted March 12, 2008 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 Quote Link to comment Share on other sites More sharing options...
unsider Posted March 12, 2008 Share Posted March 12, 2008 <?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. Quote Link to comment Share on other sites More sharing options...
jesushax Posted March 12, 2008 Author Share Posted March 12, 2008 indeed it is, thankyou very much Quote Link to comment Share on other sites More sharing options...
unsider Posted March 12, 2008 Share Posted March 12, 2008 Welcome, good luck with your project. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.