Jump to content

niche

Members
  • Posts

    3,671
  • Joined

  • Last visited

  • Days Won

    17

Posts posted by niche

  1. this script deletes dupe rows when table_key is a column:

    DELETE t1 FROM obssum_history  t1
    INNER JOIN obssum_history  t2 
    WHERE 
        t1.id < t2.id AND 
        t1.table_key = t2.table_key

     how would I do that when table_key is a column alias?

    Already tried something like this (when table_key is NOT contained in the table):

    USING CONCAT(col1, col2) AS table_key
    DELETE t1 FROM obssum_history  t1
    INNER JOIN obssum_history  t2 
    WHERE 
        t1.id < t2.id AND 
        t1.table_key = t2.table_key

    didn't work.

  2. Why client side, w/ javascript and some kind of database, instead of server side, w/ something like PHP and MYSQL?

    I'd go w/ PHP and MYSQL to dynamically populate a menu, but that's me.

    Please confirm that you've thought about client side / server side and purposely chose client side.

     

     

     

     

  3. Please limit each question to a single question.  I suggest you post a notice that you suspend this thread and re submit per my suggestion.    

    EDIT

    Also, please limit your code posts to the relevant part and please use the code tags <>.  

     

  4. I'd do it client side with php.  either way you'd need to know something about php (server side) or javascript (client side).  else, the answer is probably beyond your current capabilities.  Someone else might have a different approach/opinion.

    We're  happy to help as long as you try to ask informed questions.  The best hint I can give you is that you'll probably need to use some kind of loop.  so, read up on php loops specifically and php in general and try to rough out how you'd fit a php loop into your code.

    First things first, though.  you'll need to set a localhost.  i'd use wampserver for that.  So, install wampserver (assuming you're using windows) and get back with us.  The step after that is familiarizing yourself w/ php.

    This will be a leap worth taking.

×
×
  • Create New...