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:

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
  • 6 months left

Multiple Item Calendar Booking Web Application

Develop a web-based calender which can integrate into my company's website to allow customers to book items for hire and view availability of items. Once the client books an item for hire, I want to receive an instant email to provide details of the booking...

Skills Required: php website-development
  • Fixed Price Project
  • Max $150
  • 5 years, 1 month left

PHP/Webservices - Software Developer

$1200 PER MONTH SALARY ON CONTRACT JOB MUST BE WEBSERVICES EXPERT, REALLY GOOD AT API WORK TO PAPLY FULL TIME WORK 7 DAYS A WEEK, 8 HOURS PER DAY MUST KNOW; 1. WRITE AND CONSUME WEBSERVICES 2. API 3. PHP DEVELOPMENT 4. SOFTWARE DEVELOPMENT 5. SVN 6. PHP & .NET ARE INVOLVED< YOU MUST KNOW

  • Fixed Price Project
  • Max $1200
  • 1 month 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
  • 2 months, 1 week 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
  • 2 years, 11 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
  • 7 months, 1 week left

Develop A Location-Based Skills Website

This website is designed to link skilled people with clients who need small tasks to be completed in their local area. Vendors create skill profiles, and clients search for them using skills and geographic location as the main criteria...

  • Fixed Price Project
  • Max $7000
  • 5 years, 4 months left

Need Web Designers(Only Bangladesh)-Part 3

We need 1000 of web designers for our company. If you are a good web designer, you are welcome. Mind It only experienced person need. We hire contractor for 2 years contact. Requirement---------------- 1. Should have skype id. 2. Should available during time 9am-9pm. 3. Should have past working e

  • Fixed Price Project
  • Max $20
  • 7 months, 1 week left

Full Time Developer(Experienced Above 6 Months And Under 1.5 Years)

Hello Freelancers. READ ,IF YOU HAVE MORE THAN 1.5 YEARS OF EXPERIENCE. YOUR APPLICATION WILL BE STRAIGHTLY DECLINED....THIS JOB POSTING MEANT FOR THOSE WHO HOLD EXPERIENCE BETWEEN 6 MONTHS to 1.5 YEARS......

Skills Required: opencart php wordpress x-cart
  • Fixed Price Project
  • Max $200
  • 5 years, 5 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
  • 1 week, 1 day left

Job Details

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