How to use parameters in sql ?(PHP)

[afraze]

I want to write this sql query:

Select * from table1 limit 0,5

when i wanted to use php parameter for this query, i got syntax error.

My code:

[PHP]...
$count = 0;
...
mysql_query("Select * from table1 limit".$count.",5");[/PHP]

So how can i fix the syntax problem for using the parameter in sql?

[ak1dnar]

Hi There!
Welcome to TSDN!

Try This

[PHP] mysql_query("Select * from table1 limit $count,5");[/PHP]

Or

[PHP] mysql_query("Select * from table1 limit {$count},5");[/PHP]

[afraze]

Thanks so much for your interest!. . .

[ak1dnar]

Thanks so much for your interest!. . .

So does it works afraze?

[afraze]

ajaxrand,

i am not using my personal comp.. So i 'll answer u after a couple of hours.. nearly 22:00 (my pos: gmt + 2)

see u later

[afraze]

ajaxrand,

Your code doesn't work . . .

i have still syntax problem.. :(

[realin]

ajaxrand,

Your code doesn't work . . .

i have still syntax problem.. :(

the code is perfect, it should work.. paste the error ;)

that would help us

[afraze]

Ajaxrand,
i fixed my problem. Yes your code is perfect. i had a character problem. So thnks again..

[ak1dnar]

Ajaxrand,
i fixed my problem. Yes your code is perfect. i had a character problem. So thnks again..

Ahha, Glad to hear that.
post back any time if you have any doubts!

-Ajaxrand