[resolved] where clause

[solitario]

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.

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;

[visualAd]

I assume the reason you are posting here is becuase it doesn't work. Check your SQL statment, it should be:

SELECT username FROM users WHERE username='$_POST[lstUser]'

SQL is different from PHP, the equality operator is = not ==. You also had your quotes surrounding the entire 'username=$_POST[lstUser]', they just need tto surround the value.

[ober0330]

Originally posted by visualAd
SQL is different from PHP, the equality operator is = not ==. You also had your quotes surrounding the entire 'username=$_POST[lstUser]', they just need tto surround the value.

You should really be seperating your values from your string better like this:

$query = "SELECT x FROM y WHERE username='" . $_POST['lstUser'] . "'";