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:

University Graduate American Freelancer

American only. Perfect Web Designer/Web Developer with superb knowledge of English wanted. HTML5 - CSS3 - JavaScript - PHP - MySQL - joomla 3 - Adobe Muse - Adobe Creative Cloud

  • Fixed Price Project
  • Max $10000
  • 1 year, 4 months left

Senior Software Developer

FULL TIME JOB, START IMMEDIATELY 8 HOURS PER DAY 6 DAYS PER WEEK WORK EST TIME ZONE FUNCTION Under the supervision of the Senior Software Developer, the Junior Software Developer shall: 1. help design and maintain software applications 2...

  • Fixed Price Project
  • Max $1300
  • 8 months, 1 week 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, 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
  • 5 years, 10 months left

Web Dev/master/designer Full Time

Responsibilities include: managing multiple websites on hostgator creating multiple squeeze pages and video landing pages creating campaigns on AWBER updating and creating websites for continuous campaigns. Build mini-nets, SEO optimization for existing websites...

  • Fixed Price Project
  • Max $400
  • 11 months 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
  • 1 year, 3 months left

Iphone And Android APP Developer 1 Year Project

I need a programmer to collaborate with me to produce a smart phone application for a working group of health care professionals and neurological disease patients. The application will be a set of questions concerning symtoms and daily functioning ("Symptom Log")...

  • Fixed Price Project
  • Max $4000
  • 1 month 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
  • 5 months left

Wordpress Web Designers

Hi, Am looking for a web developer who is extremely knowledgeable in responsive designs, content management systems like word press, eCommerce platforms like open-cart, magneto. This job is a long term partnership.I have lots of clients, so I can not finish all the work on time...

  • Fixed Price Project
  • Max $50
  • 5 months, 4 weeks 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, 5 months left

Job Details

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