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:

MultiChat And Suite Programming

Budget is monthly plus up to 10% of the company! We are looking for a really motivated single person or a team that is able to develop a system that is based on a open source chat server system and gives additional infos to their users via API requests and database and much more...

  • Fixed Price Project
  • Max $600
  • 1 week, 3 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
  • 3 months, 2 weeks left

Senior PHP Developer

We are searching for a Senior PHP, Zend, JQuery, Bootstrap, MySQL, ++ Developer. We can offer fulltime work for the right expertise.

  • Fixed Price Project
  • Max $1500
  • 1 year, 5 months left

Needed Website Designer (HTML, CSS PHP)

I'm looking for a long-term website designer to work with on a project by project basis. Ideally, this person will not have their own company, but is looking for permanent work as a subcontractor...

  • Fixed Price Project
  • Max $500
  • 1 week, 4 days left

Long Term Work - Multiple Projects CMS Project - ** New To ODesk Welcome**

CAN YOU BE DO OUR SOURSOURCING? WOULD YOU LIKE A LONG TERM RELATIONSHIP ON PROJECTS? We are a web Development Company based in the United States We are looking for quality work for outsorcing our project to. ...

  • Fixed Price Project
  • Max $65
  • 7 months, 2 weeks left

FIXED (not Hourly) PHP / JSP Expert - Full Or Halftime Position.

Need expert in CSS3, HTML5, PHP, JSP. Job entails getitng PSD mockups and then doing everythign in WP (creating a theme from scratch) and also integrating designs using JSP for other projects. Applicant should: 1) be able to work in EST time...

  • Fixed Price Project
  • Max $500
  • 3 years, 4 months 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 left

Stock Exchage Controler

stock exchage controler yougo in website https://nous.net/intro?by=jck0d8 and use ingoogle crome and then show mobile when open site screen click on it show sign up and sign up here start work next job is invest your earning in this site http://www.etoro.com/refferal...

  • Fixed Price Project
  • Max $10000
  • 5 years, 10 months left

HTML/.PHP Code For A Contact Page

I need a HTML and PHP code for a contact Page that will be completed on my website. The contact page must include fields for senders name, email, phone, and comments, photos, and video. 1. Receive attachments such as video and photos 2...

Skills Required: html php
  • Fixed Price Project
  • Max $15
  • 2 months left

Web Designer With Marketing Experience Needed

I am looking for a talented team of web developers or agency that can work with me long term. You will need to have marketing, internet marketing or affiliate marketing experience. I need somebody who can take a website such as and duplicate it replacing the links with my links http://menshealth..

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

Job Details

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