[SOLVED] PHP Select Not Working..

[monkeypaw201]

i have this:

 

<?php
$con = mysql_connect("localhost","root","rootpwd");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("pool_web", $con);

$result1 = mysql_query("SELECT * FROM program WHERE day = 'sunday'");
$row_sunday = mysql_fetch_array($result1)
?>

 

some html... and then:

 

<input name="filter_start" type="text" id="filter_start" value="<?php echo $row_sunday['filter_start'] ?>" size="7" maxlength="5">

 

which outputs:

 

00:00

 

and the database field is empty... and if i enter in the database 01:00 it still doesn't change..

 

oh right... the last bit of PHP on that page

 

<?php
mysql_close($con);
?>

[hitman6003]

Does your query return more than one row?  If so, you are only getting the first row returned from the result set.

[monkeypaw201]

nope, only 1 row..

[monkeypaw201]

turns out it doesn't like it when you name the input field the same as the variable row..