adwfun

Hi all, I need a form to request users to enter information such as Company Name, Address, Tel, Contact, etc.. and their branches info if they have any. i.e. If they have a headquarter and several branches, I need all their info. How do I proceed to build the form that the Company has the option to add unlimited branches info so that I can store them in MySQL database ? And the Company is able to review all the entry before posting, preferably in a format such as a spreadsheet ? Anyone, please give me a direction ? I am using PHP & MySQL Thanks.

I produced several dropdown menu from some MySQL tables. I want to set default value "Please select" to each of these menu and if not selected the menu returns no value (i.e. to select all data from tables). Does it mean I have to add one data of "Please select" to the top of each table and set it to NULL and order by asc ? Any suggestion ?? Thanks.

I made a Select.....Where... query with over 10 conditions after Where. It returned with a syntax error and I am wondering if there is a maximum conditions allowed. I did that because I setup 5 dropdown menu to let user choose and then submit to get data, and there are 8 tables required in Select.... Please kindly advise. Thanks ???

I have 2 tables named City and District in MySQL. Table City fields : CityID, CityName Table District fields : DistrictID, DistrictName, CityID I linked District to City. When retrieving data from District Table, how could I display CityName instead of cityID ? My codes as follow: What's problem ? <?php include("connectdb.php"); $district=mysql_query("select * from District"); while ($result=mysql_fetch_array($district)) { echo $result["DistrictID"]."<br>"; echo $result["Districtname"]."<br>"; echo $result["select Districtname, Cityname from District, City where City.CityID=District.CityID"]."<br>"; } ?>