Jump to content

niche

Members
  • Posts

    3,671
  • Joined

  • Last visited

  • Days Won

    17

niche last won the day on November 13 2021

niche had the most liked content!

6 Followers

About niche

  • Birthday 01/01/1958

Previous Fields

  • Languages
    php, mysql, html, css, javascript

Profile Information

  • Location
    Lincoln, Nebraska, USA
  • Interests
    coding, inventing, selling, building large scale models, sci fi

Recent Profile Visitors

57,233 profile views

niche's Achievements

Devoted Member

Devoted Member (5/7)

159

Reputation

  1. https://www.sqlshack.com/different-ways-to-sql-delete-duplicate-rows-from-a-sql-table/
  2. This'll take care of your question: https://www.w3schools.com/css/css_font_size.asp Feel free to post your code, if you still need help
  3. Why did you use NOT instead of WHERE?
  4. niche

    MySQL query help

    If you want to do a COUNT, one of both tables have some dupes. Which ones or both?
  5. niche

    MySQL query help

    What kind of duplication do you have in both tables?
  6. Where's your form in your last post? EDIT: Based on just the code in the your last post, your $_POST array doesn't exist.
  7. You're using the POST method and '' for the action, so put an if statement after your form and do whatever you need to within that if. Like this: // form goes here if (isset($_POST['pick a name from your form'])) { // do your thing here } Voila!
  8. niche

    Query help

    I don't think that will do anything. You need to SELECT more columns than than just the ones you want to JOIN ON to get anything back. Also, I recommend changing imageid to output_images.imageid
  9. niche

    Query help

    Never wrote a do while Loop. So, I looked it up! Looks like it should work Pretty simple concept.. If not post the error, if you can't resolve it and we'll deal with it then. Great example of the student teaching the teacher, which is frequently the case. Thanks!
  10. niche

    Query help

    Take the results from both queries and do array_push to combine results. Then, do what ever you want in a loop. https://www.w3schools.com/php/func_array_push.asp EDIT: You can also do a UNION if that makes sense.
  11. niche

    Query help

    Let's deal with what might be the first challenge. How you want to do to do your mult queries? Actual separate multiple queries, sub queries, JOINS, etc. If something else needs to happen first, let us know.
  12. niche

    Query help

    What's your question?
  13. Glad you solved you question. I went camping and didn't have any access. Didn't even see a desktop, pad or smartphone for two days Incredible!
  14. Are you using an admin tool like phpmyadmin? If so which one?
  15. Glad to help, but what should you do first before inserting?
×
×
  • Create New...