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> Link to comment https://forums.phpfreaks.com/topic/67870-solved-display-date/ 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. Link to comment https://forums.phpfreaks.com/topic/67870-solved-display-date/#findComment-341163 Share on other sites More sharing options...
DarkPrince2005 Posted September 4, 2007 Author Share Posted September 4, 2007 Cause datediff gives errors Link to comment https://forums.phpfreaks.com/topic/67870-solved-display-date/#findComment-341168 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 Link to comment https://forums.phpfreaks.com/topic/67870-solved-display-date/#findComment-341183 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?? Link to comment https://forums.phpfreaks.com/topic/67870-solved-display-date/#findComment-341185 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 Link to comment https://forums.phpfreaks.com/topic/67870-solved-display-date/#findComment-341188 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" Link to comment https://forums.phpfreaks.com/topic/67870-solved-display-date/#findComment-341221 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. Link to comment https://forums.phpfreaks.com/topic/67870-solved-display-date/#findComment-341236 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 Link to comment https://forums.phpfreaks.com/topic/67870-solved-display-date/#findComment-341238 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...) Link to comment https://forums.phpfreaks.com/topic/67870-solved-display-date/#findComment-341307 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. Link to comment https://forums.phpfreaks.com/topic/67870-solved-display-date/#findComment-341950 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'])');!!!! Link to comment https://forums.phpfreaks.com/topic/67870-solved-display-date/#findComment-342048 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.