DarkPrince2005 Posted September 4, 2007 Share Posted September 4, 2007 This problem was solved a while ago but, for some reason I can't get it working after my pc bombed-out. I am trying to save the difference between two dates in a field in the database. But all it is saving to the database is the words 'Select column1,column' <?php mysql_connect("localhost","root",""); mysql_select_db("npa"); $str_birthday = mysql_query ("select Date_Recieved from dis"); // My Birth Day $str_today = date("Y-m-d"); // The exact time $date = date("Y-m-d"); $date1 = mysql_query ("SELECT (YEAR(CURDATE())-YEAR(Date_Recieved)) - (RIGHT(CURDATE(),5)<RIGHT(Date_Recieved,5)) from dis"); $r = mysql_query("UPDATE dis SET Date_Added=('SELECT (YEAR(CURDATE())-YEAR(Date_Recieved)) - (RIGHT(CURDATE(),5)<RIGHT(Date_Recieved,5)) from dis');"); $q = mysql_query("SELECT * from dis"); while ($row = mysql_fetch_assoc($q)) { $html .= "<center><form> <table cellpadding='0' border='0' cellspacing='0'><tr> <td valign='top'><table width='400'> <tr><td><b>File Ref</td><td> </td> <td>$row[File_Ref]</td></tr> <tr><td><b>Employee Firstname</td><td> </td> <td>$row[Employee_Firstname]</td></tr> <tr><td><b>Employee Lastname</td><td> </td> <td>$row[Employee_Lastname]</td></tr> <tr><td><b>Persal Number</td><td> </td> <td>$row[Persal_Number]</td></tr> <tr><td><b>Occupation</td><td> </td> <td>$row[Occupation]</td</tr> <tr><td><b>Level</td><td> </td> <td>$row[Level]</td</tr> <tr><td><b>Gender</td><td> </td> <td>$row[Gender]</td</tr> <tr><td><b>Race</td><td> </td> <td>$row[Race]</td</tr> <tr><td><b>Suspension</td><td> </td> <td>$row[suspensions]</td</tr> <tr><td><b>Period</td><td> </td> <td>$row[Period]</td></tr> <tr><td><b>Date Recieved</td><td> </td> <td>$row[Date_Recieved]</td</tr> <tr><td><b>Unit</td><td> </td> <td>$row[unit]</td</tr> <tr><td><b>Region</td><td> </td> <td>$row[Region]</td</tr> <tr><td><b>Date Of DC</td><td> </td> <td>$row[Date_Of_DC]</td</tr> <tr><td><b>Status</td><td> </td> <td>$row[status]</td</tr> <tr><td><b>Category</td><td> </td> <td>$row[Category]</td></tr> <tr><td><b>Outcome</td><td> </td> <td>$row[Outcome]</td></tr></table></td><td> </td><td valign='top'><table width='400'> <tr><td valign='top'><b>Status Report</td><td> </td> <td width='250'>$row[status_Report]</td></tr> <tr><td>$row[Date_Added]</td></tr> </table></table> </form>"; }; ?> <html><head><title></title><link rel='stylesheet' href='stylesheet.css' type='text/css'> <style> a:link{font-family:'Times New Roman'; font-size:10pt; color:'#ffffff'; font-weight:700; text-decoration:none; } a:visited{font-family:'Times New Roman'; font-size:10pt; color:'#ffffff'; font-weight:700; text-decoration:None; } a:hover{font-family:'Times New Roman'; font-size:10pt; text-decoration:none; color:'#B37A04'; font-weight:700; } a:active{font-family:'Times New Roman'; font-size:10pt; color:'#ffffff'; font-weight:700; } </style></head><body bgcolor='#FDCC67' topmargin='0' bottommargin='0' leftmargin='0' rightmargin='0'> <center><table width="100%" height="100%" cellpadding="0" cellspacing="0" border="0"> <tr><td valign='top' width='140' bgcolor='#000000'><br> <a href='home.html'>Home</a><br><br> <a href='view.php'>View Records</a><br><br> <a href='add.html'>Add Record</a><br><br> <a href='edit1.php'>Edit Record</a><br><br> <a href='delete1.php'>Delete Record</a><br><br> <a href='report.php'>View Report</a><br><br> <a href='q.php'>Query Report</a><br><br> <a href="search1.php">Search</a></td><td valign="top" align="center"><table><tr> <td align="right" valign="top"><form action="search2.php" method="post"><b>Search by Persal Number:</b> <input type="text" name="search"> <input type="submit" value="Search"></form></td></tr> <tr><td align="center" valign="top"><h1>View Disciplinary Records</h1></td></tr> <tr><td align="center" valign="top"></td></tr> <tr><td align="center" valign="top"><br><?= $html ?></td></tr></table></td></tr></table> </body> Quote Link to comment Share on other sites More sharing options...
gerkintrigg Posted September 4, 2007 Share Posted September 4, 2007 blimey that's a lot of code. Why not try the datediff function in SQL? it's built in. Quote Link to comment Share on other sites More sharing options...
DarkPrince2005 Posted September 4, 2007 Author Share Posted September 4, 2007 Cause datediff gives errors Quote Link to comment Share on other sites More sharing options...
DarkPrince2005 Posted September 4, 2007 Author Share Posted September 4, 2007 Please it is quite important and essential that I get it working and I can't remember how I got it to work the previous time Quote Link to comment Share on other sites More sharing options...
ToonMariner Posted September 4, 2007 Share Posted September 4, 2007 date diff is the way to go - what errors do you get when you use it?? Quote Link to comment Share on other sites More sharing options...
DarkPrince2005 Posted September 4, 2007 Author Share Posted September 4, 2007 what i want to achieve with the script is to calculate the datediff in days and store it in a field in the database... and datediff doesn't seem to give any errors anymore, i think there was an error in my syntax Quote Link to comment Share on other sites More sharing options...
DarkPrince2005 Posted September 4, 2007 Author Share Posted September 4, 2007 the only thing it seems to insert into the field is the words "Resource id#4" Quote Link to comment Share on other sites More sharing options...
ToonMariner Posted September 4, 2007 Share Posted September 4, 2007 you don't seem to be extarcting any data from the query then - use mysql_fetch_assoc or similar to see what is in the results. Quote Link to comment Share on other sites More sharing options...
DarkPrince2005 Posted September 4, 2007 Author Share Posted September 4, 2007 The words "Resource id#4" is stored in the database where it's suppose to display the daatediff Quote Link to comment Share on other sites More sharing options...
ToonMariner Posted September 4, 2007 Share Posted September 4, 2007 yes which means that you are putting the result of teh query directly into teh database instead of extracting the information form it using one of the functions that does so (mysql_fetch_assoc etc...) Quote Link to comment Share on other sites More sharing options...
DarkPrince2005 Posted September 5, 2007 Author Share Posted September 5, 2007 I dont want to return the num of rows. I want to store the bloody datediff. Quote Link to comment Share on other sites More sharing options...
ToonMariner Posted September 5, 2007 Share Posted September 5, 2007 I KNOW the Resource #xxxx menas you are doing $res = mysql_query($qry); $input = mysql_query('INSERT INTO `table` (field) values ($res)');!!!! LIKE I KEEP SAYING!!!!!!!!!! $res = mysql_query($qry); $DATEDIFF = mysql_fetch_assoc($res) $input = mysql_query('INSERT INTO `table` (field) values ($DATEDIFF['somenamethat picks datadiff'])');!!!! 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.