PHP while() question.

[markeh]

Hi, in Zend Studio I'm using this:

while ($row = mysql_fetch_array($sql)) 
{
// .. long code here
}

 

Where is something wrong with it, well it gives me a warning. When I change it to:

$row = mysql_fetch_array($sql)
while ($row) 
{
// .. long code here
}

 

Would the above work?

 

Thanks,

Mark

[Q695]

It could, but I always use option A, and on a rare logical occasion I will nest a fetch statement.  Do simple trial, and error.

[markeh]

No, it did not work. How can I fix this warning:

 

Description Resource Path Location Type

bool-assign : Assignment in condition login.php game line 40 Code Analyzer Error

 

$teller = 1;
$row = mysql_fetch_array($sql);
while ($row = mysql_fetch_array($sql)) 
  {
 if ($row['badge'] == $user['badge'])
 {
	$badge_selected = $teller;
}
 session_badges[$teller] = $row['badge'];
 $teller++;
}

 

Any ideas?

[Q695]

Do you want to use "SELECT * FROM employees WHERE badge=$badge_selected"?

[markeh]

$sql = mysql_query("SELECT badge FROM badges WHERE owner = '".$username."';");

[trq]

To me, that looks like a bug in Zend studio. Its basically saying that you are creating an assignment within a condition, which you need to do in order to loop through your results ($sql).

[markeh]

To me, that looks like a bug in Zend studio. Its basically saying that you are creating an assignment within a condition, which you need to do in order to loop through your results ($sql).

 

I have no knowledge of what that means...

 

Anything else you can suggest? Is there a way I can ignore these warnings? There really annoying because I have about 160 of them in my code.

[trq]

Why not ask on a zend studio board? The issue is nothing at all to do with php.

[haku]

Have you actually run mysql_query() on your query?