+- SphereCommunity (https://forum.spherecommunity.net)
+-- Forum: Sphere 0.56d (/Forum-Sphere-0-56d)
+--- Forum: Script Help (/Forum-Script-Help)
+--- Thread: About mysql (/Thread-About-mysql)
About mysql - 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.
RE: About mysql - 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
RE: About mysql - 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>
endforAnd 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
RE: About mysql - Fahrenait - 03-17-2013 11:24 AM
for 0 <eval <db.row.numrows>>
must be
for 0 <eval <db.row.numrows>-1>