I have the following:
$q = "w0";
$stmt = $db_found->prepare("SELECT DISTINCT callsign FROM NetLog WHERE callsign LIKE ?");
$stmt->execute(array("%q%"));
$result = $stmt->fetchAll();
$print_r($result);
It returns:
Array
(
[0] => Array
(
[callsign] => KA0QIG
[0] => KA0QIG
)
)
So what went wrong? Why am I only getting one return when the DB has many values for callsign with 'w0'?