Hi all:
I am having trouble with a query. What appears to be happening is that the query doesn't want any open values. So if a search is done solely for (SHL_Players.player = ?) and all other values are empty, no results are given. So, if I am correct, how can I "wildcard" all the other variables?
Thanks in advance!
if ($stmt = mysqli_prepare($link, "
SELECT
SQL_CALC_FOUND_ROWS
SHL_Players.player,
sport,
canceled,
eventDate,
startTime,
endTime,
SHL_Locations.location,
address,
city,
state,
phone,
zip,
advanceTix,
payPalEmail,
SHL_Promoters.promoter,
advanceTixWebLink,
mailOrder,
mailOrderWebLink,
promoterPhone,
promoterEmail,
listingType,
promoterWebSite,
tipAdditional,
tip,
notes,
SHL_Promoters.discountAmount,
blockDiscount,
SHL_Locations.loID,
SHL_Promoters.prID,
SHL_Locations.location2,
itemsDue,
startDate,
listingType,
admissionID,
evID,
twitter,
facebook
FROM
SHL_Events
INNER JOIN SHL_Players ON SHL_Players.plID = SHL_Events.plID
INNER JOIN SHL_Promoters ON SHL_Promoters.prID = SHL_Events.prID
INNER JOIN SHL_Sports ON SHL_Sports.sportCode = SHL_Players.sportCode
INNER JOIN SHL_Locations ON SHL_Locations.loID = SHL_Events.loID
WHERE
SHL_Players.player = ? AND
(state = ? OR state = 'Private Signing') AND
eventDate = ? AND eventDate >= CURDATE() AND eventDate <= ? AND
SHL_Promoters.promoter = ? AND
sport = ? AND
prID = ? AND
evID = ? AND
listingDate >= ? AND
notes LIKE CONCAT('%',?,'%') AND
((listingType = 'B' AND CURDATE() >= startDate) OR listingType IN ('F', 'S') OR eventDate = CURDATE()) AND
hold = 'N'
ORDER BY
eventDate,
state,
CASE
WHEN LEFT(SHL_Players.player, 1) = ''''
THEN
SUBSTRING(SHL_Players.player, 2)
ELSE
SHL_Players.player
END,
SHL_Locations.location
LIMIT
" . (($pagination->get_page() - 1) * $records_per_page).", ".$records_per_page."
")) {
mysqli_stmt_bind_param($stmt, "ssssssssss",
$aPlayer,
$aStates
$aEventDate,
$aUpcoming,
$aPromoter
$aSport,
$aPrID,
$aEvID
$aListingDate,
$aNotes
);
mysqli_stmt_execute($stmt);
mysqli_stmt_bind_result($stmt,
$rPlayer,
$rSport,
$rCanceled,
$rEventDate,
$rStartTime,
$rEndTime,
$rLocation,
$rAddress,
$rCity,
$rState,
$rPhone,
$rZip,
$rAdvanceTix,
$rPayPalEmail,
$rPromoter,
$rAdvanceTixWebLink,
$rMailOrder,
$rMailOrderWebLink,
$rPromoterPhone,
$rPromoterEmail,
$rListingType,
$rPromoterWebSite,
$rTipAdditional,
$rTip,
$rNotes,
$rDiscountAmount,
$rBlockDiscount,
$rLoID,
$rPrID,
$rLocation2,
$rItemsDue,
$rStartDate,
$rListingType,
$rAdmissionID,
$rEvID,
$rTwitter,
$rFacebook
);
