Weblabor

$msgfiles = mysql_query("SELECT msg_id, userid, name, newname, size, type FROM files_temp WHERE msg_id='".$msgid."'") or die(mysql_error());
		
while ($row = mysql_fetch_array($msgfiles)) 
{
     mysql_query("INSERT INTO files (id, msg_id, userid, name, newname, size, type) VALUES (0, '".$row['msg_id']."', '".$row['userid']."', '".$row['name']."', '".$row['newname']."', '".$row['size']."', '".$row['type']."')") or die(mysql_error());
}

CREATE TABLE forumtemak (
   id SMALLINT UNSIGNED NOT NULL auto_increment,
   cim VARCHAR(50) NOT NULL default '',
   leiras TEXT NOT NULL,
   PRIMARY KEY (id)
);

CREATE TABLE hozzaszolasok (
    id SMALLINT UNSIGNED NOT NULL auto_increment,
    forumid SMALLINT unsigned NOT NULL,
    nev VARCHAR(50) NOT NULL default '',
    email VARCHAR(50) NOT NULL default '',
    comment TEXT NOT NULL,
    datum DATETIME NOT NULL default '0000-00-00 00:00:00',
    re SMALLINT default '0',
    PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS juzerz (
   azonosito VARCHAR(20) NOT NULL,
   becenev VARCHAR (20),
   ...
   PRIMARY KEY (azonosito)
);

SELECT hozzaszolasok.*, forumtemak.*, juzerz.azonosito, juzerz.becenev FROM hozzaszolasok, forumtemak
   LEFT OUTER JOIN juzerz
   ON SUBSTRING(hozzaszolasok.nev, 2) = juzerz.azonosito
   WHERE hozzaszolasok.forumid = forumtemak.id 
   GROUP BY hozzaszolasok.forumid
   DESC