[SOLVED] Simple Echo help

[iceblox]

HI Guys,

 

I have a simple echo query what i need it to do is on the last row not to print the "|" Seperator as in my ajax query im getting a blank option.

 

Can someone help me with this please?

 

<?php


$query = "SELECT * FROM deals WHERE MakeName = '$id' GROUP BY ModelName ORDER BY ModelName ASC";

$result = mysql_query($query);

if (mysql_num_rows($result) > 
                            0)
{

while($row = mysql_fetch_row($result))
{

echo '' . $row[10] . ',' . $row[12] . '|';

}

}
else
{
echo '';
}


?>

 

Thanks in advance

[Orio]

You can change the while loop into something like this:

 

<?php

$row = mysql_fetch_row($result);
while($row !== FALSE)
{

echo '' . $row[10] . ',' . $row[12];
$row = mysql_fetch_row($result);
if($row !== FALSE)
echo "|";

}

?>

 

 

Orio.

[iceblox]

Thanks Orio

 

Worked a treat ;o)