Count the number of scripts with reference number
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!