Search results for query: *

Thank you r937. It worked perfectly.

Hi, I have 4 tables Table 1: institutions instID instName CityID (FK) Table 2: cities cityID cityName regionID (FK) countryID (FK) Table 3: regions regionID regionName countryID (FK) Table 4: countries countryID countryName I'm trying to list all the institution name, the city, the region...

Thank you guys. But lets push this a little further. We have countries, states, cities. We know the countries and the cities but the states won't always be available. For example: City -> Columbus State -> Ohio Country -> USA City -> Columbus State -> Wisconsin Country -> USA City -> Ottawa...

r937, Thargy, Thank you for the advice but how come almost all the tutorials I've read on the web (PHP and MySQL) have never mentioned this. I do think it's a wise decision even if the database validation is very limited

@Thargy I'm developing with PHP and I'll be validating what the user will be entering either client side or server side. I won't let MySQL do the validation.

Thank you very much. You all have contributed to make me (and hopefully others) more knowledgeable. I'm developing a complex DB using MySQL Workbench (for the first time). I have much to learn and you have helped me quite a lot. If their are others that would like to add anything, you are very...

Hi everyone, What would be the best way of representing this relation between Countries, States and Cities. 1- tblCountries countID(PK), countName tblCountries_States countID, stateID tblStates stateID(PK), stateName tblStates_Cities stateID, cityID tblCities cityID(PK), cityName OR is...

I don't know, that's what i'm trying to find out. I'm working with the FTP feature of DW - connect directly to the server (no local files). I've searched everywhere to understand why DW overwrites (but not always) an image (sometimes a file) that had just been modified by another program - my...

Thank you Greg, I'm connecting directly to the server (I'm not using local files). I'v decided to work with phpDesigner. I'm afraid (;-) to start DW and have it overwrite what I've done whit phpDesigner. Do you have any other suggestion. w11z

Hello everyone, I'm working with Dreamweaver CS3. Sometimes when I replace an image that is already being used in a webpage (for example I change the color of the image sky.jpg and re-upload it to the server using ws-ftp). When I start Dreamweaver (ftp connect) DW overwrites the new sky.jpg...

Thank you very much Feherke. Your code was exactly what I needed. I've found my other problem. You derserve this star...

Feherke, I understand the idea. Currently when I echo the count($_POST[app][$row2[reu_reg_id]]) it gives me 0. As if nothing was passing from the form to the 2nd page (the update page). This is the HTML output of the 1st page: <form name='approved' action='test.php' mehod='POST'> John Doe...

Thanks Feherke, But I don't quite understand. My while loop is on the first page and displays the client that already are in the DB. The 2nd page receives the information from the form of the 1st page. It's in the 2nd page that I update the table. I cannot do a pg_fetch_array on the second...

Hello everyone, I have a form generated by the database (PHP, Postgresql). It displays every client with a checkbox (either checked or unchecked) after the name. The client has to be approved by an admin. The admin approves or uncheck the approve checkbox. After submitting, the database must be...

Thanks for the response AceMan1, but the ComboBox already have that feature (without having to code anything) As you type in letters, it fills itself with the rest of the word. For example if you type in U, the rest will find anything that starts with U. But still, it makes for a heavy way to...

Hello everyone, I have to work with someone else's Access database. On the form, there is a dropdown menu refering to a table with more than a 100,000 records (almost all the high schools and universities in the world). You can see that it is a bit heavy to work with. What would be the best way...

Thanks for your response Kaht but out of 15 different activities the users have to only choose 5 and place them in order of most important to least important. Example: a. Planning -> 4 b. Lectures c. Teaching d. Motivation -> 2 e. Active -> 5 f. Learning theories -> 1 g. Learning styles h...

Hi Everyone, I have a form in which the user must enter in a textbox his preferred choice on a scale of 1 to 5. How do I loop through and validate that the user has entered is first 5 choice. Here is part of the form: <input type="textbox" name="s1q8_1">a. Planning <input type="textbox"...

Many thanks! I have finished what I wanted to do. Your suggestions were very helpful. There were to many different patterns in the Date field (for example : 03-01-2004, 01-03-2004, 03.01.2004, 01.03.2004, 03/01/2004, 01/03/2004, 2004-03-01, 2004-01-03, etc.) I unfortunately had to go through...

Back to work this morning, I've looked at your post and want to thank you. I've succeeded in getting the word (Poster, Viewbook, etc.) on to a separate field. The remaining (date, comma, and other unwanted 'junk') is in another field (temp). I will have to use different ways suggested here to...