Creating a MySQL query using WHERE, ORDER BY RAND()

Question

I've been playing around with this query for a while but I'm getting the:

    Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in 
C:\xampp\htdocs\Manny\FantasyMockProject\test.php on line 50

Which is telling me I'm not using the query correctly. My original query is like so:

$simulateQuery1 = mysql_query("SELECT * FROM player2 WHERE 
preranking >= " .$_SESSION['max_pick']. " ORDER BY RAND() LIMIT 1");

I want to return all columns from the player2 table where preranking >= $_SESSION['max_pick'] also I want to include the ORDER BY RAND() LIMIT 1

Is this possible using only 1 query? Thanks.

[EDIT: Found the mistake. I had missing ' ' around my Session variable.]

@CBroe That wasn't my question why the thumbs down? My question was combining the queries together. — GeekByDesign, May 08 '14 at 00:07
echo out your query and/or your `mysql_error()` result and you will see the problem. — Mike Brant, May 08 '14 at 00:10
Add error reporting to the top of your file(s) `error_reporting(E_ALL); ini_set('display_errors', 1);` — Funk Forty Niner, May 08 '14 at 00:15
The answers in this question tell you how to look for the _reason_ of the error you’re getting, which you completely neglected to do before asking. — CBroe, May 08 '14 at 00:25

score 1 · Answer 1 · answered May 08 '14 at 00:06

1

Your query is broken. The reason is that you should add a space before ORDER. So basically:

$simulateQuery1 = mysql_query("SELECT * FROM player2 WHERE 
preranking >= " .$_SESSION['max_pick']. " ORDER BY RAND() LIMIT 1");

The error message says "boolean given" because a broken query returns FALSE, which is a boolean.

answered May 08 '14 at 00:06

David

1 Answers1