Delimiting entries into a mysql database

[WBSKI]

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

[wsantos]

http://www.phpfreaks.com/forums/index.php?topic=138705.0

[fenway]

There's also mysql_real_escape_string, which is the better function to use for your input values.