mSQL Web Address Book

Back to the Address Book listing.

0) { /* * here we would update the record identified by $id */ } else { /* * generate a new id from the sequence */ $err = msqlQuery ($db, "select _seq from addr_book"); if ($err < 0) { printf ("Error: $ERRMSG\n"); exit (1); } else { $res = msqlStoreResult (); $row = msqlFetchRow ($res); $id = $row[0]; msqlFreeResult ($res); } /* * insert the new record */ $err = msqlQuery ($db, " \ INSERT INTO addr_book \ (id, last_name, first_name, title, company, e_mail) \ VALUES \ ($id, '$last_name', '$first_name', '$title', \ '$company', '$e_mail') \ "); if ($err < 0) { printf ("Error: $ERRMSG\n"); exit (1); } else { echo (" Entry for $last_name, $first_name inserted successfully.\n "); } } >