Error 8 (Undefined index: show_location) in /nfs/c03/h03/mnt/55919/domains/looppharmacyjobs.com/html/local/h_jobdetails.php on line 52
Array
(
[p] => CDBOProfession Object
(
[table] => professions
[fields] => Array
(
[0] => id
[1] => name
)
[db] => CDB Object
(
[host] => internal-db.s55919.gridserver.com
[user] => db55919_user
[password] => nfj22swf
[db] => db55919_loop
[prefix] => lp_
[link] => Resource id #69
)
[prefix] =>
[pk] => id
[pkv] =>
[data] =>
[set] => Array
(
[0] => Array
(
[id] => 1
[name] => Pharmacist
)
[1] => Array
(
[id] => 2
[name] => Pharmacy Technician
)
[2] => Array
(
[id] => 3
[name] => Pharmacy Assistant
)
[3] => Array
(
[id] => 4
[name] => Assistant Front Store Manager
)
[4] => Array
(
[id] => 5
[name] => Beauty Master
)
[5] => Array
(
[id] => 6
[name] => Case Manager
)
[6] => Array
(
[id] => 7
[name] => Cashier
)
[7] => Array
(
[id] => 8
[name] => Cosmetician
)
[8] => Array
(
[id] => 9
[name] => Customer Services
)
[9] => Array
(
[id] => 10
[name] => Drivers / Delivery
)
[10] => Array
(
[id] => 11
[name] => Front Store Manager
)
[11] => Array
(
[id] => 12
[name] => Front Store Supervisor
)
[12] => Array
(
[id] => 13
[name] => Health Service Representative
)
[13] => Array
(
[id] => 14
[name] => Hospital Pharmacist
)
[14] => Array
(
[id] => 15
[name] => Internship
)
[15] => Array
(
[id] => 16
[name] => Merchandiser
)
[16] => Array
(
[id] => 17
[name] => Miscellaneous
)
[17] => Array
(
[id] => 18
[name] => New Pharmacy - all positions
)
[18] => Array
(
[id] => 19
[name] => Night Supervisor
)
[19] => Array
(
[id] => 20
[name] => Other
)
[20] => Array
(
[id] => 21
[name] => Owner / Franchise
)
[21] => Array
(
[id] => 22
[name] => Partnership
)
[22] => Array
(
[id] => 23
[name] => Patient Educator
)
[23] => Array
(
[id] => 25
[name] => Photo Lab Manager
)
[24] => Array
(
[id] => 24
[name] => Photo Lab Technician
)
[25] => Array
(
[id] => 26
[name] => Post Manager
)
[26] => Array
(
[id] => 27
[name] => Post Office Clerk
)
[27] => Array
(
[id] => 28
[name] => Retail Pharmacist
)
[28] => Array
(
[id] => 29
[name] => Security
)
[29] => Array
(
[id] => 30
[name] => Store Administrator
)
)
[query_load] =>
[query_load_set] =>
[query_store] =>
[filter] =>
[limit_start] => -1
[limit_count] => 0
[sort_field] =>
[sort_dir] =>
[name] =>
)
[d] => CDBODuration Object
(
[table] => durations
[fields] => Array
(
[0] => id
[1] => name
)
[db] => CDB Object
(
[host] => internal-db.s55919.gridserver.com
[user] => db55919_user
[password] => nfj22swf
[db] => db55919_loop
[prefix] => lp_
[link] => Resource id #69
)
[prefix] =>
[pk] => id
[pkv] =>
[data] =>
[set] => Array
(
[0] => Array
(
[id] => 1
[name] => Full time
)
[1] => Array
(
[id] => 2
[name] => Part time
)
[2] => Array
(
[id] => 3
[name] => Relief
)
)
[query_load] =>
[query_load_set] =>
[query_store] =>
[filter] =>
[limit_start] => -1
[limit_count] => 0
[sort_field] =>
[sort_dir] =>
[name] =>
)
[j] => CDBOJob Object
(
[table] => lp_jobs
[table_systems] => systems
[table_provinces] => provinces
[table_durations] => durations
[table_professions] => professions
[table_user_data] => user_data
[table_shifts] => shifts
[fields] => Array
(
[0] => id
[1] => user_id
[2] => timestamp
[3] => profession_id
[4] => title
[5] => description
[6] => show_location
[7] => province_id
[8] => city
[9] => dates
[10] => duration_id
[11] => system_id
[12] => shift_id
[13] => shift_times
[14] => rate
[15] => avg_rx
[16] => blisters
[17] => methadone
[18] => methadone_day
[19] => techs
[20] => travel
[21] => meals
[22] => accomodation
[23] => parking
[24] => reference
[25] => zip
[26] => view_count
[27] => bump
[28] => highlight
[29] => top
[30] => homepage
)
[db] => CDB Object
(
[host] => internal-db.s55919.gridserver.com
[user] => db55919_user
[password] => nfj22swf
[db] => db55919_loop
[prefix] => lp_
[link] => Resource id #69
)
[prefix] =>
[pk] => id
[pkv] =>
[data] =>
[set] =>
[query_load] =>
SELECT
`%TABLE%`.*,
`%TABLE%`.`city`,
`%TABLE_SYSTEMS%`.`name` AS system,
`%TABLE_PROVINCES%`.`name` AS province,
`%TABLE_DURATIONS%`.`name` AS duration,
`%TABLE_SHIFTS%`.`name` AS shift,
`%TABLE_PROFESSIONS%`.`name` AS profession
FROM
`%TABLE%`
LEFT JOIN `%TABLE_USER_DATA%` ON `%TABLE%`.`user_id` = `%TABLE_USER_DATA%`.`user_id`
LEFT JOIN `%TABLE_SYSTEMS%` ON `%TABLE%`.`system_id` = `%TABLE_SYSTEMS%`.`id`
LEFT JOIN `%TABLE_PROVINCES%` ON `%TABLE%`.`province_id` = `%TABLE_PROVINCES%`.`id`
LEFT JOIN `%TABLE_DURATIONS%` ON `%TABLE%`.`duration_id` = `%TABLE_DURATIONS%`.`id`
LEFT JOIN `%TABLE_SHIFTS%` ON `%TABLE%`.`shift_id` = `%TABLE_SHIFTS%`.`id`
LEFT JOIN `%TABLE_PROFESSIONS%` ON `%TABLE%`.`profession_id` = `%TABLE_PROFESSIONS%`.`id`
WHERE(`%TABLE%`.`id` = 3) LIMIT 1
[query_load_set] =>
[query_store] => UPDATE `%TABLE%` SET `view_count` = `view_count` + 1 WHERE(`id` = 0)
[filter] =>
[limit_start] => -1
[limit_count] => 0
[sort_field] =>
[sort_dir] =>
[name] =>
)
[s] => CDBOSystem Object
(
[table] => systems
[fields] => Array
(
[0] => id
[1] => name
)
[db] => CDB Object
(
[host] => internal-db.s55919.gridserver.com
[user] => db55919_user
[password] => nfj22swf
[db] => db55919_loop
[prefix] => lp_
[link] => Resource id #69
)
[prefix] =>
[pk] => id
[pkv] =>
[data] =>
[set] => Array
(
[0] => Array
(
[id] => 3
[name] => Applied Robotics
)
[1] => Array
(
[id] => 4
[name] => Fill Ware
)
[2] => Array
(
[id] => 5
[name] => Healthwatch
)
[3] => Array
(
[id] => 6
[name] => Kroll
)
[4] => Array
(
[id] => 7
[name] => Nexxsys
)
[5] => Array
(
[id] => 8
[name] => Simplicity
)
[6] => Array
(
[id] => 9
[name] => T-Rex
)
[7] => Array
(
[id] => 10
[name] => Tri-comp
)
[8] => Array
(
[id] => 11
[name] => Various
)
[9] => Array
(
[id] => 12
[name] => Zadall
)
[10] => Array
(
[id] => 13
[name] => Flexipharm
)
[11] => Array
(
[id] => 14
[name] => Unknown
)
)
[query_load] =>
[query_load_set] =>
[query_store] =>
[filter] =>
[limit_start] => -1
[limit_count] => 0
[sort_field] =>
[sort_dir] =>
[name] =>
)
[b] => CDBOBanner Object
(
[table] => banners
[fields] => Array
(
[0] => id
[1] => url
)
[db] => CDB Object
(
[host] => internal-db.s55919.gridserver.com
[user] => db55919_user
[password] => nfj22swf
[db] => db55919_loop
[prefix] => lp_
[link] => Resource id #69
)
[prefix] =>
[pk] => id
[pkv] => 3
[data] => Array
(
[id] => 3
[url] => http://www.stopcuts.ca
)
[set] =>
[query_load] => SELECT * FROM `%TABLE%` ORDER BY RAND() LIMIT 1
[query_load_set] =>
[query_store] =>
[filter] =>
[limit_start] => -1
[limit_count] => 0
[sort_field] =>
[sort_dir] =>
[name] =>
)
[field] => show_location
)