Thank you all

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" <dikos@vip.gr> To: "Caleb Carvalho" <havanero@hotmail.com> CC: <php-general@lists.php.net> 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" <havanero@hotmail.com> To: <dikos@vip.gr> Cc: <php-general@lists.php.net> 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" <dikos@vip.gr> To: "Caleb Carvalho" <havanero@hotmail.com> CC: <php-general@lists.php.net> 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" <havanero@hotmail.com> To: <dikos@vip.gr> Cc: <php-general@lists.php.net> 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" <dikos@vip.gr> To: "Caleb Carvalho" <havanero@hotmail.com> CC: <php-general@lists.php.net> 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" <havanero@hotmail.com> To: <php-general@lists.php.net> 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: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail:

php-list-admin@lists.php.net

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail:

php-list-admin@lists.php.net

_________________________________________________________________ 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: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail:

php-list-admin@lists.php.net

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail:

php-list-admin@lists.php.net

_________________________________________________________________ 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: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net

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