Anyone, please help me here. I created a view in mysql but when I use it in my code in php, an error appears that the view doesn't exist. What can I do?
Here is my code.
$count = mysql_query("SELECT COUNT(*) FROM ViewName where ftTimeIn != '' AND ftTimeOut != '' AND fdDate like '$date' AND fcShiftCode like '$shift' AND fcDivDesc like '$division'")or die(mysql_error()); $manpower_no = mysql_result($count,0,0);