<a href="http://www.dlrarmy.com/forums/contest.php" target="_blank">http://www.dlrarmy.com/forums/contest.php</a>
here is my error message
Warning: Offset 0 is invalid for MySQL result index 9 in ./admin/db_mysql.php on line 187
here is what I am using
<?
require('./global.php');
?>
<?php
$date1 = "UNIX_TIMESTAMP(\"2001-08-01\")";
$date2 = "UNIX_TIMESTAMP(\"2001-08-31\")";
$users = $DB_site->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 <> 'admin' group ".
"by post.userid order by count DESC");
$admin = $DB_site->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 = 'admin' group ".
"by post.userid order by count DESC");
?>
<!-- Put your header in here -->
<!-- This is mine -->
<? include("/home/dlrarmy/public_html/forums/head.html") ?>
<p align="center"><b><font face="verdana,arial,helvetica" size="2">The TOP THREE USERS who
posts the most on-topic posts from August 1st, 2001 to Aug 31st 2001 will receive the following: TO BE ANNOUNCED. For
residences in the U.S. and Canada.</font></b></p>
<div align="center">
<table border="1" cellpadding="4" cellspacing="4">
<tr>
<td bgcolor="#9900CC"><b><font face="verdana,arial,helvetica" color="#FFFFFF" size="3">User</font></b></td>
<td bgcolor="#9900CC"><b><font face="verdana,arial,helvetica" size="3"><font
color="#FFFFFF">Posts
from July 8th to Aug 8th</font></font></b></td>
</tr>
<tr>
<td>
<FONT face="verdana,arial,helvetica" size="2">
<br>
<?php
while ($user = $DB_site->fetch_array($users))
{
$username = $user["username"];
echo"$username<br>";
}
echo"<br>";
while ($user = $DB_site->fetch_array($admin))
{
$username = $user["username"];
echo"$username<br>";
}
?>
<br>
</font>
</td>
<td align="center">
<FONT face="verdana,arial,helvetica" size="2">
<br>
<?php
$DB_site->data_seek(0,$users);
while ($user = $DB_site->fetch_array($users))
{
$count = $user["count"];
echo"$count<br>";
}
echo"<br>";
$DB_site->data_seek(0,$admin);
while ($user = $DB_site->fetch_array($admin))
{
$count = $user["count"];
echo"$count<br>";
}
?>
<br>
</font>
</td>
</tr>
</table>
</div>
<p> </p>
<!-- Put any Footer info in here -->
<!-- This Is Mine -->
<?php
include ("/home/dlrarmy/public_html/forums/foot.html");
?>
I would love to get this to work! Any clues?!
|