less than or greater than!

[Anon]

Hi,
I'm trying to use the greater than or equal to, and less than or equal expressions in a piece of code, but i always seem to get a parse error, below is my code, i'd be greatful if someone code tell me whats wrong.
It seems to be the "if ($start_new..." line that is erroring

$sql="SELECT * FROM availability WHERE user_id='$sUserID' AND room_code='$sRoomcode'";
$result=db_query($sql);
if ($result) {
$old = mysql_fetch_array($result);
$row = mysql_fetch_row($result);
$start_old = $old['start_date'];
$end_old = $old['end_date'];
if ($row[0] == 0) {
echo 'Database Error';
} else {
if ($start_new <= $start_old && $end_new >= $start_old && $end_new <= $end_old) {
echo 'Update Needed';
} else {
echo 'No Update Needed';
}
}

[djg_uk]

Hi Ben,

Have you tried encasing the three expressions in brackets?

Besides that, I can't see where the values for $start_new and $end_new are being set.

Regards,

David

[Anon]

Yeah tried that! tis weird. the 2 values are passed to the script by another page. I know they are set, cause i tested it using print "$start_new";. I think this is something to do with having..
if ($row[0] == 0) {
if ($start_new >= $start_old) {
echo 'text here';
}
}

Can you have 2 if statements together like that?
if(){
if(){
}
}

[Anon]

Ben Blackmore wrote:

Yeah tried that! tis weird. the 2 values are passed to the script by another page. I know they are set, cause i tested it using print "$start_new";. I think this is something to do with having..
if ($row[0] == 0) {
if ($start_new >= $start_old) {
echo 'text here';
}
}

Can you have 2 if statements together like that?
if(){
if(){
}
}

I think it is wrong
Well i doint think that is right.

[Anon]

ray wrote:

Ben Blackmore wrote:

Yeah tried that! tis weird. the 2 values are passed to the script by another page. I know they are set, cause i tested it using print "$start_new";. I think this is something to do with having..
if ($row[0] == 0) {
if ($start_new >= $start_old) {
echo 'text here';
}
}

Can you have 2 if statements together like that?
if(){
if(){
}
}

I think it is wrong
Well i doint think that is right.

Well it is actually correct noticing after some thought. sorry

[djg_uk]

Hi Ben,

There is nothing wrong with nesting if statements.

What is the exact line you get the error on?

Regards,

David

[cheesehead]

If that is all the code you are missing the closing brace of the first if statement. If it is everything you should be able to tell as it will give you a parse error stating the line number of the ?> tag. Try adding a closing brace } at the end of the the script and it should sort out your problem (depending on the logic you want it might need to go somewhere else.)