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!
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...
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
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...
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...
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
=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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.