PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
Hi folks I am new to this forum, but I guess I may be in and out quiet a bit since I "lost" my php programmer and am having to learn whislt doing.
Can anybody please help with this little problem, I need to add mulitple rows to a DB table. Th form is built (that bit is easy) but when I try to sqlInsert I always get error messages. If someone could "ponit me" in the right direction I would be very happy.
The sqlinsert needs to be on the same page with a simple confirmation message. I can "sort out" which table etc it needs sent to but what I can't do is get multiple variables sent to the sqlInsert.
What kind of error do you get an what is structure of databases jobskills, jobtojobskills and employeejobskills?
You may first try to put this sql into one line (ie remove linebreak after "$sql = "SELECT * FROM jobtojobskills")
Crom, Thanks for your reply, the line break is only there "in the forum" on the actual php page it deoesn't exist.
The error is quiet simple, I cannot get the "multiple" rows skill[] ti insert, I can get an accurate row count on submit, but the form always only ever adds the "last" record never all the records
Crom, Thanks for your reply, the line break is only there "in the forum" on the actual php page it deoesn't exist.
The error is quiet simple, I cannot get the "multiple" rows skill[] ti insert, I can get an accurate row count on submit, but the form always only ever adds the "last" record never all the records