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!

  • Congratulations Mike Lewis 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: *

  1. biscuitboy

    error messages appearing

    Hi, Im currently working on a residential database and working on the 'delete resident' page. Everything works and the correct reisdent gets deleted as wanted. The problem I have is that when the page loads up all of the "else" statements such as "you have forgot to enter your surname" appears...
  2. biscuitboy

    deleting an entire record by users request

    Hiya, I have reorganised some of the code and it now works great. Thank you for all your help best regards
  3. biscuitboy

    deleting an entire record by users request

    Hiya, Ok I understand you know, got a bit confused then. What you have suggested does work. However it it wont allow me to delete a whole record based on two fields. Is there any way of doing this as I dont want the user to have to enter all of the fields in the where statement. best regards
  4. biscuitboy

    deleting an entire record by users request

    Hiya. I would normally construct like that as well however dont you have to have the line "delete from table where field = value? I might be wrong as im quite new to php interacting with mysql. How would you construct it?? Best Regards
  5. biscuitboy

    deleting an entire record by users request

    Hiya, Currently I am having problems with deleting a complete record from a mysql db. The code below shows that I am requesting the user to enter four fields that will identify the record in the database. In total there are four more fields in each record however I dont want the user to...
  6. biscuitboy

    re-directing a page?

    Hiya, The following script I am using as a login screen and it seems to work fine apart from where the user is meant to be sent to the surname.php page. Have I written this incorrectly? Any advice would be great Best regards Code: <?php # Scrtipt 6.6 - viewresidents.php if...
  7. biscuitboy

    changing a table display format

    Hiya, The script below returns all of records stored in a mysql database and displays them in a table. The current table is displayed like the following: Surname First Name Flat No etc etc etc ----------------------------------------------------- record1data data data...
  8. biscuitboy

    how do you display records underneath a form?

    Hiya, That was so obvious I cant believe I didnt think of that. Thank you for the help.
  9. biscuitboy

    how do you display records underneath a form?

    Hiya, Below is a script that searches a mysql database and returns records based on the surname entered into the form. Currently when the records are returned they are displayed above the form. Is there anyway to have the records displayed underneath the form?? best regards Code: <?php #...
  10. biscuitboy

    to search a mysql database by the field surname

    Hiya, Currently when I run the script nothing appears on the screen? Andy ideas? Regards
  11. biscuitboy

    to search a mysql database by the field surname

    Hi all, Im trying to create a simple script to search a mysql database and search by the surname of the entries. Ufortunatly I have tried this script in the browser and doesnt seem to work. I have created a connect.php script which I know works and so I know that isnt the problem. Could...
  12. biscuitboy

    getting php to work on fedora2

    when I type in "rpm -qa | grep -i php" I get: php-pgsql-4.3.4-11 php-4.3.4-11 php-mysql-4.3.4-11 php-pear-4.3.4-11 php-ldap-4.3.4-11 php-odbc-4.3.4-11 so im guessing php is installed. Just need to get it configured now regards
  13. biscuitboy

    getting php to work on fedora2

    The apache was installed after the installation of fedora. As for the php there were no options to install it so im only guessing it might of been installed automatically. Can I make the changes to the httpd.conf file like you said anywherew in the document or does it have to go in a particular...
  14. biscuitboy

    getting php to work on fedora2

    Hi, Im a first time user of linux and have just installed Fedora2. What I want to be able to do is design a html document with php contected to a mysql database. The problem I have is that when I try even the most simple strings of code for php like: <?php print ("test"); ?> when I run it...
  15. biscuitboy

    Permitting a single copy of the database to be opened.

    Hi Ive created a database in access and what I would like to be able to do is create a piece of code so that if it is open on a computer the user can not open a second copy of it. Is this possible? Regards
  16. biscuitboy

    Exporting two tables to seperate sheets in excel

    Hiya Sorry about that. Im working in Access and trying to export them into excel. However I want excel to open onto an unsaved workbook and then the tables to be inserted onto the sheets. I have tried the output method however it requires a file name for the excel sheet to be saved under...
  17. biscuitboy

    Exporting a Table into a blank Excel sheet

    Hi, This in theory should be simple but for some reason I cant figure it out. All I want to do is with a click on a button in Access I would like a blank excel worksheet to open and then a Table from Access called "Data" to be copied onto sheet1. Can anyone help? Best regards
  18. biscuitboy

    Exporting two tables to seperate sheets in excel

    Hi, I would like to be able to export two tables, one called "Data" and one called "Monthdetails". I would like them to be exported into a new workbook in excel with "Data" being on sheet1 and "Monthdetails" on sheet2. Is this possible, can anyone help. Best regards
  19. biscuitboy

    filtering a form twice

    Hiya, I would like to filter a form called "Authorisors" however I would like to open the form and filter it with the existing filter in stlinkcriteria and also the filter: "[Workgroup number]=" & "'" & Me![Text162] & "'" Is this possible?? The code I am using currently to filter one field...
  20. biscuitboy

    coping data from one table to another

    Hiya I have two tables in my database. One is called Data and one is called userdetails. These tables contain different information. What I would like to be able to do is when the user hits the button the information in the "Username" coloumn in the userdetails table to be copied and pasted...

Part and Inventory Search

Back
Top