Search results for query: *

Hi I have two tables [Hymn] and [Hymn_usage] and I want to select only the hymns that have a hymn_usage_date of 90 days or more, but also haven't been used within the last 90 days. The problem is - while the query works by selecting only hymns greater than 90 days - a hymn can also appear more...

Hi I am a Pastor of a church and have a database that I am creating to help me plan services much more quickly. I have a small Access 2002 DB that generates an 'order of service' report each week. I enter 4 hymns for the AM service and 4 hymns for the PM service (in the same service_id record...

I have the following that calculates and displays the result in an html input form field called payment_amount <input type="button" class="input-calc" name="plus2" value="Calculate Deposit" onClick="document.calc2.payment_amount.value = parseFloat((document.calc2.total_cost.value) -...

I am doing this on a small intranet $current_page = $_SERVER['REQUEST_URI']; This brings back something like: /dir/page.php But can also bring back: /dir/order.php?order_id=3456 Which is fine but how can I limit the url string to just the file name without the directory and without any...

I have this which pulls a country select box: <? $query_country = "SELECT * FROM country"; $result_country = mysql_query($query_country) or die (mysql_error()); echo "<select name = country>"; while ($row2 = mysql_fetch_array($result_country)) echo "<option value =...

I have two form fields and I want to be able to subtract the value from one. What I currently have doesn't work. I haven't written a javascript function before but this is what I have: <script language="JavaScript"> function deduct() { document.form1.payment_amount.value =...

Hi I have an application that lists rows of jobs by date. What I'd like to do is list them in the same manner but to have a row shown if there is no job on that date but to still have the date displayed at the beginning of the row so that it can be quickly seen that a job can be added in for...

Hi Does anyone know of any script examples where you are able to select multiple dates and have them available to populate into a simple holiday table. My application takes a holiday date for an employee in the basic format into a holiday table: employee_id, holiday_date I could just have a...

Hi I am trying to compare two different DATE fields from a mysql DB. The two fields are DATE and not DATETIME. Here's my query $query6 = "SELECT * from holiday WHERE installer_id = 1 AND holiday_date = $row4[job_date]"; But I am not getting the expected results. If I output the two DATE...

Hi I have a query that returns rows of records from a mysql database and I was wondering how I would alternate the cell colours for the rows that are of the same day. I could have 1 or more records returned for each day. Jan 1 This is the first record Jan 1 This could be the second record...

Hi I have a CUSTOMER Tbl and a Comments Tbl and a CUSTOMER can have more than one Comment record in their Notes. i.e One to Many from Customer. I have a Customer_ID in the Comments tbl as a foreign key. I have a query that produces rows of customers and I have a popup window that displays...

I have a newsletter which has about 20 dynamic pieces of content that come from a mySql database. One of the fields in my newsletter table is called test_field. I am just creating this application at the moment but have got to the stage where I want to be able to edit each part of the...

Hi Is it possible to print an RTF file to screen so that it can be printed?

Hiv I have two tables and all I want to do is update the cust [table] with a value from the territory [table] The tables are related and have a foreign key. Here's what I have thus far: UPDATE cust c, territory t SET c.t_office_id = t.t_office_id WHERE c.t_office_id = t.t_office_id AND...

I would like to be able to pass a Month like 'Jan' which is a datetime field in a table called sales from a mysql db and pull back all sales for Jan 2007. I can't get the following hard coded month to bring back the sales it's just empty. SELECT Date_Format(order_date, 'mmm') AS monthDate...

I have a mySQL DB with customer details and I would like to be able to generate a query to print out address labels. How would I write the query so that it prints out to the screen in a format that is two labels across and 4 rows down? A total of 8 labels on each page but further pages if the...

Hi Guys I have two sets of data in the same worksheet. I have a spreadsheet with uk addresses including postcode data in rows and I want to be able to read the first 4 characters of the address postcode in that column and add the name of the office that falls in that territory into an empty...