Select Random Field From Row in mySQL ??

Jamez

Hi All,

Im working on a small project where I need to select a random field...

The TABLE is setup like this:

id | cat1 | cat2 | cat3 | cat4
01 | computer | internet | Web | Technology
02 | finance | investment | Money | Accounting

So I want the end result to echo a random feild from row 1 and row 2.....

I figured out how to select random rows.. but how can i select random fields 😕

cheese

As no one has answered, I will give you my dodgy code that will be close;


$thing = rand(0, numberoffields-1);


$query = mysql_query("SELECT * FROM table");

while ($row = mysql_fetch_array($query, MYSQL_NUM))
{

echo $row[$thing];

}

// or



$query = mysql_query("SELECT * FROM table");

while ($row = mysql_fetch_array($query, MYSQL_NUM))
{

$thing = rand(0, numberoffields-1);

echo = $row[$thing];

}

I think this should do it. Like I say, my code is fairly crude, but I hope it helps.

Cheers,

Neil.