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:

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

Web Development Team

Ho we are looking for a great web developement team that has proven skills to manage and take care of a word press blog. The current team is just not cutting it and I need a team that will finish tasks completely and doubl check their work...

Skills Required: html php wordpress
  • Fixed Price Project
  • Max $100
  • 5 months, 1 week left

I Need An Internet Security Expert

I need an Internet security expert Can found my site 'backdoor and vulnerabilities. Also can fix it. Familiar with php mysql, and linux. contact me with skype:smith-stevens8888

Skills Required: php security wordpress
  • Fixed Price Project
  • Max $500
  • 4 months, 1 week left

Want To Create A Portal In Mvc Pattern

I wanted to create job portal or you can say clone of naukri or monster.com with different design . 1> Website should be able to handle records of more than 100,000 users ...

  • Fixed Price Project
  • Max $50
  • 3 weeks, 3 days left

Need Long Term Web Designer

Hello, Need long term Web Developer. Expertise Needed: - PHP (STRONG Skills) - HTML5 - JQUERY (STRONG Skills) - CSS3 - AJAX (STRONG Skills) - Template Design () Work is really LONG TERM and Fulltime. Prospective Hire will be required to log time through Odesk...

  • Fixed Price Project
  • Max $300
  • 3 months left

Video Chat Website

Building a team of the best programmers, developers, and engineers to create an awesome website. The website will be Video Chat based, such as Justin.tv but with a twist (more details provided after NDA and Legal documents being signed)...

  • Fixed Price Project
  • Max $15000
  • 1 month, 1 week 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
  • 2 months left

HTML/.PHP Code For A Contact Page

I need a HTML and PHP code for a contact Page that will be completed on my website. The contact page must include fields for senders name, email, phone, and comments, photos, and video. 1. Receive attachments such as video and photos 2...

Skills Required: html php
  • Fixed Price Project
  • Max $15
  • 5 months, 3 weeks left

Create Randomly Generated Math Problems

I run LIVE Online Math (www.liveonlinemath.com) and I am currently developing a system whereby students can practice various skills. Specific types of problems are randomly generated using PHP, then the problem is worked out (with work shown) and the answer is provided...

Skills Required: css html php teaching-mathematics
  • Fixed Price Project
  • Max $1000
  • 2 days, 13 hours left

Job Details

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