sql query
Posted: Thu Jul 27, 2006 9:06 am
Can somebody help me please? I cannot find where i am going wrong! I have checked the manual and still cant see anything.
I am createing a form that will auto fill the fields once complete so that when a member returns to the form the fields they have already filled in are there. I have the rest of the form working its just getting the data from the db and into the correct fields. Here is the query i have so far.
and here is the html
Please point me in the right direction thanks
I am createing a form that will auto fill the fields once complete so that when a member returns to the form the fields they have already filled in are there. I have the rest of the form working its just getting the data from the db and into the correct fields. Here is the query i have so far.
Code: Select all
<?php
$MY_QUERY = "SELECT * FROM byb_players WHERE BYB_ID = '$BYB_ID'";
$SITEDATA = mysql_query($MY_QUERY);
$row = mysql_fetch_array($SITEDATA, MYSQL_ASSOC);
$STARS = $SITEDATA['STARS'];
echo "\nBYB_ID is", $BYB_ID
echo "\nSTARS is", $STARS
echo "\nSITEDATA is", $SITEDATA
echo "\nMY_QUERY is", $MY_QUERY
echo "\nrow is", $row
?>Code: Select all
<input name='PokerStarsPlayerName' type=text value="<?php echo $STARS ?>">Please point me in the right direction thanks