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

English Test

Find resources to prepare for English tests, with study guides, practice tests, flashcards and more. English tests come in many different forms testing different subjects such as grammer, writing composition and reading comprehension. For more information, see Tests.com's English 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=510 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=510 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=510 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=510 ) x order by ifnull(priority,999), freesort limit 0 , 10
 
Test Item Organization Description Cost
select pagename from contactvendors where prodid=193514
Grammar Practice Test
Grammar Practice Test
Location Type: Online

Organization: Tests.com
Address: USA
Tests.com
Take a free Grammar practice Test and see how well you know your grammar. Free
select pagename from contactvendors where prodid=98261
Reading Detective Series
Reading Detective Series
Email: Service@CriticalThinking.com
Phone: 800-458-4849

Organization: The Critical Thinking Co.™
Phone: 800-458-4849
The Critical Thinking Co.™
800-458-4849
Standards-based critical thinking activities develop the analysis, synthesis, and vocabulary skills students need for exceptional reading comprehension. $24.99
select pagename from contactvendors where prodid=193483
Live Person Grammer Test Tutoring
Live Person Grammer Test Tutoring
Location Type: Online

Organization: Liveperson.com
Address: USA
Liveperson.com
Get expert Grammer Test Tutoring for just .50 cents a minute
select pagename from contactvendors where prodid=193484
Live Person Literature Test Tutoring
Live Person Literature Test Tutoring
Location Type: Online

Organization: Liveperson.com
Address: USA
Liveperson.com
Get expert Literature Test Tutoring for just .50 cents a minute
select pagename from contactvendors where prodid=82660
Exambusters English Vocabulary CD-Rom Study Cards
Exambusters English Vocabulary CD-Rom Study Cards
Email: info@exambusters.com
Location Type: Online

Organization: Ace Academics Inc.
Address: 550 Durie AvenueCloster USA NJ 07624
Ace Academics Inc.
English Vocabulary CD-Rom Study Cards
select pagename from contactvendors where prodid=190877
English Grammar
English Grammar

Organization: Permacharts™
Phone: 800-387-3626
Description: This informative Guide provides both students and those interested in building stronger grammatical skills with a comprehensive summary of English Grammar and its multitude of rules and exceptions.
Permacharts™
Permacharts - English Grammar
select pagename from contactvendors where prodid=190886
The Basic Cozy English Grammar Course
The Basic Cozy English Grammar Course
Email: cozygrammar@splashesfromtheriver.com
Phone: 800-201-2280

Organization: Splashes From The River
Phone: 800-201-2280
Description: Still not sure whether or not The Basic Cozy Grammar Course is the right course for you? Please feel free to take this test. If you can correctly answer all, or most, of the questions on this test, you likely don't need this basic course and should look toward a more advanced grammar course.
Splashes From The River
800-201-2280
Basic English Grammar Course - Free Online Test
select pagename from contactvendors where prodid=190878
Test Time! Practice Books That Meet the Standards: Grammar & Usage
Test Time! Practice Books That Meet the Standards: Grammar & Usage

Organization: Walch Education®
Phone: 800-558-2846
Description: Help students make the grade on state and national tests!
Walch Education®
Help students make the grade on state and national tests!
select pagename from contactvendors where prodid=190884
Master Essential English Grammar and Creative Writing Skills
Master Essential English Grammar and Creative Writing Skills
Email: info@core-learning.com
Phone: 800-270-4643

Organization: Core Learning
Phone: 800-270-4643
Core Learning
800-270-4643
Language Arts Companion: English Grammar I - Master Essential Grammar Skills


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