thank you soooo much that was much much better indeed :),

i am assuming that i need to use the same for sql_quey sql_display
is that correct?


Caleb Carvalho
Application Engineer
LoadRunner/APM
-----------------------------------------------------------------------------------------
Enterprise Testing and Performance Management Solutions
-----------------------------------------------------------------------------------------
Mercury Interactive
410 Frimley Business Park
Frimley, Surrey.  GU16 7ST
United Kingdom
Telephone :  +44 (0)1276 808300



>From: "Dimitris Kossikidis" <[EMAIL PROTECTED]>
>To: "Caleb Carvalho" <[EMAIL PROTECTED]>
>CC: <[EMAIL PROTECTED]>
>Subject: Re: [PHP] still learning php
>Date: Mon, 1 Oct 2001 15:52:23 +0300
>
>Use addslashes() to escape single quotes or double quotes. It 's in the
>manual....
>
>// giving some values
>$firstname ="Bob";
>$lastname = "O' Reily"; // This could cause an error if not use addslashes
>$address = "Somewhere";
>$age= 19;
>
>// adding slashes to quotes
>$firstname = addslashes($firstname);
>$lastname = addslashes($lastname);
>$address = addslashes($address);
>
>$sql =  " insert into TABLE values ( '$firstname', '$lastname', '$address',
>$age) ";
>
>----- Original Message -----
>From: "Caleb Carvalho" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Cc: <[EMAIL PROTECTED]>
>Sent: Monday, October 01, 2001 3:36 PM
>Subject: Re: [PHP] still learning php
>
>
> > Hi Dimitris,
> >
> > thanks, but what if I have 5 fields to add into ie 
>name,surname,comments?
> >
> >
> >
> > Caleb Carvalho
> > Application Engineer
> > LoadRunner/APM
> > 
>--------------------------------------------------------------------------
>---------------
> > Enterprise Testing and Performance Management Solutions
> > 
>--------------------------------------------------------------------------
>---------------
> > Mercury Interactive
> > 410 Frimley Business Park
> > Frimley, Surrey.  GU16 7ST
> > United Kingdom
> > Telephone :  +44 (0)1276 808300
> >
> >
> >
> > >From: "Dimitris Kossikidis" <[EMAIL PROTECTED]>
> > >To: "Caleb Carvalho" <[EMAIL PROTECTED]>
> > >CC: <[EMAIL PROTECTED]>
> > >Subject: Re: [PHP] still learning php
> > >Date: Mon, 1 Oct 2001 14:29:14 +0300
> > >
> > >$field_value = "I 'm bla bla";
> > >$field_value  = addslashes($field_value);
> > >
> > >$sql = "Insert into TABLE values('$field_value');
> > >
> > >
> > >----- Original Message -----
> > >From: "Caleb Carvalho" <[EMAIL PROTECTED]>
> > >To: <[EMAIL PROTECTED]>
> > >Sent: Monday, October 01, 2001 2:05 PM
> > >Subject: [PHP] still learning php
> > >
> > >
> > > > I posted a msg earlier on regarding error when adding text with 
>quotes
>'
> > > > ..
> > > > I have just found out thar I need to use addslash() function,
> > > >
> > > > my q's is
> > > >
> > > > where do i put this function?
> > > >
> > > >
> > > >
> > > > Caleb Carvalho
> > > > Application Engineer
> > > > LoadRunner/APM
> > > >
> >
> >--------------------------------------------------------------------------
> > >---------------
> > > > Enterprise Testing and Performance Management Solutions
> > > >
> >
> >--------------------------------------------------------------------------
> > >---------------
> > > > Mercury Interactive
> > > > 410 Frimley Business Park
> > > > Frimley, Surrey.  GU16 7ST
> > > > United Kingdom
> > > > Telephone :  +44 (0)1276 808300
> > > >
> > > >
> > > > _________________________________________________________________
> > > > Get your FREE download of MSN Explorer at
> > >http://explorer.msn.com/intl.asp
> > > >
> > > >
> > > > --
> > > > PHP General Mailing List (http://www.php.net/)
> > > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > > To contact the list administrators, e-mail:
>[EMAIL PROTECTED]
> > > >
> > > >
> > >
> > >
> > >--
> > >PHP General Mailing List (http://www.php.net/)
> > >To unsubscribe, e-mail: [EMAIL PROTECTED]
> > >For additional commands, e-mail: [EMAIL PROTECTED]
> > >To contact the list administrators, e-mail: 
>[EMAIL PROTECTED]
> > >
> >
> >
> > _________________________________________________________________
> > Get your FREE download of MSN Explorer at 
>http://explorer.msn.com/intl.asp
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> >
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to