How to output JOINed tables?
- by ilhan
$id=(int)$_GET["id"];
$result = mysql_query("SELECT questionstable.*, categorytable.name
FROM questionstable
INNER JOIN categorytable
ON categorytable.id = questionstable.category
WHERE id=$id");
$row = mysql_fetch_assoc($result);
Warning: mysql_fetch_assoc() expects
parameter 1 to be resource, boolean
given in C:\Program
Files\EasyPHP-5.3.4.0\www\scsoru.php
on line 33