limiting search

[germon]

I only want to records on this page were the value lot has been duplicated within the colum lot. can anyone help me here please.

$query = "SELECT * FROM main GROUP BY lot ORDER BY time, part LIMIT $start, $display";

God bless -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[divinepower]

Code:
query = "SELECT
foo,
bar,
qux,
lot
FROM main
GROUP BY lot
having count(lot) > 1
ORDER BY
time,
part
LIMIT $start, $display"; -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --