troubleshooting Question

Displaying fomatted mysql date field

Avatar of jezskill
jezskill asked on
Adobe Creative Suite CSMySQL ServerPHP
7 Comments1 Solution244 ViewsLast Modified:
in the code window is my code to sdisplay a form that allows a user to edit information, the last diaplayed form element is the Expiry date field, I have tried all sorts of ways to format it so that it displays as DD-MM-YYYY , but no luck, I am probably missing something simple.

Where does the date_format function come into play , before the form code or in the form element below?

<p>
            <label for="Expiry">Expiry <em>*</em></label>
            <input name="Expiry" id="Expiry" size="25" maxlength="100" class="required" value="' . $row_user_edit['Expiry'] . '"/>
            </p>

thanks in advance.
$user_edit = '<div><form id="edituser" method="post"><input type="hidden" name="action" value="updateuser">		
		<fieldset>

		<p>
		<label for="name">Name <em>*</em></label>
		<input id="name" name="name" size="25" maxlength="255" class="required" value="' . $row_user_edit['name'] . '"/>
		</p>

		<p>
		<label for="local_authority_id">Local Authority <em>*</em></label>
		<select style="width:175px;" name="local_authority_id" id="local_authority_id" value="' . $local_auth_name['la_name'] . '">			
			'.$local_authority_option.'
		</select>
		</p>

		<p>
		<label for="school_learning_est_id" >School or Learning Establishment name <em>*</em></label>
		<select style="width:175px;" name="school_learning_est_id" id="school_learning_est_id" value="' . $school_name['School'] . '">'.$tblschool_new_option.'</select>
		</p>

		<p>
		<label for="email">E-Mail <em>*</em></label>
		<input id="email" name="email" size="25" maxlength="100" class="required email" value="' . $row_user_edit['email'] . '"/>
		</p>

		<p>
		<label for="telephonenumber">Telephone Number <em>*</em></label>
		<input name="telephonenumber" id="telephonenumber" size="25" maxlength="100" class="required" value="' . $row_user_edit['telephonenumber'] . '"/>
		</p>

		<p>
		<label for="Expiry">Expiry <em>*</em></label>
		<input name="Expiry" id="Expiry" size="25" maxlength="100" class="required" value="' . $row_user_edit['Expiry'] . '"/>
		</p>

		<p>
		<input class="submit" type="submit" value="Submit"/>
		</p>
    </fieldset></form></div>';

Open in new window

ASKER CERTIFIED SOLUTION
johnwarde

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros