No, but SQL is your friend, and is actually easier than messing around with
recordsets, once you get the hang of it.
The exact form of your INSERT statement will depend a bit on the database
are you using, but the following is typical. This is MySQL syntax, I
believe PostgresSQL is similar.
INSERT INTO tablename ( firstname, lastname, phone_number) VALUES (
'$strFirst', '$strLast', '$strPhoneNo' )
and if you are truly confident and believe your table structure will NEVER
change, you could shorten it to
INSERT tablename VALUES ( '$strFirst', '$strLast', '$strPhoneNo' )
Sometimes you just UPDATE
UPDATE tablename SET firstname = '$strFirst', lastname = '$strLast',
phone_number = '$strPhoneNo' WHERE primary_key_field = '$UniqueID'
If any rows are returned by a SELECT statement determines whether you use
an INSERT or an UPDATE, but then you have to do that to determine whether
you .AddNew or .Edit.
Hope this helps - Miles Thompson
PS Of course _nothing_ beats the ease of use and clarity of FoxPro and its
At 11:00 PM 11/20/2001 +0100, Daniel Schwab wrote:
>I came from ASP and I'm sort of a newbie. I'm sure you'll see
>that after my question :-)
>I'm looking for a way to insert data in an mysql db but not with an
>insert into statement. Is there any way i can do some sort of:
>mydb.myfieldname = $myvalue
>(same as in asp with recordsets: rs!fieldname = value)
>any way to do that in a similar manner?
>thanks for your help
>PHP Database 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 Database 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]