<?php
# Output last 5 used categories
$sql = "SELECT
inquiries.category, categories.name, categories.id
FROM
inquiries, categories
WHERE
userid='$userid'
JOIN
category
ON
inquiries.category = categories.id
ORDER BY
inquiries.createdate
DESC LIMIT 5";
$res = $mysqli->query($sql);
while($cat = $res->fetch_array()) {
echo '<option value="'.$cat['categories.id'].'">'.$cat['categories.name'].'</option>';
}
?>
<b>Fatal error</b>: Call to a member function fetch_array() on a non-object in <b>/home/d/i/ftp_dinethdk/m/inquiry.php</b> on line <b>196</b><br />
<b>Warning</b>: mysqli_error() expects exactly 1 parameter, 0 given in <b>/home/d/i/ftp_dinethdk/m/inquiry.php</b> on line <b>194</b><br />
<br />
<b>Fatal error</b>: Query Failed! SQL:
SELECT
inquiries.category, categories.name, categories.id
FROM
inquiries, categories
WHERE
userid='6'
JOIN
category
ON
inquiries.category = categories.id
ORDER BY
inquiries.createdate
DESC LIMIT 5 - Error: in <b>/home/d/i/ftp_dinethdk/m/inquiry.php</b> on line <b>194</b><br />
SELECT
inquiries.category, categories.name, categories.id
FROM
inquiries, categories
JOIN
category
ON
inquiries.category = categories.id
WHERE
userid='$userid'
ORDER BY
inquiries.createdate
DESC LIMIT 5
$sql = "SELECT
inquiries.category, categories.name, categories.id
FROM
inquiries
INNER JOIN
categories
ON
inquiries.category = categories.id
WHERE
userid='$userid'
ORDER BY
inquiries.createdate
DESC LIMIT 5";
$sql = "SELECT
inquiries.category , categories.name, categories.id
FROM
inquiries
INNER JOIN categories ON inquiries.category = categories.id
WHERE
userid = '$userid'
GROUP BY
inquiries.category
ORDER BY
inquiries.createdate
DESC
LIMIT 2";
In truth, “select distinct” is a rather dull animal with minimal decision making powers."select distinct" is the most abused, and most misunderstood, SQL feature IMO. Use it sparingly.
$sql = "SELECT
inquiries.category , categories.name, categories.id
FROM
inquiries
INNER JOIN categories ON inquiries.category = categories.id
WHERE
userid = '$userid'
GROUP BY
inquiries.category
ORDER BY
MAX(inquiries.createdate) DESC
LIMIT 2";
$sql = "SELECT inquiries.category , categories.name, categories.id
FROM inquiries
INNER JOIN categories ON inquiries.category = categories.id
WHERE userid = '$userid'
GROUP BY inquiries.category , categories.name, categories.id
ORDER BY MAX(inquiries.createdate) DESC LIMIT 2";
Open in new window