I can't see the wood for the trees

[Elmserv]

I am getting this error message

Notice: Undefined index: invno in /home/clients/rcldev/html/rlt/invoicecreate.php on line 97


From this chunk of code

// get next invoice no
$query = "select max(invno) from sledger where cno = $mast_cno";

$mysql = conectmysql();

$res = mysql_query($query,$mysql);
	// test for sucess
if (mysql_errno() >0)
	{die( mysql_error($mysql));}	

	if (mysql_numrows($res) == 0 )
		{$invno = 99;}
	else
		{
			$row = mysql_fetch_array($res, MYSQL_ASSOC);
L97 ->			$invno = $row['invno'];
		}
$invno++;

invno is an integer field with a width of 7

Richard

 

[jpadie]

change this line as follows

$query = "select max(invno) [b]as invno[/b] from sledger where cno = $mast_cno";

 

[Elmserv]

Brilliant

Thanks very much, I looked at that for days. It will be a long time before I forget that lesson


Richard