Establish your online prosperity by your own hands

Start Your Internet Business With Us. We create solutions that put you in profit.
VIE Scripts Team

Click Here for More Detail

Local PPC Management

According to the Kelsey group, 60 percent of all internet searches are local. Some estimates run as high as 75 percent. But even if it were only 20 percent, that's still a lot of searches. Tens of millions a day, at least.

Whatever the number is, local search is undoubtedly the most untapped opportunity in PPC management. You want to sell weight loss plans, MP3 downloads, high definition TVs, or mortgages nationwide on Google? You can do it, but you'd better strap on your gladiator helmet and prepare for a fight. But if you're an accountant, plumber, painter, repair shop, or podiatrist, it's an easy victory. In most local markets, your internet competitors have no idea what they're doing.

This is also a great place to consult, setting up campaigns for neighboring businesses, because it's so underserved. Think about it:

Hundreds of local businesses in your city spend upwards of $1,000 a month just on Yellow Pages ads, so these people are already spending money!

The Yellow Pages reps are also selling Internet Yellow Page listings, creating more awareness of online marketing. But they're not selling Google ads on Yahoo.

Companies like Google are so busy dealing with existing opportunities, putting reps on the street to sell PPC to local businesses is a long way off at best. (There are rumors of partnerships with Yellow Pages companies though.)

In categories where mail order is impossible and you have to get it locally, the clicks are cheap. For example, rin Chicago, there are only six ads showing for the keyword "Brake Shop" and one of them is eBay. Nickel clicks, anyone?

Web savvy local advertisers are very rare, and this is not going to change any time soon. Running a retail store and running an online store are two entirely different things. So for local yokels, "In the land of the blind, the man with one eye gets to be king."

If you can accept the fact that many keywords will only produce a few local clicks a month, the return on investment (ROI) on what you do get is extraordinary.

VIE Scripts
Article By Imhotep Yakub
Article Source: EzineA rticles.com

Back to Content

Sponsor Ad

Your Ad Here

Your Sponsor Ad Might Be In This Ad Box Lifetime
Click Here for More Detail

Insert Data Into a Database Table
The INSERT INTO statement is used to add new records to a database table.

The first form doesn't specify the column names where the data will be inserted, only their values:

The second form specifies both the column names and the values to be inserted:

INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...)

To get PHP to execute the statements above we must use the mysql_query() function. This function is used to send a query or command to a MySQL connection.

Example:
In the previous chapter we created a table named "Persons", with three columns; "Firstname", "Lastname" and "Age". We will use the same table in this example. The following example adds two new records to the "Persons" table:

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("my_db", $con);

mysql_query("INSERT INTO Persons (FirstName, LastName, Age)
VALUES ('Peter', 'Griffin', '35')");

mysql_query("INSERT INTO Persons (FirstName, LastName, Age)
VALUES ('Glenn', 'Quagmire', '33')");

mysql_close($con);
?>

Now we will create an HTML form that can be used to add new records to the "Persons" table.
Here is the HTML form:

When a user clicks the submit button in the HTML form in the example above, the form data is sent to "insert.php".

The "insert.php" file connects to a database, and retrieves the values from the form with the PHP $_POST variables.

Then, the mysql_query() function executes the INSERT INTO statement, and a new record will be added to the "Persons" table.
Here is the "insert.php" page: