Multi Numbers problem

[Chevy]

I am trying to get multiple number is 1 if statement here is an example

[code]
if ($latitude==1||2||3||4||5 AND $longitude==1||2||3||4||5){
[/code]

It doesn't work the way I want it to, I want every cordante from long 1, lat 1 to long 5,lat 5

[willfitch]

This sounds like something that should be done on the database side to prevent giving birth to spaghetti code.  Have you tried a query like:

SELECT * FROM table WHERE latitude BETWEEN 1 AND 5 AND longitude BETWEEN 1 AND 5?

[ChaosXero]

[quote author=Chevy link=topic=101020.msg399387#msg399387 date=1153250641]

[code]
if ($latitude==1||2||3||4||5 AND $longitude==1||2||3||4||5){
[/code]
Try:

[/quote]

[code]
if (($latitude==1||2||3||4||5) && ($longitude==1||2||3||4||5)){
[/code]

[Chevy]

well $latitude and $longitude are varibles that take a row from mySQL

[willfitch]

Would you post a code snippet besides that particular line so we can see what you are doing?

[Chevy]

I tried

[code]if (($latitude==1||2||3||4||5) && ($longitude==1||2||3||4||5)){[/code]

No luck on 6,6 I still got the massage

[code]
$latitude = $row['latitude'];
$longitude = $row['longitude'];
$totalfish = $row['totalfish'];

if ($process == play){

if (isset($_POST["right"])) {$latitude++; mysql_query("UPDATE table SET latitude='$latitude' WHERE username='$MySN'")
or die(mysql_error());}
if (isset($_POST["left"])) {$latitude--; mysql_query("UPDATE table SET latitude='$latitude' WHERE username='$MySN'")
or die(mysql_error());}
if (isset($_POST["up"])) {$longitude++; mysql_query("UPDATE table SET longitude='$longitude' WHERE username='$MySN'")
or die(mysql_error());}
if (isset($_POST["down"])) {$longitude--; mysql_query("UPDATE table SET longitude='$longitude' WHERE username='$MySN'")
or die(mysql_error());}

if ($latitude==1||2||3||4||5 AND $longitude==1||2||3||4||5){
        echo "Testing this cordnate!";
}

[/code]

[ChaosXero]

Did you try the code that I suggested, and did it give diffrerent results?

[Chevy]

ChaosXero - my previous post said it

[ChaosXero]

Try a $latitude<6 && $longitude<6 (and add >0 if you like).  If it MUST be an int, try isint() also.

[Chevy]

Thank you very much! That never even crossed my mind  ;D It has been a long day...

[ChaosXero]

No problem.  It's always fun to help other people out. (Mostly because they help me when I have questions)

[akitchin]

for the record, you have to explicitly set each condition within an if():

[code]<?php
if (($long == 1 || $long == 2 || $long == 3) && ($lat == 1 || $lat == 2 || $lat == 3))
{

}
?>[/code]

etc.