when using If statement

[Sanjes]

When im using an If statement in PHP with the word (keyword) and, OR it gives me an error

eg

IF ($var >1) AND ($var<5)
echo &quot;Between 2 and 4&quot;

Im using IIS on Win2k, im writing my php scripts in Macromedia Homesite 5..

Please could you assist
thank you

 

[sleipnir214]

Try

IF (($var >1) && ($var<5)) ______________________________________________________________________
TANSTAAFL!

 

[Sanjes]

Parse error: parse error, unexpected T_BOOLEAN_AND in E:\Inetpub\

http://wwwroot\ITB\hello3.php

on line 97

this is the error message if i use the && for &quot;AND&quot; or || for &quot;OR&quot;,

sorry to be a pain

 

[sleipnir214]

You should be using &quot;&&&quot; and &quot;||&quot;. Those operators have higher precedence than &quot;and&quot; and &quot;or&quot;, repectively.

Did you also add the outer set of parentheses? ______________________________________________________________________
TANSTAAFL!

 

[Sanjes]

i didnt but i have just tried it and it works thanks im have been working on that little thing for about an hour last week... i know very fundamental issue. thank u for ur help

sanj

 

[sleipnir214]

In PHP all conditionals, &quot;if&quot;, &quot;while&quot;, &quot;for&quot;, &quot;switch&quot; require that the condition be withing parentheses.

This is different from, say VB, where such things are optional. ______________________________________________________________________
TANSTAAFL!

 

[Sanjes]

yea i think that is where i was failing, i have done VB before but this is the first time im doing a true web scripting language (even though VB can do web scripting not very widely used)

I very quick question, the debate on that mySQL cannot do correlated sub queries, i.e. queries within queries... how far can it nest queries, for example can u do sub queries upto a certain point like Select (......
Select (......
Select(.......)))
thank u in advance
sanj

 

[sleipnir214]

This from the MySQL online manual (

http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html):

MySQL Server currently only supports nested queries of the form INSERT ... SELECT ... and REPLACE ... SELECT .... You can, however, use the function IN() in other contexts. Subselects are currently being implemented in the 4.1 development tree. ______________________________________________________________________
TANSTAAFL!