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

PSAT - NMSQT®

Find resources to prepare for the PSAT/NMSQT, with study guides, practice tests and other prep materials. The PSAT/NMSQT is a preparatory test for the SAT and qualifier for the National Merit Scholarship. The PSAT/NMSQT is published by the College Board. For more information, see Tests.com's Guide to the PSAT/NMSQT.
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=572 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=572 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=572 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=572 ) x order by ifnull(priority,999), freesort limit 0 , 10
 
Test Item Organization Description Cost
select pagename from contactvendors where prodid=193597
PSAT/NMSQT
PSAT/NMSQT
Location: New York City NY
Phone: (212) 713-8000
Location Type: Online

Organization: The College Board
Address: 45 Columbus AvenueNew York City USA NY 10023-6917
Phone: (212) 713-8000
The College Board
(212) 713-8000
The PSAT/NMSQT is cosponsored by The College Board and the National Merit Scholar Association to prepare students for the SAT, and determine which students qualify for the National Merit Scholar Award.
select pagename from contactvendors where prodid=193405
Exambusters PSAT/NMSQT Study Package
Exambusters PSAT/NMSQT Study Package
Location Type: Online

Organization: Ace Academics Inc.
Address: 550 Durie AvenueCloster USA NJ 07624
Ace Academics Inc.
PSAT/NMSQT Study Package
select pagename from contactvendors where prodid=190385
PSAT Platinum Test Preparation
PSAT Platinum Test Preparation
Location: Chicago IL
Email: info@prepme.com
Phone: 877-773-7634
Location Type: Online

Organization: PrepMe LLC
Address: 207 E. Ohio StChicago USA IL 60611
Phone: 877-773-7634
Description: Online PSAT lessons, tests, top tutors and more!
PrepMe LLC
877-773-7634
Online PSAT lessons, tests, top tutors and more!
select pagename from contactvendors where prodid=190754
PSAT Gold Test Preparation
PSAT Gold Test Preparation
Location: Chicago IL
Email: info@prepme.com
Phone: 877-773-7634
Location Type: Online

Organization: PrepMe LLC
Address: 207 E. Ohio StChicago USA IL 60611
Phone: 877-773-7634
PrepMe LLC
877-773-7634
Online SAT lessons, tests & guaranteed score increase!
select pagename from contactvendors where prodid=190930
Private SAT Tutoring Nationwide
Private SAT Tutoring Nationwide
Location: New York NY
Email: newyork@parliamenttutors.com
Phone: 877-873-0511

Organization: Parliament Tutors
Phone: 646-750-0202
Description: #1 Rated SAT Prep Program Features Our Exclusive Test Prep Materials and Diagnostic Grading Module
Parliament Tutors
877-873-0511
Private Tutoring and Test Prep from the nation's leading home tutoring service.


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