select id, url, name, guideurl, guidelink, dirtitle, dhtmltitle, htmldesciption, metadescription, keywordsdesc, categorydesc, htmldesciption, practicetesturl, toppagelinks, examid, examtext1, examtext2, examimage from categories where url=? and enabled is not null
field (s) = Medical-Tech-Tests

PHP Error
Error number 8: Undefined index: guidetitle
Line 85 of /home/testdeveloper/secure_html/Alp/controllers/HomeController.php


PHP Error
Error number 8: Undefined index: guidemetadescription
Line 86 of /home/testdeveloper/secure_html/Alp/controllers/HomeController.php

select id, pagedataid from categories where id = 51
select p.id, p.template from categories c, pagedata p where c.pagedataid=p.id and c.id=
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

PHP Error
Error number 8: Use of undefined constant categories_pagedataid - assumed 'categories_pagedataid'
Line 94 of /home/testdeveloper/secure_html/Alp/controllers/HomeController.php

select pagesize from settings
select qstnset, free from examset where free is not null

AJAX Debug:

select distinct adid, link, image, imgtitle, imgalt, rank, showgoogle from adsdesc where status is null and categoryid=51 union all select distinct adid, link, image, imgtitle, imgalt, rank+200, showgoogle from adsdesc where status is null and parentid=51 union all select distinct adid, link, image, imgtitle, imgalt, rank+300, showgoogle from adsdesc where status is null and rootid=51 union all select adid, link, image, imgtitle, imgalt, rank+100, showgoogle from ad where status is null and rank is not null order by rank limit 10
select guidelink from categories where id=51
select url, name, guideurl, guidelink, dirtitle, dhtmltitle, htmldesciption, metadescription, keywordsdesc, categorydesc, htmldesciption, practicetesturl, toppagelinks, examid, examtext1, examtext2, examimage from categories where id=51 and enabled is not null

Medical Technician Tests

Find resources to prepare for medical technician tests, with medical tech study guides, medical tech practice tests, courses and more. All medical tech positions have organizations that offer certification in their respective fields. For more information, see Tests.com's Medical Technician's Test Guide.
select count(id) records from ( select p.id, p.priority from product p, organization o, productcategories pc where p.orgid=o.id and p.id=pc.product and pc.category=51 and pending is null and (p.pricecheck is null or (p.pricecheck!=3 and p.pricecheck!=404)) union select p.id, p.priority from product p, organization o, categories c, productcategories pc where p.orgid=o.id and p.id=pc.product and pc.category=c.id and c.parent=51 and pending is null and ((p.pricecheck!=3 and p.pricecheck!=404) or pricecheck is null) ) x
select id, url, name, orgname, type, price, phone, email, title, priority, price1, followlink, descr, city, state, address, orgcity, orgstate, zip, orgphone, fax, orgemail, country, loctype, showprice from ( select p.id, p.url, p.contacturl, p.name, o.name orgname, o.image, p.orgid, p.type, p.price, ifnull(p.phone,o.phone) phone, ifnull(p.email,o.email) email, p.title, p.priority, p.price1, p.followlink, o.showprice, p.descr, ifnull(p.city,o.city) city, ifnull(p.state,o.state) state, o.address, o.city as orgcity, o.state as orgstate, o.zip, o.phone as orgphone, o.fax, o.email as orgemail, o.country, o.loctype, freesort from product p, organization o, productcategories pc where p.orgid=o.id and pending is null and ((p.pricecheck!=3 and p.pricecheck!=404) or pricecheck is null) and p.id=pc.product and pc.category=51 union select p.id, p.url, p.contacturl, p.name, o.name orgname, o.image, p.orgid, p.type, p.price, ifnull(p.phone,o.phone) phone, ifnull(p.email,o.email) email, p.title, p.priority, p.price1, p.followlink, o.showprice, p.descr, ifnull(p.city,o.city) city, ifnull(p.state,o.state) state, o.address, o.city as orgcity, o.state as orgstate, o.zip, o.phone as orgphone, o.fax, o.email as orgemail, o.country, o.loctype, freesort from product p, organization o, categories c, productcategories pc where p.orgid=o.id and pending is null and ((p.pricecheck!=3 and p.pricecheck!=404) or pricecheck is null) and p.id=pc.product and pc.category=c.id and c.parent=51 ) x order by ifnull(priority,999), freesort limit 0 , 10
 
Test Item Organization Description Cost
select pagename from contactvendors where prodid=193879
Medical Assistant Practice Exam
Medical Assistant Practice Exam
Location Type: Online

Organization: Tests.com
Address: USA
Tests.com
Ace the CMA, RMA or NCMA Medical Assistant Exam using this 750 question, expert written practice exam with answers fully explained for ideal study. Complete Practice of Actual Exam Topics: General: Medical Terminology, Anatomy and Physiology, etc. Clinical: Infection Control, Patient Preparation, Specimen Collection, First Aid, etc. Administrative: Filing, Billing, Coding, Accounting, etc. 39.95
select pagename from contactvendors where prodid=193238
Medical Assistant Practice Test
Medical Assistant Practice Test
Location Type: Online

Organization: Tests.com
Address: USA
Tests.com
Take a free practice test to see how prepared you are for a medical assistant certification exam. Free
select pagename from contactvendors where prodid=193880
Medical Assistant Practice Exam Questions
Medical Assistant Practice Exam Questions
Location Type: Online

Organization: Tests.com
Address: USA
Tests.com
26 Free Medical Assistant Practice Questions organized by exam sections that match actual exam topics. Free
select pagename from contactvendors where prodid=193658
Asthma SAE
Asthma SAE
Location: Grand Rapids MI
Email: info@naecb.org
Phone: (877) 408-0072

Organization: National Asthma Educator Certification Board
Address: 2153 Wealthy SEE Grand Rapids USA MI 49506
Phone: (877) 408-0072
National Asthma Educator Certification Board
(877) 408-0072
The Asthma Educator Self Assessment Exam is taken by anyone studying to be an asthma educator.
select pagename from contactvendors where prodid=193642
PANCE
PANCE
Location: Johns Creek GA
Email: nccpa@nccpa.net
Phone: (678) 417-8100

Organization: National Commission on Certification of Physicians Assistants
Address: 12000 Findley RoadJohns Creek USA GA 30097
Phone: (678) 417-8100
Fax: (678) 417-8135
National Commission on Certification of Physicians Assistants
(678) 417-8100
The Physician Assistant National Certifying Exam is taken by anyone pursuing a degree as a physician's assistant.
select pagename from contactvendors where prodid=194798
Sonography Practice Test
Sonography Practice Test
Location Type: Online

Organization: Tests.com
Address: USA
Tests.com
Sonography Practice Test Free


select linkname, url, template, examid, viewid, pageid from categorylinks where catid=51 order by posn
select name, value from publiccontent where page='home' or page='All Pages'