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

    Printing Address Labels

    Jpadie I appreciate that but I haven't attempted something like this before and will learn from seeing the entire structure. I'll post back with how I get on!
  2. andyb2005

    Printing Address Labels

    Jpadie, that's what I am trying to do, but have you got a complete example with all the bits and pieces together so that I can see how this works?
  3. andyb2005

    Concat Poscode

    Hi What I ended up doing was: $query= "SELECT * FROM customer WHERE postcode1 = '$_POST[postcode1]' AND postcode2 = '$_POST[postcode2]'"; And just having two form fields for each part of the postcode. But thanks anyway guys!
  4. andyb2005

    Concat Poscode

    Hi I have a UK postcode broken down into two database fields: postcode1 and postcode2. What I want to be able to do is to query the database from a form and return customers from the complete postcode entered on the web form. I am trying this sort of thing at the moment but it's not...
  5. andyb2005

    DATE_ADD

    It's OK - I've figured it out!
  6. andyb2005

    DATE_ADD

    I have it more or less working now but how do I just display those records that are 14 days and older and not records less than 14 days old?
  7. andyb2005

    DATE_ADD

    I have isolated the code from my main script and it returns the correct records. It would seem that I must have a problem elsewhere which I should be able to find. Thanks for your help!
  8. andyb2005

    DATE_ADD

    Hi All I am trying to excute is this: $queryCheck2week = "SELECT * from customer WHERE DATE_ADD(date_entered, INTERVAL 21 DAY) >= now() AND two_wk_follow_up = 'No'"; $result10 = mysql_query($queryCheck2week) or die (mysql_error()); while($row10 = mysql_fetch_array($result10)) {...
  9. andyb2005

    DATE_ADD

    Hi ok I am doing this now "SELECT * from customer WHERE DATE_ADD(date_entered, INTERVAL 21 DAY) >= now() AND two_wk_follow_up = 'No'"; There are 3 records that should satisfy this query -however, it returns 3 unique results and then repeats them continously. I'm baffled!
  10. andyb2005

    DATE_ADD

    Hi typo - I have got a comma there but it just seems to bring back all of my records instead of the ones that are 14 days and older.
  11. andyb2005

    DATE_ADD

    Hi here's my query: "SELECT * from customer WHERE DATE_ADD(date_entered INTERVAL 14 DAY)"; date_entered is a DATE held in my database and is datetime. I am trying to highlight the records where the date_entered has now exceeded 14 days since it was entered into the database. I know I have...
  12. andyb2005

    Dynamic Page Counter

    Thanks, It's been a while but I may try that approach soon.
  13. andyb2005

    simple query error

    DOH!!! Many thanks!
  14. andyb2005

    simple query error

    Hi I am just trying to execute this query on a new mysql db with the query window in phpMyAdmin but am getting an error but can't figure out why - anyone got any ideas? Error SQL-query : CREATE TABLE cust( cust_id INT NOT NULL AUTO_INCREMENT , cust_title VARCHAR NULL , cust_firstname...
  15. andyb2005

    Stored User Names and Passwords

    Many thanks for the info. For some reason the [ADD] button isn't available still. But thanks for the info about that hidden option.
  16. andyb2005

    Stored User Names and Passwords

    Hi I have a Windows XP Home installation and I'd like to be able to add a 'Stored Username and Password' so that the user doesn't have to login with their exchange server username passord. However, when I access the 'Stored User Names and Passwords' GUI there are no entries and there is no ADD...
  17. andyb2005

    How to pass a parameter from a form button

    How would I pass a parameter from a form button (which opens another form) and update a text field with the parameter from the previous form? Any help appreciated!
  18. andyb2005

    Mulitple Line Update Query

    I have two tables. [Stock] has a list of part numbers and quantities. [Order] has a list of part numbers and their order number. So [Order] table could have the following data: Index, Order No, Qty, Part No, 101 9702 1 121-454 102 9702 2 121-403 103 9702...
  19. andyb2005

    Add carriage return where comma exists

    Hi Tony I can live with it ;o) Many thanks
  20. andyb2005

    Add carriage return where comma exists

    Hi =SUBSTITUTE(A1,",",CHAR(10)) The above works fine except that it creates a carriage return and includes a space at the new line before the data starts.

Part and Inventory Search

Back
Top