thank you all, you've been a really good help
I must say i've learned a lot, i will now try and get busy
ps. this php mailing list really works :>)
many thanks
Caleb Carvalho
Application Engineer
CSO Europe
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 17:08:00 +0300
>
>$sql = " select firstname, lastname, address etc from TABLE";
>
>execute sql statement;
>
>while fetching records {
> $firstname = stripslashes( $firstname);
> $lastname = stripslashes ( $lastname); // "O\' Reily" now becomes "O'
>Reily"
> }
>that's all
>
>----- Original Message -----
>From: "Caleb Carvalho" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Cc: <[EMAIL PROTECTED]>
>Sent: Monday, October 01, 2001 4:32 PM
>Subject: Re: [PHP] still learning php
>
>
> > 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]
>
_________________________________________________________________
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]
