[thelist] Help with sql statements
CDitty
mail at redhotsweeps.com
Sun Jul 23 00:35:57 CDT 2000
Is there anyone here that can assist me in re-writing the sql statements
below to give me better memory usage? I recently rewrote the program that
holds them, and now it is using too much memory. I am guessing that JOINs
are needed, but I have never used them am at a loss.
Any help is appreciated.
Thanks in advance.
CDitty
$lastnumbers = "7, 36, 37, 47, 55, 56";
$sql = "select count(pick) as cnt, ticket
from drawpicks
where pick IN ($last_numbers)
group by ticket
having count(pick) = '$n'";
$countpicksresult = mysql_query($sql) or die(mysql_error());
while($myrow = mysql_fetch_array($countpicksresult)) {
$ticket = $myrow["ticket"];
$cnt = $myrow["cnt"];
$sql2 = "select pick from drawpicks
where ticket = $ticket";
$picksresult = mysql_query($sql2) or die(mysql_error());
$i = 0;
while($myrow2 = mysql_fetch_array($picksresult)) {
$pick[$i] = $myrow2["pick"];
$i = $i + 1;
}
mysql_free_result(picksresult);
// Combine the user's picks into one variable.
$user_picks = $pick[0] . ", " . $pick[1] . ", " . $pick[2] . ", " .
$pick[3] . ", " . $pick[4] . ", " . $pick[5];
$usersql = "select id, emailaddr, userid, DATE_FORMAT(date, 'b d, Y') as
enter_date from drawusers
where id = $ticket";
$usersqlresult = mysql_query($usersql) or die(mysql_error());
More information about the thelist
mailing list