Search results for query: *

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!

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?

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!

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

It's OK - I've figured it out!

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?

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!

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

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!

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.

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

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

DOH!!! Many thanks!

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

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

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

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!

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

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

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.