Jump to content
iyeru42

Looping SQL Data into variables with manual arrays

Recommended Posts

Another issue, but it focuses on two variables, one dependant off of a previous one.

	// Load Style Configs...	// Get the default style first!	$sql2 = mysql_query("SELECT `name`,`id` FROM `styles` WHERE `default`='1'");	$row2 = mysql_fetch_array($sql2);		// Grab The style configs for that style.	$sql3 = mysql_query("SELECT `content`,`name` FROM `style_config` WHERE `styleid`='{$row2['id']}'");		$style_cfg = Array();		while($row3 = mysql_fetch_array($sql3)){		$style_cfg[$row3['name']] = $row3['content'];	}		$CFG['style']['table']['bgcolor'] = $style_cfg['tbl-bg'];	$CFG['style']['table']['cella']   = $style_cfg['tbl-cella'];	$CFG['style']['table']['cellb']   = $style_cfg['tbl-cellb'];

These three output blank. Not sure how to modify the loop above to make it work with this. Because, editing it like below...

	// Grab The style configs for that style.	$sql3 = mysql_query("SELECT `content`,`name` FROM `style_config` WHERE `styleid`='{$row2['id']}'");	while($row3 = mysql_fetch_array($sql3)){		if($row3['name'] == "tbl-bg")			$CFG['style']['table']['bgcolor'] = $row3['content'];		else if($row3['name'] == "tbl-cella")			$CFG['style']['table']['cella'] = $row3['content'];		else if($row3['name'] == "tbl-cellb")			$CFG['style']['table']['cellb'] = $row3['content'];	}

still outputs the three as blank. Although I don't really need it right now, since I'm going the roundabout way...

	// Grab The style configs for that style.	$sql3 = mysql_query("SELECT `content`,`name` FROM `style_config` WHERE `name`='tbl-bg' OR `name`='tbl-cella' OR `name`='tbl-cellb' OR `name`='page-bg' OR `name`='forum-bg'");	while($row3 = mysql_fetch_array($sql3)){		if($row3['name'] == "tbl-bg") // Table BG			$CFG['style']['table']['bgcolor'] = $row3['content'];		else if($row3['name'] == "tbl-cella") // Cell A			$CFG['style']['table']['cella'] = $row3['content'];		else if($row3['name'] == "tbl-cellb") // Cell B			$CFG['style']['table']['cellb'] = $row3['content'];		else if($row3['name'] == "page-bg") // Page BG			$CFG['style']['page']['bgcolor'] = $row3['content'];		else if($row3['name'] == "forum-bg") // Forum BG			$CFG['style']['forum']['bgcolor'] = $row3['content'];	}

but it would still be nice to know how to optimize the loop.

Share this post


Link to post
Share on other sites
These three output blank. Not sure how to modify the loop above to make it work with this. Because, editing it like below...still outputs the three as blank.
It should be obvious that the database query isn't returning any results. If it was, then they wouldn't be blank. Check your query.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...