<?Php $query = $conn->query("SELECT * FROM candidate

Question

<?Php $query = $conn->query("SELECT * FROM candidate

WHERE position = 'speaker'");
while($fetch = $query->fetch_array())
{
$id = $fetch['candidate_id'];
$query1 = $conn->query("SELECT COUNT(*) as total FROM votes WHERE candidate_id = '$id'");
$fetch1 = $query1->fetch_assoc();

?>

0

20.05.2019

3 ответов

9 просмотров

Пользователь 616fc Автор вопроса

thats the code am using

0

20.05.2019

Reny Ramos

You gotta check them all.. check the id to see if is the right value, check changing the count for a normal request to see if that request return values, etc.

0

20.05.2019

Martin Rys · Accepted Answer

Martin Rys

so var_dump() the results of the queries and look what went wrong

0

20.05.2019

Похожие чаты

<?Php $query = $conn->query("SELECT * FROM candidate

3 ответов

Похожие вопросы