RE: [PHP] Array maybe? Or many SQL insert queries

> -----Original Message----- > From: Burhan Khalid [mailto:phplist@meidomus.com] > Sent: Saturday, November 01, 2003 3:50 AM > To: Jake McHenry; php-general@lists.php.net > Subject: Re: [PHP] Array maybe? Or many SQL insert queries > > > Jake McHenry wrote: > > > Hi everyone, here's what I'm doing. > > > > As of right now, I don't have anything implemented, but > here's what I > > need to do. > > > > I have a web page, with a drop down list of hotels, an > input box for > > the users frequent hotel number, and a add button. At the bottom of > > the page is a update and continue button to move the user > to the next > > page with more options. > > > > What my boss wants is, when someone puts in a number, and > clicks add, > > he wants it to take that number and put it below the box, > all on the > > fly. I know I could do this through repeated sql insert > querys, but I > > was wondering if I could just put them into an array, then > update the > > database with one query after the user clicks the update > and continue > > button at the bottom, to get them to the next page? > > This sounds like something javascript can fix. If you can be > a bit more > precise "below the box" doesn't mean much. What box? Is it a > big green > box? Blue box? Box of boxes? > > If you want "on the fly" then its javascript. For php to work, you'd > have to send a request to the server, which would kill your > "on the fly" > part. > > > -- > Burhan Khalid > phplist[at]meidomus[dot]com > http://www.meidomus.com > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > I don't know why I said on the fly.. Lol.. The box I'm referring to is the input field box. I just need what's submitted via the input field and add button to show up in a list below the input box, to show the account numbers that were entered. I can either insert them into the database each time the add button is clicked, or my preference if possible, put them in an array of some kind then submit them all at once. To get a picture of what I want...: Site Logo ______________ |______________| ADD Submit and Continue Submit and Exit That's basically what this page looks like. What I need is when the person inputs the account number in the input box, and clicks add, it needs to refresh the page with the added number below that box, then again for each number they enter. Like I said, I can do this with multiple accesses to the database, but I would like to know of a way I could submit them all at once instead of multiple accesses to the database. Let me know if you need more info. Thanks, Jake McHenry Nittany Travel MIS Coordinator http://www.nittanytravel.com