Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: w11z
  • Order by date
  1. w11z

    4 tables query

    Thank you r937. It worked perfectly.
  2. w11z

    4 tables query

    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...
    • w11z
    • Thread
    • Replies: 2
    • Forum: MySQL
  3. w11z

    database design suggestion

    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...
  4. w11z

    database design suggestion

    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
  5. w11z

    database design suggestion

    @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.
  6. w11z

    database design suggestion

    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...
  7. w11z

    database design suggestion

    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...
  8. w11z

    Dreamweaver overwrites images

    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...
  9. w11z

    Dreamweaver overwrites images

    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
  10. w11z

    Dreamweaver overwrites images

    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...
    • w11z
    • Thread
    • Replies: 4
    • Forum: Adobe
  11. w11z

    Multiple checkbox - Help

    Thank you very much Feherke. Your code was exactly what I needed. I've found my other problem. You derserve this star...
    • w11z
    • Post #6
    • Forum: PHP
  12. w11z

    Multiple checkbox - Help

    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...
    • w11z
    • Post #5
    • Forum: PHP
  13. w11z

    Multiple checkbox - Help

    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...
    • w11z
    • Post #3
    • Forum: PHP
  14. w11z

    Multiple checkbox - Help

    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...
    • w11z
    • Thread
    • Replies: 5
    • Forum: PHP
  15. w11z

    Forms with dropdown of more than 100,000 records

    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...
  16. w11z

    Forms with dropdown of more than 100,000 records

    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...
  17. w11z

    Validate 1 to 5 in textbox

    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...
  18. w11z

    Validate 1 to 5 in textbox

    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"...
  19. w11z

    De-concatenate ;-)

    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...
  20. w11z

    De-concatenate ;-)

    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...

Part and Inventory Search

Back
Top