[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