Threaded Mode | Linear Mode

Dullais · 03-17-2013 01:07 AM

grr... Hello everyone (agin)
I just spend about 3 hours searching for answer about mysql and its usage, nowhere nothing was told about it. So finally i post my problem here.
Iam thinking about making another vendor system like wallmart, but not wallmart. (every client has his own vendor).
So my problem is: how do i return multiple values ? (from multiple rows) (i do know this is made by for). I can only get script to return last value, i need it to read all rows with my uid and make a list with thoes items.
I hope you could understand my pain and i'am sorry if something is not understandable in my text.

Shaklaban · 03-17-2013 01:21 AM

PHP Code:

DB.QUERY "SELECT * FROM vendors ORDER BY price LIMIT 5"  //return maximum 5 items with lowest price

for 0 <eval <db.row.numrows>>
    serv.log <db.row.<local._for>.name>:<db.row.<local._for>.price>
endfor 

Dullais · 03-17-2013 01:34 AM

(03-17-2013 01:21 AM)Shaklaban Wrote:
PHP Code:

DB.QUERY "SELECT * FROM vendors ORDER BY price LIMIT 5" //return maximum 5 items with lowest price for 0 <eval <db.row.numrows>> serv.log <db.row.<local._for>.name>:<db.row.<local._for>.price> endfor

So i made one like this

Code:

DB.QUERY "SELECT * FROM vendor_sys ORDER BY PRICE LIMIT 5"  //return maximum 5 items with lowest price

for 0 <eval <db.row.numrows>>

    serv.log <db.row.<local._for>.NAME>:<db.row.<local._for>.PRICE>

endfor

And it gives me:
17:36:(functions.scp,73):
17:36:(functions.scp,73):
17:36:(functions.scp,73):

From my neverendig lookings, There was dlocal not local, this one worked fine Smile

Fahrenait · 03-17-2013 11:24 AM

for 0 <eval <db.row.numrows>>

must be

for 0 <eval <db.row.numrows>-1>

Threaded Mode \| Linear Mode About mysql
Author	Message