Basic If Else Help.

[HostWeb]

Hi there,

I am still getting the hang of PHP and am stuck. I have a recordset called workorderresult.

If the date value returns 0000-00-00 I need to print Still Avtive instead of 0000-00-00. Otherwise if any other value is returned besides that the print it. Here is what I have so far.... Where am I going wrong. Please help.

<?php
$comp = $row_workorderresult['completiondate'];
if (comp == date("Y-m-d",0000-00-00);{
echo "Still Active";
}
else {
echo $row_workorderresult['completiondate'];
}
?>

Can anyone help???

 

[Olavxxx]

Hmm, if you are to format the date, why not do it inside your mysql database?

Converting the date there, will give you less system stress, which again will give you faster loading-times.

I however see a small typo you have:

if ([b]$[/b]comp == date("Y-m-d",0000-00-00);{
echo "Still Active";
}

eg. you lack the $ in front of the variable $comp.

Good luck!

ps. You can also echo out the variables, to check which values they give you, to ensure that your if/else will run correctly based on your logic.

Olav Alexander Mjelde

http://www.volvo-power.net

Admin & Webmaster

 

[HostWeb]

Thanks a mill. I will check it out now.

 

[Olavxxx]

Np.

I would look up on this page for date and time manipulation:

http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html

(including formatting)



Olav Alexander Mjelde

http://www.volvo-power.net

Admin & Webmaster

 

[Westbury]

I also notice that you have a semi-colon at the end of the if statement. This is not needed and might cause problems for php.

if (comp == date("Y-m-d",0000-00-00);{

should be

if (comp == date("Y-m-d",0000-00-00) {

If it aint broke, redesign it!