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:

Expert Pilipino/a: WebSite - SEO - Web Marketing

If you are from the India Sub-Continent, please avoid responding to this ad...

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

We Will Make A "Power Human" Out Of You !!!

We will make a "Power Human" out of you !!! If you are from the Middle East, from North Africa from the Indian Subcontinent or from China, please avoid responding to this ad. Please be so kind not waste your time and ours...

  • Fixed Price Project
  • Max $5
  • 5 years, 5 months 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 and pay up to $1500 per month.

  • Fixed Price Project
  • Max $1500
  • 10 months, 3 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
  • 5 years, 6 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
  • 3 months, 4 weeks 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 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
  • Job Expired

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, 9 months left

Team Member For My Company

I'm looking for developers to get in my team as my company has a local business web-developing in the U.S. We need you to get hired whenever we get a job, you should be responsive, 24/7 online, and easy to connect. We need 25 developers and web designers to be part of that team...

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

Job Details

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