Select MAX with PHP/SQL Server with ADODB

Question

I need to select the maximum value from a table , as described below , but do not return anything. I use PHP / SQL Server with library ADODB.

<?php
session_start();
//connessione al DB
include("dati_db.inc.php");
include ("init.php");
$qry = "select (IDSQL) from test.dbo.TTS_ext_ticket";
echo $qry;
$newrecordSet = $db->Execute($qry);
if ($db->ErrorMsg() != '') {    echo $db->ErrorMsg().' '.$condition; return;}

$ID_TICKET=$recordSet->fields["idticket"];
echo $ID_TICKET;   
?>

possible duplicate of [SQL Server - Selecting a Record With MAX Value](http://stackoverflow.com/questions/8387587/sql-server-selecting-a-record-with-max-value) — Axel Guilmin, Jul 29 '15 at 17:04

score 1 · Answer 1 · answered Jul 29 '15 at 16:49

1

Use MAX() Like :

$qry = "select MAX(IDSQL) AS max_idsql from test.dbo.TTS_ext_ticket";

answered Jul 29 '15 at 16:49

callmemath

8,185
4
37
50

in truth I had already changed the query , but still does not work – Marco Attanasio Jul 29 '15 at 16:57

score 0 · Answer 2 · answered Jul 29 '15 at 17:12

0

use this query

$qry = "select MAX(IDSQL) AS idticket from test.dbo.TTS_ext_ticket";

Note that the alias is named as idticket as this is what you expect later in code.

answered Jul 29 '15 at 17:12

DhruvJoshi

17,041
6
41
60

Select MAX with PHP/SQL Server with ADODB

2 Answers2