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:

Fulltime Web Designer (Affiliate Pages, Etc)

Hello, We are seeking a fulltime web designer to work with us building web pages for affiliate marketing purposes. You should be a hard working team player who wants to be a permanent part of our company...

  • Fixed Price Project
  • Max $350
  • 8 months, 1 week 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 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
  • 5 months, 1 week 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
  • 5 months, 1 week left

Full Time Philippines Based Joomla, Php, HTML, CSS Website And , Apple/Android Apps Project Coordinator

Looking for a full time website / app project coordinator with the following experience from Philippines - Understanding of Joomla, Php, CSS and HTML website development - Understanding of Iphone/Andriod app development - Good communication skills in English - Ability to coordinate with offshore...

  • Fixed Price Project
  • Max $400
  • 4 months left

Web Development Team

Ho we are looking for a great web developement team that has proven skills to manage and take care of a word press blog. The current team is just not cutting it and I need a team that will finish tasks completely and doubl check their work...

Skills Required: html php wordpress
  • Fixed Price Project
  • Max $100
  • 3 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, 2 months 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, 11 months left

Multidisciplinary Web Developer - Long Term

We are looking for a talented web developer to join our long term Dev-Team. Ideally, the candidate is proficient in multiple different languages, is consistently available and meets strict deadlines...

  • Fixed Price Project
  • Max $400
  • 1 month left

Job Details

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