DarkPrince2005 Posted September 16, 2007 Share Posted September 16, 2007 In the attached script I am actually trying to update and display a date, but it doesn't display the date in php it only displays the words Resource Id#4... can anybody help, pls it is important... <?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 datediff(curdate(),Date_Recieved) from dis"); $r = mysql_query ("UPDATE dis SET Date_Added='$date1';"); $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>$date</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 https://forums.phpfreaks.com/topic/69602-solved-date-display/ 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.