[thelist] What does this MYSQL command mean?

Daniel J. Cody dcody at oracular.com
Fri Jul 14 21:08:11 CDT 2000


its selecting the id, banner, alt_tag, and hiddentag columns from the
lottobanners table.

its selecting those columns only where the timesclicked column is less
than the numbersbought column OR 

where the timesclicked column is less than the numberbought column minus
1.

then its showing you those results ordered by the id column

not sure what the 'limit' function does for mysql though, hopefully
someone else can get that for ya. :)

hth 

.djc.

CDitty wrote:
> 
> I am trying to figure out what one of my programmers is doing here.  Can
> someone explain what this statement is doing?
> 
> SELECT id, banner, alt_tag, hiddentag FROM lottobanners where timesclicked
> < numberbought or numberbought = -1 ORDER BY id LIMIT 3,1 LIMIT 0, 100




More information about the thelist mailing list