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
  • 7 months, 2 weeks 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
  • 4 months, 2 weeks left

Web Design / Development / ECommerce

seo javascript facebook wordpress css html website-development microsoft-powerpoint php mysql transcription java virtual-assistant-skills joomla adobe-photoshop adobe-flash infusionsoft zencart project-management ecommerce-consulting internet-research adobe-after-effects research internet-marketing

  • Fixed Price Project
  • Max $5
  • 1 year, 10 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
  • 1 year, 6 months 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
  • 3 months, 1 week 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
  • 8 months, 2 weeks left

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

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

  • Fixed Price Project
  • Max $2000
  • 5 years, 9 months left
  • Fixed Price Project
  • Max $40000
  • 1 month, 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
  • 1 month 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
  • 1 year, 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