Jump to content

SQL query problem


tpwalker1980

Recommended Posts

The following code is causing my page to come up entirely blank  pure white.  no errors..


//Get all group submisions
$sgroups = $db->sql_query("SELECT * FROM group_report ORDER BY greport_id ASC");
    //roll the above into an array indexed by greport_id
    while(list($greport_id, $group_stime, $group_etime, $group_date, $group_loc, $group_mem1, $group_mem2, $group_mem3, $group_mem4, $group_mem5, $group_mem6, $submit_date) = sql_fetch_row($sgroups)) {
    	$sgroups_array[$greport_id[] = array($greport_id, $group_stime, $group_etime, $group_date, $group_loc, $group_mem1, $group_mem2, $group_mem3, $group_mem4, $group_mem5, $group_mem6, $submit_date);
    }

 

If I comment out

$sgroups_array[$greport_id[] = array($greport_id, $group_stime, $group_etime, $group_date, $group_loc, $group_mem1, $group_mem2, $group_mem3, $group_mem4, $group_mem5, $group_mem6, $submit_date);

The page will display but with no data as its missing the array...

 

full page of code can be found http://www.vanguardlegacy.com/code.html

output can be found here http://www.vanguardlegacy.com/modules.php?name=Submit_Group&file=list_submits

Link to comment
https://forums.phpfreaks.com/topic/40397-sql-query-problem/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.