I resolve all the errors but this one..

nawar youssef · October 20th, 2011, 12:48 AM

I still have this error which I found no way to solve;
its :

Code:

public static function getMembers($startRow, $numRows, $order) {
			$conn = parent::connect();
			$sql = "SELCET SQL_CALC_FOUND_ROWS * FROM" . TBL_MEMBERS . "ORDER BY $order LIMIT :startRow, :numRows";

and the browser tells me that the syntax of SQL is not correct and I am sure of that and checked the documentation of the same sql that I have.
so whats the next step. thank you

UseLess · October 20th, 2011, 08:58 AM

Greetings,

Try:

Code:

$sql = "SELCET SQL_CALC_FOUND_ROWS * FROM " . TBL_MEMBERS . " ORDER BY $order LIMIT :startRow, :numRows";

Added a space before and after TBL_MEMBERS, because if there are no spaces in the table name then the sql would end up being;

Code:

$sql = "SELCET SQL_CALC_FOUND_ROWS * FROMmembersORDER BY $order LIMIT :startRow, :numRows";

the above assumes the members table is simply called 'members'.

nawar youssef · October 21st, 2011, 12:14 AM

you know its very hard to find such a bug if you are not used to.
at first I added the space in one part, becasue I did not read you comment well and did not work. but after that I correct them, thanks