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

Woodcock-Johnson III® Test - WJ-III

Find resources to prepare for the Woodcock-Johnson Test, with prep materials, practice tests and more. The WJ is used with all ages to assess the test-taker's general intellectual ability. It is also known as an IQ Test. For more information about the test, see Tests.com's Woodcock-Johnson 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=987 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=987 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=987 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=987 ) x order by ifnull(priority,999), freesort limit 0 , 10
 
Test Item Organization Description Cost
select pagename from contactvendors where prodid=192205
Woodcock-Johnson® III Normative Update Tests of Cognitive Abilities
Woodcock-Johnson® III Normative Update Tests of Cognitive Abilities
Location: Rolling Meadows IL
Email: info@tornado-insider.com
Phone: 800-323-9540
Organization: Riverside Publishing
Address: Riverside PublishingRolling Meadows USA IL 60008
Phone: 800-323-9540
 Riverside Publishing
800-323-9540 		Provides a comprehensive system for measuring general intellectual ability, specific cognitive abilities, scholastic aptitude, oral language, and academic achievement.
select pagename from contactvendors where prodid=192206
WJ III Tests of Cognitive Abilities with Normative Update - Canada
WJ III Tests of Cognitive Abilities with Normative Update - Canada
Location: Scarborough
Phone: 800-268-2222
Organization: Nelson Education
Address: 1120 Birchmount RoadScarborough Canada M1K 5G4
Phone: 800-268-2222
Fax: 800-430-4445
 Nelson Education
800-268-2222 		Training sessions are offered across Canada at various times each year.
select pagename from contactvendors where prodid=192208
Essentials of WJ III Cognitive Abilities Assessment
Essentials of WJ III Cognitive Abilities Assessment
Location: Maple Ridge
Email: mdangus@psychtest.com
Phone: 604-464-1466
Organization: M.D. Angus & Associates Ltd.
Address: 12420 Gray StreetMaple Ridge Canada V2X 0W3
Phone: 604-464-1466
Fax: 604-357-3113
 M.D. Angus & Associates Ltd.
604-464-1466 		Provides books on administering, scoring and interpreting the WJIII.
select pagename from contactvendors where prodid=192207
Essentials of WJ III Cognitive Abilities Assessment, 2nd Edition
Essentials of WJ III Cognitive Abilities Assessment, 2nd Edition
Location: Hoboken NJ
Email: info@wiley.com
Phone: 201.748.6000
Organization: Wiley knowledge for generations™
Address: 111 River StreetHoboken NJ 07030-5774
Phone: 201-748-6000
Fax: 201-748-6088
 Wiley knowledge for generations™
201.748.6000 		The most widely used comprehensive assessment system—the Woodcock-Johnson—is separated into two distinct test batteries: Cognitive Abilities (COG) and Achievement (ACH).


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