Vaupell
02-07-2009, 10:24 PM
Doing a result in admin cp and want it paged
cause some results might show up several hundred :
Total post EDIT
found a excelent ARTICLE.. (https://vborg.vbsupport.ru/showthread.php?t=200413)LOVELY..
now i just need a hand with a query
$SPBI = $vbulletin->db->query("SELECT * FROM " . TABLE_PREFIX . "post WHERE ipaddress='".$vbulletin->GPC['searchstring']."' LIMIT " . ($limitlower - 1) . ", $perpage");
this one gives me 1064 :P yeah i know. but not sure how to fix such a query.
Fixed the limitlower was wrong, plus misplaced ''s ;)
cause some results might show up several hundred :
Total post EDIT
found a excelent ARTICLE.. (https://vborg.vbsupport.ru/showthread.php?t=200413)LOVELY..
now i just need a hand with a query
$SPBI = $vbulletin->db->query("SELECT * FROM " . TABLE_PREFIX . "post WHERE ipaddress='".$vbulletin->GPC['searchstring']."' LIMIT " . ($limitlower - 1) . ", $perpage");
this one gives me 1064 :P yeah i know. but not sure how to fix such a query.
Fixed the limitlower was wrong, plus misplaced ''s ;)