Re: Last ID Problem

Hi ,

> will your suggestion protect my db if I have two
> customers with the same name?

Yes , it would with the consideration that the sequence used to create
the cust_id is increasing  by some number , customer may have same
name but in all means the customer name which is having the MAXIMUM
cust_id is ur need.

>  does it always return
> the highest cust_id and is that *always* the last
> cust_id entered?
>

did i said I gave you a query that would run faster you may alternatively use

 $id = "SELECT max(cust_id) from customer  where  customer_name ='$cust' " ;

Use explain in psql and u will know why I suggested the previous query.


--
With Best Regards,
Vishal Kashyap.
Lead Software Developer,
http://saihertz.com,
http://vishalkashyap.tk