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

This Is A Request For Any Plugin In Makers

I am useing the script http://www.datemill.com/index.php this script is a good script ,there or lots of people useing this script ,but only a few mods...

Skills Required: php forum-posting
  • Fixed Price Project
  • Max $10
  • 12 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, 1 month left

Wordpress Expert!

The company is in need of someone who has commitment in making big projects together with the other people on the team. He/she will be responsible in all aspects of the website's back-end...

  • Fixed Price Project
  • Max $420
  • 6 months, 2 weeks 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
  • 5 years, 2 months 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
  • 3 months, 2 weeks left

Website Developers For Multiple Mobile Friendly Website Projects - ** New To ODesk Welcome**

TALK TO US ABOUT HANDELING THE OUTSOURCING OF OUR WEBSITE DESIGNS? DEVELOP A RELATIONSHIP THAT CAN BE BENEFICIAL FOR ALL OF US? We are a web Development Company based in the United States We are looking for quality a quality company or several contractors for outsourcing our projects to. ...

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

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

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

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

Job Details

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