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

Graduate Management Admissions Test - GMAT®

Find resources to prepare for the GMAT, with GMAT study guides, GMAT practice tests, courses and more. The GMAT is an entrance exam for business school graduate programs and must be taken by a candidate to be considered for admission. The GMAT is published by the Graduate Management Admissions Council (GMAC). For more information, see Tests.com's Guide to the GMAT.
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=501 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=501 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=501 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=501 ) x order by ifnull(priority,999), freesort limit 0 , 10
 
Test Item Organization Description Cost
select pagename from contactvendors where prodid=193537
GMAT Preparation Tools & GMAT Samples
GMAT Preparation Tools & GMAT Samples

Organization: GMAT PREP
Address: USA
GMAT PREP
Ways of the GMAT Winners and the Winners\' Guide to GMAT Math: A complete list of GMAT formulae in one place. With comprehenisve theory, and over 100 questions
select pagename from contactvendors where prodid=193609
Graduate Management Admissions Test (GMAT)
Graduate Management Admissions Test (GMAT)
Location: Reston VA
Phone: (703) 668-9600
Location Type: Online

Organization: Graduate Management Admissions Council
Address: 11921 Freedom DriveReston USA VA 20190
Phone: (703) 668-9600
Fax: (703) 668-9601
Graduate Management Admissions Council
(703) 668-9600
The GMAT is published by the Graduate Management Admissions Council (GMAC). The GMAT measures the aptitude of students applying to graduate school.
select pagename from contactvendors where prodid=193497
Live Person GMAT Tutoring
Live Person GMAT Tutoring
Location Type: Online

Organization: Liveperson.com
Address: USA
Liveperson.com
Get expert GMAT Tutoring for just .50 cents a minute
select pagename from contactvendors where prodid=82531
Exambusters New GMAT Study Package
Exambusters New GMAT Study Package
Email: info@exambusters.com
Location Type: Online

Organization: Ace Academics Inc.
Address: 550 Durie AvenueCloster USA NJ 07624
Ace Academics Inc.
New GMAT Study Package
select pagename from contactvendors where prodid=99596
GMAT Math Work Book - Topic wise Practice Tests
GMAT Math Work Book - Topic wise Practice Tests
Email: info@4gmat.com
Phone: 617-671-1209

Organization: 4GMAT.com
Address: 14B/1, Dr Thirumurthy Nagar 1st StreetChennai India 600 034
Phone: 617-671-1209
Description: 4GMAT.com offers classroom training for GMAT, online practice tests for the math section of GMAT and Math lesson books for GMAT. You can post in the forums, post your blogs, receive free sample GMAT questions by email by signing up at 4gmat.
4GMAT.com
617-671-1209
GMAT Math Practice Tests, Math work Books - 4GMAT Math Preparation
select pagename from contactvendors where prodid=190004
The PowerScore GMAT Critical Reasoning Bible
The PowerScore GMAT Critical Reasoning Bible
Location Type: Online

Organization: PowerScore, Inc.
Address: 57 Hasell StreetCharleston USA SC 29401
Phone: 800-545-1750
Fax: 843-414-6999
PowerScore, Inc.
The PowerScore GMAT Critical Reasoning Bible
select pagename from contactvendors where prodid=190009
GMAT Test Preparation Course
GMAT Test Preparation Course
Location: Charleston SC
Email: contact@powerscore.com
Phone: 800-545-1750
Location Type: Online

Organization: PowerScore, Inc.
Address: 57 Hasell StreetCharleston USA SC 29401
Phone: 800-545-1750
Fax: 843-414-6999
Description: GMAT Test Preparation Course
PowerScore, Inc.
800-545-1750
GMAT Test Preparation Course
select pagename from contactvendors where prodid=190016
Self-Directed GMAT Study
Self-Directed GMAT Study
Location: Charleston SC
Email: contact@powerscore.com
Phone: 800-545-1750
Location Type: Online

Organization: PowerScore, Inc.
Address: 57 Hasell StreetCharleston USA SC 29401
Phone: 800-545-1750
Fax: 843-414-6999
PowerScore, Inc.
800-545-1750
The PowerScore GMAT Sentence Correction Bible
select pagename from contactvendors where prodid=190094
GMAT Test Preparation Tutoring
GMAT Test Preparation Tutoring
Location Type: Online

Organization: PowerScore, Inc.
Address: 57 Hasell StreetCharleston USA SC 29401
Phone: 800-545-1750
Fax: 843-414-6999
PowerScore, Inc.
GMAT Test Preparation Tutoring
select pagename from contactvendors where prodid=190096
The PowerScore GMAT Verbal Bible
The PowerScore GMAT Verbal Bible
Location Type: Online

Organization: PowerScore, Inc.
Address: 57 Hasell StreetCharleston USA SC 29401
Phone: 800-545-1750
Fax: 843-414-6999
PowerScore, Inc.
The PowerScore GMAT Verbal Bible


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