PHP / MySQLi - Cycle Failure

Question

Here is my code:

$v = $conn->query("SELECT * FROM `categories` WHERE `Link`!=''"); while($vrowi = mysql_fetch_array($v, MYSQLI_ASSOC)) { $url = $vrowi['Link']; $Cat = $vrowi['id']; } 

while does not work. Could you tell me where the error is? Thanks in advance!

Answer 1

You mix MySQLi object-oriented code with a functional approach and must choose one or the other. In your exact solution, this is:

 $v = $conn->query("SELECT * FROM `categories` WHERE `Link` != '';"); while ($vrowi = $v->fetch_assoc()) { $url = $vrowi['Link']; $Cat = $vrowi['id']; }