Jump to content

Archived

This topic is now archived and is closed to further replies.

Chevy

Multi Numbers problem

Recommended Posts

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

Share this post


Link to post
Share on other sites
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?

Share this post


Link to post
Share on other sites
[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]

Share this post


Link to post
Share on other sites
well $latitude and $longitude are varibles that take a row from mySQL

Share this post


Link to post
Share on other sites
Would you post a code snippet besides that particular line so we can see what you are doing?

Share this post


Link to post
Share on other sites
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]

Share this post


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

Share this post


Link to post
Share on other sites
Thank you very much! That never even crossed my mind  ;D It has been a long day...

Share this post


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

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.