$query = "SELECT ID,NEID,VPI,VCI,PCR,PVC,IP FROM NB WHERE NB.NEID=? ORDER BY RC_CISCO_NB.ID DESC LIMIT 1 "; $sth = $dbh->prepare($query) or die "Error in query prepare: $DBI::errstr\n"; $sth->execute($neid) or die "Error executing query: $DBI::errstr\n";