Small PHP Job In Joomla

This is a small programming job. There will be ongoing work for the right candidate.

Need to tweek an existing script SPECIALITIES at the bottom of this note
to filter for specific regions

Current Page on front end without filter for regions:
http://comprehensivetherapyapproach.com/index.php/for-the-public/2011-04-27-00-46-55

DB Info (Joomla 1.6 with CE plugin)
mttsd
jos_ce_details- table that you will access for this & maps
catid There are for 4 ID numbers is for each of the areas below

One sample:
San Diego-
http://comprehensivetherapyapproach.com/index.php/for-the-public/san-diego-therapists/specialties-for-san-diego
42
46
47
48

Script~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
SPECIALITIES
<html>
<head></head>
<body>
<div class="round2"><img src="images/MTTgraphics/turqbox-top.gif" _mce_src="images/MTTgraphics/turqbox-top.gif" alt="graphic" width="175"><br></div>
<div style="text-align: center; " _mce_style="text-align: center;" class="findbox2">
<br>Therapists<br> with this Specialty<br></div>
<div class="findbox2">
<?php
$tspecial="";
$first_code="X";

//http://www.comprehensivetherapyapproach.com/administrator/index.php?option=com_modules&view=module&layout=edit&id=48
include("dbcon.php");
$db_select = mysql_select_db("the1sd",$connection);
if (!$db_select) {
die("Database selection failed: ". mysql_error());
}
$db_select = mysql_select_db("mttsd",$connection1);
if (!$db_select) {
die("Database selection failed: ". mysql_error());
}
$uri = $_SERVER["REQUEST_URI"];
$uri = explode("?", $uri);
// print_r($uri);

$ar_uri = explode("/", $uri[0]);

// print_r($ar_uri);
// print_r($ar_codes);

// 3. Perform database query
echo "<pre>"; // print_r($ar_uri);
// print_r($_REQUEST);
$match = mysql_query("SELECT * FROM jos_ce_details", $connection1) ;
if (!$match) {
die("Database query failed: " . mysql_error());
}
while($rows = mysql_fetch_array($match)){

}
// print_r($ar_uri[7]);

$first_code = split("-", $ar_uri[7] );
//echo "First code = ";
//print_r($first_code);

$query = "SELECT * FROM specialty where url2 LIKE '%$first_code[0]%'";

// echo $query;

$result = mysql_query($query, $connection) ;
if (!$result) {
die("Database query failed: " . mysql_error());
}

while($row = mysql_fetch_array($result)){
$ttspec ='';
$tspecials = explode(",", $row["Tspecialties_ID"]);
$ttspec = implode(",", $tspecials);
if($ttspec!="" && $tspecial!=""){
$tspecial .= ",".$ttspec;
}else{ $tspecial=$ttspec;}
$page = $row["url2"];
}

// echo($tspecial);

$detail = mysql_query("SELECT * FROM jos_ce_details where id IN (".$tspecial.")", $connection1);
if (!$detail) {
die("Database query failed: " . mysql_error());
}
while($detail1 = mysql_fetch_array($detail)){
//print_r($detail1);
$Link=$detail1["id"]."-".$detail1["alias"];
// print_r($Link);
if($_SERVER['REQUEST_URI']!="/index.php/for-the-public/2011-04-27-00-46-55")
{
echo "<p><a href='http://www.comprehensivetherapyapproach.com/index.php/for-the-public/emdr-therapist-directory/".$Link."'>".$detail1["name"]."</a></p>";
}

}

mysql_close($connection);
mysql_close($connection1);
?>
</div>
<div class="roundB2">
<img src="images/MTTgraphics/turqbox-bot.gif" _mce_src="images/

Search All Jobs:

Web Designer - Diverse Projects

Hello all and thank you for your interest in this job posting. One of our clients, a multinational hosting company, is looking for a couple of web designers to regularly send them projects to be worked on behalf of the company...

  • Fixed Price Project
  • Max $50
  • 1 week, 5 days left

Partnership With Major Upside!

We are currently seeking a full-time/part-time Web Developer to form a partnership. This position will be responsible for web site design and coding, troubleshooting, working with vendors, seeking out solutions to programming challenges and other duties as assigned...

  • Fixed Price Project
  • Max $3000
  • 11 months, 3 weeks left

Php To Python Migration Of A Project

Prosper202 Development process Main description: Prosper202 is a tool designed to gather and analyze internet marketing campaigns information provided by each user when they visit certain URL's...

  • Fixed Price Project
  • Max $3500
  • 2 months, 2 weeks left

Versatile Web Developer - Management Candidat

You are a truly versatile, motivated INDIAN Web Developer with excellent skills in Joomla, JomSocial, VirtueMart and similar Joomla extentions, preferably residing in CHENNAI or willing to relocate in the future there? Then we ascend not only an interesting, but long-term task with the ability to..

  • Fixed Price Project
  • Max $5
  • 6 years, 8 months left

Full-time Job As Allround Assistant

Hey guys, I'm looking out for experienced people who want to get a long term job. I'm working mostly as affiliate and need someone who has the following skills: PHP HTML etc...

  • Fixed Price Project
  • Max $1500
  • 2 months, 3 weeks left

Building A Search Engine (Budget:$1200)

I only have a budget of $1200. I want a search engine built with its own database and webcrawler. This is how it will be different from Google: I want it to have multiple search boxes, each box representing a an exact phrase...

Skills Required: css html javascript php
  • Fixed Price Project
  • Max $1200
  • 1 year, 8 months left

Landing/Home Page Covers/Adds

I have a Shopify Website and I am looking for a graphic designer to take product from my web site and design slide show images that are less than 1280 x 600 based on different event driven shirts that I do.Please feel free to messege me for futher info. Feel Free to submit samples made from my web s

  • Fixed Price Project
  • Max $15
  • 1 month, 1 week left

Video Chat Website

Building a team of the best programmers, developers, and engineers to create an awesome website. The website will be Video Chat based, such as Justin.tv but with a twist (more details provided after NDA and Legal documents being signed)...

  • Fixed Price Project
  • Max $15000
  • 5 months, 3 weeks left

Maintenance On Existing Customers Websites

I have multiple websites that need occasional updating and the addition of the new content. You must be proficient with PHP/MYSQL/HTML/JQUERY, etc.. I also have a couple of jquery mobile sites and standard html formatted mobile websites.

  • Fixed Price Project
  • Max $15
  • 8 months, 2 weeks left

Magento Website Optimization ,SEO & Customization.

My magento website (www.macdius.com) takes too much time to load and i need to optimize to load faster. 1. Ability to manage Magento On-Site Optimization to load faster in 2/3 sec. 2. Ability to set up the Payment Gateways 3. Ability to set up Products (CSV) to update price and Qty 4...

  • Fixed Price Project
  • Max $300
  • 2 months, 3 weeks left

Job Details

  • Job Type
  • Hourly Project
  • Budget
  • N/A
  • Start Date
  • 12/28/2011 08:38:35 PM
  • Job Status
  • Job Expired