Hi alternate_dph, > Suppose I'm connected to a database and I do the following: > > $query = "Select q_id, question From questions Order by q_id"; > > $result = mysql_query($query); > > Now, what is the best way to pull out 20 random rows from my questions > table? $query = "SELECT q_id, question FROM questions ORDER BY RAND() LIMIT 0, 20";
This will give you 20 random records. Marc Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/php-list/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
