Question about order by RAND() alternative

[LanceT]

Here is fenway's code

 

SELECT * FROM tablename
WHERE id >= FLOOR( RAND( ) * ( SELECT MAX( id ) FROM tablename ) )
ORDER BY id ASC
LIMIT 1

 

My original code was

 

SELECT * FROM tablename WHERE (hello='1' OR hello2='1')

 

But how do I add the second where query to the first code? I tried simply pasting it into the query and it didn't work.

 

Please help.

 

 

[bubblegum.anarchy]

Probably something like this:

 

SELECT * FROM tablename 
WHERE ( hello = '1' OR hello2 = '1' ) AND id >= FLOOR( RAND( ) * ( SELECT MAX( id ) FROM tablename ) )
ORDER BY id ASC
LIMIT 1

[LanceT]

I get a

 

Parse error: syntax error, unexpected T_STRING

 

After doing that.

[LanceT]

Heres the whole code so you guys can see if I typed something in wrong

 

$buddyquery = mysql_query(SELECT * FROM buddies 
WHERE (requester='$user' OR requestee='$user') AND id >= FLOOR( RAND( ) * ( SELECT MAX( id ) FROM buddies ) ) 
ORDER BY id ASC 
LIMIT 6);

[bubblegum.anarchy]

Add quotes to the query string.

[LanceT]

oh man I am stupid. Wow. Wow. :-X

[LanceT]

OK now theres a new problem. Since I wanted 6 random entries to show, now its only giving me sometimes 3-4 entries. Please help!