title: Using where id = last_insert_id() returns empty result set
body: <p>I am trying to fetch a row of data in mysql after inserting a row of data in mysql table using</p>
  
  <p><code>SELECT * FROM incoming_sms WHERE id = last_insert_id();</code> but this returns an empty set of results although i have indeed inserted a new row and my table contains data.</p>
  
  <p>How can i make my query return some data?.</p>