It's hard to explain. I want to display 16 records
I want to first find the first record with $top set to 1 then show if first
The do another query and display 15 more normal records but if the one showen above comes up to leave it out.
This is what I have
<?php
$result = mysql_query ("SELECT * From news WHERE top = 1 order by id desc limit 1");
while ($row = mysql_fetch_array($result)) {
$top = $row[id];
echo "Stuff":
}
$result2 = mysql_query ("SELECT * From news WHERE MAIN = 0 order by id desc limit 15");
while ($row = mysql_fetch_array($result)) {
$loop = $row2[id];
?>
<?php
if ($top == $loop) {
} else {
echo "Stuff 2";
}
}
?>
Nothing shows for part two!!
(the first record has top set it 1)
What is wrong??? can my second SQL line look for 15 records with the id of $top???