query database to show results

I have a site for which I need content to start search engine optimization before launching it. I've got about 10.000 items with names, provinces, cities, phones, URLS. So, my idea is creating content for this info that I already have, which will help me improve my rankings, add content to site, and start optimization before launch.

We already have some xhtml files and css so that you base on that for the design of this page.

So, what would I need? This is what I would need:

An xhtml page where we'll show items for each of the provinces, there are about 50 provinces. Each of these pages will be a db query to a different province. But we need to create just 1 xhtml page based on the design that you did where we'll show:

- h1 header with keyword

- sub header for other keywords

- small description

- a table with list of items in that province with these columns:

- Name of item

- City

- Province

- Phone

- Mobile

Each time a person clicks on the row, not just the name, it would link to site if URL is available

- Page navigation. We’ll show 100 items at a time.

- Top "search" area where we can filter by

- Province (dropdown with all provinces). You can see list of provinces in the access database.

- City: search box to filter city

- Columns should allow ordering ascending/descending on Name, City and Province by clicking on the header's icons (up/down)

- We'd have an area that stands out at the upper right, where we tell users that we'll be launching site very soon, and ask them to subscribe to our mailing list, as we did on the home page.

-When we click on a city name, we'll show all items in that city, with URLs as I describe below but with each of the keywords. We might refine this later. We'd have a page or sitemap where we might have each of the provinces like this:

Keyword1 in [province1]

Keyword1 in [province2]

Keyword2 in [province1]

And then, when we click on it we'd see a list of all cities in that province with links to the page where it shows items for each city. It's all the same page always, but showing data for a city or a province, with one keyword or another. By doing so, we would get a lot of content on the site for different keywords, cities and provinces, in 6-8 languages, you’d provide the admin panel and language files and we’d translate them into different languages, but we need multi language: 6-8 languages

Content pages editable: Metatags, titles, descriptions, all tags for a page. Each page should have these tags editable so that I can have the Search engine optimizer guy to edit them. Page's content, header, sub header and content should also be editable for each of the pages.

- MOD_REWRITE: we'd need to have 5-8 URLs like this, with keywords in each different language:

[url removed, login to view]

[url removed, login to view]

Each of these URLS, when entered on the internet browser, would query the database and show content for that province, with header, sub header and metatags for those provinces and in the language selected.

MOD_REWRITE would work for each of the group of keywords for each of the provinces and cities; we’d take it from a database.

We'd need to track how many times people clicked on each of the urls, so we'd need to add a new field to the database, which is the number of times that a user clicked on any given item. We'll use this data to contact clients later, so that they know already that they are getting clicks from us.

As I mentioned, I have this database, I have the css/xhtml to base the design of this couple of templates and structure.

Please, let me know if you can do this for me. I would need it the sooner the better so that I can start Seo as soon as possible.

I would need these pages designed in XHTML based on the design that I already have.

Looking forward to hearing from your bids and how you’d manage all this to have it automatically query my database and show results on the template. I'll provide you with a link to my site and css/xhtml files if you match what I'm looking for.

Don't post robot-like messages that you're the best and you'll offer 100% [url removed, login to view], be specific in your messages and tell me how you'd do this for me, how long it would take you to have it up and running, and how much. I'd like to have it ready this week.

Beceriler: PHP

Daha fazlasını gör: work from home search engine, work from home phones, work from home mailing, work at home database, what keywords to use when looking for a seo, what is link list data structure, what can i do to work from home, what can i do at home, user rankings, translate where you need it, translate search engine, translate get by, translate from home, translate base, track description, top query, top group, top 100 templates, t mobile work from home, templates with icons, templates in c language, soon as i get home from work, show how we can create a site, seo mailing list, search engine optimization work from home

İşveren Hakkında:
( 138 değerlendirme ) San Bartolome de Geneto, Spain

Proje NO: #104691

Bu iş için 10 freelancer ortalamada $276 teklif veriyor


Valueonweb is a customer-specific service oriented company has got an Professional and creative team. We are the Professional Web Development Company having 3 years experience in Web design and development. We have exp Daha Fazla

in %bids___i_period_sub_35% gün içinde300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(211 Değerlendirme)

This is my bid.

in %bids___i_period_sub_35% gün içinde220%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(97 Değerlendirme)

Please check your PM!

in %bids___i_period_sub_35% gün içinde300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(54 Değerlendirme)

We at Varshyl Tech - an ITES company provide Internet Marketing services with primary focus on Website Design and Development, Graphic designs, Flash Animations, Logo Designing, 3D Max, Web Copywriting and Web marketi Daha Fazla

in %bids___i_period_sub_35% gün içinde300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

Hello, My name is Justin Turner and I can help you implement your database query for your seo. I am very experienced in php and mysql, and I can do this in one day. I currently attend the University of Texas majoring i Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

I can do it for you fast...

in %bids___i_period_sub_35% gün içinde300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)


in %bids___i_period_sub_35% gün içinde300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

We deliver quality product!!!.see my [url removed, login to view] of past project [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view]

in %bids___i_period_sub_35% gün içinde220%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Hi, we are a software development house based in new delhi, we have about 40+ employees and over 250+ clients,we are very much willing and able to execute this, thanks, sidharth

in %bids___i_period_sub_35% gün içinde270%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Hello, We are ready to handle your work. Please send the specifications in brief, so that we can send you the time and cost estimation of the workflow. Or else, we like to work as a software development center Daha Fazla

in %bids___i_period_sub_35% gün içinde300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)