Search found 4 matches

by davejog
Wed Apr 30, 2008 6:04 am
Forum: Databases
Topic: small query problem
Replies: 7
Views: 698

Re: small query problem

nothing, I have a very little experience with mysql/sql I'm kinda shooting in the dark here...
by davejog
Wed Apr 30, 2008 4:17 am
Forum: Databases
Topic: small query problem
Replies: 7
Views: 698

Re: small query problem

this means I will have to query the db several times, or the union will connect everything?
by davejog
Wed Apr 30, 2008 3:49 am
Forum: Databases
Topic: small query problem
Replies: 7
Views: 698

Re: small query problem

what if I don't need it shuffled, only get x results with company=1, y results with company=2 and z results with company=3?
by davejog
Tue Apr 29, 2008 9:36 am
Forum: Databases
Topic: small query problem
Replies: 7
Views: 698

small query problem

Hi, I know it's a generic data, but it will help simplify the question: table with fields: ID (int, auto increment), name (varchar), price (int), company (int) lets assume there are around 300 rows in this table. company can be 1,2,3,4 is there a way to query the following: shuffle all the data and ...