[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