Is it possible to insert a fetch_array into a database?

[SeanKann]

I have a fetch_array that gets all my records. Can be anywhere from 10-400 or more records.

Then I have to do a form on the page to tie 2 other manual pieces of information then I need to insert it all into a table to view later on with all the information.

I've tried just doing a form with method='post' but I got a URL to long error did some researching.

Work around needs to be done on the server but I don't want to do this.

Is there another way of doing all this?

TIA

[Weedpacket]

If you're getting something out of the database only to put it back in again, then it suggests to me that you don't need to pass it from one page to another; you already have it.

Similarly, there's no need to send it all out to users only to have them send it all back again. Instead, keep a copy of what you send in a [man]session[/man] and match it up with the information supplied by the user.

[SeanKann]

What I need to do is the following.

My mySQL Query is doing a bunch of left joins on a couple other tables. Then with that information that I get from my query I need to add manual information into it. Information that isn't in any of my tables at all. Plus there is some math that I have to do with it as well.

Then I need to send all that information into another table with the new updated information.

This is why I am asking..

Thoughts?

[Ashley_Sheridan]

Can't you create an update query that pulls in information from those other tables and adds in the ancillary information you want to add to it, or does that extra information require specific details from the first query?

If you really do need to do it your way, then you'll need to do a bit of work. There's no "chuck this mixed data from different tables into another single table with extra info" function in PHP, you're going to have to create the insert query yourself.

Tell us a bit more specifically about what you're updating/adding to the retrieved data. Are you just incrementing a field, splitting a string field into different parts? Your answer could mean that a quicker way to do what you need can be found.