[RESOLVED] foreach issue..i think

jjheath

This is fairly involved, so here it goes:

I have two tables. one named pages, the other, content. The pages table has a field named content. it's a text field with values ie; contentOne contentTwo contentThree etc.. each one has a \n after it.

I am querying for the pages like this:

$pageQuery = mysql_query("SELECT * FROM pages WHERE id = '111111' LIMIT 0, 1");
$page = mysql_fetch_assoc($pageQuery);

after that i use explode to create an array with the data from the content column:

$contentArray = explode("\n", $page['content']);

once that is done, i use foreach to loop through the array. while it's looping, i am querying the content table for the content by using the $value from the array.

foreach($contentArray as $value) {
${"{$value}Query"} = mysql_query("SELECT content FROM content WHERE contentArea = '".$value."' ORDER BY id ASC LIMIT 0, 1");
${"{$value}Result"} = mysql_fetch_assoc(${"{$value}Query"});
$$value = ${"{$value}Result"}['content'];
}

I am dynamically naming the query, query results, and resulting var so it won't be overwritten during the loop.

My end goal is to be able to call the variables later in the page outside the loop.

<div id="contentOne"><?=$contentOne;?></div>
<div id="contentTwo"><?=$contentTwo;?></div>
etc...

My issue is that, even though it's dynamically naming everything within the loop, it will still only display the last value from the loop, as if it's still overwriting what was before it.

I know this is maybe not the perfect solution, but it is pretty much a requirement for how i need this set up. anyone see anything obvious that's wrong here? It seems my logic is fairly solid, I'm just missing something.

Any help would be much appreciated.

dagon

you would save your self a world of pain by making proper use of the db in the first place.

contentOne contentTwo contentThree sholuld each be an their own db field

jjheath

I know but that won't work for me in this instance. There will be different number of contents for each page with no real maximum

dagon

jjheath;10877662 wrote:
I know but that won't work for me in this instance. There will be different number of contents for each page with no real maximum

id | page id | content

i don't see the problem

jjheath

it is already like that that's what I'm querying in the for each loop

dagon

you have one text field for each content, not one for all. no explode needed.

jjheath

I am querying one from the other. Like I said I know it isn't elegant but has to be set up this way

dagon

jjheath;10877669 wrote:
but has to be set up this way

no it does not.

jjheath

well I'm not going to argue about it. I presented a specific problem and this isn't solving it

NogDog

I can't say I really understand exactly what you're trying to do, but I would suspect it would be much easier to manage using an array rather than variable variables and complex variables.

$results = array();
foreach($contentArray as $value) {
   $results[$value]['query'] = mysql_query("SELECT content FROM content WHERE contentArea = '".$value.
         "' ORDER BY id ASC LIMIT 0, 1");
   $results[$value]['result'] = mysql_fetch_assoc($results[$value]['query']);
   $results[$value]['content'] = $results[$value]['result']['content'];
}

Still, it looks unnecessarily complex to me, but that may simply be because I don't see the "big picture".

jjheath

It is unnecessarily complex. If the situation were different i could have used others methods to do this, but the requirements of the program have pretty much locked me in to this lame solution.