Welcome to Dream.In.Code
Getting Help is Easy!

Join 132,277 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 1,195 people online right now. Registration is fast and FREE... Join Now!




Mass editing through sql

 
Reply to this topicStart new topic

Mass editing through sql

webmin
post 30 Sep, 2008 - 02:25 PM
Post #1


D.I.C Head

**
Joined: 21 May, 2008
Posts: 96


My Contributions


Hi,

I am running cubecart 3.0.15 and have run into an issue of needing to be able to look up hundreds of products at a time. The product id is the unique number I would like to look up by.

This question may also fit in the php forum so if you need to move it, that's fine, but I would like to be able to build a web form that I can copy and paste all these product id's into, then have it query my database for any products that match it. If there isn't a match for an item number, it should say something like "Item number not found. Please check the rest of the results for any found products."

It can display all the results on one page, but if it does find a record that matches, I would like for it to get the product name and id, and I would like for it to give us an option to delete the record as well. Also I would like an option at the bottom of the results page for deleting all found matches. Please let me know if this is possible .Thanks
User is offlineProfile CardPM

Go to the top of the page

mocker
post 30 Sep, 2008 - 03:54 PM
Post #2


D.I.C Regular

Group Icon
Joined: 14 Oct, 2007
Posts: 256



Thanked 15 times
My Contributions


Yes. This is possible. If you are asking for someone to do all the work for you then I suggest moving this to Request A Service.
User is offlineProfile CardPM

Go to the top of the page

webmin
post 30 Sep, 2008 - 04:07 PM
Post #3


D.I.C Head

**
Joined: 21 May, 2008
Posts: 96


My Contributions


I'm not asking someone to do it for me. I do know how to build the form, I just don't know how to work the backend part of it connecting it to a database, and having it query the records. Basically, I don't know how to make php run the sql commands I need.
User is offlineProfile CardPM

Go to the top of the page

Fast ReplyReply to this topicStart new topic
Time is now: 11/22/08 12:34AM

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

Bye Bye Ads

Free DIC T-Shirt

T-Shirt Example

Related Sites

Monthly Drawing

Thumb Drive

Partners

Top Contributors

Top 10 Kudos This Month