TalkPHP - View Single Post

xenon · 05-07-2008, 09:04 PM

Extending what Highway said above, you don't need to use a table alias when you're fetching values from a single table. You're only slowing down the query. So, the following is the same with what you wrote in the first place:

PHP Code:


			
$sql = "SELECT mid, username, email 
        FROM members
        WHERE username = '" . mysql_real_escape_string($username) . "'";

05-07-2008, 09:04 PM	#3 (permalink)
xenon The Frequenter Join Date: Dec 2007 Location: Bucharest, Romania Posts: 438 Thanks: 3	Extending what Highway said above, you don't need to use a table alias when you're fetching values from a single table. You're only slowing down the query. So, the following is the same with what you wrote in the first place: PHP Code: `$sql = "SELECT mid, username, email FROM members WHERE username = '" . mysql_real_escape_string($username) . "'";` __________________ I have optimistic thoughts, even though sometimes (if not always) life's a bitch.