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

Academic Tests

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=1 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=1 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=1 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=1 ) x order by ifnull(priority,999), freesort limit 0 , 10
 
Test Item Organization Description Cost
select pagename from contactvendors where prodid=98258
Math Analogies Book 2
Math Analogies Book 2
Email: Service@CriticalThinking.com
Phone: 800-458-4849

Organization: The Critical Thinking Co.™
Phone: 800-458-4849
The Critical Thinking Co.™
800-458-4849
The Critical Thinking Co.™ - Math Analogies Book 2 $11.99
select pagename from contactvendors where prodid=98271
Mathematical Reasoning Series
Mathematical Reasoning Series
Email: info@CriticalThinking.com
Phone: 1-800-458-4849

Organization: The Critical Thinking Co.™
Phone: 800-458-4849
The Critical Thinking Co.™
1-800-458-4849
These books teach the mathematical concepts and skills students are expected to know per grade level. They also introduce several skills and concepts normally taught in the next grade level. $24.99 & up
select pagename from contactvendors where prodid=98264
Building Thinking Skills® Level 3 Verbal
Building Thinking Skills® Level 3 Verbal
Email: Service@CriticalThinking.com
Phone: 800-458-4849

Organization: The Critical Thinking Co.™
Phone: 800-458-4849
The Critical Thinking Co.™
800-458-4849
The Critical Thinking Co.™ - Building Thinking Skills® Level 3 Verbal $29.99
select pagename from contactvendors where prodid=194303
Practice Questions for the CogAT Test®
Practice Questions for the CogAT Test®
Location: McKinney TX
Phone: (877) 609-6203
Location Type: Online

Organization: TestingMom.com
Address: 6841 Virginia ParkwayMcKinney USA TX 75071
Phone: (877) 609-6203
TestingMom.com
(877) 609-6203
Instantly view, download, and print over 50,000 Practice Questions including the Cognitive Abilities Test®. Get 100 free practice questions to get started. As low as $10.99/mo
select pagename from contactvendors where prodid=194438
Missouri Assessment Program (MAP) Practice Test
Missouri Assessment Program (MAP) Practice Test
Location: McKinney TX
Phone: (877) 609-6203
Location Type: Online

Organization: TestingMom.com
Address: 6841 Virginia ParkwayMcKinney USA TX 75071
Phone: (877) 609-6203
TestingMom.com
(877) 609-6203
Free MAP Practice Test with instant scoring; illustrations and sections by grade level. Free
select pagename from contactvendors where prodid=194471
Oklahoma Core Curriculum Test and State Common Core Standards Test
Oklahoma Core Curriculum Test and State Common Core Standards Test
Location: McKinney TX
Phone: (877) 609-6203
Location Type: Online

Organization: TestingMom.com
Address: 6841 Virginia ParkwayMcKinney USA TX 75071
Phone: (877) 609-6203
TestingMom.com
(877) 609-6203
Free Oklahoma Core Curriculum Test and State Common Core Standards Practice Test with instant scoring; illustrations and sections by grade level. Free
select pagename from contactvendors where prodid=194382
Prep for Connecticut Mastery Test - CMT and CAPT
Prep for Connecticut Mastery Test - CMT and CAPT
Location: McKinney TX
Phone: (877) 609-6203
Location Type: Online

Organization: TestingMom.com
Address: 6841 Virginia ParkwayMcKinney USA TX 75071
Phone: (877) 609-6203
TestingMom.com
(877) 609-6203
Connecticut uses SMARTER Balanced Assessment Consortium, or the SBAC test.
select pagename from contactvendors where prodid=194461
Rhode Island NECAP Practice Test
Rhode Island NECAP Practice Test
Location: McKinney TX
Phone: (877) 609-6203
Location Type: Online

Organization: TestingMom.com
Address: 6841 Virginia ParkwayMcKinney USA TX 75071
Phone: (877) 609-6203
TestingMom.com
(877) 609-6203
Free PSSA Practice Test with instant scoring; illustrations and sections by grade level. Free
select pagename from contactvendors where prodid=194469
Georgia CRCT and State Common Core Standards Practice Test
Georgia CRCT and State Common Core Standards Practice Test
Location: McKinney TX
Phone: (877) 609-6203
Location Type: Online

Organization: TestingMom.com
Address: 6841 Virginia ParkwayMcKinney USA TX 75071
Phone: (877) 609-6203
TestingMom.com
(877) 609-6203
Free Georgia CRCT and State Common Core Standards Practice Test with instant scoring; illustrations and sections by grade level. Free
select pagename from contactvendors where prodid=194623
Cognitive Abilities Practice Test
Cognitive Abilities Practice Test
Location Type: Online

Organization: Tests.com
Address: USA
Tests.com
These free Cognitive Abilities practice questions and answers have instant scoring. Free


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