Recent content by cc4mail

mySql 5.0.81 CREATE TABLE `blocks` ( `start` bigint(16) NOT NULL, `end` bigint(16) NOT NULL, `location` bigint(16) NOT NULL, KEY `start` (`start`), KEY `end` (`end`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 used the FORCE INDEX with start and start, end using start only, was approx 2 secs...

I added the end index - still about a 7sec user second query. -actual query .0002 for start<= only query -actual query 2.193 for start<= and end>= query. EXPLAIN - after I added ur suggestion, index "end" - sorry, couldn't make the display cleaner. id select_type table type...

Will do, I appreciate the lession and why I couldn't find a row number function - Thank you. (and the sunday response) Since my db is static (data never changes), it would make sense then just to add a field "row" to the DB then $sql = " SELECT row FROM blocks WHERE start>=" . $dword . "...

Thanks. I felt I was overlooking a simple solution. Would this query... $sql = " SELECT (the internal mySql row number) FROM blocks WHERE start>=" . $dword LIMIT 1"; avoid a row by row examination, on an indexed table? Then, I could retrieve the (mySQL row number result -1) for the...

I have a DB table with 4.1 million unique rows of dword number blocks, indexed on start. start end location 1259273696 1259273703 11532 1259273704 1259273704 4249 1259273705 1259273705 3487 1259273706 1259273711 4249 1259273712 1259273727 11532 1259273728 1259273791 117384...

sorry for the late response. very helpful. defining multiple clases is something I'm getting my arms around. I defined the "global" class but had asked how to use it as a variable - you cleared this up by the use of multiple classes: class="menu_e subcat" - perfect! the site came with a...

I appreciate you trying to help. re: "Yes, you can do it the way you want to, but it won't work, because it's a made up code that doesn't do anything. " The example was just trying to convey the concept of trying to set a class property with a common global value in css. The question is...

Thanks, I understand that, but trying to get flexibility... so the oddball class isn't altered, teh menus may have dozens of subcats and is still easily recognized in the css code eg: .global_subcat{font-weight;normal; font-size:11pt} .menu_a_subcat{style=".global_subcat"}...

This may seem convoluted, but there is a need. I have a complex css page - 800+ lines to manage multiple menu boxes with each with many different properties ( BG, images, colors, etc)and some common properties (fonts, etc...). eg: menu_a_cat{font-weight;bold; font-size:11pt color:#000}...

wonderful, it was smallint(6) - INT solved it - I see the limit 32767 gave it away... I missed it. appreciate the help!

Im trying to do the following INSERT from my us_business DB (12 fields) to service_providers_que DB (60+fields) and add some static values along with the INSERT at the end. 611612 is the test value that is to go into all shop_naics fields the INSERT works, but the last added value '611612' is...

data_seek worked perfect! I spent 7 hours on this yesterday... you replied in 11 minutes... thanks. Now, knowing what works, I found a one sentence reference to it in my 1000 page PHP manual.... I need to leave this project to the pros... thanks!

I have tried to pass a sql_query result ($result) to a function. Within the function is a WHILE loop that parses out the associative array. Works fine on the first pass. On the second call to the function, the associtive array pointer appears to be at the end, so there are no results. I...

Thanks Macropod! That's what I needed. I wouldn't have known where to look for charformat switch. That made it simple. If Microsoft could just write it that way! I appreciate the help, and the "cheers" encouraged me to have a margarita. Thanks for your efforts! cc

I originally copied the cell from excel, pasted into the word doc and formatted it with a link to excel and destination formatting. I also tried Paste Special, with a link to excel, and unformatted text. The first option breaks to a new line on updating, the second loses font formatting, but...