[RESOLVED] Getting info from mysql problem.

[devsie]

I seem to be having trouble with the numbers i'm taking out of my mysql database. I figure that my script is considering them to be text string rather than treating them as numbers, but i'm not sure. Any help would be great.

//Connects fine.

//Searchestable and takes out longditude and lattitude for selected postcode fine.
$result = mysql_query("SELECT * FROM postcode WHERE postcode1='ab21'") or die(mysql_error());

$row = mysql_fetch_array($result);

$distance = 10;

$lon = $row[1]; <------ if i use this and only take data from mysql, then i get NO output.
$lat = $row[2];

$lon = -2.21; <---- if i make up some numbers and run them thru' the script i get the output i expect/wanted.
$lat = 52;

if ($distance==10){
$lonMAX = $lon + 0.26;
$lonMIN = $lon - 0.26;
$latMAX = $lat + 0.2;
$latMIN = $lat - 0.2;
}elseif($distance==20){
$latMAX = $lat + 0.2;
$latMIN = $lat - 0.2;
$lonMAX = $lon + 0.26;
$lonMIN = $lon - 0.26;
}

//Search DB again
$result2 = mysql_query("SELECT * FROM postcode WHERE lon BETWEEN {$lonMIN} AND {$lonMAX} AND latt BETWEEN {$latMIN} AND {$latMAX}") or die(mysql_error());

$row2 = mysql_fetch_array($result2);

while($row2 = mysql_fetch_array($result2))

I'm just trying to find the bit that lies between the two values.
I'm sure there is probably an easier way of doing this too, but i've only been learning this stuff for a week, so try not to blow my mind please. Thankyou 😃

[HalfaBee]

Do a print_r( $row ); and see what the array contains.

[devsie]

Hi and thankyou,
I had already tried that, i'd done

echo $row[0]."<br>";
echo $row[1]." by ";
echo $row[2]."<br><br>";

And got the output
AB21
57.21 by -2.20

So i know that $row[1] and $row[2] do contain numbers. And thus assume $lat and $lon will contain numbers when i set them.

But when i do the mysql search for something between those numbers it doesn't seem to work. Unless i input numbers into $lat & $lon manually.

I'm confused :o/

[devsie]

Finally sorted. Took a lot of looking around and in the end i just kinda got lucky.

Apparently can't use * when selecting the data. I assume if you use that it doesn't identify what data type it is.

I also looked at setting the variable type with php but could only find set($,"integer") which didn't help.

😃

[HalfaBee]

You can use * and still return any type of result.
you will lose the first row of data because you call mysql_fetch_array() outside the loop.

[devsie]

Can you expand on that for me halfaBee?

Are we talking about the
$result2 = mysql_query("SELECT * FROM postcode WHERE lon BETWEEN {$lonMIN} AND {$lonMAX} AND latt BETWEEN {$latMIN} AND {$latMAX}") or die(mysql_error());

...line. Is that the "call"? Do i need to do that inside the WHILE statement?

And if so, er, how come? heh 🙂

[HalfaBee]

$result2 = mysql_query("SELECT * FROM postcode WHERE `lon` BETWEEN {$lonMIN} AND {$lonMAX} AND `latt` BETWEEN {$latMIN} AND {$latMAX}") or die(mysql_error());

$row2 = mysql_fetch_array($result2); // this will drop the first row

while($row2 = mysql_fetch_array($result2))

[devsie]

I've omitted that line and it works properly now. Thankyou.