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

Multiple Item Calendar Booking Web Application

Develop a web-based calender which can integrate into my company's website to allow customers to book items for hire and view availability of items. Once the client books an item for hire, I want to receive an instant email to provide details of the booking...

Skills Required: php website-development
  • Fixed Price Project
  • Max $150
  • 5 years, 9 months left

Team Member For My Company

I'm looking for developers to get in my team as my company has a local business web-developing in the U.S. We need you to get hired whenever we get a job, you should be responsive, 24/7 online, and easy to connect. We need 25 developers and web designers to be part of that team...

  • Fixed Price Project
  • Max $100
  • 5 years, 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

Drupal Specialist

We need a reliable web developer who specializes in drupal. This is a fulltime position. The website to be worked on is www.hypealot.com

Skills Required: css drupal php
  • Fixed Price Project
  • Max $1000
  • 1 week, 3 days left

It - Web - Graphics Director

National Association in the beauty and wellness industries is seeking a professional full time Chief Information Officer. Candidates must have network skills including setting up a fresh server for web hosting...

  • Fixed Price Project
  • Max $45000
  • 1 month, 1 week 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
  • 6 years left

Job Details

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