1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Recent Content by Benanamen

  1. Benanamen
    Post

    Need help on Mysql Select to show all under one id using php.

    Your post makes no sense at all. What is the REAL problem you are trying to solve?
    Post by: Benanamen, Jul 16, 2018 in forum: Databases
  2. Benanamen
    Post

    Include file inside PHP class

    The OP's question is an XY Problem, therefore the answers given to it are not the right answers for the real problem. You do not hard code...
    Post by: Benanamen, Jul 1, 2018 in forum: PHP
  3. Benanamen
    Post

    Why is the last array returning null?

    What is the real problem you are trying to solve? I dont mean your attempt at solving it.
    Post by: Benanamen, Jul 1, 2018 in forum: PHP
  4. Benanamen
    Post

    Angular and server set up for project needed

    What is your budget for the project?
    Post by: Benanamen, Jan 16, 2018 in forum: Programming
  5. Benanamen
    Post

    update multiple rows with multiple columns using loop

    Did you look at ETL software as suggested? This is a good situation for it. If you are able to provide the file I can guide you.
    Post by: Benanamen, Jan 7, 2018 in forum: Databases
  6. Benanamen
    Post

    update multiple rows with multiple columns using loop

    You still didn't answer if this is a one time update you need to do. Where is the data coming from in the first place?
    Post by: Benanamen, Jan 7, 2018 in forum: Databases
  7. Benanamen
    Post

    update multiple rows with multiple columns using loop

    Your using Mysqli AND PDO in the same script? You don't use both. Use PDO and be done with it.
    Post by: Benanamen, Jan 7, 2018 in forum: Databases
  8. Benanamen
    Post

    update multiple rows with multiple columns using loop

    Is this a one time update? If so, the easiest way to do this is with ETL Software. https://en.wikipedia.org/wiki/Extract,_transform,_load
    Post by: Benanamen, Jan 3, 2018 in forum: Databases
  9. Benanamen
    Post

    Upating Thousands of Records

    Your head is in the wrong place. Forget about code. Mysql does not require code to run queries. You can run them from the command line or use free...
    Post by: Benanamen, Dec 25, 2017 in forum: Databases
  10. Benanamen
    Post

    Upating Thousands of Records

    How about skipping the code gymnastics and just run the proper querys on the database?
    Post by: Benanamen, Dec 25, 2017 in forum: Databases
  11. Benanamen
    Post

    How to force an INSERT INTO job to continue despite errors?

    Going back to the OP's question, INSERT IGNORE is the solution. "So, I'm adding content to a db but sometimes one of the entries already exists,...
    Post by: Benanamen, Dec 16, 2017 in forum: Databases
  12. Benanamen
    Post

    How to force an INSERT INTO job to continue despite errors?

    No, No, and NO! You create a race condition when you do that. The correct method is to set a unique constraint on the column, attempt the insert...
    Post by: Benanamen, Dec 16, 2017 in forum: Databases
  13. Benanamen
    Post

    How to force an INSERT INTO job to continue despite errors?

    Rather than just answer your question, how about try it and see what happens.
    Post by: Benanamen, Dec 9, 2017 in forum: Databases
  14. Benanamen
    Post

    How to force an INSERT INTO job to continue despite errors?

    Your problem is the single quotes in your data. If you are using Php with prepared statements it will be no problem. If you are inserting the data...
    Post by: Benanamen, Dec 9, 2017 in forum: Databases