mysqli_query failure not providing errno

[cearlp]

Two identical php programs doing a mysqli_query, but on different databases. One succeeds and the other fails. The one that fails returns no errno.

Could the cause be the databases?

If so, what could be the problem? They are real similar in construction, one has more fields than the other, but almost the same data in both. 

$conn = use, passwd, database

$sql = insert into members (name,addr,city,state) values('Joe','123 St','Somecity','CA')

$result = mysqli_query($conn, $sql) or die (Can't run query because " . mysql_errno());

 

[Barand]

42 minutes ago, cearlp said:

Could the cause be the databases?

More likely the coder.

mysql_errno() does not exist. It should be

mysqli_errno($conn)

Try turning error reporting on occasionally.

[ginerjm]

What am I not privy to?  I see no user of errno nor mysql in this topic.  And not much real code either.

[Barand]

4 minutes ago, ginerjm said:

I see no user of errno nor mysql in this topic.

[cearlp]

My BAD! The code is mysqli_error() not mysql_errno(). BUT, adding the $conn to the mysqli_error($conn) produces a valid and informative error message.

Many thanks for the help.