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 Link to comment https://forums.phpfreaks.com/topic/95777-sql-error-someone-point-me-in-the-right-direction/ 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. Link to comment https://forums.phpfreaks.com/topic/95777-sql-error-someone-point-me-in-the-right-direction/#findComment-490327 Share on other sites More sharing options...
jesushax Posted March 12, 2008 Author Share Posted March 12, 2008 indeed it is, thankyou very much Link to comment https://forums.phpfreaks.com/topic/95777-sql-error-someone-point-me-in-the-right-direction/#findComment-490332 Share on other sites More sharing options...
unsider Posted March 12, 2008 Share Posted March 12, 2008 Welcome, good luck with your project. Link to comment https://forums.phpfreaks.com/topic/95777-sql-error-someone-point-me-in-the-right-direction/#findComment-490335 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.