PHP Functions with multiple MySQL results only returning one record

Question

This is the function that im calling.

function GetSubmissions($coach){
                $result = mysql_query("SELECT * FROM `ptable` WHERE coach = '$_SESSION[username]'") or trigger_error(mysql_error()); 
                while($row = mysql_fetch_array($result)){ 
                foreach($row AS $key => $value) { $row[$key] = stripslashes($value); } 
                    $id = $row['id'];
                    $teampre = $row['team'];
                    $eventpre = $row['event'];
                    $statuspre = $row['status'];
                    $eventarray = DecodeEvent($eventpre);
                        $event = $eventarray[0];
                        $cat = $eventarray[1];
                        $subcat = $eventarray[2];
                        $division = $eventarray[3];
                        $type = $eventarray[4];
                    $teamarray = explode(",", $teampre);
                        foreach ($teamarray AS $tkey => $tvalue){
                            $result = mysql_query("SELECT * FROM `students` WHERE id = '$tvalue'") or trigger_error(mysql_error()); 
                            while($row = mysql_fetch_array($result)){ 
                            foreach($row AS $skey => $svalue) { $row[$skey] = stripslashes($svalue); } 
                            $firstname = $row['firstname'];
                            $lastname = $row['lastname'];
                            $teamgo .= "$firstname $lastname<br/>";
                            }

                }       
                    $push .= "<div id=submission><div id=event>$event</div><div id=status>$statuspre</div><div id=subinfo>$cat $subcat $division $type</div><div id=team>$teamgo</div></div>";
                }           

    return $push;
}

It works, except its only returning a single result. Ive made little tweaks here and there, but im not seeing any positive changes in the output. Any ideas where im going wrong?

Corey Ballou · Accepted Answer · 2009-10-15 11:39:38Z

2

You have nested $result variables. You should try to avoid using the same variable name twice. Renaming the second one inside your second foreach loop would probably do the trick.

answered Oct 15, 2009 at 11:39

Corey Ballou

43.7k8 gold badges66 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mrpatg Over a year ago

this worked, but im getting repeating results on the second loop

Michael Krelin - hacker · Accepted Answer · 2009-10-15 11:40:23Z

1

You use the same $result for inner loop.

answered Oct 15, 2009 at 11:40

Michael Krelin - hacker

144k25 gold badges200 silver badges177 bronze badges

Collectives™ on Stack Overflow

PHP Functions with multiple MySQL results only returning one record

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related