Search results for query: *

And thats the best thing about this site - completely un-biased opinions! You have no idea how much these responses have helped! Stars all round. BB

last week my server suffered catastophic data loss. the basic server setup is one server with RAID with four drives attached. the sequence of events was a series of input/output read/write errors where the drives had reportedly gone into read-only mode. the server was rebooted on three...

What you want is an order by statement, and then jsut change the date to show the whole year. So your statement would look a little like this: Select * from table where date_field > [start_of_year] and date_field < [end_of_year] order by date_field asc, staff_name This will order everything...

Ok, so its friday afternoon again, and here's the issue at the end of a long week! I have a table, with IDs and TYPEs. What I need to be able to do is return a recordset with 2 random records for each TYPE. There are 30,000 records in the db, and 150 types, and I'm trying to avoid running 150...

Very nice, neat solution. Thanks - have a star! BB

Ok, I know when I'm beat, and this might well be one of those times. I have 40 menus, and now I need to change the style of all the menus to capital letters. Using the text-transform property, this is easy enough, and works great. The only issue I have is that one word is McGrath, which I...

You may want to checkout http://www.paypaltech.com/Dave/api_sourcebook/html/ewp/ewpphp.html . This provides you with the OpenSource Classses required to generate any encrypted buttons within your PHP script. Good luck BB

Ok, this is probably something simple, and I'm just not getting it. I'm running php4, and I need to send XML data to a WebService. I'm a conmplete beginner when it comes to XML and webservices, so any help, or pointers to a tutorial would be great. Currently I have generated the XML data, and...

How do you do it? Everytime I get stuck with a little SQL query issue, there you are with the answer. Everytime! Thanks again, and have another star. Cheers BB

Ok, I know that isn't particularly good practice, but I hope there is an easier solution. I have two tables, customer and customer_phone. The customer table has an id col, cust_id, which links the two tables. The phone table has a number col, a type col, and a few more. What I need is to be...

I'm a complete newbie when it comes to servers, and DNS, but very willing to learn. I have a server set up at the moment, which has 2 domain names pointed to it. mysite1.com and mysite2.com. This server is fine, and works well. What I need is to replicate this on another server, and I don't...

I'm not sure that this is even possible with only a single query, but if it is, hopefully someone here can set me straight. I have the standard order, and order_products tables, linked by order_id fields. Order table holds the customer id, order date etc, and the order_products table holds the...

Perfect. Thanks r937 Have a star for your efforts. BB

I have the standard orders table, with the amount of an order, the order id, the customer id, and the date. What I now need is the ability to group the order totals by quarter. So give customer id, I need to be able to display how much they spent between each quarter. Is this possible without...

Many thanks for your responses. It now works perfectly. BB

I thought this was an easy thing that I over looked, and after a long week, and now wanting to quit for the weekend, I can't seem to see the wood for the trees! I have a function, and within the function I refer to a session variable. I've tried echoing out the variable, and I don't get...

I am posting these variables to the form. www.mysite.com/myform.php?item[101]=1 or www.mysite.com/myform.php?item=1 Is there anyway to distinguish between the two values of $_GET['item']?? Many thanks BB

I am posting to a form using the GET method. The problem is that I need to be able to distinguish between item[101]=2 and item=2. Is there a way distinguish where the variable is an array element, or using pairs, is there a way to to reutn true if pairs exist, or false if they are missing...

I don't know if this is possible, but is it possible to iterate through the following: I have a selection of textboxes, making up a form. One of the groups of boxes is named: textbox[i][quantity], where i is a varible. Currently I have the following: var sum = 0; var quantity =...

Sorry, got some sleep, and re-read the original post, and I realise I wasn't very clear. I need to be able to batch print a number of reports. Each report has parameters in the url, such as my_report.php?id=32&product=13245&deliver=SW I tried using include($myreport_1), but once I try and...