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:

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
  • 3 years, 7 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
  • 4 years, 5 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
  • 4 years, 5 months 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
  • 4 years, 5 months left

Automated Email / Texts / Phone Call+Voicemail Reminder Software

This project is to build appointment confirmation software - Make a website button like this: http://i.imgur.com/lf3IVyQ.png - When you click it, it leads to a page like this: http://i.imgur.com/QBIqRlw.png - That page would also have this: http://i.imgur.com/8mlFwpQ...

  • Fixed Price Project
  • Max $3000
  • 3 years, 10 months left

Gaming & Web Development Ghost Writer

Hello there, I'm looking for a great writer in English to ghost-write technical blog posts related to gaming and programming (based around web development). I'm currently looking to pay on a project basis, where I can provide a topic and purpose of the post, and have you put it into a slee

  • Fixed Price Project
  • Max $100
  • 3 years, 11 months left

Approve Wordpress Fully Cutomized Theme In Themeforest.net

Hello Friends, I want to approve my wordpress theme in themeforest.net urgent basis. This theme is fully cutomized with all new features like layout, colors, font effects, slides etc. i have more theme for approval so cantact me urgent. Ravi Chauhan

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

Full Time Developer(Experienced Above 6 Months And Under 1.5 Years)

Hello Freelancers. READ ,IF YOU HAVE MORE THAN 1.5 YEARS OF EXPERIENCE. YOUR APPLICATION WILL BE STRAIGHTLY DECLINED....THIS JOB POSTING MEANT FOR THOSE WHO HOLD EXPERIENCE BETWEEN 6 MONTHS to 1.5 YEARS......

Skills Required: opencart php wordpress x-cart
  • Fixed Price Project
  • Max $200
  • 4 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