Uphoreum
-
Posts
4 -
Joined
-
Last visited
Never
Uphoreum's Achievements
Newbie (1/5)
0
Reputation
-
Say each user had a row in a table to store information about them and I want the row to automatically be created if it's not there, but I don't want a new one to be created with the same username. So, one column would be for the username and I would create one if no rows had that username. Is there a mysql query or something for this, or do I have to cycle through each row and check if it has that username manually?
-
Ken's Code fixed it. Thanks! He's right, the data in the table was fine, but when I tried to read it back into the form, it got screwed up. I never used MySQL to just look at the table first.
-
Here's the main chunk of the first page. It's several text boxes that link to... [code] echo "<form name='favupdate' action='update.php' method='get'>"; echo "Book: <input type='text' name='book' value=$row[book]>"; echo "<br>"; echo "Game: <input type='text' name='game' value=$row[game]>"; echo "<br>"; echo "Celeb: <input type='text' name='celeb' value=$row[celeb]>"; echo "<br>"; echo "Movie: <input type='text' name='movie' value=$row[movie]>"; echo "<br>"; echo "TV Show: <input type='text' name='tv' value=$row[tv]>"; echo "<br>"; echo "Music: <input type='text' name='music' value=$row[music]>"; echo "<br>"; echo "<input type='submit' value='Update'>";[/code] ...this page: [code] <html> <?php $con = mysql_connect("localhost","anonymous"); mysql_select_db("users",$con); mysql_query("UPDATE favs SET book = '$_GET[book]' WHERE uid = 'testid'"); mysql_query("UPDATE favs SET game = '$_GET[game]' WHERE uid = 'testid'"); mysql_query("UPDATE favs SET celeb = '$_GET[celeb]' WHERE uid = 'testid'"); mysql_query("UPDATE favs SET movie = '$_GET[movie]' WHERE uid = 'testid'"); mysql_query("UPDATE favs SET tv = '$_GET[tv]' WHERE uid = 'testid'"); mysql_query("UPDATE favs SET music = '$_GET[music]' WHERE uid = 'testid'"); echo "Update Successful! <a href='index.php'>Click To Return</a>."; ?> </html>[/code]
-
I used to know the answer to this question, but I forgot and I can't find the information again. When I use UPDATE or INSERT to put data in to a table, if that data has a space, it cuts off the string at the space. How can I stop this from happening?