&& in while loop not returning first function

Question

The below code only returning the second echo and if I remove && $fetch_desc = mysql_fetch_array($select_desc) then first echo is working else only second echo is displaying.

Any clue how to handle this? Thanks.

$select_name = mysql_query("query1");
$select_desc = mysql_query("query2");
      while($fetch_name = mysql_fetch_array($select_name) && $fetch_desc = mysql_fetch_array($select_desc)){
      echo $fetch_name['field_value'];
      echo $fetch_desc['field_value'];
      }

You should probably provide more details in the code snippet, such as the query. Provide a table structure perhaps as well... This sounds like something you should be either (A) querying multiple columns, or (B) using a JOIN.. Nonetheless, you shouldn't be using any mysql_* functions as they are deprecated. — Rob W
– Rob W, Commented Jun 24, 2014 at 15:28
Probably a boolean short-circuit biting you in the rump. If the entire while() condition can be determined by only executing ONE of the fetch operations, then the other fetch won't be performed. — Marc B
– Marc B, Commented Jun 24, 2014 at 15:29
What @HalfCrazed said, mysqli provides better security from SQL injections through pre-initialised queries! — James Hunt
– James Hunt, Commented Jun 24, 2014 at 15:30

James Hunt · Accepted Answer · 2014-06-24 15:29:37Z

3

Try:

while(($fetch_name = mysql_fetch_array($select_name)) && ($fetch_desc = mysql_fetch_array($select_desc))){

It might be that it's getting the conditions muddled, parenthesis stop that from happening.

answered Jun 24, 2014 at 15:29

James Hunt

2,53813 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

&& in while loop not returning first function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related