PHP - show variable in while loop

Question

I have while loop in a PHP file and outside of that, I have one variable. When I try to add this variable into while, it doesn't work.

example code:

<? $var1 = 2999288; while($row = mysql_fetch_array($result)){ echo $var1; } ?>

Can anybody tell me a solution, how to echo that variable into a while? Or what I'm doing wrong?

If the variable is not echoing, then you're DB Query probably isn't returning any results. Before the loop do a: echo mysql_affected_rows($db); — Jasper
– Jasper, Commented Sep 30, 2013 at 17:49
Try echo "hello" instead of echo $var and see if its echoing. — sskoko
– sskoko, Commented Sep 30, 2013 at 17:49
I'm with @Jasper on this one. The only reason for this to not work is that your query either did not work or did not return any results. Adding error handling and checking for edge cases when writing your code would reveal this. — Mike Brant
– Mike Brant, Commented Sep 30, 2013 at 17:51
it seems that $result has a value false so check your sql query — tanay tandon
– tanay tandon, Commented Sep 30, 2013 at 18:04

sunshinekitty · Accepted Answer · 2013-09-30 18:02:57Z

2

Your SQL query is not returning any rows, make sure that your query is working properly before echoing results. Also please look into prepared SQL statements, they are more safe than the traditional way that you are using.

answered Sep 30, 2013 at 18:02

sunshinekitty

2,3856 gold badges20 silver badges32 bronze badges

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

2 Comments

Snowburnt Over a year ago

There's nothing he's posted that says he's not using prepared statements or at least not parameterizing his inputs. A real concern is that mysql_* is deprecated and he should use mysqli or pdo.

sunshinekitty Over a year ago

You are right, I assumed he wasn't using prepared statements since he was using mysql_*.

Collectives™ on Stack Overflow

PHP - show variable in while loop

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related