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

Medical College Admissions Test - MCAT®

Find resources to prepare for the MCAT, with MCAT study guides, MCAT practice tests, MCAT flashcards, courses and more. The MCAT is an entrance exam for medical school. The MCAT is published by the The Association of American Medical Colleges (AAMC). For more information, see Tests.com's Guide to the Medical College Admissions Test.
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=502 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=502 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=502 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=502 ) x order by ifnull(priority,999), freesort limit 0 , 10
 
Test Item Organization Description Cost
select pagename from contactvendors where prodid=193613
The Medical College Admissions Test
The Medical College Admissions Test
Location: DC
Phone: (202) 828-0400
Organization: The Association of American Medical Colleges
Address: 2450 N Street USA DC 20037-1126
Phone: (202) 828-0400
Fax: (202) 828-1125
 The Association of American Medical Colleges
(202) 828-0400 		The MCAT is taken by students applying for medical college. The test is published by the Association of American Medical Colleges.
select pagename from contactvendors where prodid=82522
Exambusters New MCATStudy Package
Exambusters New MCATStudy Package
Email: info@exambusters.com
Location Type: Online
Organization: Ace Academics Inc.
Address: 550 Durie AvenueCloster USA NJ 07624
 Ace Academics Inc.
 New MCAT Study Package
select pagename from contactvendors where prodid=190232
New MCAT Study Package
New MCAT Study Package
Location Type: Online
Organization: Ace Academics Inc.
Address: 253 Closter Dock RoadCloster USA 07624
Description: A fast, focused review for the MCAT. Review study cards one by one and eliminate them from your stack once you've learned them. Take a sample quiz, mid-term, or final and keep track of test results as you progress.
 Ace Academics Inc.
 Over 1,000 Questions and Answers. Review the Basics!!! Made in USA.


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