Error when I try to add a select limit

Question

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\me.php on line 30

$sql = mysql_query('SELECT * FROM cms_alert limit WHERE user_id = '.$user->row['id'].', 10');
while($row = mysql_fetch_assoc($sql)){

Does someone know what's te problem?

What are you actually trying to achieve? The generated SQL does not make much sense. — Joachim Isaksson, Jul 19 '14 at 07:18

Vijayaragavendran · Answer 1 · 2014-07-19T07:41:14.763

0

You wrongly added the keyword limit before where

Try this

$sql = mysql_query('SELECT * FROM cms_alert WHERE user_id = '.$user->row['id'].' LIMIT 10');

edited Jul 19 '14 at 07:41

answered Jul 19 '14 at 07:17

Vijayaragavendran

1

Well, actually there is a LIMIT in the query already, just not in a place that makes sense. – Joachim Isaksson Jul 19 '14 at 07:18
I still get the same error. I want that there just a limit for alerts that get displayed for users then it's not a flood when someone has many alerts on he's userid. – Generator Jul 19 '14 at 07:19
ho i didnt notice the limit , edited my code – Vijayaragavendran Jul 19 '14 at 07:20
Has someone a solution? I've tried to add it after where but still the same error. – Generator Jul 19 '14 at 07:34
try adding before while loop `if(!$sql){ echo mysql_error(); }` – Vijayaragavendran Jul 19 '14 at 07:37
remove the comma before the LIMIT – Vijayaragavendran Jul 19 '14 at 07:41

TBI · Answer 2 · 2014-07-19T07:35:46.137

0

Try using this -

$sql = mysql_query('SELECT * FROM cms_alert WHERE user_id = '.$user->row['id'].' limit 0,10');

edited Jul 19 '14 at 07:35

answered Jul 19 '14 at 07:20

TBI

Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\xampp\htdocs\me.php on line 29 Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, null given in C:\xampp\htdocs\me.php on line 30 – Generator Jul 19 '14 at 07:24
@Generator The answer does not use `mysqli_query`, but your error message does. You cannot mix mysql_ calls with mysqli_ calls. – Joachim Isaksson Jul 19 '14 at 07:36
Have you tried the query in your table directly ? Use static userid and run it once. – TBI Jul 19 '14 at 07:36

score 0 · Answer 3 · answered Jul 19 '14 at 07:21

0

Please see the syntax for SELECT;

In your case you need to write LIMIT after your WHERE condition.

answered Jul 19 '14 at 07:21

H. Mahida

Muhammad Ali · Answer 4 · 2014-07-19T07:30:38.123

0

if you are using php5.5 then mysql_fetch_assoc is deprecated see here

you can use mysqli driver

and make you query in double quotation single quotation is for varchar

 mysql_query("SELECT * FROM cms_alert WHERE user_id = '".$user->row['id']."' limit 0,10);

edited Jul 19 '14 at 07:30

answered Jul 19 '14 at 07:21

Muhammad Ali

Yes I did that. I also tried to add it after WHERE but I get the error Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\me.php on line 30 – Generator Jul 19 '14 at 07:28
make you query between double quotation – Muhammad Ali Jul 19 '14 at 07:31

score 0 · Answer 5 · answered Jul 19 '14 at 07:34

0

You are using invalid SQL Query it should be

SELECT * FROM table_name WHERE id=some_id LIMIT 0, 20

answered Jul 19 '14 at 07:34

Shushant

5 Answers5