php while loop with row variable

Question

Not sure why this will not work? Does the loop not like my variable? If I hard code this workings...

while($row = mysql_fetch_array($resultno))
  {

  echo "<tr>";
  echo "<td><a href=reportip.php?prov=&date1=$date1&starthour=$hour1&endhour=$hour2&prov=$prov&date2=$date2&$hour2&$prov=13&lookup=" . $row['$radio'] . ">" . $row['$radio'] . "</a></td>";
  echo "<td>" . $row['count'] . "</td>";
  echo "</tr>";
  }

We need to see more code - how are you getting $resultno? Also, are you sure the query is returning any rows? If there aren't any rows returned, your loop will have nothing to loop through :) — Steven Mercatante
– Steven Mercatante, Commented May 10, 2011 at 13:06

Emil Vikström · Accepted Answer · 2011-05-10 13:05:47Z

5

'$radio' is a string, not a variable. Remove the apostrophes and make it into $radio:

$row[$radio]

This will make it possible to choose a column from the MySQL resultset by setting $radio to the chosen value.

answered May 10, 2011 at 13:05

Emil Vikström

92.3k17 gold badges144 silver badges178 bronze badges

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

Comments

Tamás · Accepted Answer · 2011-05-10 13:06:05Z

0

Your row is not likely to have a $radio key; maybe you meant $row['radio']. Or $row[$radio].

answered May 10, 2011 at 13:06

Tamás

48.2k12 gold badges107 silver badges125 bronze badges

Comments

carlgarner · Accepted Answer · 2011-05-10 13:07:24Z

0

Your array referencing is wrong:

$row['$radio']

should be written as follows, when referencing an array element using another variable

$row[$radio]

or as follows when accessing an element name

$row['radio']

answered May 10, 2011 at 13:07

carlgarner

895 bronze badges

Comments

DanielB · Accepted Answer · 2011-05-10 13:08:41Z

0

$row['$radio'] seems to be a problem. Is $radio a variable with a value you would like to use as index for the $row then write $row[$radio] otherwise if the table column is named "radio" only write $row['radio'].

answered May 10, 2011 at 13:08

DanielB

20.3k2 gold badges48 silver badges52 bronze badges

Collectives™ on Stack Overflow

php while loop with row variable

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related