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

TOEFL® - Test of English as a Foreign Language

Find resources to prepare for the TOEFL, with TOEFL study guides, TOEFL practice tests, TOEFL courses, tutoring, informational guide and more. The TOEFL evaluates a student's proficiency with English as a second language. The TOEFL is published by Educational Testing Services. For more information, see Tests.com's Guide to the TOEFL.
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=490 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=490 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=490 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=490 ) x order by ifnull(priority,999), freesort limit 0 , 10
 
Test Item Organization Description Cost
select pagename from contactvendors where prodid=193498
Live Person TOEFL Tutoring
Live Person TOEFL Tutoring
Location Type: Online
Organization: Liveperson.com
Address: USA
Liveperson.com
 Get expert TOEFL Tutoring for just .50 cents a minute
select pagename from contactvendors where prodid=190047
TOEFL Test Study Guide
TOEFL Test Study Guide
Email: support@apexpreparation.com
Organization: APEX Test Prep
Description: APEX Prep offers an independently researched study guide for the TOEFL that is guaranteed to increase your score.
 APEX Test Prep
 TOEFL Test Study Guide Helps TOEFL Test Takers Prepare for the TOEFL Exam
select pagename from contactvendors where prodid=75947
Prep Series for the TOEFL Test: Vocabulary and Reading
Prep Series for the TOEFL Test: Vocabulary and Reading
Location: Ann Arbor MI
Email: techstreet.service@thomson.com
Phone: 800-699-9277
Organization: Thomson Reuters
Address: 3916 Ranchero DriveAnn Arbor USA MI 48108
Phone: 800-699-9277
Fax: 734-780-2046
 Thomson Reuters
800-699-9277 		Prentice Hall Preparation Series for the TOEFL Test: Vocabulary and Reading
select pagename from contactvendors where prodid=190234
Pass Key to TOEFL iBT
Pass Key to TOEFL iBT
Email: info@newagepublishers.com
Phone: 91-11-2327680
Organization: New Age International
Phone: 91-11-2327680
Description: This compact version of Barrons latest full-size TOEFL iBT manual includes a review of academic skills (note taking, paraphrasing, summarizing, and synthesizing) and review chapters covering every section of the test.
 New Age International
91-11-2327680 		New Age International
select pagename from contactvendors where prodid=190230
TOEFL Vocabulary
TOEFL Vocabulary
Email: admin@testinfo.net
Phone: 800-335-0038
Organization: Oakwood Publishing Company
Phone: 800-335-0038
Description: TOEFL Vocabulary
 Oakwood Publishing Company
800-335-0038 		TOEFL Vocabulary
select pagename from contactvendors where prodid=190242
TOEFL Vocabulary AudioLearn
TOEFL Vocabulary AudioLearn
Location: Rockville MD
Phone: 800 881-5717
Organization: Audiolearn™
Address: 160 Talbott St. #104Rockville MD
Phone: 800 881-5717
Fax: 202 449-3830
Description: A Complete Review of Over 500 Common TOEFL Vocabulary Words
 Audiolearn™
800 881-5717 		TOEFL Vocabulary Audio Guide - Downloadable Review for the TOEFL Test
select pagename from contactvendors where prodid=83582
Delta`s Key to the Next Generation TOEFL Test (iBT) (10 CD Free)
Delta`s Key to the Next Generation TOEFL Test (iBT) (10 CD Free)
Email: info@newagepublishers.com
Phone: 91-11-2327680
Organization: New Age International
Address: 4835/24, Ansari RoadNew Delhi India 110 002
Phone: 91-11-23276802
Fax: 91-11-23267437
 New Age International
91-11-2327680 		New Age International
select pagename from contactvendors where prodid=83768
Cracking the TOEFL iBT with CD, 2010 Edition
Cracking the TOEFL iBT with CD, 2010 Edition
Email: webmaster@randomhouse.com
Organization: Random House Inc.
Address: 1745 BroadwayNew York USA NY 10019
 Random House Inc.
 Cracking the TOEFL iBT with CD, 2010 Edition by Princeton Review - Trade Paperback - Rando
select pagename from contactvendors where prodid=83775
Essential TOEFL Vocabulary
Essential TOEFL Vocabulary
Email: webmaster@randomhouse.com
Organization: Random House Inc.
Address: 1745 BroadwayNew York USA NY 10019
 Random House Inc.
 Essential TOEFL Vocabulary by The Princeton Review - Non-traditional book - Random House
select pagename from contactvendors where prodid=86554
400 Must-Have Words for the TOEFL
400 Must-Have Words for the TOEFL
Email: pbg.ecommerce_custserv@mcgraw-hill.com
Phone: 877-833-5524
Organization: McGraw-Hill Professional
Address: 7500 Chavenelle Road.Dubuque IO 52002
Phone: 877-833-5524
Fax: 609-308-4484
Description: McGraw-Hill Book, For students whose first language is not English and who wish to study at a university with an English-based curriculum, no admittance test is more important than the Test of English as a Foreign Language (TOEFL). 400 Must-Have Words for th e TOEFL helps you score well by arming
 McGraw-Hill Professional
877-833-5524 		McGraw-Hill: 400 Must-Have Words for the TOEFL : Book


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