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

COMPASS®

Find resources to prepare for the COMPASS Test, with study guides, practice tests and more. The COMPASS test helps colleges place students in the appropriate course level. The COMPASS is published by ACT, Inc. For more information, see Tests.com's Guide to College Placement Tests: CPAt, ASSET, COMPASS & ACCUPLACER.
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=578 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=578 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=578 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=578 ) x order by ifnull(priority,999), freesort limit 0 , 10
 
Test Item Organization Description Cost
select pagename from contactvendors where prodid=192303
COMPASS
COMPASS
Location: Iowa City IA
Phone: 319-337-1270
Organization: ACT, Inc
Address: P.O. Box 168Iowa City USA IO
Phone: 319-337-1270
 ACT, Inc
319-337-1270 		The Computer-Adaptive Placement Assessment and Support System offers test modules in the subject areas most frequently used by postsecondary institutions to evaluate the skill levels of their incoming students. The test is published by ACT, Inc.
select pagename from contactvendors where prodid=81020
COMPASS test
COMPASS test
Email: webmaster@OnlineTestPreparation.net
Phone: 91 44 23719586
Organization: OnlineTestPreparation.net
Address: G58E, Manthopu COlonyTamilNadu India 600033
Phone: 91 44 23719586
Description: COMPASS test. Complete Guide on COMPASS test. Free online COMPASS test guide
 OnlineTestPreparation.net
91 44 23719586 		COMPASS test
select pagename from contactvendors where prodid=190005
COMPASS Math Prep: Lesson 002
COMPASS Math Prep: Lesson 002
Organization: Your Teacher.com
Address: 815 Walker StreetHouston TX 77002
Phone: 713-893-1303
Fax: 713-513-5397
Description: Positives and Negatives Multiplication and Division (Integer Multiplication)
 Your Teacher.com
 Watch Online Math Video on Integer Multiplication - Multiplication of Integers - COMPASS M
select pagename from contactvendors where prodid=190249
COMPASS Math Prep: Lesson 003
COMPASS Math Prep: Lesson 003
Organization: Your Teacher.com
Address: 815 Walker StreetHouston TX 77002
Phone: 713-893-1303
Fax: 713-513-5397
Description: Positives and Negatives Word Problems (Integer Word Problems)
 Your Teacher.com
 Watch Online Math Video on Integer Word Problems - Word Problems with Integers - COMPASS M
select pagename from contactvendors where prodid=190320
COMPASS Math Prep: Lesson 001
COMPASS Math Prep: Lesson 001
Location: Houston TX
Email: education@yourteacher.com
Phone: 713-893-1303
Organization: Your Teacher.com
Address: 815 Walker StreetHouston TX 77002
Phone: 713-893-1303
Fax: 713-513-5397
Description: Positives and Negatives Addition and Subtraction (Adding Integers)
 Your Teacher.com
713-893-1303 		Watch Online Math Video on Adding Integers - Add Integers - COMPASS Math Prep


select linkname, url, template, examid, viewid, pageid from categorylinks where catid=578 order by posn
Tests.com BBB Business Review
Bookmark Page
select name, value from publiccontent where page='home' or page='All Pages'