insert centimeter, inch symbol.

[joe2]

Hi,

How to insert 5'x5'.5" and 5'x5' in one insert statement.
for e.g.

INSERT INTO mytable (size1,size2) VALUES ('5'x5'.5"',''5'x5'');

Fields are varchar.

Thanks

[olaf]

use this:

$val1 = addslashes("5'x5'.5\"");
$val2 = addslashes("5'x5'0"); 

mysql_qery("INSERT INTO mytable (size1,size2) VALUES ('$val1','$val2')");