[SOLVED] Email Trigger Help Needed

[GsXtAsY]

So what i have here is a .inc file an email trigger...in the email trigger I need this script checking the database to see if the account is a shared account in the database, if it is a shared account...I am receiving a syntax error...can someone please look at the code below to see what I am missing or doing wrong?

require_once('includes/db_login.inc');

 

$qry_shared_email = 'SELECT teaming_shared_account FROM account WHERE nickname = '.$order_details['account_name'];

 

$result = mysql_query($qry_shared_email) or die('Invalid query: ' . mysql_error());

 

while($row = mysql_fetch_array($result))

{

if ($row['teaming_shared_account'] == 1) 

{ 

    $message .= "This is a shared account."; 

}

}

[rarebit]

Your only extracting:

teaming_shared_

But checking against:

teaming_shared_account

[GsXtAsY]

sorry that was just a typing error...i should have just copied and pasted it

[rarebit]

what and where is the error...

[GsXtAsY]

$qry_shared_email = 'SELECT teaming_shared_account FROM account WHERE nickname = '.$order_details['account_name'];

 

This is the line that has the error...its a syntax error

[rarebit]

try

$qry_shared_email = "SELECT teaming_shared_account FROM account WHERE nickname = '".$order_details['account_name']."'"; 

[GsXtAsY]

Thank You! That worked!