Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: [assombracao] randon results

Quote Reply
Re: [assombracao] randon results In reply to
Hi,

You could do something like below:

$self->{db}->select_options("ORDER BY RAND() LIMIT 0,1");
my $rec = $self->{db}->select({field_name => ['New','Discount']})->fetchrow_hashref;

Cheers,
Jean
Gossamer Threads Inc.

Last edited by:

jean: Feb 26, 2003, 1:58 PM
Subject Author Views Date
Thread randon results assombracao 6559 Nov 22, 2002, 9:29 AM
Post Re: [assombracao] randon results
assombracao 6297 Feb 24, 2003, 3:26 PM
Thread Re: [assombracao] randon results
jean 6313 Feb 26, 2003, 11:50 AM
Thread Re: [jean] randon results
assombracao 6293 Feb 26, 2003, 6:56 PM
Thread Re: [assombracao] randon results
assombracao 6268 Mar 4, 2003, 4:04 PM
Thread Re: [assombracao] randon results
assombracao 6160 May 27, 2003, 2:39 PM
Thread Re: [assombracao] randon results
604 6131 May 30, 2003, 1:55 PM
Thread Re: [TheStone] randon results
assombracao 6098 Jun 14, 2003, 9:33 AM
Thread Re: [assombracao] randon results
604 6100 Jun 14, 2003, 9:22 PM
Post Re: [TheStone] randon results
assombracao 5731 Dec 17, 2004, 10:16 AM