|abchirk||hey guys..I am trying to REVOKE user PRIVILEGES FROm USER abchirk but it doesnt work? maybe I did a mistake -> http://nopaste.info/3f3cdc7b6d.html|
|DarkRaverNL||Hi, is there a function that allows me to push fields, i have 10 fields in wich i want to keep record of the last 10 session ( scores, kills, playtime) but the first field must always be the newest session, so if a session gets added session 1 goes to session 2 etc etc and session 10 is deleted.|
|deSilva||so you have only one table?|
I have to eat breakfast now
|DarkRaverNL||i got time :)|
here is the table -> http://darkraver.pastebin.ca/361886
|DarkRaverNL||CMANNS if you got a question type it :)|
|cmanns||I will in a sec :D|
Have to think things through.
|cmanns||Alright, so I'm trying to make my first php script (I can modify scripts and add features "OK" but never made a whole script) So I'm using functions from another script im familiar with to minimize errors on my part, I got that all fixed except the create table part, I cant figure out how to make the table's structure.|
|pookey||hey all - can you do anything like this: CREATE TRIGGER moo BEFORE UPDATE OR INSERT ON table I want to execute a trigger for BOTH inserts and updates, creating 2 triggers seems a bit silly.|
|DarkRaverNL||CMANNS, if you use PHPMyAdmin and u just create a table you want, then you can copy the code that it shows above, and use that in your PHP, its how i started learning ;)|
|cmanns||I don't have it :(|
I've tryed to install it on my servers, I always fail at it lol.
Thats just a table i am needing help with today :P
|cmanns||Whats wrrong with it?|
This is what im working with
|DarkRaverNL||Nothing wrong with it|
|cmanns||Your making/editing it?|
|DarkRaverNL||But i need a function to push fields or some sort|
|cmanns||from my paste above, I assume the table name is images_submitted, and ID is one field, i need to add another filed "I think" to make my script better in the future and want to get it done over with.|
|DarkRaverNL||i think you can just use ALTER TABLe to add fields|
If possible you shoud consider installing PHP MyAdmin
|cmanns||yea I can but this script makes everything if it dosent exsist.|
The old code looked like.
|OrgulloKmooore||I'm writing to a table in utf-8, but non-ascii characters appear all funny, any advice?|
|joebloggss||if i want to put a time only as in 8:00 or 21:00 into a database, what way would i set that record in the design of the database/|
|domas||mmm, TIME ? :)|
i need to create a super account with all privilegs and the account must be usable from any host, how to do this?
and, is there a good program to manage mysqld from console?
|SpComb||the daemon itself or the databases?|
not the process
|SpComb||the 'mysql' client or 'mysqladmin' tool|