Hello Everybody,
I would like to format the search result "asking_price".
Something Like this :::: $asking_price = number_format($asking_price); :::: But I don't know how or if it is even possible.
--- Is it done here? -----
while ($b = mysql_fetch_array($result)) {
printf( "
<tr align=\"center\" bgcolor=\"%s\">
<td><a href=\"%s?propid=%s\"><img src=\"images/view.gif\" width=\"130\" height=\"18\" border=\"0\"></a></td>
<td class=\"body\">%s</td>
<td class=\"body\">%s</td>
<td class=\"body\">$%s</td>
<td class=\"body\">%s</td>
<td class=\"body\">%s</td>
<td><a href=\"%s?propid=%s\"><img src=\"%s\" border=\"0\"></a></td>
</tr>\n", $rowcolor, $file, $b[propid], $b[sale_lease], $b[village], $b[asking_price], $b[bedrooms], $b[bathrooms], $file, $b[propid], $b[photo_thumb]);
if ($rowcolor == $color1) {$rowcolor = $color2;}
elseif ($rowcolor == $color2) {$rowcolor = $color1;}
}
----- Or here? -----
$result = mysql_query("select * from properties where agent like '%$agent%' and
sale_lease like '%$sale_lease%' and category like '%$category%' and view like '%$view%' and village like '%$village%' and bedrooms like '%$bedrooms%'
and bathrooms like '%$bathrooms%' limit $offset,$limit");
while ($b = mysql_fetch_array($result)) {
Thank You
