Newbie: replace numeral with string

[Ravensleach]

I have a query which produces a list of products and prices (four price fields for different versions of the same product). Prices are type DECIMAL field. Where there is no known price it has the value 0. When printing to the page I would like to replace these 0 values as "<a href="contactus.htm">contact us</a>".

Probably should be some combination of a conditional statement and str_replace .. but it's not replacing a string .. can anyone help?

 

[vacunita]

Not without seeing how you are outputting it.

But at its most basic something like:

if($value=='0'){
echo '<a href="contactus.htm">contact us</a>';
}
else{
echo $value;
}




----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[Ravensleach]

Here's the code:

$data = mysql_query("SELECT boat_name, charter, shared_cabin, child, single_cabin FROM boats INNER JOIN cost2009 ON boats.boat_ID = cost2009.BoatIDfk") 


/* try to replace 0 with contact us, otherwise $value on charter, shared_cabin_child_single_cabin */


or die(mysql_error()); 


Print "<table border cellpadding=3>"; 
Print "<tr><th>Boat</th><th>Charter</><th>Per person in shared cabin</th>
<th>Child aged under 12</th><th>Single cabin</th></tr><tr>";
while($info = mysql_fetch_array( $data ))


{ 
Print "<td><a href='[URL unfurl="true"]http://www.mysite.com/directory/"[/URL] . strtolower($info['boat_name']) . ".html'>" .$info['boat_name'] . "</a></td>"; 
Print "<td align='right'>$".number_format($info['charter'],0,'.',',') . " </td>";
Print "<td align='right'>$".number_format($info['shared_cabin'],0,'.',',') . " </td>";
Print "<td align='right'>$".number_format($info['child'],0,'.',',') . " </td>";
Print "<td align='right'>$".number_format($info['single_cabin'],0,'.',',') . " </td></tr>"; 
} 
Print "</table>"; 
?>

 

[vacunita]

You'll have to modify a bit:

function check_for_zero($value){
 if($value==0){
  $return_value='<a href="contactus.htm">contact us</a>';
 }
 else{
  $return_value=number_format($value,0,'.',',');
 }
return $return_value;
}

Then inside the while loop:

...
Print "<td align='right'>$". check_for_zero($info['charter']) . " </td>";
Print "<td align='right'>$". check_for_zero($info['shared_cabin']) . " </td>";
Print "<td align='right'>$".check_for_zero($info['child']) . " </td>";
Print "<td align='right'>$".check_for_zero($info['single_cabin']) . " </td></tr>"; 
...

----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[Ravensleach]

Works great, thank you so much Vacunita. Just have to get rid of the $ now!

 

[vacunita]

You can add the $ to the string in the function and remove them from the print statement in the while loop.

else{
 $return_value=[red]"$"[/red] . number_format($value,0,'.',',');
}

----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.