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:

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

Part Time Developer

Small Startup Company is need of a Part-Time Developer Position New tech Development group. This Opening Budgeted for at least 1 year...

  • Fixed Price Project
  • Max $100
  • 5 months, 1 week 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
  • 6 months, 1 week left

Data To Import Into Sear Marketplace

I have a lot of data to import into sear marketplace. Every data easy to customize. 1. put all product data such as image, price, and MAP policy etc. 2. must show the product description 2. i have all most 17,000 data to import 4. every data should be same as i give you. I will not give the sear

  • Fixed Price Project
  • Max $150
  • 7 months, 2 weeks left

Want To Create A Job Portal In Mvc Pattern

Want a clone like naukri or monster...

  • Fixed Price Project
  • Max $50
  • 3 days, 15 hours left

Looking For Campus Interns For App Developement- Paid

we are developing a bunch of apps. we are looking for students only - who can program in php/android/ios and ready to work with us. these are paid positions. they would develop apps for us. they will get the credit for the app as well as paid for the app...

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

Need Web Designers(Only Bangladesh)-Part 2

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, 3 months left

Create A Magento Website

To whom it may concern, I am planning on designing a high specified e-commerce website. I have a number of requirements so I need somebody with many years of advanced Magento experience as well as a person with css, html, php, mysql experience...

  • Fixed Price Project
  • Max $1000
  • 1 month, 2 weeks left

Ayris Beauty Machine Or The Ayris Earth Restoration Machine

THE AYRIS PROJECT, THE CULTURAL AND ECOLOGIC RESTORATION MACHINE. THE AYRIS MACHINE...

  • Fixed Price Project
  • Max $6000
  • 1 week, 1 day left

Job Details

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