Search results for query: *

From a general industry point of view, who owns code we write while we are employed by a company? Say if we write code in and out of work time? Is there any agreement on this? There's a couple of neat things I want to work on. Basically it'll be of use to the company, but I want to be free to...

I pull out a lot of reports for weekly figures, but is there any way to get the start date for a particulr week number?

I feel I should be able to work this out, but I'm drawing a blank. How would I retrieve, for example, the top 10 orders for each day for a period, where I order by orderTotal? I can't seem to find any way to limit the results for each day, rather than the results as a whole. Any ideas?

I can't seem to find an answer in the literature, but is it possible in 4.1 to place a lock on a particular record? Say, to prevent changes to the record while being viewed. There's plenty on table locks but no record locks. Are these not supported?

Recently I've noticed the mysql server going very slow at times. At such times i've run show full processlist and there's been one or two processes with a status sleep and time being anything up to about 40 seconds. What are theses proceses? Are they read/write processes waiting for their...

I have a table of customer problems, and another table of cummunications relating to the problem. I'm trying to pull out for each problem: details of the problem, the most recent comversation, and the timestamp of the oldest conversation. I've got the latest conversation like so: select *...

I Have this query which just takes too long and kills the server. I have 2 left joins and want to do an inner join matching values in either of the left joins. It seems to be the use of an OR in this inner join which is the bottleneck. select * from categories c INNER JOIN cat_subCat csc...

Is there a way to copy some data from 1 table to another in a insert into...select statement AND remove the affected data from the original table? ie combining these 2 statements: insert into superCat_subCat (sCatId, subCatId) select from cat_subCat where catId = 327 delete from cat_subCat...

I've got a fairly complicated query on the go here, and I might have bitten off more than I can chew! In short, i'm trying to get daily totals over a period for sales, alongside similar info from identically structured tables showing a reversal, or subtraction of any of the sales. The sales are...

I'm trying to do a query to get sales totals. Here's the definitions: CREATE TABLE `torders` ( `orderID` int(11) unsigned NOT NULL auto_increment, `uts` int(11) NOT NULL default '0', `subTotal` float NOT NULL default '0', `delivery` float NOT NULL default '0', `deliveryCost` float NOT...

I need to keep a running count of actions for particular dates, so I need to say 'if this date & value aren't in the table, insert them. if they are, increment them'. Is this possible to do in 1 query? I can't figure how. Here's what I'm doing at the minute: SELECT count(*) FROM tracking...

I have inherited a fairly clunky database design for the company I work at. This query I'm running takes nearly 3 minutes to run, so I daren't un it on the website! What I need to do is delete items from the products table where that item does not appear in an order. I was starting off with...

Is there an alternative to STR_TO_DATE which I can use in mysql 4.0? I have some dates in the format 'August 24, 2004' and want to be able to order a query by that field. Cheers

I am trying to preload some images for a rotating adbanner type affair. But my script, which is pretty identical to others on the internet, seems like it only preloads the last picture in the array, having looked at the broswer cache. Any ideas? Yes I could use something that someone else has...

I have a menu system which pops up a submenu when the mouse hovers over a menu item. It dynamically creates a div for the submenu, and removes it when the mouse the submenu, or the main menu item which spawned it. All good so far. Nearly there. But what I'm finding now is that the submenu...

I am creating a pop-up menu/submenu thingy by using a function to read from an array containing info on the submenus, and dynamically attaching a div containing submenu hyperlinks to the menu item. Make sense? All is working fine except that the hyperlinks don't work (OK i guess that's not...

Haven't quite got to grips with regular expressions yet, so could someone help me with this query: I need to select a field from a table, but excluding any text that is enclosed within brackets. For example, we have this data: '(1) row 1' 'row 2' '(3)row 3 (yes, that's 3)' I need to return...

I'm working on a site which has a bit of a dodgy tabled layout. When the browser window gets too small the layout goes really bad. As a quick fix, I thought i'd fix the size of the tables to full screen width, and this is where I ran into problems. window.width gives the full screen resolution...

For a search facility on my website I want to get a bunch of rows where any words match, then I want to go through the record set and assign relevance values according to which/how many fields match search terms. At present I've done the assigning of relevance values with PHP, but am having...

Hi. How do I get all rows from 2 tables, where there may not be a corresponding rows in EITHER table? I have 2 tables 'online orders' and 'offline orders', both with 'date' and 'order total' columns. I want to combine them into 1 table, but there may be dates in 'online orders' which are not in...