edit profile php

ianhaney

I have now made the project site I am working on much simpler than before and now got all the fields in one form and added to one dbtable

I have got the profile.php page working so it displays all the data from the users table and renewal table for the dates to display to display

Now I am trying to make a edit-profile.php page which I have made and put all the coding and put the markup at the bottom and the php above it but for some reason the current data is not displaying within the form fields

I have done a var_dump on the query and outputs the following

string(346) "SELECT u.id , name , email , address1 , address2 , town , county , postcode , telnumber , mobnumber , model , numplate , DATE_FORMAT(renewal_date, '%e %M %Y') as datedue FROM users u INNER JOIN renewal USING (id) INNER JOIN item USING (item_id) WHERE id='23'"

so then did a var_dump on just on the one variable var_dump($name); and that outputted the following

string(9) "Ian Haney"

so seems to connecting to the db and retrieving the data so not sure why is not displaying the current data within the form, all the fields are the same as the db etc.

the link to the pastebin coding is below

http://pastebin.com/UUSp0wgZ

ianhaney

done it with the following coding in the pastebin link

http://pastebin.com/td96Gey0

I just got to test it now to make sure it updates

ianhaney

I have noticed one issue as well, it's the dates are being outputted the same, the coding is in the following pastebin link

http://pastebin.com/8iTenNmM

I took the loop out, well think I have

Is it ok to check the coding?

ianhaney

sorry sorted this one now