timhysniu

Hi there, My knowledge on query optimization ends here. I am stuck! My table with following structure has more than 1 million records. CREATE TABLE `dreambank`.`db_ip_data_buffer` ( `ip_from` bigint(20) unsigned NOT NULL default '0', `ip_to` bigint(20) unsigned NOT NULL default '0', `country_code` varchar(2) default NULL, `country_name` varchar(64) default NULL, `region_name` …

Hello All, While trying to optimize my web site for certain keywords, I can see the need for some tool that would capture the ranking of my web site pages for these specific keywords, on a regular basis. The way it would function would be, for example: - every day …

Hi There I do have a form and a little sql query to update the row before do something else. Problem is in the code below works when I enter the date like that= 01-02-2001 but I need to do it dynamic I know getdate() but it does not work.. …

i'm having trouble getting this to work. i want mysql to delete a row where the word 'example' is within a paragraph of a column. e.g. in the column reply.. it has a paragraph with the word 'example' in it. [code]$deletebadreply1= mysql_query("DELETE FROM `Reply` WHERE `reply` LIKE '%example%'") or die …

I am calling a function in PHP that should return values from a database that I have set up. However, I'm getting a blank screen instead of what I'm asking for. If I comment the correct lines out and process it without the function, everything works perfectly. I've posted both …

Hi, I am pretty new to this scripting language. I have just installed the following s/w packages in my system via XAMPP. >php >MySQL >Apache Next,I started writing a basic script in notepad and saved it as "hello.php" My question is where to run this script, either in the Command …

This is stumping me...it's probably pretty obvious, but I'm working under medication for the flu... I finally got my form submitting to my database and to separate tables from the update.php script. Problem is, (I know this sounds trivial and I shake my head as I query) I can't get …

Below you will find my code for a form. I am trying to do Regular expression. I have the expression but when i enter something that is not right it will still post. I believe the reason is that i am still calling the $_POST of original not taking into …

Hi I am just stucked. Would be great if someone can help me. I have created form in page1.html. User fill the form and can view it in page2.php where there is also an edit button. If they need to edit any details, page3.php comes and they they can edit …

Hi there, I'm working on a multimedia project that involves capturing images from a web cam, analyzing pixels and playing some audio. I got a hold of some sample code that plays audio and reads images using DirectX, but I was really disappointed with the stability of the application overall …

Hi there, I've used Zen Cart before since it was an open source. Although the cart is not bad, I think it is a bit outdated and not very flexible when it comes to presentation. Can someone suggest a Shopping cart that is easy to use and is flexible? I …

Hello group, Im a new member in this site. Seems very resourceful. My first question is what is really .NET framework? Although quite programming background, I'm not very experienced with Vstudio and now this .NET (which I just purchased with aim to learn something) is a little unclear to me. …

Hi guys, Can you please recommend a Java/JSP framework for a larger web application? It would help if this uses a MVC architecture. From my research, it looks like Struts is THE major and decent framework. I have heard from someone here, though, that there are better frameworks. I just …

Hi there, I haven't worked in Java for a while and I want to go back to it. Can someone please recommend an IDE software that is good for Java Development. I am interested in struts. Things like autocompleters would probably be very helpful. Any responses would be greatly appreciated! …

Hi there, Do you guys know any good software that I can use to manage passwords. It would be great if it was open source, but I wouldn't mind paying for it too. Basically I want to store: - linux server passwords, root password, linux user passwords - mysql passwords …

Hi guys, I am trying to find a solid optimization technique for my problem. I have two tables that grow quote large: [code] CREATE TABLE `mydb`.`xm_artist` ( `artist_id` int(10) unsigned NOT NULL auto_increment, `artist_name` varchar(255) NOT NULL, PRIMARY KEY (`artist_id`), UNIQUE KEY `index_artist_name` USING BTREE (`artist_name`), FULLTEXT KEY `fulltext_artist_name` (`artist_name`) …

Hi there, Can someone recommend a PHP&MySql open source project management software that supports time tracking. It would be nice to be very simple and easy to use. Focus is only one project, so simplicity would be very nice. I looked at demos for dotproject and phpproject and they seem …

Hi there, I am looking for a sharp database design tool. Take a look ad wikipedias db schema. Looks fantastically neat. Do you guys know what this tool is called? upload.wikimedia.org/wikipedia/commons/4/41/Mediawiki-database-schema.png Visio has been good to me, but tables dont look look that sharp, doesnt export to sql scripts. mysql …

Hi there, My web site is has a lot of content that is related to places overseas and not in North America. Target audience on the other hand is in North America. I'm wondering does the geolocation of backlinks affect the quality of my pages, PR and poularity from Search …

Hi there, Can someone suggest me some top sites that have high traffic that allow article submission. It would help if they don't snipe my signature! Any ideas would be greatly appreciated! Tim

Hello there, We are using XSL transformations using XML for one of our sites. Anyway the idea is to show everything styled just like a regular html. I have a problem though. I have a node that looks like this. When I display it it will show on browser as …

Hi there, I am wondering does anyone have any idea how to execute PHP scripts (a maintenance script in my case) in the background. The reason for this is because I don't want visitors to be slowed down by the maintenance execution, so having it run as a separate process …

Hello there, I am working on a web site which google is not indexing properly at all. The site might have some adult content and I am assuming that could be the problem. Apparently even google ads aren't related to anything in my pages. My site is basically the same …

Hi there, I am new to all this optimization thing. Yahoo and a few other search engines are finally showing my site and this is good. Google, however, won't do it. So, I read a few tutorials and a bunch of messages and I realize that there are a few …

Hi there, I posted here earlier and my post might have been lost somewhere. I have an review site that has adult content reviews and a few banners related to adult content. I see many other similar sites that have considerably high page rank and they seem to be well …

Hi guys, I have 3 pages where 1 of them (last one) is in secure server. I use sessions in all of them and these sessions work fine in first two pages (using session_start()), but when I get switched to secure server ([url]https://xxx.xx.../site/page3.php[/url]) a new session comes in. I can …

Finally, I am ranking highest for (bctutor dot com) on yahoo. No response from google though. It seems very strange that I don't even have 1 pagerank on google. I can't find my site at all on google. Can anyone give any suggestions? It seems like my site got banned …

... I hope I am not annoying the admins already. Can anyone recommend me a good webserver for ASP/ASP.NET, Java and VBasic? My friend suggested Appache Webserver (I got some instructions on how to set it up but I barely know if I'm going to be able to make it …

Hello guys, Being a little dissappointed I'm coming here for a relief. I just gave up with my Linear Algebra. The proff I got is not very useful and his lecture makes no sense. Tests questions are all new to me etcetera ...rambling... Anyways, I was doing very well on …

Hi there, I am new to this site so please re-direct me if necessary. I am basically looking for an online dating service template (not neccessarily a free dodgy one). I am interested in further design but I do not want to make it from scratch. Does anyone have any …