note 72216 added to function.pdostatement-execute

For a query like this: SELECT t1.user_id, t1.user_name, t2.* FROM table1 t1 LEFT JOIN table2 t2 ON t2.user_id = t1.user_id WHERE t1.user_id = 2 If I don't have an entry in table2 for user_id=2, the user_id in result will be empty. SELECT t1.user_id, t1.user_name, t2.user_pet, t2.user_color, t2.user_sign FROM table1 t1 LEFT JOIN table2 t2 ON t2.user_id = t1.user_id WHERE t1.user_id = 2 This query will return nonempty user_id. So please be careful with wildcard select. ---- Server IP: 212.93.155.36 Probable Submitter: 82.77.232.138 ---- Manual Page -- http://www.php.net/manual/en/function.pdostatement-execute.php Edit -- https://master.php.net/note/edit/72216 Del: integrated -- https://master.php.net/note/delete/72216/integrated Del: useless -- https://master.php.net/note/delete/72216/useless Del: bad code -- https://master.php.net/note/delete/72216/bad+code Del: spam -- https://master.php.net/note/delete/72216/spam Del: non-english -- https://master.php.net/note/delete/72216/non-english Del: in docs -- https://master.php.net/note/delete/72216/in+docs Del: other reasons-- https://master.php.net/note/delete/72216 Reject -- https://master.php.net/note/reject/72216 Search -- https://master.php.net/manage/user-notes.php