Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tazanet

    mySQL SELECT two tables

    members table --------------------------------- ID   CREDIT   fname   lname 1    24      jon     smith 2    50      mark     tween 3    23      sam     jonson 4    61      dave    derian 5    28      gio     fery 6    95      anna    lopez ads table --------------------------------...
  2. tazanet

    mySQL SELECT two tables

    Thank you so much it works, but when I do rand() it always gives me a first 'AID' from the group how can I randomize it like from 1 member get always different ads LIMIT 5
  3. tazanet

    mySQL SELECT two tables

    I have two tables members and ads, members table has auto_increment 'ID' , 'CREDIT' and some members information. ads table has 'AID' auto_increment and 'ID' to track who's link is that Basically 1 member can have up to 5 link ads. I want to get from query LIMIT 5 ads who has enough credits...

Part and Inventory Search

Back
Top