форум вебмастероff на AlfaSpace.NET

SELECT * FROM tbl ORDER BY RAND() LIMIT 3 

 Tabellenstruktur fьr Tabelle `slaed_stories` 
# 

CREATE TABLE `slaed_stories` ( 
`sid` int(11) NOT NULL auto_increment, 
`catid` int(11) NOT NULL default '0', 
`aid` varchar(30) NOT NULL default '', 
`title` varchar(80) default NULL, 
`time` datetime default NULL, 
`hometext` text, 
`bodytext` text NOT NULL, 
`comments` int(11) default '0', 
`counter` mediumint(8) unsigned default NULL, 
`topic` int(3) NOT NULL default '1', 
`informant` varchar(20) NOT NULL default '', 
`notes` text NOT NULL, 
`ihome` int(1) NOT NULL default '0', 
`alanguage` varchar(30) NOT NULL default '', 
`acomm` int(1) NOT NULL default '0', 
`haspoll` int(1) NOT NULL default '0', 
`pollID` int(10) NOT NULL default '0', 
`score` int(10) NOT NULL default '0', 
`ratings` int(10) NOT NULL default '0', 
`associated` text NOT NULL, 
PRIMARY KEY  (`sid`), 
KEY `sid` (`sid`), 
KEY `catid` (`catid`), 
KEY `counter` (`counter`), 
KEY `topic` (`topic`) 
) TYPE=MyISAM; 

# -------------------------------------------------------- 

$sql = "SELECT T.topicid, T.topicname, T.topicimage, T.topictext, SUM(S. 
counter) AS sum_counter, COUNT(DISTINCT(S.sid)) AS count_stories FROM ".$prefix. 
"_topics T LEFT JOIN ".$prefix."_stories S ON S.topic=T.topicid WHERE time <= NO 
W() GROUP BY T.topicid ORDER BY T.topicname"; 
$result = $db->sql_query($sql); 
while ($row = $db->sql_fetchrow($result)) { 
    $topicid = intval($row['topicid']); 
    $topicname = stripslashes($row['topicname']); 
    $topicimage = stripslashes($row['topicimage']); 
    $topictext = stripslashes(check_html($row         ['topictext'], "nohtml")); 
    $reads = intval($row['sum_counter']); 
    $numrows = intval($row['count_stories']); 
    ..и так далее