I have a database and I have 3 different values that I want to count, to say that You have x amount of tickets open. I am created an array
$array = array( 'Pending', 'Waiting on parts', 'Waiting for customer response' );
and a query string
$result = mysql_query("SELECT COUNT(*) FROM computerdb WHERE email = '$id' AND FIND_IN_SET($array,'status' );"); list ( $count ) = mysql_fetch_row ( $result ); echo $count
for some reason it will not count it just errors out...
Warning: in_array() [function.in-array]: Wrong datatype for second argument in
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource