Jump to content

niche

Members
  • Posts

    3,671
  • Joined

  • Last visited

  • Days Won

    17

Everything posted by niche

  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?
  16. So, sessions isn't a way to spread out requests from different people?
  17. Is it correct to think that sessions would spread out the initial hit?
  18. I don't see a way to avoid the initial touch by a 100, except to space-out those initial touches, which would automatically happen with sessions. then the problem becomes re integration, which would make it similar to a Version Control challenge IMO.
  19. Taking the question as written, using SESSION would mediate the challenge. That way, every user won't be hitting the same file all the time. Ingolme, what do you think, given only the available info?
  20. Set up a SESSION for each user, so your server will hit the session file for each user, instead of the original server file. https://www.w3schools.com/php/php_sessions.asp EDIT: Using tables and databases, instead of a file, may eliminate your concern.
  21. First step. Let's agree on what we're looking at. I see buttons, floating inside a div, with some padding and a brown background. What do you see?
  22. never had a reason to do that with css, but this looks to be on point: https://stackoverflow.com/questions/14512119/css-move-an-element-overriding-its-position-in-the-html EDIT: Learned something new!
  23. I probably don't understand what you're actually asking, but based on on all the available information, in your question, here's what I'd do: <div class="region region-content"> <h1 class="js-quickedit-page-title page-header">Real Estate Investors1</h1> <div class="views"> .... </div> </div>
  24. add LIMIT 1 SELECT image FROM img ORDER BY uploaded DESC LIMIT 1 EDIT: https://www.w3schools.com/php/php_mysql_select_limit.asp NOTE: the row that gets selected depends on your whether your ORDER BY is ASC or DESC
  25. SHOW INDEX FROM yourtable
×
×
  • Create New...