deepatpaul
Programmer
I have a Location component that has a paypal optional payment field populated, and a Disable webshop registration = yes in the Administration. A query on the front end pulls both of these fields, but is returing the paypal field blank. Below is a sample of the query. location.regDisabled is boolean, while location.paypalAddress is varchar.
Any idea on why a field that I KNOW is populated in the backend isn't returning anything in the query?
SELECT product.product_id, schedule.*, DAYOFWEEK(schedule.start) AS day, location.name AS locationName, location.city, location.state, location.regDisabled, location.regFile, location.paypalAddress
FROM mos_makinmusic_schedule AS schedule INNER JOIN
mos_makinmusic_class AS class ON (schedule.classid=class.id) INNER JOIN
mos_makinmusic_location AS location ON (schedule.locationid=location.id)
Output for template results below.
$bRegDisabled = false;
$bPaypalAddress = false;
if($aLocation['regDisabled']) // Currently, this is true
{
$bRegDisabled = true;
if(!empty($aLocation['paypalAddress'])) // this should not be empty
$bPaypalAddress = true;
}
Any idea on why a field that I KNOW is populated in the backend isn't returning anything in the query?
SELECT product.product_id, schedule.*, DAYOFWEEK(schedule.start) AS day, location.name AS locationName, location.city, location.state, location.regDisabled, location.regFile, location.paypalAddress
FROM mos_makinmusic_schedule AS schedule INNER JOIN
mos_makinmusic_class AS class ON (schedule.classid=class.id) INNER JOIN
mos_makinmusic_location AS location ON (schedule.locationid=location.id)
Output for template results below.
$bRegDisabled = false;
$bPaypalAddress = false;
if($aLocation['regDisabled']) // Currently, this is true
{
$bRegDisabled = true;
if(!empty($aLocation['paypalAddress'])) // this should not be empty
$bPaypalAddress = true;
}