I hoping to get some assistance. I'm creating an upload property form consisting of four different pages, each page requiring different information.
Page1 - requiring information about the property. I have created my table based on what is required from this this page only.
This is what it looks like with information inputted from page 1
All this works great. Once I get to page 2 this then requires further information (no. Bathrooms, bedrooms garage etc). What I want to do (if possible) is add Bathrooms/Bedrooms/Garage to this column based on information already submitted. So by the end, the image above with contain alot more information
$id = "SELECT propertyid FROM propertylisting WHERE username = '$username'";
$update= "UPDATE INTO propertylisting WHERE propertyid='$id' ADD (bathrooms varchar(2))"; // This is what I mean
I hope this makes sense...