Variables in While clause... trouble.

[lilwing]

Not sure how to fix this problem... been cracking at it for a half hour.

 

<?php
$query = mysql_query('SELECT * FROM hyperlinks WHERE Category="primary" ORDER BY LinkOrder ASC') or die(mysql_error());
while($row = mysql_fetch_array($query)) {

$primaryHREF = $row['ID'];

}

$query = mysql_query('SELECT * FROM hyperlinks WHERE Category="primary" ORDER BY LinkOrder ASC') or die(mysql_error());
while($row = mysql_fetch_array($query)) {

$primaryName = $row['Name'];

}

echo ('<li><a href="'.$primaryHREF.'">'.$primaryName.'</a>');

?>

[sader]

does this help?

<?php

$query = mysql_query('SELECT * FROM hyperlinks WHERE Category="primary" ORDER BY LinkOrder ASC') or die(mysql_error());
while($row = mysql_fetch_array($query)) 
{
$primaryName = $row['Name'];
$primaryHREF = $row['ID'];

echo ('<li><a href="'.$primaryHREF.'">'.$primaryName.'</a></li>');

//or just
//echo ('<li><a href="'.$row['ID'].'">'.$row['Name'].'</a></li>');
}


?>

 

if it's still crashes try

 

$query = mysql_query('SELECT * FROM hyperlinks WHERE Category="primary" ORDER BY LinkOrder ASC LIMIT 25') or die(mysql_error());

[lilwing]

That worked. I changed it a little though. Now I have a horrible loop problem.

 

<?php

$query = mysql_query('SELECT * FROM hyperlinks WHERE Category="primary" ORDER BY LinkOrder ASC') 
or die(mysql_error());

while($row = mysql_fetch_array($query)) {

while($row[Category] = 'primary') {

$primaryName = $row[Name];
$primaryHREF = $row [hrEF];

	while($row[Category] = 'secondary') {

		$primaryCategory = $row['PrimaryCategory'];
		$secondaryName = $row['Name'];
		$secondaryHREF = $row['HREF'];

		echo ('<li class="off"><a href="'.$primaryHREF.'">'.$primaryName.'</a>');

		if($row[PrimaryCategory] != 0) { 

			echo ('<ul>');
			echo ('<li><a href="'.$secondaryHREF.'"></a>'.$secondaryName.'</li>');
			echo('</ul>');

		}

		echo ('</li>');
	}
}
}

?>