Hello all.
This is my first try at a WHERE clause with PHP.
What I need is the syntax for retrieving the correct record and printing it on the page.
Any help is appreciated.
Many thanks.Code:if (!$conn = new COM("ADODB.Connection")) exit("Unable to create an ADODB connection."); $strConn = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("..\db\users.mdb"); $conn->open($strConn); $sql = "SELECT username FROM users WHERE 'username==$_POST[lstUser]'"; $rs = $conn->execute($sql); // Need something here // Print result here $rs->Close(); $conn->Close(); $rs = null; $conn = null;




Reply With Quote