[SOLVED] While loop does not work?

[Miko]

Hello,

 

I've created a function that checks in my DB if I have a record in the table CATEGORIES, if there is none it asks to add a category.

If there is at least 1 record it must echo these categories, I'm doing this with a while:

 

function Select_Categories(){

		$sql = "SELECT * FROM CATEGORIES";
		$query = mysql_query($sql);
		$num_rows = mysql_num_rows($query);

		if($num_rows == '0'){

			echo "You do not have any Main Categories in your database! <br />Please add at least 1 Main Category to your database! <br />";

			?>
				<form action="<?php $_SERVER['PHP_SELF'] ?>" method="post">
			<?php

			echo "<ul>";
			echo "<li>Category Name:</li>";
			echo "<li><input type=\"text\" name=\"category_name\" /></li>";
			echo "<li><input type=\"submit\" name=\"insert_category\" value=\"Insert Category!\" /></li>";
			echo "</ul>";
			echo "</form>";

			$insert_category = $_POST['insert_category'];

			if(isset($insert_category)){

				Insert_Category();

			}
			return false;


		}else{

			echo "Main Categories:";

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

				$id = $row['id'];
				$cat_name = $row['name'];

				echo $cat_name."<br />";

				return true; 				

			}

		}

	}

 

But for some reason it returns me only 1 result, but I have about 15 records in my table.

I'm a bit stuck here

[Q]

Try enabling errors

 

ini_set("display_errors", E_ALL);

[Miko]

found it, I had to place my return outside my while