Nested While Loop Issue

Anon

We have all seen this, but perhaps I am missing something ...

typical WHILE loop with a nested if loop:

while ($row = mysql_fetch_array ($res)) {
$pageName=$row["pageName"];

if ($pageName==0) {
$insertLinkage="<td><a href=../formCreatePage.php>Test</a></td>";
}

$carriageReturn="\n";
}

I cannot seem to evaluate properly. Am I doing this improperly?

jariizumi

First of all, what nested while loop? Second of all, exactly what's wrong with it? And most of all, what the heck is this supposed to do? This code will only display the last result, if any, and $carriageReturn should definitely be out of the loop. Also, not a good idea to use ../ in any HREF's, as some browsers seem to hate it (don't remember which...)... and keep all HREF's in quotes:

And if column pageName is a number, I would seriously question your column naming conventions, and strongly recommend using something like pageNumber. If it's a string and want to see if it's empty, something like this would work better:

if (!$pageName) {

So hopefully, that gives you more insight. Hope this helps 🙂