string problem

hi,

i have this string

$type = 12'8" x 16'8"

which i need to enter in the database.

when i use

$type = addslashes($type);

the value becomes 12' and the rest is removed.

so which functions i should use which gives me the string as it so that it be added to a database/

thanks in advance

kalyan

if you have MySQL databaze, you don't need to add extra slashes. simpy do insert like
$q="insert into table...values('$type'...

and mysql will convert that string itself.

for another databases you'll need to double '.. eg $type=ereg_replace("'","''",$type);

i am using mysql

it gets stripped when i insert some values with 6' 8 ''
which means 6 feet and 8 inches

thanks in advance for any ideas

kalyan

Tom Z. Meinlschmidt wrote:

if you have MySQL databaze, you don't need to add extra slashes. simpy do insert like
$q="insert into table...values('$type'...

and mysql will convert that string itself.

for another databases you'll need to double '.. eg $type=ereg_replace("'","''",$type);

hi,

I think this might help u. If u r getting the value (12'8" x 16'8") posted from a page , i mean its the value got by submitting the page , then

use this

$name=stripslashes(addslashes($txtCheck));

where txtCheck is the control's name.

Now insert $name through sql query.