So how much does an app like this cost? 

Regards
Joseph

i have attached the actual php page as i am not sure which part of the code is giving the error. 

error occurs on this p[age - http://www.socanews.com/music/albums/album.php?8-Mile-Riddim-190

thanks
Joseph

This is the code up to line 45:

<?php
require_once "/var/www/vhosts/socanews.com/httpdocs/cmsAdmin/lib/viewer_functions.php";
function getArtist($artistname) {

$artistname1 = mysql_real_escape_string(trim($artistname));
// $artistname=addslashes($artistname1);
list($artist, $blogMetaData) = getRecords(array(
'tableName' => 'artists',
'limit' => '1',
'where' => "title = '$artistname1'",
'allowSearch' => '0',
));
return $artist;
//print_r($artist);
}
list($albumsRecords, $albumsMetaData) = getRecords(array(
'tableName' => 'albums',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$albumsRecord = @$albumsRecords[0]; // get first record
//print_r($albumsRecord);
// show error message if no matching record is found
if (!$albumsRecord) {
header("HTTP/1.0 404 Not Found");
print "Record not found!";
exit;
}

list($musicnewsRecords, $featuredartistMetaData) = getRecords(array(
'tableName' => 'news',
'limit' => '3',
'where' => "catNews LIKE '%news%' AND catNews LIKE '%entertainment%'",
'orderBy' => 'publishDate DESC',
'allowSearch' => '0',
));
function getCountrytitle($id)
{
// $query = 'title = '.$id;
list($countryRecords, $countryMetaData) = getRecords(array(
'tableName' => 'country',
'where' => "title='$id'",
'limit' => '0',
));
return $countryRecords[1];

I  worked out how to create the Tabs. 

Thanks in advance. 

Joseph

How did you create those blue tabs on the left hand side for your sections editors?

Joseph

Excellent got it to work. 

I am looking to creating a CRM system to track all my advertisers etc. 

Joseph

For eg. i am trying to create a CRM so i have created 2 tables one for the Company the other for Employees. 

i have an employee called John Doe who works for Western Digital. 

when i open John Doe's record i would like to see the name of the company he works for plus all of the data held for that company for eg. Company Name, Address, Phone number, website etc etc.

I hope the above makes sense

Joseph

My Code:
SELECT num, title
FROM `<?php echo $TABLE_PREFIX ?>images` LIMIT 1050

when i use the code above it only gives me a list of around 100 images

I shall try and explain this as best as I can.

I have created a section in CMSB called Images where i have uploaded close to 1050 images. I have alsoe created a section called News and within news i have created a drop down menu called Images which allows the user to select from the images section. My problem now is the Drop down image list in News will only display the first 1,000 images and any news article accessing an image that migt be image no.1035 comes up with a number and not the image name in fact it says the image name is missing.

how can i adjust the drop down menu within the news section to display more than 1,000 images?