Search results for query: *

This is kind of weird im trying to pull the number of layers from a .psd file. I get to the section where it contains the information. Its a 2 byte section (short integer) But it looks like this in hex FF FD and some how its suppose to equal 2? FF FC = 3 FF FB = 4 & so forth it seems...

Hi I really dont understand this check this out.. Field exclude has been dropped (Query took 5.8564 sec) SQL query: ALTER TABLE `_teamContest` DROP `exclude` This table has 0 rows and it takes 6 seconds to drop it??!? Why would it take so long to drop a row I am quite confised by this.

Hi we have a problem with our Apache server. Every once in a while our Apache server will stop responding for like 10 minutes.. its running fine but it will just not respond and load a blank page for 5 minutes and fail. All i do is restart apache and all is normal. Anyone ever heard of this...

Hi I currently set my FPS to 24. Now when I play the SWF file from my computer it runs just fine. But when I view it from Internet Explorer or FireFox the FPS is much slower like 12.. why does the browser make it go slower?

I currently bought https:// for my site dtdyno.com. The problem is that if you type https:// for my other sites it will forward to http://dtdyno.com. For example: https://shiftcode.com goes to https://dtdyno.com https://dtdyno.com goes to https://dtdyno.com I do not want it to-do that for the...

I got a good one for you guys. For some reason when I type the command "top" in unix. I get this. 21925 mysql 15 0 217M 162M 1844 S 4.7 16.1 3:36 0 mysqld 30992 mysql 16 0 217M 162M 1844 S 3.9 16.1 0:31 0 mysqld 13926 mysql 16 0 217M 162M 1844 S 3.3...

Hi, I know its possible to count all the rows in a table by SELECT COUNT(*) FROM table Is there anyway to count all the rows in a database? Thanks, Andrew

How could I get mysql to just print the number of rows for this query, because this is currently return hundreds of rows. I just want one row. I want to know how many duplicate first names there is. SELECT COUNT(*) as total FROM members WHERE first!='' GROUP BY first HAVING total>1

Lets say I host 6 websites, and they all have different image directories as follows: /images/1/ (site1.com) /images/2/ (site2.com) /images/3/ (site3.com) /images/4/ (site4.com) /images/5/ (site5.com) /images/6/ (site6.com) Now lets say they goto: http://site1.com/images/1/ and they see all...

I believe one of my pages are looping, but I dont know what page on my server is. My server will get extremely slow, and I will run a "service httpd restart" to the console and then it will be fine. Is there anyway I can see what pages are looping? Andrew

Hi, I currently want to split between commas and return it an array, this can accomplished with this. $string = "'i like birds, and dogs','col2 value','col3 value'"; $array = explode(',',$string); Now I want to return like this: Array (0 => 'i like birds, and dogs', 1 => 'col2...

For someone reason this query runs slower SELECT * FROM 3280296_spends ORDER BY id LIMIT 2800 , 200 than this query.. SELECT * FROM 3280296_spends ORDER BY id There is a primary key on 'id'

Hi I currently have this query. SELECT sum( worth ),sum( burst ) FROM 3280266_spends WHERE donation = '0' This sometimes runs through 70,000 rows.. what would be the best way to index this?

Hi I currently have this query.. SELECT sum( burst ) AS sum, sum( worth ) AS sum2 FROM 3279655_spends WHERE donation = '0' It will run for 14-15 seconds at a time. I am running MySQL 4.1 Is there any way to make this query not go so slow.

Check out these logs Host: 201.50.215.207 /signUp.php?ref=1945777 Http Code: 200 Date: May 20 00:55:40 Http Version: HTTP/1.0 Size in Bytes: 0 Referer: - Agent: Mozilla/5.0 (Macintosh; WUU; PPC Mac OS X; en-US) AppleWebKit/778.7 (KHTML, like Geco, Safari)...

This table is creating temporary tables.. is there a better way to execute this.. ( SELECT u.id, p.function, u.hotspot, u.psid, u.ord FROM userHotSpots u, prodSpots p WHERE u.tid = '68' AND u.type = 'product' AND u.psid = p.id ) UNION ALL ( SELECT u.id, '', u.hotspot, u.psid, u.ord FROM...

Would this have any impact on my queries. I am running almost every 4.0 query/syntax possible, and I can not afford one query to be faulty because it's changed in 5.0. Thanks, Andrew

Hi, I have read a lot about optimization, and I actually own some books but I am thrown for a loop on this one. I have this one site that slows down all my others because the queries are so massive. For example one of these queries I use to-do a search by a user's account number. I also get...

Is there a way to make the scroll bars get larger as you drag an object in the ScrollPane. Currently when I srag a movie clip in the ScrollPane it does not change the ScrollBars.

Hi.. I currently have these queries. $q = $_db->Query('SELECT id,DATE_FORMAT(start, \'%M %d, %Y\') as start,DATE_FORMAT(end, \'%M %d, %Y\') as end FROM refContest ORDER BY id DESC LIMIT 10'); while($r = $_db->Fetch($q)) { $q = $_db->Query('SELECT w.*,m.username FROM refContestWinners w...