Threaded Mode | Linear Mode

Pidrila · 04-09-2013 11:07 PM

sorry for DP DP.. but there i get a problem..

in this script is for main page of dialog right??

Code:

DB.QUERY "SELECT * FROM <tag.auction_table> ORDER BY `id` DESC LIMIT 99999999";

 src.ctag.totalpages=<eval (((<db.row.0.id>-1) / 7) + 1)>

 dtext 715 3 0481 Items: <eval (<db.row.0.id>)>

 dtext 623 448 0481 Page: [<eval (<src.ctag.actualpage>)>/<eval (<src.ctag.totalpages>)>]

but now i need to get info from only one field in the database calling category..

i tryed to do something like this

Code:

DB.QUERY "SELECT * FROM <tag.auction_table> WHERE category='1' ORDER BY `id` DESC LIMIT 99999999";

 src.ctag.totalpages=<eval (((<db.row.0.id>-1) / 7) + 1)> 

 dtext 715 3 0481 Items: <eval (<db.row.0.id>)>

 dtext 623 448 0481 Page: [<eval (<src.ctag.actualpage>)>/<eval (<src.ctag.totalpages>)>]

but it's givving the same info as the main page.. i tryed to do <eval (<db.row.0.category>)> or <eval (<db.row.11.id>)> //11 is the field of category but there is no success.. maybe you could help me..
how to get info and then array it on dialog taking info only from one field in db and summing it like id or smth..

Okey i finished it myself..

if someone need it. here it is.

Code:

DB.QUERY "SELECT COUNT(*) as category1_items FROM <tag.auction_table> WHERE category='1'";

src.ctag.totalpages=<eval (((<db.row.0.category1_items>-1) / 7) + 1)>

dtext 715 3 0481 Items: <eval (<db.row.0.category1_items>)>

dtext 623 448 0481 Page: [<eval <src.ctag.actualpage>>/<eval <src.ctag.totalpages>>]

Threaded Mode \| Linear Mode Page system
Author	Message