www.webdeveloper.com

Search:

Type: Posts; User: lilfellabob

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    7
    Views
    745

    haha, all good! thanks dude! One more thing I'm...

    haha, all good! thanks dude!
    One more thing I'm wondering, is it possible to run this query but have it show the duplicated rows? What I need to do is compare some of the other columns then decide...
  2. Replies
    7
    Views
    745

    I got it working by changing that up a little: ...

    I got it working by changing that up a little:


    SELECT
    CONCAT_WS(', ', first_name, last_name) AS full_name,
    COUNT(*) AS num_res
    FROM table_name GROUP BY full_name
    ORDER BY num_res...
  3. Replies
    7
    Views
    745

    Yeah, there is an int as a unique id Hmm,...

    Yeah, there is an int as a unique id



    Hmm, that seems to be returning all rows with num_instances as the full row count..
  4. Replies
    7
    Views
    745

    Find duplicates in table

    Hey, I am trying to find rows that have the same value for 2 columns in my table. Specifically duplicate people in the table (same first and last names).
    I have tried the following (plus some...
  5. jQuery Awesome, thank you!

    Awesome, thank you!
  6. jQuery Set element's text as a target's value

    Hey,
    What I want to do is pretty simple, but I am very new to jquery. I can set text to a div by doing
    $("#target").text("This is text");
    But what if I want the "This is text" to be replaced by...
  7. Replies
    3
    Views
    1,699

    Hey - I don't know if I solved it (sorry) - I...

    Hey - I don't know if I solved it (sorry) - I think I may have just pulled all columns then compared them in php since there wasn't that many to go through..
  8. AJAX Run two XMLHttpRequests with the second based off the first

    Hey all,

    I am trying to use a javascript function to run an sql query via an external php page and then use the returned value of that to then execute more javascript before executing another...
  9. Thanks heaps man, it works! The logic is a...

    Thanks heaps man, it works!
    The logic is a little confusing but that's ok :P
  10. Select one row with a distinct column, ordered by another column..

    Hi,

    I am trying to make a simple search where I can look up orders. The thing that's getting me is I want only one result for each unique 'client_name', and it has to be the most recent row (I...
  11. Replies
    3
    Views
    1,699

    dynamic column query mysql

    Hey all,

    I am trying to make a script where I can query for a column that changes depending on a passed variable. So I have a variable passed called division, lets say it will be a, b, c or d.. I...
  12. Ok after some troubles it's now working :D - I...

    Ok after some troubles it's now working :D - I think maybe I had issues with quotation marks..
    Thanks guys!
  13. Awesome, thanks so much dude!

    Awesome, thanks so much dude!
  14. Memory problem when uploading large(ish) images

    Hey all,

    I have a page where I can upload an image and php will create 2 down-scaled images. One is for the thumbnail which is max width of 125px and max height of 95px and the other for the...
  15. Sweet, I may look into it! thanks

    Sweet, I may look into it! thanks
  16. Get height of an element /if/ set to auto

    Hey all,

    So I am making a nav for a mobile webapp and I found an awesome guide that I have picked apart then changed.
    http://designshack.net/articles/css/verticalaccordionav/
    He says in there...
  17. Replies
    2
    Views
    1,785

    Thanks for the reply! I think the precomposed has...

    Thanks for the reply! I think the precomposed has indeed fixed it.
    Apple says:
    'If you donít want Safari on iOS to add any effects to the icon, replace apple-touch-icon with...
  18. Replies
    2
    Views
    1,785

    iDevice 'add to homescreen' icon

    Hey guys,

    So I have a mobile website that I have made compatible with iPhones using


    <meta name="apple-mobile-web-app-capable" content="yes" />

    and I have tried to get it to have an icon...
  19. Replies
    2
    Views
    2,269

    After more searching, I found what I am looking...

    After more searching, I found what I am looking for. In case anyone else find this when trying to do the same thing:


    $sql = "SHOW TABLES FROM demonsi1_db LIKE '&#37;_gallery'";
    $do_sql =...
  20. Replies
    2
    Views
    2,269

    List tables that have specific string

    Hi all,

    I am wanted to list tables from my database, but only tables that contain a certain string.
    Say I have a database with four tables:
    honda_car
    yamaha_bike
    kawasaki_bike
    ford_car
    I...
  21. Replies
    4
    Views
    2,017

    thanks NogDog, you are seriously a champion mate...

    thanks NogDog, you are seriously a champion mate :D
  22. Replies
    4
    Views
    2,017

    thanks dude, the www part is the issue.. to use ...

    thanks dude, the www part is the issue.. to use
    ini_set('session.cookie_domain', '.domain.com');
    I would have that before session_start();
    correct?
    (that doesn't seem to fix it..)
  23. Replies
    4
    Views
    2,017

    session variables problem

    So I've used sessions a heap before but they have decided they don't like me anymore and are not working.. I cannot for the life of me work out why and it's driving me crazy..
    I have a page that...
  24. Hmm yeah I thinking that first lot is what I'd...

    Hmm yeah I thinking that first lot is what I'd use. But I decided that I'd be better off putting it in one table then adding a field to split it up later.

    Thanks for the help guys, really...
  25. thanks for the reply. It fixed the error but it...

    thanks for the reply.
    It fixed the error but it still loops through some row's many many times (no idea why..)

    :S
Results 1 to 25 of 53
Page 1 of 3 1 2 3
HTML5 Development Center



Recent Articles