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 left

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
  • 5 months, 1 week left

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

PHP Developer / Monthly Tasks / Joomla

Meetai is looking for a web developer with experience working up and down the entire technology stack to build features for a web application. About the Developer - Expert for monthly maintenance tasks on websites (css, js, photoshop, mercurial...). This is a long-term offering...

  • Fixed Price Project
  • Max $100
  • 5 days, 18 hours left

Full Time Philippines Based Joomla, Php, HTML, CSS Website And , Apple/Android Apps Project Coordinator

Looking for a full time website / app project coordinator with the following experience from Philippines - Understanding of Joomla, Php, CSS and HTML website development - Understanding of Iphone/Andriod app development - Good communication skills in English - Ability to coordinate with offshore...

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

PHP/Webservices - Software Developer

$1200 PER MONTH SALARY ON CONTRACT JOB MUST BE WEBSERVICES EXPERT, REALLY GOOD AT API WORK TO PAPLY FULL TIME WORK 7 DAYS A WEEK, 8 HOURS PER DAY MUST KNOW; 1. WRITE AND CONSUME WEBSERVICES 2. API 3. PHP DEVELOPMENT 4. SOFTWARE DEVELOPMENT 5. SVN 6. PHP & .NET ARE INVOLVED< YOU MUST KNOW

  • Fixed Price Project
  • Max $1200
  • 8 months left

YOURLS Themes Project

YOURLS stands for Your Own URL Shortener. It is a small set of PHP scripts that will allow you to run your own URL shortening service (a la TinyURL or bitly). ---I DID NOT CREATE THIS SCRIPT---- I would like a batch of themes for this open source script. Both Front End and Back end...

Skills Required: graphic-design php web-design
  • Fixed Price Project
  • Max $5
  • 1 year, 2 months 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
  • 6 months, 2 weeks left

Seo/php/mysql Guru

I am looking for someone with a strong background and understanding to : * PHP * My SQL * Kayko Fusion Experience ( any helpdesk background for that matter ) * Website Optimization ( SEO ) You will be working with our marketing team to help maintain our Websites/blogs/social media! Also help us...

Skills Required: mysql php seo seo-backlinking
  • Fixed Price Project
  • Max $850
  • 2 months, 1 week left

Job Details

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