WBSKI Posted December 1, 2007 Share Posted December 1, 2007 Hi, I am using MYSQL 4.025 I want to know how I can delimit entries into a database in a different way than the way I know. Currently I know that field entries are separated like this ',' but is there another way I can separate the entries because I want to enter data that has the ' character in it like shown below. <code> INSERT INTO photo( fullurl, midurl, thumburl, width, height, lat, lng, title, caption, user, visible, datetaken, dateadded, tag ) VALUES( '/data/4/photos/franzstriple/full/Franz's Chair01.jpg','/data/4/photos/franzstriple/mid/Franz's Chair01.jpg','/data/4/photos/franzstriple/thumb/Franz's Chair01.jpg','800','600','','','Franz's Chair','Top Station','Russell P','1','1120101509','1196547193','(l-14)(s-4)' ) </code> Thanks You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's Chair01.jpg','/data/4/photos/franzstriple/mid/Franz's Chair01 Check the manual that corresponds to your MySQL server version for the right syntax to use near '/data/4/photos/franzstriple/full/Franz's Chair01.jpg,/data/4/ph Link to comment https://forums.phpfreaks.com/topic/79743-delimiting-entries-into-a-mysql-database/ Share on other sites More sharing options...
wsantos Posted December 1, 2007 Share Posted December 1, 2007 http://www.phpfreaks.com/forums/index.php?topic=138705.0 Link to comment https://forums.phpfreaks.com/topic/79743-delimiting-entries-into-a-mysql-database/#findComment-403828 Share on other sites More sharing options...
fenway Posted December 2, 2007 Share Posted December 2, 2007 There's also mysql_real_escape_string, which is the better function to use for your input values. Link to comment https://forums.phpfreaks.com/topic/79743-delimiting-entries-into-a-mysql-database/#findComment-404190 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.