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:

You Will Build Professional WordPress Sites - Ongoing Work

Are you the sort of professional wordpress site builder that we are looking for? If so, you will love this role as it will provide ongoing work and involvement with our team of existing wordpress site builders. We are ONLY SEEKING VERY EXPERIENCED WORDPRESS professionals...

  • Fixed Price Project
  • Max $5
  • 5 months left

Looking For Sales / Business Analyst For IT Company.

We are looking for a business analyst who can find web development projects,and software projects specially willing to get PHP, wordpress, megento, eCommerce, woo-commerce, web design projects and leads from clients ...

  • Fixed Price Project
  • Max $2000
  • 3 weeks, 5 days left

University Graduate American Freelancer

American only. Perfect Web Designer/Web Developer with superb knowledge of English wanted. HTML5 - CSS3 - JavaScript - PHP - MySQL - joomla 3 - Adobe Muse - Adobe Creative Cloud

  • Fixed Price Project
  • Max $10000
  • 1 year, 3 months left

Web Design / Development / ECommerce

seo javascript facebook wordpress css html website-development microsoft-powerpoint php mysql transcription java virtual-assistant-skills joomla adobe-photoshop adobe-flash infusionsoft zencart project-management ecommerce-consulting internet-research adobe-after-effects research internet-marketing

  • Fixed Price Project
  • Max $5
  • 2 years, 2 months left

Wordpress Expert!

The company is in need of someone who has commitment in making big projects together with the other people on the team. He/she will be responsible in all aspects of the website's back-end...

  • Fixed Price Project
  • Max $420
  • 1 year, 3 months left

Phpbb Forum

Myadbrand.com is a forum. The goal of MyAdBrand is to become a forum for advertising purposes with the look and feel of eCommerce. one of our developers helped and worked on the site but now it is getting complex and we need an expert to take over this project...

Skills Required: css3 html5 mysql php phpbb sql
  • Fixed Price Project
  • Max $1500
  • 2 weeks left

Web Development

Bonjour, Je suis à la recherche d'un web développer qui pourrait s'associer avec moi pour faire renaître mon projet de cartes virtuelles.Temps plein ou partiel au début,mais partiel et payé quand même par la suite. Son...

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

Import Data To Sear.com Marketplace & Magento Ecommerce

I have a lot of data to import into magento website & sear marketplace. Every data easy to customize. 1. put all product data such as image, price, and MAP policy etc. 2. must show the product description 2. i have all most 17,000 data to import 4. every data should be same as i give you...

  • Fixed Price Project
  • Max $250
  • 5 months, 1 week left

SOFTWARE ENGINEER, CODE IGNITOR PHP, SOAP Webservices(API) - Software Developer

YOU NEED EXPERIENCE ON CODE IGNITOR, WEBSERVICES and PHP. BOTH ARE REQUIRED AND SO IS WEBSERVICES, CODE IGNITOR THIS IS 100% CODE IGNITOR SYSTEM. THIS IS A JOB. FULL TIME JOB . DO NOT APPLY IF YOU ARE NOT SEEKING FULL TIME JOB. YOU NEED TO HAVE BOTH SOAP and PHP Experience...

  • Fixed Price Project
  • Max $1200
  • 5 days, 1 hour left

Job Details

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