Mysql_fetch_array(): supplied argument is not a valid MySQL result [duplicate]

Question

$query_user2 = mysql_query("SELECT TOP 1 * FROM $var WHERE id = (rand() * (SELECT MAX(id) FROM $var))");
$estrai2 = mysql_fetch_array($query_user2);

Problem: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

Why? :/

Please at least glance at the hundreds of questions about that error message here and elsewhere. Look at the "Related" sidebar for a start. — Mat
– Mat, Commented Nov 16, 2013 at 9:35
Probably because you have a syntax error in your query. Look at mysql_error() after you've run the query to find out what is happening. — user1864610
– user1864610, Commented Nov 16, 2013 at 9:35

Jaap Moolenaar · Accepted Answer · 2013-11-16 09:39:38Z

1

TOP 1 is a sql server ( not MySQL ) command to select the first row, remove that and add LIMIT 1 to the end of the query.

you might want to alter your question. The problem is your query, not the "supplied argument is not a valid mysql result"

answered Nov 16, 2013 at 9:39

Jaap Moolenaar

1,0806 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1