Welcome to Dream.In.Code
Become an Expert!

Join 150,201 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 2,015 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
30 Sep, 2008 - 02:25 PM
Post #1

D.I.C Head
**

Joined: 21 May, 2008
Posts: 97



Thanked: 1 times
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
+Quote Post

mocker
RE: Mass Editing Through Sql
30 Sep, 2008 - 03:54 PM
Post #2

D.I.C Regular
Group Icon

Joined: 14 Oct, 2007
Posts: 290



Thanked: 17 times
Dream Kudos: 25
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
+Quote Post

webmin
RE: Mass Editing Through Sql
30 Sep, 2008 - 04:07 PM
Post #3

D.I.C Head
**

Joined: 21 May, 2008
Posts: 97



Thanked: 1 times
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
+Quote Post

Fast ReplyReply to this topicStart new topic
Time is now: 1/9/09 05:02AM

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month