Currently I am dealing with a sys that track manuscripts. For every manuscript submitted, an auto increment id will assigned. If manuscript is accepted to be published, a reference number will be given.

How do I count the the number of manuscripts(in the database) already with reference number(accepted scripts) and then add one to this number.

$sql_max = "SELECT COUNT(*) FROM MANUSCRIPT_TABLE where ref_no != '' ";

$result = mysql_query($sql_max) or die("SELECT Error: ".mysql_error());

How do I get the count number in this case? I would want to add one to this number.

Any advise is most appreciated.

Thanks and good day!