[SOLVED] ORDER BY Clause.....something is amiss here.

[maliary]

 

Hi people,

 

I this SQL statement that is supposed to get the last row in a table

 

$sql4="SELECT batch_nr FROM care_test_request_baclabor WHERE batch_nr LIKE '%".$branchID."' ORDER BY batch_nr DESC LIMIT 1"; 

 

The last row happens to have a batch_nr value of 1080

The second last row has a batch_nr value of 11322070

 

The query picks the second last row, why dosen't it pick the actual last one. Is this a problem with the ORDER BY clause ?

 

[tinker]

hats the value of $branchID ?

[revraz]

How is it stored, INT or VARCHAR?

 

You want it as a INT.

[Daniel0]

There is no point in having an ORDER BY if you limit it to one row.

[revraz]

How else can you only return 1 result if there are mutiple rows returned?

 

There is no point in having an ORDER BY if you limit it to one row.

[Daniel0]

Ah, I see what he was trying to do now. Disregard what I said above.

[maliary]

Tinker,

 

The value of $branchID is 0.

[Barand]

try

SELECT batch_nr FROM  care_test_findings_baclabor
ORDER BY create_time DESC LIMIT 1

[maliary]

 

 

That did it !!

 

Thanks