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:
  
Contact

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
    Tests.com BBB Business Review
    Bookmark Page
    select name, value from publiccontent where page='home' or page='All Pages'