theo Posted August 10, 2011 Share Posted August 10, 2011 mysql:5.0.91 php:5.2.12 SELECT CONCAT(masterpx.mpx_lname, ', ', masterpx.mpx_fname) AS name, DATE_FORMAT(inpx_admission.inpx_admission_date, '%M %d, %Y') AS indate FROM masterpx INNER JOIN inpx_admission ON masterpx.mpx_id=inpx_admission.mpx_idfk AND inpx_admission.admission_status = 'admitted' ORDER BY masterpx.mpx_lname help pls..when i use these query i receive this error message: Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result Unknown column 'inpx_admission.admission_status' in 'on clause' Link to comment Share on other sites More sharing options...
Larry Posted August 10, 2011 Share Posted August 10, 2011 That means there is no column named admission_status in the inpx_admission table. Link to comment Share on other sites More sharing options...
theo Posted August 10, 2011 Author Share Posted August 10, 2011 thanx..hehe i forgot to update my table online..only the table in the localhost was updated.. Link to comment Share on other sites More sharing options...
Recommended Posts