Jump to content

Archived

This topic is now archived and is closed to further replies.

somo

Mysql...

Recommended Posts

Im trying to select and email address of a customer where their username matches the variable in my script. I'm gettin "Unknown column 'somo' in 'where clause' " somo is a username and is in the databse. Any clues?


[code]
<?
//select the email address of the user that is booking
$result = mysql_query("SELECT C_Email FROM Customer WHERE U_Username = "$username" LIMIT 1") or die(mysql_error());
$row = mysql_fetch_assoc($result);
$C_Mail = $row['C_Email'];// return email
?>
[/code]

Share this post


Link to post
Share on other sites
try:

$result = mysql_query("SELECT C_Email FROM Customer WHERE U_Username = '$username' LIMIT 1") or die(mysql_error());

Share this post


Link to post
Share on other sites
cheers mate that sorted it, you just don't see them when you look at the code for too long, anyways thanks.

[quote author=GingerRobot link=topic=100446.msg396412#msg396412 date=1152804284]
try:

$result = mysql_query("SELECT C_Email FROM Customer WHERE U_Username = '$username' LIMIT 1") or die(mysql_error());
[/quote]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.