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:

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
  • 11 months, 3 weeks left

Kayada Project 1

We are seeking for freelancers for multiple projects with the stated qualifications: *Good knowlagde of PHP, MYSQL (knowladge of Codeigniter is a plus) *Basic knowladge of Javascript, Ajax, Jquery *Experience or personal interest about e-commerce *Being able to follow the trends and technologies and

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

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

Best Of The Best Designer Or Developer Or Project Manager

I'm looking for the best of the best designer, developer, project managers, and English editors. I'm looking to start a web development company with some developers in the US, south america and every where else. I'm looking for the best of the best...

  • Fixed Price Project
  • Max $50000
  • 3 months, 1 week left

Designers PHP, .NET, CODE IGNITOR

THIS IS DESIGN JOB, ITS FOR A DESIGNER WITH CODE IGNITOR EXPERIENCE Full Time Job 2 Designers needed. 1 for PHP 1 for Code Ignitor Its full time work, FULL TIME. 6 Days a week. Report each day 12 months contract. $700 per PERSON per MOnth.

  • Fixed Price Project
  • Max $700
  • 3 months, 1 week left

Web Developer And Designer Needed URGENTLY

Ignore the budget I gave for Job please mention your monthly salary...

  • Fixed Price Project
  • Max $5
  • 1 month, 2 weeks left

CODE IGNITOR SOFTWARE ENGINEER, PHP, Webservices(API) - Software Developer

YOU NEED EXPERIENCE ON CODE IGNITOR, .NET and PHP. BOTH ARE REQUIRED AND SO IS WEBSERVICES, CODE IGNITOR THIS IS 100% CODE IGNITOR SYSTEM. THIS IS A JOB. FULL TIME JOB . DO NOT APPLY IF YOU ARE NOT SEEKING FULL TIME JOB. YOU NEED TO HAVE BOTH .NET and PHP Experience...

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

Want To Create A Portal In Mvc Pattern

I wanted to create job portal or you can say clone of naukri or monster.com with different design . 1> Website should be able to handle records of more than 100,000 users ...

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

Social Network Developers.

Hello, For the past year, I have been working with a team of business minded people and programmers, building a social networking site. We are currently in the very advanced stages of development and have received highly positive feedback from our beta test users...

  • Fixed Price Project
  • Max $1000
  • 1 month, 3 weeks left

Social Media Website-PHP Specialist

Dear Contractors, For this project we are looking only for professional team to could handle the complicated project. we want to start a social media website The website is not exactly like facebook but As quickly and interactively as facebook. and it is for private big group...

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

Job Details

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