Right ok.. Can you see anything wrong with this code?

[Devboy]

can you guys see anything wrong with this?

 

	
$check_contestant = tep_db_query("select contestants_name, contestants_email from " . TABLE_CONTEST . " where contestants_email = '" . tep_db_input($contestant_email) . "'");
$already_entered = $check_contestant['contestants_email'];

    if ($already_entered == $contestant_email) 
	{
	tep_redirect(tep_href_link(FILENAME_CONTEST, 'entered=1' , 'NONSSL'));	

    } 

 

Does anything look wrong in that code?

[fenway]

I don't see any SQL... just PHP code.  Echo the query.

[Devboy]

well the sql is:

 

tep_db_query("select contestants_name, contestants_email from " . TABLE_CONTEST . " where contestants_email = '" . tep_db_input($contestant_email) . "'");

 

I will echo the query . never thought of that heh

[teng84]

I don't see any SQL... just PHP code.  Echo the query.

 

yes better to post it in phphelp section