You just add more fields:
$sql = "Insert into TABLE values('$name', $surname, $comments);
that's assuming that the order of the data exactly matches the order of the 
fields in the table.

Take the time to work through a couple of MySQL tutorials(assuming that's 
what you're using), and have a look at the tutorials Julie Meloni has on 
her http://www.thickbook.com site.

Miles

At 12:36 PM 10/1/01 +0000, Caleb Carvalho wrote:
>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]

Reply via email to