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) = Dental-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 = 32
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=32 union all select distinct adid, link, image, imgtitle, imgalt, rank+200, showgoogle from adsdesc where status is null and parentid=32 union all select distinct adid, link, image, imgtitle, imgalt, rank+300, showgoogle from adsdesc where status is null and rootid=32 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=32
select url, name, guideurl, guidelink, dirtitle, dhtmltitle, htmldesciption, metadescription, keywordsdesc, categorydesc, htmldesciption, practicetesturl, toppagelinks, examid, examtext1, examtext2, examimage from categories where id=32 and enabled is not null

Dental Test

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=32 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=32 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=32 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=32 ) x order by ifnull(priority,999), freesort limit 0 , 10
 
Test Item Organization Description Cost
select pagename from contactvendors where prodid=192570
Dental Hygienist Practice Test
Dental Hygienist Practice Test
Location Type: Online

Organization: Tests.com
Address: USA
Tests.com
Take a free practice test to see how prepared you are for the NBDHE. Free
select pagename from contactvendors where prodid=194089
NBDHE Practice Exam
NBDHE Practice Exam
Location Type: Online

Organization: Tests.com
Address: USA
Tests.com
Ace the Dental Hygienist - NBDHE Exam using this 750 question, expert written practice exam with answers fully explained for ideal study. BONUS: Flash Card Study System. 29.95
select pagename from contactvendors where prodid=193922
Practice Exam Kit for the DANB CDA Exam
Practice Exam Kit for the DANB CDA Exam
Location Type: Online

Organization: Tests.com
Address: USA
Tests.com
Ace the Certified Dental Assistant - CDA® Exam using this full-length, expert written practice exam with answers fully explained for ideal study. BONUS: Flash Card Study System. 29.95
select pagename from contactvendors where prodid=35448
Flashcard Study System for the DANB Exam
Flashcard Study System for the DANB Exam
Location: Beaumont
Location Type: Online

Organization: FlashcardSecrets
Address: 3827 Phelan #179Beaumont USA 77707
FlashcardSecrets
Flashcards to help raise your score on your Certified Dental Assistant exam
select pagename from contactvendors where prodid=193630
NBDE Test
NBDE Test
Location: Chicago IL
Phone: 312-440-2500

Organization: American Dental Association
Address: 211 East Chicago Ave.Chicago USA 60611-2678
Phone: 312-440-2500
American Dental Association
312-440-2500
The National Board Dental Examination is administered to all students studying to be a dentist or dental hygienist.
select pagename from contactvendors where prodid=193661
DANB CDA Exam
DANB CDA Exam
Location: Chicago IL
Phone: 312-642-3368

Organization: Dental Assisting National Board, Inc.
Address: 444 N. Michigan Ave., Suite 900Chicago USA IL 60611
Phone: 312-642-3368
Fax: 312-642-1475
Dental Assisting National Board, Inc.
312-642-3368
The DANB CDA Exam is for people who wish to become a Certified Dental Assistant.
select pagename from contactvendors where prodid=36650
Dental Assistant
Dental Assistant
Phone: 847-823-5169

Organization: American Medical Technologists (AMT)
Address: 10700 West HigginsRosemont IL 60018
Phone: 847-823-5169
Fax: 847-823-0458
Description: AMT - American Medical Technologists - Dental Assistant
American Medical Technologists (AMT)
847-823-5169
AMT - American Medical Technologists - Dental Assistant


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