i am trying to get results from mssql database table using php pdo , but its not returning any results , but i can count table rows , advice plz
//this one working fine return 500 recrod in table
$sql = "SELECT count(*) FROM Content";
$stmt = $conn->prepare($sql);
$stmt->execute();
$num_rows = $stmt->fetchColumn();
//this one not returning anything
$sql = " SELECT c.* FROM (
SELECT ROW_NUMBER() OVER(ORDER BY ID) AS RowID,* FROM Content
) AS c
WHERE c.ID > :row_start AND c.ID <= :row_end
";
$stmt = $conn->prepare($sql);
$stmt->bindParam(':row_start', $row_start);
$stmt->bindParam(':row_end', $row_end);
$stmt->execute();
$allsuck = $stmt->fetchAll(PDO::FETCH_COLUMN);
print_r($allsuck);
table info :
Array
(
[0] => ID
[1] => Title
[2] => Fulldata
[3] => description
[4] => Catid
[5] => language
[6] => Created
[7] => Userid
[8] => MetaKey
[9] => Thumbnail
[10] => Thumbnail_desc
[11] => Hits
[12] => Active
[13] => ModifiedDate
[14] => ModifiedBy
[15] => Fb_image
[16] => important
[17] => hashTags
)
Aucun commentaire:
Enregistrer un commentaire