random number

hi everybody im trying to cycle through a list of numbers in the database is it possible

if(!$_GET['categ_id']) $_GET['categ_id'] = 1;

Code (markup):

to example:

if(!$_GET['categ_id']) $_GET['categ_id'] = 1,2,3;

Code (markup):

1 2 and three being the category id's thanx in advance

 

You can define an array to hold multiple values like 1,2,3 or store it as csv in a string.

 

so the example should work?

 

Be a bit more specific on what you intend to do with the list of numbers.

 

the numbers are categories in the script i need it to cycle through the categories aka the numbers to make my page look fresh

 

1) You can't assign a value to a $_GET.

2) $category = isset($_GET['categ_id']) ? $_GET['categ_id'] : rand(1, 3);

If $_GET['categ_id'] is being sent to the file you'll use that. Otherwise you'll get a random number from 1 to 3.

 

mysql_query("SELECT * FROM categ_id ORDER BY RAND() LIMIT 10"); // for 10 results

 

only one category can be called at a time this will work?

 

mysql_query("SELECT * FROM categ_id ORDER BY RAND() LIMIT 1"); // for 1 random category

 

hmm i tried them all and nothing changes just load like normal