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:

PHP Coder

We are hiring! We are looking to add talented PHP coders to our team. Additionally programming languages is a PLUS...

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

Develop A Location-Based Skills Website

This website is designed to link skilled people with clients who need small tasks to be completed in their local area. Vendors create skill profiles, and clients search for them using skills and geographic location as the main criteria...

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

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

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

Job Details

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