Results 1 to 5 of 5

Thread: Update Data

  1. #1
    Join Date
    Sep 2011
    Posts
    35
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Question Update Data

    I want to update the product list and inside all product list will shown even add by multiple user.
    Now user 1 add more than one product and one product has been sold than User 1 press the Update button and the product status will shown "SOLD". I am using php with mysql.
    please see the image for Product List Click image for larger version. 

Name:	Product_Display.jpg 
Views:	411 
Size:	96.4 KB 
ID:	5267

    please see the image for sql table: Click image for larger version. 

Name:	SQL.jpg 
Views:	217 
Size:	68.2 KB 
ID:	5268
    Last edited by salman1karim; 11-06-2013 at 11:30 AM.

  2. #2
    Join Date
    Jan 2007
    Location
    Davenport, Iowa
    Posts
    2,385
    Thanks
    100
    Thanked 113 Times in 111 Posts

    Default

    If I am understanding you correctly you want the seller to be able to view the list of items for sale including his own items. Where his items are displayed there will be an option to press a button which will update whether the item has been purchased and therefore no longer available.

    The problem that you are having is that when the owner has more than one item for sale there will be more than one update button and you want the button to only update the listed availability for that item. Am I understanding you correctly?
    To choose the lesser of two evils is still to choose evil. My personal site

  3. #3
    Join Date
    Sep 2011
    Posts
    35
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Default

    yes you are right!

  4. #4
    Join Date
    Sep 2011
    Posts
    35
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Default

    Quote Originally Posted by salman1karim View Post
    yes you are right!
    Yeah I did it through the jquery.

  5. #5
    Join Date
    Jan 2007
    Location
    Davenport, Iowa
    Posts
    2,385
    Thanks
    100
    Thanked 113 Times in 111 Posts

    Default

    Quote Originally Posted by salman1karim View Post
    Yeah I did it through the jquery.
    Does this mean that your problem is solved? If so please mark this thread as resolved by editing your first post in this thread and hit go advanced and there will be an option next to the title of your thread to mark the thread as resolved.

    If your problem is not resolved could you post the code that you are currently using so we can troubleshoot your code?
    To choose the lesser of two evils is still to choose evil. My personal site

Similar Threads

  1. Change syntax from Update Case Statement to Update Union Statement
    By newphpcoder in forum MySQL and other databases
    Replies: 0
    Last Post: 11-11-2011, 01:23 AM
  2. Include and Update Data in the database
    By Dilruba in forum ASP
    Replies: 2
    Last Post: 09-02-2011, 01:40 PM
  3. Replies: 7
    Last Post: 04-29-2008, 11:55 AM
  4. Update form data without refreshing page
    By devil_vin in forum PHP
    Replies: 3
    Last Post: 09-21-2007, 05:16 PM
  5. Replies: 2
    Last Post: 03-04-2007, 04:23 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •