timhysniu

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 …

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 …

You could also use MySQL to figure out the date: ie. UPDATE Contact_positions SET x=CURDATE(), y=DATE_ADD(CURDATE(),INTERVAL 1 MONTH) I prefer using database layer for dates, just in case php and mysql times are out of sync

Have you tried [code=mysql]"SELECT FROM `Reply` WHERE `reply` LIKE '%example%'[/code] ? If that returns no results then probably delete will not work either. Check your indexes too maybe (FULL TEXT vs LIKE). It's possible that your selection isn't working...

While developing it's also a good idea to turn display_errors on in php.ini. Blank screen generally doesn't give you any feedback on what the errors are. Turning if off is generally a setting you want to use in your live/production environment.

To run PHP on command line you probably want PHP CLI. then you do something like: php-cli php_file.php

Terminology you are using, ie. '..appends the database and the dynamic table on...' is kind of confusing to me. But here are few ideas: - ordering of your results should generally occur in database layer. So try your query before doing anything on HTML! Use ORDER BY ascending/descending (google ORDER …

If you don't want to submit a form when a certain condition is not met then what you want to do is add something like this to your submit button: <input type="submit" ... onsubmit="javascript:return(some_javascript_function())" /> this javascript function would return false if conditions are not met (ie. form shouldnt be …

If you are not using any framework and wanted this done fast, then the approach that I would take is as follows: - each step would have the presentation and the handlers for $_POST in same page. - you use a session variable to keep track of what page the …

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 …

This site is the best. I hope I lose my job so it can suit my new lifestyle :twisted: P.S. Looking forward to reading what ya gotta say