Usarjjaco Posted July 15, 2010 Share Posted July 15, 2010 I think we can tell who the rookie is here, with all my question posts... but hey... better to ask and find out then sit there for a month in silence!So here goes,When someone "Builds" and item it posts this information in the table "Stockpiles"Everything posts fine, except for one thing. I use latitude and longitude for location.Example: Latitude is "1234" Longitude is "-1234" "Latitude" posts fine."Longitude" does not. If I set "Longitude" as "INT" then it displays the above number (-1234) as "0" If I set "Longitude" as "VARCHAR" then it displays the above number (-1234) as a blank entry.Input would be much appreciated!Thanks again! Link to comment Share on other sites More sharing options...
wirehopper Posted July 15, 2010 Share Posted July 15, 2010 You should probably use FLOAT for a data type.http://dev.mysql.com/doc/refman/5.1/en/numeric-types.html Link to comment Share on other sites More sharing options...
Usarjjaco Posted July 15, 2010 Author Share Posted July 15, 2010 Thanks for the reply.However I tried that and the negative grid number still showing up as '0' ... Any more ideas? Link to comment Share on other sites More sharing options...
Synook Posted July 15, 2010 Share Posted July 15, 2010 Can you show us the relevant code? Link to comment Share on other sites More sharing options...
Usarjjaco Posted July 15, 2010 Author Share Posted July 15, 2010 Hey Guys,Total Palm To The Face Moment. When I was getting ready to copy over the script's page I noticed that I had a letter off that had been changed in one of my variables, henceforth it was defaulting to '0'. Thanks for all the help! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.