Random relation

[hagman]

CREATE TABLE `events` (
  `id` int(3) unsigned NOT NULL auto_increment,
  `event` varchar(255) NOT NULL default '',
  `date` timestamp(8) NOT NULL,
  `unique` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `unik` (`unique`)
) TYPE=MyISAM;

CREATE TABLE `gallery` (
  `id` int(3) unsigned NOT NULL auto_increment,
  `ext` varchar(4) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `event` int(3) unsigned NOT NULL default '0',
  `width` int(4) NOT NULL default '0',
  `height` int(4) NOT NULL default '0',
  `width_nail` int(4) NOT NULL default '0',
  `height_nail` int(4) NOT NULL default '0',
  `unique` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `unik` (`unique`)
) TYPE=MyISAM;

I have two tables one is the gallery and the other one is table for events so I can categorise the images.

Now I wan't to get all the rows from events (id, event, date) in cronological order by date. But I also wan't a random row (id, , ext, *_nail) from the gallery where gallery.event is equal to event.id.

In pratical speech; I wan't to list the events and show a random image from that category.

[PurpleMonkey]

When getting the random image you could put a rand(min,max);
and declare it as a variable so you can use it in your SQL, as shown below:

$num = rand(0,10);

$sql = "select id from gallery where id = $num";

[hagman]

Originally posted by PurpleMonkey
When getting the random image you could put a rand(min,max);
and declare it as a variable so you can use it in your SQL, as shown below:

$num = rand(0,10);

$sql = "select id from gallery where id = $num";

[/B]

That does not do the trick because the rows doesn't always have a complete range of id's. I must somehow get RAND() in the order by clause.