[SOLVED] Queries with php

[summerpewp]

<?php ...
$newx = $row['player_loc_x']-1;
$y = $row['player_loc_y'];
$border = mysql_query("SELECT * FROM zones WHERE zone_id = '1' AND zone_b_x = '$newx'");
$row2 = mysql_fetch_array($border);
$zoneby = $row2['zone_b_y'];

if ( $newx == $zonebx && $y == $zoneby) { "do this" } else { "do this instead" };
...
?>

 

 

This only seems to return 1 value that is in my database. when i Echo $zoneby. I need it to hold all info that is relevant for validation in my if statement. Any ideas? I'm sure its something easy that I'm over looking.

 

Here is an example of what I'm trying to do.

 

1. Retrieve all the data related to zone_b_x and zone_id

2. In this case its 5, 8, 10 But when I echo it, it only holds the value of 5 and doesn't look at 8 or 10 for the statement.

 

[smerny]

<?php ...
$newx = $row['player_loc_x']-1;
$y = $row['player_loc_y'];
$border = mysql_query("SELECT * FROM zones WHERE zone_id = '1' AND zone_b_x = '$newx'");
$row2 = mysql_fetch_array($border);
$zoneby = $row2['zone_b_y'];

if ( $newx == $zonebx && $y == $zoneby) { "do this" } else { "do this instead" };
...
?>

 

 

This only seems to return 1 value that is in my database. when i Echo $zoneby. I need it to hold all info that is relevant for validation in my if statement. Any ideas? I'm sure its something easy that I'm over looking.

 

Here is an example of what I'm trying to do.

 

1. Retrieve all the data related to zone_b_x and zone_id

2. In this case its 5, 8, 10 But when I echo it, it only holds the value of 5 and doesn't look at 8 or 10 for the statement.

 

What columns are in zones?

 

$row2['zone_b_y'] will be what is in the cell matching:

- the first row where zone_id is 1 and zone_b_x is $newx

- the column zone_b_y

[summerpewp]

in the table zones :

 

zone_id

zone_b_x

zone_b_y

 

everything in zone_id right now is set to 1 since I am just trying to get this to function

 

in zone_b_x i have numerous values, but just want to compare it to the current $newx

 

so, if i have data such as this:

id, x, y

1, 5, 5

1, 5, 8

1, 5, 10

1, 6, 5

1, 9, 4

etc.

 

I want it to look at zone_id 1, zone_b_x 5 and zone_b_y hold the values of 5 8 and 10 so i can compare them in the if statement.

[smerny]

so an example row would look like this?

 

+---------+----------+----------+
| zone_id | zone_b_x | zone_b_y |
+---------+----------+----------+
|   1     |    5     |    5     |
+---------+----------+----------+

 

that's the only row you will get if you just do what you have, which means that ['zone_b_y'] will be 5

 

you can look through it though, which will get each row in order, like this:

 

while($row2 = mysql_fetch_array($border)){
   echo $row2['zone_b_y'] ."<br />";
}

 

which would output:

 

5

8

10

 

(each time you call mysql_fetch_array($border), it will get the next row that matches up)

 

you can probably figure it out from here with what you want to do

[summerpewp]

got it! Thanks a ton!