wildcard query
I was using this basic code for MySql and it worked fine but it doesn't seem to do the same job in MySqli. I need a default wildcard selection if no session value is available. It does work if I set a session value. What am I doing wrong?
$artistChosen_item_list = "%";
if (isset($_SESSION['artist_selected'])) {
$artistChosen_item_list = $_SESSION['artist_selected'];
}
?>
<?php
$ListItems = new WA_MySQLi_RS("ListItems",$blankcanvas,0);
$ListItems->setQuery("SELECT products.artist_id, products.active, products.sold, products.media_id, products.item_number, products.item_name, products.item_description, products.item_size, products.item_price, products.main_photo, products.detail_photo_1, products.detail_photo_2, products.detail_photo_3, products.detail_photo_4, media.media_name FROM products INNER JOIN media ON products.media_id = media.media_id WHERE products.artist_id = ? ORDER BY products.item_name ASC");
$ListItems->bindParam("i", "".$artistChosen_item_list ."", "-1"); //WAQB_Param1
$ListItems->execute();
?>