Post the Most contest - please help with this code

[brookemegg]

Hello, I have found some code on here that was from a few years ago and needed to be adjusted from 3.0 to 3.5 to run a Post the Most contest. I know the code was eventually fixed and used correctly, but I can't find that anywhere. Nor do I know how to figure it out.

Please help me fix this code and get this up and running. I'd greatly appreciate it!! And I have experience in html, but none in php, so explicit directions would help.The members names are showing up fine, but the post counts are not.


Here is what I am trying to do, scroll down to the table that has the Post the Most in it:
http://www.familycorner.com/forums/contest_month.php3

Here is what my page looks like:
http://spiffymoms.com/forums/view.php?pg=post_the_most

And here is the code I used:

PHP Code:

<?php
$date1 = "UNIX_TIMESTAMP(\"2007-11-01\")";
$date2 = "UNIX_TIMESTAMP(\"2007-11-02\")";

$users = $db->query(
"SELECT post.userid, count(post.userid) as count, user.username from " .
"post, user WHERE post.dateline >= $date1 and post.dateline <= $date2 " .
"and post.userid = user.userid and user.username <> 'Dawn' group ".

"by post.userid order by count DESC");
$admin = $db->query(
"SELECT post.userid, count(post.userid) as count, user.username from " .
"post, user WHERE post.dateline >= $date1 and post.dateline <= $date2 " .
"and post.userid = user.userid and user.username = 'Dawn' group ".
"by post.userid order by count DESC");

 ?>
 
 <?php
while ($user = $db->fetch_array($users))
{
$username = $user["username"];
echo ("$username<br>");
}
echo ("<br>");
while ($user = $db->fetch_array($admin))
{
$username = $user["username"];
echo ("$username<br>");
}
?>
<br>
</font>
</td>
<td align="center">
<FONT face="verdana,verdana" size="2">
<br>
<?php
$db->data_seek(0,$users);
while ($user = $db->fetch_array($users))
{
$count = $user["count"];
echo ("$count<br>");
}
echo ("<br>");
$db->data_seek(0,$admin);
while ($user = $db->fetch_array($admin))
{
$count = $user["count"];
echo ("$count<br>");
}
?>

If you can help, thanks in advance!!

--------------- Added [DATE]1194103886[/DATE] at [TIME]1194103886[/TIME] ---------------

**bump**

Please help, we are trying to do this for Monday, thanks!

[brookemegg]

Bump