Announcement

Collapse
No announcement yet.

More Problems

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Steviepowers
    replied
    Yes, that what I was looking for, the distinct thing, thanks again Max Albert

    Leave a comment:


  • Mark Hensler
    replied
    Really? I've never played with postgreSQL. That's interesting. So what would you do if you had a table that had duplicates, and you wanted to select all the unique fields? Do you have a query you can run, or would you use PHP to siff out the uniques?

    Leave a comment:


  • Scott MacVicar
    replied
    SELECT DISTINCT would also work i guess, i prefer LIMIT 1 as postgresql was giving me problems with DISTINCT.

    Leave a comment:


  • Mark Hensler
    replied
    You mean... SELECT DISTINCT ...?

    there is DISTINCT and DISTINCTROW

    Leave a comment:


  • Scott MacVicar
    replied
    add

    limit 1

    to the end of the code so the query looks something like

    PHP Code:
    $query mysql_query("SELECT * FROM database.table WHERE email='$email' LIMIT 1"); 

    Leave a comment:


  • Steviepowers
    started a topic More Problems

    More Problems

    How do I make it so that when I request data from a table which contains a mailing list, it doesn't select the same person twice if they have added themselves twice?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X