Re: [PHP-DB] Query does not work

[email protected] ("Ethan Rosenberg, PhD") Tue, 01 Jul 2014 23:43:32 -0400
Newsgroups php.db
Organization Hygeia Biomedical Research, Inc.
Message-ID <[email protected]>
Dear List -

I think I've lost the database connection.

I put in the following code:

$sql31=	"select Lname, Fname,  Phone, Cust_Num from Customers order by 
Lname";

echo $sql31; //echos correctly
			
$result31 = mysqli_query($cxn,$sql31);

var_dump($result31); // result null


while ($row31 = mysqli_fetch_row($result31)) {
   printf ("%s %s %s %s %s\n", $row31[0], $row31[1], $row31[2], $row31[3]);
     } // no output

How can I loose a db connection in the middle of a program?





TIA

Ethan