Login for Shopping Cart

[leighhobson89]

Hi all,  I have this bit of code here.  It is supposed to call someones name out of the database when the variable is echo'd at the bottom, but instead, the variable $username2 is echoing out the whole SQL statement.  Does anyone know what i'm doing wrong.  I want the value of 'custFirstname' to be the word that echoes out.  It is being used for a login screen/shopping cart.  

 

Here's the code...

 

 

$username2 = "SELECT custFirstname from lptCustomerrecord WHERE userName = ".$_SESSION['username'];

if(!$resultusername = mysql_query($username2,$connection))
	echo "ERROR. SQL is '".$username2."'\n";
else
{
	$Row6 = mysql_fetch_array($resultusername);
}

echo "<p>Welcome ".$Row6['custFirstname'].", you just chose the following product.  To add it to your cart, click the Add to Cart button below, otherwise click No Thanks, to return to the shopping screen without adding the item to your cart.</p>";

I hope someone can help!

[flappy_warbucks]

You have a error in your statement!

 

$username2 = "SELECT custFirstname from lptCustomerrecord WHERE userName = ".$_SESSION['username'];

 

should be:

 

$username2 = "SELECT custFirstname from lptCustomerrecord WHERE userName = \"". $_SESSION['username']. "\"";

 

[leighhobson89]

would you be able to give me the correct line of code?

Im a complete php noob!

  cheers