Jump to content

shivabharat

Members
  • Posts

    371
  • Joined

  • Last visited

    Never

Everything posted by shivabharat

  1. shivabharat

    url trouble

    Have you had a look at this http://www.phpfreaks.com/link2us.php Not sure if you are tyring to do the same
  2. This is waht I got LOAD DATA INFILE \'C:\\Documents and Settings\\shiva\\Desktop\\1.txt\' INTO TABLE marketing FIELDS TERMINATED BY \',\' LINES TERMINATED BY \'n\'; Check the data you have.........
  3. If you are using windows you can get yourself SQLYOG a GUI based toolw hich can help you a lot. See this http://www.phpfreaks.com/sqlyog/ But this tool isnt a freeware. ------------ To import data Go to the structure TAB click on Insert data from a textfile into table choose whihcever is appopriate. If you are using CSV (comma separted values) Fields terminated will be : , Fields enclosed by: \" (if applicable( Lines terminated by: n
  4. The default user is root with password blank mysql -u root Now if you have set a password and lost it have a look at this one http://www.mysql.com/doc/en/Access_denied.html
  5. First you have to say about the OS you are using. Intslling mysql in windows is no big deal. Get yourself the mysql setup www.mysql.com and you can get yourself a copy. Run the setup which will take you to a step by step installation and you can alswyas go with the default value thats selected. Once mysql is installed you can see a service \"mysql\" in the list of services. Bydefault they are configured to automatic which means they will start as soon as you boot your system. You may also have a icon showing the statsu. To do that mysqlbinwinmysqladmin.exe Run this exe and you will see an iconw hich will show you all the details about your mysql. Installing phpbb is explained step by step in the readme which comes along with the PHPBB so you have to spend some reading it.
  6. Did that work also ensure that you have the mysql.so file in the exetsnion path you sepicified.
  7. Try this http://www.mysql.com/doc/en/Backup.html
  8. I am not sure if PHP 4.2 has mysql function inbulit. You can either try to upgrade or try to edit the php.ini file. You may see mysql library file name in the extension just uncomment the line and see if it helps.
  9. Read more about BINARY mysql>SELECT "a" = "A"; -> 1 mysql> SELECT BINARY "a" = "A"; -> 0
  10. Hi, You havent told about the OS you use. If you are using windows downlaod the SQLYOG which is a GUI based tool. www.sqlyog,com To start the mysql go to c:mysqlbinwinmysqladmin.exe You will see the srevice running in the task bar. You can also go to the command prompt and do this Once you are in the mysql prompt you can try the queries. Read the manual for more information. http://www.phpfreaks.com/mysqlmanual.php
  11. The best way to do thsi would be export the required data from your Foxpro and save it in CSV (COmma separted values). You can use the inline function in the Mysql to import the data to mysql.
  12. Try this <?php $search = mysql_query(\"SELECT fname, lname, email FROM users WHERE gender = \'$gender\'\") or die (mysql_error()); $result = mysql_fetch_row($search); ?>
  13. Try this substitue <filed_name> with what everr field you want to sort by. $sql = "SELECT * FROM $table WHERE user_id = \'1\' order by <field_name> DESC LIMIT 3";
  14. shivabharat

    Money

    I am not quiet clear with what you want say if the user enter .2 instead of 20 you can write a script which will identify them and once done .2 * 10 = 20 ?? I think I am making a wild guess. If you can be bit clear we can help you out. :roll:
  15. The log file has give you a clear description of what the problem is . You need to chnage the port as the port 3306 is used by another application. I am not very sure about changing port in MAC os. Locate the \"my.cnf\" file and change the port number to any unused number. If you arent sure of doing this you need to find which of your application is using the default port of mysql.
  16. Not sure if this will help because you statement looks fine to me GRANT SELECT, INSERT, UPDATE, DELETE ON amel_db.* TO king@localhost IDENTIFIED BY "frog65"; Ensure that you are logged in a super user and also check the MYSQL database \"USER\" table and see if you have given them the needed permission.
  17. Try this mysqldump -u username -p password databasename table name> table.sql Import data mysql -uuser -ppass database < table.sql Check manual for more details
  18. There is a chnace your table might have got corrupt. Are you able to query the table in the mysql prompt? Check this out http://www.phpfreak.com/mysqlmanual/page/m...able_types.html
  19. Whats the version of mysql you use? I guess some older version doesnt support nested queries.Check that out!
  20. Hey, I guess its a configuration issue. Check the user name you have set and also supply the password in the config file of phpMyAdmin.
  21. Hi, The default database i s\"mysql\" and you can see the user details in the \"user\" table Read this I guess this shoudl help http://www.mysql.com/doc/en/Adding_users.html You can also use the SQLYOG (www.sqlyog.com) a GUI based tool which can help you to add user pretty easily.
  22. Try this <?php $connection = mysql_connect("$hostname" , "$user" , "$pass"); $db = mysql_select_db($dbase , $connection); $q="UPDATE r99 SET have=\'1\' WHERE name=\'$name\'"; $result= mysql_query($q, $connection) or die ("Could not execute query : $q." . mysql_error()); mysql_free_result(); $q="UPDATE r99 SET paid=\'$paid\' WHERE name=\'$name\'"; $result= mysql_query($q, $connection) or die ("Could not execute query : $q." . mysql_error()); mysql_free_result();
  23. If you have the filed type as time stamp you may need to extract the date alone used SELECT COUNT(*) FROM members WHERE TO_DAYS(substring(<field_name>,1,11)) -TO_DAYS(\'$stamp_lastlogin2\') )>0 AND status=\'A\' AND level IN (2,3,4)"); ensure that \"$stamp_lastlogin2\" is in date format YYYY-MM-DD
  24. Whats the filed type of \"stamp_approved\" is that timestamp/datetime or date? This is the synaxt for TO_DAYS SELECT TO_DAYS(\'2003-10-01\');
  25. The code looks fine but tell me \"$num_players \" whats the value returned here?
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.