How to output JOINed tables?

Posted by ilhan on Stack Overflow See other posts from Stack Overflow or by ilhan
Published on 2010-12-22T23:42:28Z Indexed on 2010/12/23 6:54 UTC
Read the original article Hit count: 272

Filed under:
|
|
|
|
$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

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql