The file extension will not affect a new site, but it will affect an existing site that has already been indexed. The old page URLs in the search engines will generate 404 status codes (Page Not...

This might also help.

Preventing SQL Injection (http://www.tech-evangelist.com/2007/11/05/preventing-sql-injection-attack/)

You guys are probably all spinning your wheels with the debate about how many keywords to use in the keywords meta tag.

I've been doing SEO work since 1997 and no major search engine has used the...

You do not need all of those PHP start and end tags.

You only need one at the beginning of the PHP code and one at the end. Any blank line in between a close and start tag is being sent to the...

You might want to check with your hosting company about the MySQL connection. Not all hosting companies allow you to connect via localhost.

With GoDaddy and some others the MySQL database resides...

Here is a tutorial for building a select box from MySQL data.

Populating a Select Box With PHP and MySQL (http://www.tech-evangelist.com/2007/11/22/php-select-box/)

I think Jaseva is right....

The best way to really learn osCommerce is to download the code and set up an osCommerce test site. You don't have to sell anything, but you do need to learn to work with the code.

osCommerce is...

humbug's code is correct.

The only reason that IE appeared to be displaying the table correctly is because the table code was invalid and the closing table tag was not being recognized. Each...

You need server root access in order to manually modify the httpd.conf file. Very few hosting companies will give a site owner root access. Using cPanel to add a subdomain does the same thing.
...

No, you are not making yourself clear enough, or you would have had 10 responses to your question.

If you want to be absolutely correct, it is a Flash video, not a Flash movie.

And PHP has...

Hi Diode

The purpose for cleanQuery is to protect your data from malicious SQL injection attacks. Those attacks only occur when querying a database. The point is that cleanQuery doesn't strip any...

Try taking the links out of the Flash presentation. The hyperlinks need to be visible in the HTML code.

Hi Diode

I think you misunderstand what that function does and how it should be used. The function you are using does not clean out any SQL code. It merely escapes (with a backslash) characters...

If you just want to prevent page elements such as buttons from displaying on printed output, the easiest way to do that is by using external stylesheets. You can use a different stylesheet to format...

What is a JARGAN?

In order for CAPTCHA to work, you need to have GD support in PHP enabled on your server. It has been included with PHP since version 4.3, but it might not be enabled.

You...

I stared out using ASP in the 1990s and then migrated to PHP. I also investigated Cold Fusion and JSP.

Here are my observations about Cold Fusion:

1.You can only run it on a Cold Fusion...

PHP is server-side code. It runs on the server and is executed before a script is sent to the user.

JavaScript is typically used as client-side code. It runs in a user's browser and is executed...

I have to agree with nav33n. That would not cause the problem.

You need to isolate the problem. At this point, you don't know if the GET variable is not picking up the value or if the value is not being inserted into thte table.

add echo $q_id;

just after...

If your host allows you to modify the .htaccess file, you can add the following line of code to turn safe mode off.

php_flag safe_mode off

You are trying to insert an id value of ' ' when you have that column set up as auto_increment. Don't insert an id value. Let MySQL set the id value.

Try this:

mysql_query("INSERT INTO...

You can also turn on the error message. It does a good job of pinpointing most errors. Place it at the top of your script, just after the first opening PHP tag '<?php'

Do not leave this turned on...

IMHO, the major search engines are not likely to ever to use the keywords meta tag again, primarily due to the widespread abuse of this tag in the 1990s. People used to stuff literally hundreds of...

Here is a MySQL cheatsheet (http://www.tech-evangelist.com/2007/11/23/mysql-cheatsheet/) that includes examples of various table joins.

It's a joke. He's pulling your chain.

It's his first post.

Everyone knows that it takes exactly (%43h7c99bdE23% * (3.14159^2 / 64)) nanoseconds to train a neural network for the first time. :)...

You need to look for a shopping cart system. There are lots of good freebies out there. Check out osCommerce, Zen Cart and Cube Cart. They are all good carts. Zen Cart is based upon osCommerce and...

A general rule for the keywords meta tag is to never use words that do not appear on the page.

None of the major search engines have used the keywords meta tag since the 1990s.

As long as MySQL remains a freebie, I don't see an issue. But if they try to turn it into a fee-based DB, it will destroy an excellent DB.

Sun Microsystems developed Java. It was originally...

I strongly advise you to NOT use Word as a tool to create web pages. The Microsoft HTML conversion utility generates horrible code.

A developer is a code monkey. If you need to work with a database or ASP code or PHP code, you need a developer. A developer works with the functional aspects of a site.

A designer has the...

nav33n's solution will work if you just want to capture the ID for the last row that you wrote to the table.

If you wish to access a different row, you really need to know how to use the SELECT...

Have you tried using SELECT DISTINCT?


$sort = mysql_query("SELECT DISTINCT genre FROM bands ORDER BY genre");


That will return only one "distinct" row per genre value.

It looks like you...

Google recently went on a vendetta to penalize sites that are selling links. That means that links from these site have been devalued, which has taken a toll on sites that used directories and other...

That's a good routine to use if your server is set up to use it properly.

mysql_real_escape_string will not work unless you are using at least PHP 4.3.0. Also, if magic quotes is turned on, you...

You use dots to concatinate string values in PHP. The dots do not appear in the final value.

Try using different values for your select options. It makes it much easier to assemble a date in the proper format, which is yyyy-mm-dd.

<select name="date_year">
<option...

I agree copmpletely with csgal.

I think it comes down to this.

PHP is overwhelmingly more popular than PHP, but .NET is very popular in large corporations.

IMHO, if you want to develop web...

As MitkOK mentioned, PHP is a server-side language, which means the PHP code is executed on the server before sending it to the browser as client-side code. Server-side languages allow you to pull...

Simple PHP should do it if you do not know regular expressions.


$string = "abcd123xyz";

if((substr($string,0,3)=="abc") && (substr($string,-3)=="xyz"))
{
$string = "this is a test";
}

Here is a tutorial that shows you how to validate foms using JavaScript. Just cut-and-paste the code and follow the instructions.

Form Validation using JavaScript...