I really need help with a script I want to create which will add values in a textarea into tables into the database as records

It needs to have

So that all those values are submitted as a record into mysql

I have the basic database connect routine set up and already have a page that can show the results

I would also maybe like a page that allows you to delete/edit records but this is probably too hard

I'm not very experienced with mysql :(
Thanks a lot :D

Hi robinwilson16,

I'm sure you could find what you're looking for pretty easily at www.mysql.com. Alternatively there's a pretty good book available from Team LiB called 'Mastering Dreamweaver MX Databases'. It not only teaches you, but it helps you tie everything together in a 'real world' kind of way.

I've attached an example below that I think will give you what you need too.

All the best,
E3 :)

Thanks a lot

I could never have written anything like that

You are very helpful :D :thumbup1:

Sorry but I need help creating the mysql tables

I created all the ones I thought I needed but when I try to add an entry I get:

The tables I have are:

I also tried adding master_id as a primary table on each one but I still get the same error

Thanks for helping, I'm a n00b when it comes to this sort of thing ;)

Hi robinwilson16,

Check your PM's :).

All the best,
E3

Thanks a lot, that was really useful :D

Script is working just how I wanted :thumbup1: