| 00:06.34 | *** join/#bzflag orchid (orchid@orchid.user) |
| 00:09.07 | amathis | kool |
| 00:10.26 | Patlabor221 | ok so I have a table with one field, how do I replace the data in it? |
| 00:10.50 | amathis | what kind of table? |
| 00:10.54 | Patlabor221 | or how do I clear all the data out of a table? |
| 00:11.00 | amathis | like a db? |
| 00:11.08 | Patlabor221 | I have a table in a db called messages |
| 00:11.13 | amathis | ahh |
| 00:11.18 | Patlabor221 | with a field called message |
| 00:11.30 | Patlabor221 | there should only ever be one |
| 00:11.33 | amathis | Patlabor221, you can use UPDATE, or DELETE |
| 00:11.49 | Patlabor221 | Delete where * ? |
| 00:11.51 | amathis | UPDATE is good for replacing data without replacing unique ID's |
| 00:11.53 | Patlabor221 | or something like that? |
| 00:11.58 | Patlabor221 | I don't have unique IDs |
| 00:12.54 | amathis | http://dev.mysql.com/doc/mysql/en/DELETE.html |
| 00:13.02 | amathis | good page. |
| 00:13.02 | *** join/#bzflag newbie_dont (~ynz@cjx175.neoplus.adsl.tpnet.pl) |
| 00:13.32 | amathis | basically doing a DELETE * FROM foo WHERE blah='foo' |
| 00:13.40 | amathis | or, with no WHERE at all |
| 00:16.19 | Patlabor221 | $query = "DELETE * FROM messages"; |
| 00:16.19 | Patlabor221 | $result = mysql_query( $query ) |
| 00:16.19 | Patlabor221 | or die("motd failed ::DELETE : " . mysql_error()); |
| 00:16.19 | Patlabor221 | |
| 00:16.19 | Patlabor221 | $query = "INSERT INTO servers (message) values ( '$message');"; |
| 00:16.20 | Patlabor221 | $result = mysql_query( $query ) |
| 00:16.22 | Patlabor221 | or die("motd failed ::insert : " . mysql_error()); |
| 00:16.28 | Patlabor221 | ohh not servers |
| 00:16.40 | Patlabor221 | messages |
| 00:17.30 | amathis | Patlabor221, why put (message) |
| 00:17.30 | Patlabor221 | that's the field name |
| 00:17.30 | amathis | as long as you follow the form of the db, just use values |
| 00:17.30 | Patlabor221 | oh |
| 00:17.30 | amathis | Patlabor221, I know, but you don't have too.. |
| 00:17.30 | Patlabor221 | ok |
| 00:17.30 | Patlabor221 | I dono |
| 00:17.30 | Patlabor221 | not like I actualy KNOW php :) |
| 00:17.34 | amathis | INSERT INTO server values('foo') |
| 00:17.38 | amathis | BUT.. |
| 00:17.44 | amathis | if you have multiple fields.. |
| 00:17.50 | amathis | and you are missing a value.. |
| 00:17.58 | Patlabor221 | then should I leave it in? |
| 00:18.03 | amathis | it will give errors |
| 00:18.04 | amathis | Patlabor221, no.. |
| 00:18.05 | Patlabor221 | other fields may be added |
| 00:18.12 | Patlabor221 | later |
| 00:18.14 | amathis | Patlabor221, just make sure that you match your values up with the query |
| 00:18.19 | amathis | Patlabor221, for instance.. |
| 00:18.25 | amathis | Patlabor221, if I have two fields.. |
| 00:18.33 | amathis | then make sure to have two values in the correct order |
| 00:18.42 | Patlabor221 | this is the old code I used it from |
| 00:18.43 | Patlabor221 | $query = "INSERT INTO servers (servername,address,port,game,version,os,maxplayers,currentplayers,lastupdate) values ( '$servername','$address','$port','$game','$version','$os','$maxplayers','$currentplayers','$now');"; |
| 00:18.48 | Patlabor221 | so I just copied it |
| 00:19.10 | amathis | Patlabor221, as long as the values are in order of the db structure.. |
| 00:19.13 | amathis | just do this.. |
| 00:19.30 | amathis | $query = "INSERT INTO servers values ( '$servername','$address','$port','$game','$version','$os','$maxplayers','$currentplayers','$now')"; |
| 00:19.52 | Patlabor221 | well I changed this one like you said |
| 00:19.56 | amathis | though, if you do a $_POST something.. |
| 00:20.01 | amathis | or a $_COOKIE |
| 00:20.05 | amathis | make sure to do this... |
| 00:20.09 | Patlabor221 | not gonna |
| 00:20.30 | amathis | values('".$_POST['foo']."', 'foo') |
| 00:20.56 | amathis | makes it easy |
| 00:21.39 | amathis | Patlabor221, PHP es muy facil, no es dificil.... no de ninguna manera, |
| 00:24.35 | Patlabor221 | yay for parse errors :) |
| 00:24.59 | amathis | Patlabor221, what kind :-D |
| 00:25.08 | amathis | do it give a specific errors? |
| 00:25.10 | amathis | *error |
| 00:25.31 | Patlabor221 | dosnt' like else if (&action == "rss")// generate a feed |
| 00:25.46 | amathis | s/&/$ |
| 00:26.05 | Patlabor221 | sonova |
| 00:26.12 | amathis | else if($action == "rss") { |
| 00:26.23 | amathis | sonova? |
| 00:27.03 | Patlabor221 | hah, I forgot a submit button |
| 00:27.42 | Patlabor221 | what is it <input type="submit">DoIt!</input> ? |
| 00:28.58 | Patlabor221 | hmm |
| 00:28.58 | Patlabor221 | motd failed ::DELETE : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM messages' at line 1 |
| 00:29.07 | amathis | this is what I use |
| 00:29.08 | amathis | <form action="login.php?'.SID.'" method="post"> |
| 00:29.13 | amathis | <PROTECTED> |
| 00:29.13 | amathis | <input alt="Username" type="text" size="14" name="username" value=""> |
| 00:29.13 | amathis | Password: |
| 00:29.13 | amathis | <input alt="Password" type="password" size="14" name="password" value=""> |
| 00:29.13 | amathis | <input class="user_button" type="submit" name="submit" value="Login"> |
| 00:29.14 | amathis | </form> |
| 00:29.29 | Patlabor221 | that's basicly what I have |
| 00:29.29 | amathis | Patlabor221, pastebin? |
| 00:29.32 | Patlabor221 | I'll lecan it up later |
| 00:29.54 | Patlabor221 | http://pastebin.dyndns.org/98 |
| 00:30.17 | Patlabor221 | ignore the firestarter stuff |
| 00:30.21 | Patlabor221 | it's just what I ganked from |
| 00:31.22 | amathis | hrm. |