scarezekiel Posted February 20, 2012 Share Posted February 20, 2012 so i created this leave application program..users need to select branch/month/year. then it will show which user from which branch, on which month of the year leave details. i have created a view in my database..can someone pls help.. <? $rowid =0; if ($leavemonth =='' || $leaveyear =='' || $branchid == '') { } else { $rs = mysql_query( " call spsalary('$leavemonth', '$leaveyear', $branchid, 0);"); while($row = mysql_fetch_assoc($rs)) { $rowid =$rowid + 1; $employeeid = str_replace("’", "’", $row['id']); Quote Link to comment Share on other sites More sharing options...
trq Posted February 20, 2012 Share Posted February 20, 2012 You forgot to tell us what the actual problem is. Quote Link to comment Share on other sites More sharing options...
scarezekiel Posted February 20, 2012 Author Share Posted February 20, 2012 the problem is..i need the whole code for this program to work. Quote Link to comment Share on other sites More sharing options...
trq Posted February 20, 2012 Share Posted February 20, 2012 This link should help you. Quote Link to comment Share on other sites More sharing options...
scarezekiel Posted February 20, 2012 Author Share Posted February 20, 2012 ..that page tells me how to ask questions.. -.- .. nvm Quote Link to comment Share on other sites More sharing options...
trq Posted February 20, 2012 Share Posted February 20, 2012 ..that page tells me how to ask questions.. -.- .. Exactly. Quote Link to comment Share on other sites More sharing options...
scarezekiel Posted February 20, 2012 Author Share Posted February 20, 2012 how do i fetch data from database once the form is submitted... T.T Quote Link to comment Share on other sites More sharing options...
trq Posted February 20, 2012 Share Posted February 20, 2012 You check to see if a form has been submitted. eg; if (isset($_POST['submit'])) { // fetch data from the database. } Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.