[unclematty]

I am looking to pull back 5 random rows in a query. Can someone please help.

I tried this but it was not what I was looking for.

select rand(products_id)
from products_desc

[YourPHPPro]

Originally Posted by unclematty

I am looking to pull back 5 random rows in a query. Can someone please help.

Try this:

http://www.squeekmachine.co.uk/code.php?s=5&c=94

or

http://www.desilva.biz/mysql/random.html

[pack tloss]

Try this..

PHP Code:

//select 5 random rows

$sql = mysql_query("SELECT products_id FROM products_desc ORDER BY RAND LIMIT 5") or die(mysql_error());

while($row = mysql_fetch_object($sql))

 {

  // print product ids

  print("$row->products_id <BR>");

 } 

[eddyvlad]

Is $row->products_id the same as $row['products_id']?

[fyrestrtr]

no.

if you use mysql_fetch_obj -- you will get an object in return (which is $row->products_id)

if you use mysql_fetch_array, mysql_fetch_assoc you get an array in return ( which, in case of mysql_fetch_assoc, is $row['products_id'])

So, same information, a few ways of returning it

[unclematty]

thanks everyone. this did it...

SELECT products_id
FROM products_description
ORDER BY RAND( )
LIMIT 5