query with if needs a loop

[rayzun]

Not sure where to loop this script ...
BUT when row[DELUX] is empty for first 9 rows
the script works and output's the <br> correctly
In row 10, DELUX has a value greater than 0
the if statement works. The query stops, and not continue the set limit

$query = "select FROM loris LIMIT 0 , 22";
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array($result))
{
$DELtotal = $row[DELUX];
if ($DELtotal <= 0)
{
echo "<br>";
} else {
$query = "select FROM loris LIMIT 0 , 1";
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array($result))
{
$DELUXtotal = $row[DELUX] - $row[PRICE];
echo "$DELUXtotal<br>\n";
} } }

any ideas would really helpful.

[bradgrafelman]

When posting PHP code, please use the board's [PHP][/PHP] bbcode tags - they make the code much, much easier to read (as well as aiding the diagnosis of syntax errors). You should edit your post now and add these bbcode tags to help others in reading/analyzing your code.

Now... can you perhaps explain in words what you are trying to do? I doubt there's any need for two queries, and that code overall just seems to be much more messy and complex than it needs to be.

[Neumy]

Your second SQL call was just re-passing the same information. This should work for you:

$query = "select * FROM `loris` LIMIT 0 , 22";
$result = mysql_query($query) or die(mysql_error()); 

while ($row = mysql_fetch_array($result)) 
{
	$DELtotal = $row[DELUX];
	if ($DELtotal <= 0) 
	{
		echo "<br>"; 
	} else {
		$DELUXtotal = $row[DELUX] - $row[PRICE];
		echo "$DELUXtotal<br>\n";
	} 
}