Code: Select all
$sql = "SELECT I.*,IT.name as itname,RB.firstname FROM jtrd_items I,jtrd_itemtypes IT LEFT JOIN jtrd_repby RB ON I.itemid=RB.repid WHERE I.itypeid=IT.id AND I.uid!=$uID $st_sql $nametitle_sql $nw_sql $mod_sql $limits";
$result = mysql_query($sql) or die ("Wrong SQL query! $sql " . mysql_error());
while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$ret[$row['itemid']] = $row;
}Here it is again but easier to read:
Code: Select all
$sql = "
SELECT I.*,
IT.name as itname,
RB.firstname FROM jtrd_items I,
jtrd_itemtypes IT LEFT JOIN jtrd_repby RB ON I.itemid=RB.repid
WHERE I.itypeid=IT.id
AND I.uid!=$uID
$st_sql
$nametitle_sql
$nw_sql
$mod_sql
$limits";Can someone help me out with at LEAST understanding this thing? I mean I have 5years of MySQL experience but this stuff is a first. Oh and I should tell you this works on his OLDER MySQL server but not on my NEWER version of MySQL I have on my personal development server.