wolfie1

Thanks. A major function of the website is to send text alerts. I'm doing this via php's mail function at the moment. If the website does well, I could imagine sending thousands, possibly tens of thousands of texts per day. Any advice is appreciated. I've not thought about this too much yet, but I could generate an xml file on the GoDaddy server and have "something else" poll that xml file and send text alerts based on updates in that file. Not sure what the "something else" would be yet....

Thanks guys. I altered the table structure to store these as decimal(10,6) instead of float(10,6), and the data is getting stored correctly now. I also understand this after just having read http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html. Question: I didn't modify the query (to address the quotes issue described in both replies) and the data is getting stored correctly. Am I just getting lucky with this particular value? Does the query need to be modified for sure?

Hello, The data that actually gets stored in my database differs from what I'm trying to put there. Here's a short code snippet: $lat = 42.272939; $lng = -83.622941; // insert cordinates into dB $query = "INSERT INTO markers (lat, lng, user_id) VALUES ('$lat','$lng','$user_id')"; $results = mysql_query($query) or die(mysql_error()); When I look in the database, the data is stored as: 42.272938 and -83.622940. Any ideas as to why this happens? These values are being stored as float(10,6). Not sure if this is useful, but here's some other info: datbase: MySQL engine: InnoDB Format: Compact Collation: utf8_general_ci Thanks

Who do you recommend using?

Hello, I'm using php's mail function to send sms messages to my sprint phone. Sometimes I receive the text right away and other times it comes in as much as an hour or so later. My server is on GoDaddy. Does anyone have any ideas about what could be causing the bottleneck? To debug this I tried sending sms messages from my comcast email. So far those are always received very quickly. Perhaps the issue is on the GoDaddy server... I might try contacting them. By the way, it seems like the first text I send is received quickly, but then if I send other text messages within some short time frame, those don't always show up immediately. Has anyone else experienced anything similar?