deniz3n [Opera/9.80]

kalo FULL TEXT KEY masuk kategory primary key bukan y, tanpa key ini search.php q g berfungsi alias 0 query mulu ('coz pernah back up n restore data pake 'bigdump' hslxa FULL TEXT KEY xa hlg g keback up ulang), btw fungsi JOIN banyak dipake di jcms yaitu dg mengambil data dari tabel laen (misal tabel `users`) yg diperlukan jika data dari tabel utama (misal tabel `forum`) tdk ada/kurang lengkap, nee q copasin contohxa:
$req = mysql_query("SELECT `forum`.*, `users`.`sex`, `users`.`rights`, `users`.`lastdate`, `users`.`postforum`, `users`.`status`, `users`.`datereg`
FROM `forum` LEFT JOIN `users` ON `forum`.`user_id` = `users`.`id`
WHERE `forum`.`type` = 'm' AND `forum`.`refid` = '$id' " . ($rights >= 7 ? "" : " AND `forum`.`close` != '1'") . "
ORDER BY `forum`.`id` DESC LIMIT 5");

[Reply]

  • Tue, 13 Sep 2011 22:39:09 +0700