"Jon" <jonraston@xxxxxxxxxxx> wrote in message news:A4.E7.33075.0CDB4034@xxxxxxxxxxxxxxx > Please help with an insert problem. > > Sometimes $data1 could have a comma and that messes up the insert. how do > I > get around that? > > $query = "insert into testtable6 (indx, col1, col2) values (NULL, > '$data1', > '$data2')"; > mysql_db_query("testdb", $query); You are looking for the "addslashes" function. It prepares data for database querys: $query = "insert into testtable6 (indx, col1, col2)"; $query .= " values (NULL, '" . addslashed($data1) . "'"; $query .= ",'" . addslashed($data2) . "'"; mysql_db_query("testdb", $query); Also, you will need to use the "removeslashes" function when you get data from a query. DanB -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
