View Single Post
  #4 (permalink)  
Old February 21st, 2005, 03:07 PM
Gotaka4 Gotaka4 is offline
Authorized User
Join Date: Jan 2005
Location: , , .
Posts: 82
Thanks: 0
Thanked 0 Times in 0 Posts

if the fieldname is not unique between the two tables, you might have some problems. So to obviate this problem, either use the numerical index of the array or do this as your select statement.:

$sql = "SELECT f_Username as username, t_Username as staff_username FROM staff, student WHERE staff.staff_username LIKE '%$user%' OR student.username LIKE '%$user%'";

Never bother to learn something not knowing which does not do you any harm, and never neglect to learn something whose negligence will increase your ignorance - Imam Jafar Sadeq
Reply With Quote