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) = Chemistry-Test

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

Chemistry Tests

Find resources to prepare for chemistry tests, with study guides, flash cards, practice tests, online courses and more. Students will face basic chemistry tests in high school on such subjects as the elements. For more information, see Tests.com's Science 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=469 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=469 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=469 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=469 ) x order by ifnull(priority,999), freesort limit 0 , 10
 
Test Item Organization Description Cost
select pagename from contactvendors where prodid=193476
Live Person Chemistry Test Tutoring
Live Person Chemistry Test Tutoring
Location Type: Online

Organization: Live Person
Address: USA
Live Person
Get expert chemistry test tutoring at just 50 cents a minute.
select pagename from contactvendors where prodid=82606
Exambusters Chemistry Study Cards
Exambusters Chemistry Study Cards
Email: info@exambusters.com
Location Type: Online

Organization: Ace Academics Inc.
Address: 550 Durie AvenueCloster USA NJ 07624
Ace Academics Inc.
Chemistry Study Cards
select pagename from contactvendors where prodid=82654
Exambusters Chemistry CD-Rom Study Cards
Exambusters Chemistry CD-Rom Study Cards
Email: info@exambusters.com
Location Type: Online

Organization: Ace Academics Inc.
Address: 550 Durie AvenueCloster USA NJ 07624
Ace Academics Inc.
Chemistry CD-Rom Study Cards
select pagename from contactvendors where prodid=190103
Chemistry Boxed Cards
Chemistry Boxed Cards
Location: Closter
Email: info@exambusters.com
Location Type: Online

Organization: Ace Academics Inc.
Address: 253 Closter Dock RoadCloster USA 07624
Description: Prepare for quizzes, tests AP, PRAXIS II, GED, CLEP, SAT II, MCAT, ASVAB, and N.Y. Regents exams. Topics: Metric System, Matter, Atoms, Formulas, Moles, Reactions, Elements, Electrons, Chemical Bonds, Heat, Gases, Phase Changes, Solutions, Reaction Rates, Equilibrium, Acids
Ace Academics Inc.
Over 500 Questions & Answers. Review the basics!! Made in USA.
select pagename from contactvendors where prodid=190192
Chemistry CD-Rom
Chemistry CD-Rom
Location: Closter
Email: info@exambusters.com
Location Type: Online

Organization: Ace Academics Inc.
Address: 253 Closter Dock RoadCloster USA 07624
Description: Prepare for quizzes, tests AP, PRAXIS II, GED, CLEP, SAT II, MCAT, ASVAB, and N.Y. Regents exams. Review study cards one by one and eliminate them from your stack once you've learned them
Ace Academics Inc.
Over 500 Questions & Answers. Review the basics!! Made in USA.


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