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

HSPT® - High School Placement Test

Find resources to prepare for the HSPT, with study guides, online courses, practice tests and more. Some private high schools use the HSPT in their admission determinations. For more informations on the high school placement test, see the HSPT Guide. The HSPT is published by Scholastic Testing Services, Inc.
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=492 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=492 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=492 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=492 ) x order by ifnull(priority,999), freesort limit 0 , 10
 
Test Item Organization Description Cost
select pagename from contactvendors where prodid=193616
The High School Placement Test
The High School Placement Test
Location: Bensenville IL
Email: sts@ststesting.com
Phone: (630) 766.7150

Organization: Scholastic Testing Services, Inc.
Address: 480 Meyer RoadBensenville USA IL 601061617
Phone: (630) 766.7150
Scholastic Testing Services, Inc.
(630) 766.7150
THe HSPT is taken by 8th graders to determine the skill set they possess when they enter high school. The HSPT is published by Scholastic Testing Services, Inc.
select pagename from contactvendors where prodid=82548
Exambusters COOP / HSPT Study Package
Exambusters COOP / HSPT Study Package
Email: info@exambusters.com
Location Type: Online

Organization: Ace Academics Inc.
Address: 550 Durie AvenueCloster USA NJ 07624
Ace Academics Inc.
COOP / HSPT Study Package
select pagename from contactvendors where prodid=190001
COOP / HSPT Study Package
COOP / HSPT Study Package
Location Type: Online

Organization: Ace Academics Inc.
Address: 253 Closter Dock RoadCloster USA 07624
Description: A fast, focused review for the COOP/HSPT. Review study cards one by one and eliminate them from your stack once you've learned them. Take a sample quiz, mid-term, or final and keep track of test results as you progress.
Ace Academics Inc.
Over 1,000 Questions and Answers. Review the Basics!!! Made in USA.
select pagename from contactvendors where prodid=190788
HSPT One-day Review
HSPT One-day Review
Location: Milpitas CA
Email: steve@sasohsp.com
Phone: 408-821-4790

Organization: SASO High School Prep
Address: Milpitas USA CA
Phone: 408-821-4790
SASO High School Prep
408-821-4790
Be prepared by knowing exactly what to expect.
select pagename from contactvendors where prodid=190786
HSPT Diagnostic Assessment
HSPT Diagnostic Assessment
Location: Milpitas CA
Email: steve@sasohsp.com
Phone: 408-821-4790

Organization: SASO High School Prep
Address: Milpitas USA CA
Phone: 408-821-4790
SASO High School Prep
408-821-4790
Tests how prepared your student is for taking the HSPT.
select pagename from contactvendors where prodid=190787
Fall HSPT Prep Course
Fall HSPT Prep Course
Location: Milpitas CA
Email: steve@sasohsp.com
Phone: 408-821-4790

Organization: SASO High School Prep
Address: Milpitas USA CA
Phone: 408-821-4790
SASO High School Prep
408-821-4790
5-week or 10-week program. Increase your chances of acceptance.


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