Jump to content

Question about order by RAND() alternative


LanceT
 Share

Recommended Posts

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.

 

 

Link to comment
Share on other sites

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);

Link to comment
Share on other sites

This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.