|
| |
208 |
208 |
$sql = preg_replace('/SELECT(.*)FROM[ \n\r](.*)/is','SELECT COUNT(*) AS TableCount FROM $2', $sql); |
|
|
| |
209 |
209 |
$sql = preg_replace('/(.*)LIMIT(.*)/is','$1', $sql); |
|
|
| |
210 |
210 |
$sql = preg_replace('/(.*)ORDER BY(.*)/is','$1', $sql); |
|
| |
211 |
|
echo $sql; |
|
|
| |
212 |
|
$db =& GetADODBConnection(); |
|
|
| |
|
211 |
|
|
|
| |
|
212 |
|
|
|
| |
|
213 |
|
|
|
| |
|
214 |
$db =& GetADODBConnection(); |
|
|
| |
213 |
215 |
return $db->GetOne($sql); |
|
|
| |
214 |
216 |
} |
|
|
| |
215 |
217 |
|