[Resolved] ORDER BY problem

[bailo81]

Hi, i have the following code and it works fine for extracting info from my database with a limit for each page:

 $sql  = "SELECT * FROM catalogue_$user " .
		    "WHERE item_type   =" . $_GET['type'].
			"LIMIT $limitvalue, $limit";

but when i try to add a line to make it order it:

     $sql  = "SELECT * FROM catalogue_$user " .
		    "WHERE item_type   =" . $_GET['type'].
			"ORDER BY item_name" .
			"LIMIT $limitvalue, $limit"; 

it gives me the following error:

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 '0, 5ORDER BY item_name' at line 1

Any suggestions would be much appreciated!!!

[acrabadabra]

Put some spaces in your syntax.

" ORDER BY item_name" . 
" LIMIT $limitvalue, $limit";

[bailo81]

thats superb, thankyou