I stuck on this query for quite a while. will appreciate if someone can help me to look at this query and correct me where i had done wrongly.
$val_d = $_GET['val_d']; $sql = "SELECT * FROM device"; $sql .="WHERE device_num LIKE '%$val_d%' ";
the error message prompted was:
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIKE '%" . urlencode($val_d) . "%'' at line 2"