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
  • 3 months 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
  • 6 months, 1 week left

Part Time Developer

Small Startup Company is need of a Part-Time Developer Position New tech Development group. This Opening Budgeted for at least 1 year...

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

PHP Programmers

- Design, create and maintain for our next level online portals/websites. - Design, create and maintain for our existing management system. - Lead the change and maintain the industry lead

Skills Required: ajax html javascript mysql php
  • Fixed Price Project
  • Max $2500
  • 1 month left

PHP-программис

О компании. Разрабо

  • Fixed Price Project
  • Max $2000
  • 5 years, 11 months left

Data To Import Into Sear Marketplace

I have a lot of data to import into 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. I will not give the sear

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

WordPress Expert Need

Hello, we are seeking to start a automobile company in SA.so we need a WP developer to design a WP site for our company. All details will be provided. 50% upfront. You need to manage the web site.(Logo,Domain and host). apply with a sample.

  • Fixed Price Project
  • Max $850
  • 2 months, 3 weeks left

Need Dynamic Professionals For Online Sale

I am having a large set of web products. Premium Website Templates (wp/joomla/drupal/magento etc) and along with this all kind of web software. I need very good , dynamic and result oriented professionals to help me out to sell these items. No Upfront payment ...

  • Fixed Price Project
  • Max $100
  • 10 hours, 15 minutes 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
  • 4 months, 3 weeks left

Job Details

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