Well, let's see here.. $query = mysql_query("select name from users where uid = {$_SESSION['uid']}", $db); while ($name = mysql_fetch_row($query) { echo "<BR /><BR /><BR />$name[0]\n"; }
hope that helps Jennifer Downey wrote: >Hi all, > >Here is what I have and what I am trying to do. > >I would like the user name to be printed in the Username text box but can't >seem to get it there. >I don't want the user to have to type there username in, just click the >submit button and it is entered into the db. >Can anyone show me what I have done wrong? > >$query="SELECT name FROM users WHERE uid={$session["uid"]}"; >$ret = mysql_query($query); >while(list($name)= >mysql_fetch_row($ret)) >print("<BR><BR><BR>$name"); > > >?> ><table ALIGN="center" WIDTH="80%"><tr> ><td><form ACTION="<?php echo($PHP_SELF);?>" METHOD=post> ><? >print "<td><br>Username: <input type=\"text\" value=\"$name\" >name=\"u_name\" size=30></td></tr><tr><td>"; >print "<input TYPE=\"submit\" name=\"action\" VALUE=\"Submit my >entry\"></center><br><br>"; >?> ></form></td></tr> ></table> ><? >if($action = "Submit my entry"){ >if (!empty($name)){ >$enter = "insert into entry (id, user_name) values ('','$u_name')"; >mysql_query($enter) or die(mysql_error()); >} >} > > >TIA >Jennifer > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php