I have these prepared statements below. I perform the execute and both return 1, meaning the query was successful, but num_rows is still zero. I don't know why. Any ideas?
$ustmt = $bd->prepare("SELECT * FROM member WHERE username = ?");
$ustmt->bind_param("s", $username);
$astmt = $bd->prepare("SELECT address FROM member WHERE address = ?");
$astmt->bind_param("s", $address);
$sql = $ustmt->execute();
$sql2 = $astmt->execute();
echo($sql2);
echo($sql);
echo($ustmt->num_rows);
echo($astmt->num_rows);
I had forgotten to add store_result(); after I had executed. I have wasted a lot of hours!