MSQL query works on one column but gives 0 results for queries on other columns

[daveGivesPHPaShot]

Hello All,

I just set up a test database and had a PHP script returning XML files but only on one of the columns. So, to isolate my problem, I went back into PHPMyAdmin to check if the problem was with the data base and perhaps it is.

 

I have a column called 'name' and I can select for rows where name = X. That works fine. But I get zero results when I do select statements for any other rows. The other rows contain Null, 0, and float numbers (latitude and longitude data for ex 37.1231). Perhaps it's the way I set up the data? Thanks in advance for any help.

[kickstart]

Hi

 

Can you post the table layout, some sample data and the statements that work / don't work

 

All the best

 

Keith

[daveGivesPHPaShot]

Thank you Kickstart,

I should have posted this in a Google maps forum, as that is what I am trying to do. But perhaps this post could help someone else. So I'll attach a screenshot of data structure. In this test database, I am unable to run searches to pull lat and lng, perhaps because they are floating numbers. Perhaps my select statement needs to contain some escapes to get around the periods in the floating numbers. I was just running super-simple searches within PHPMyAdmin, such as select where lat = 'X'.

Thanks!

 

 

[attachment deleted by admin]