Jump to content

Blu_Smurf

Members
  • Posts

    32
  • Joined

  • Last visited

    Never

Contact Methods

  • AIM
    XxBluSmurf121xX
  • MSN
    Jeremy.Smith@blusmurf.net
  • Website URL
    http://www.blusmurf.net
  • Yahoo
    Blu_Smurf69

Profile Information

  • Gender
    Not Telling
  • Location
    Texas

Blu_Smurf's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. I get this following error anytime I try to use mysql, and this just started an hour ago. was working finr before error 2002: Can\'t connect to local MySQL server through socket \'/var/lib/mysql/mysql.sock (2) any ideas how to fix this? tried reinstalling mysql didnt work and i made sure the service was started. running on gentoo linux btw.
  2. oh, then.... something like htis [php:1:a66e04f4f4]<?php if(!$_POST[\'username\']) { $sql = mysql_query(\"UPDATE TABLE SET password = \'$password\' WHERE uname = \'$uname\'\"); } elseif (!$_POST[\'password\']) { $sql = mysql_query(\"UPDATE TABLE SET uname = \'$uname\' WHERE uname = \'$uname\'\"); } else { $sql = mysql_query(\"UPDATE TABLE SET uname = \'$uname\' WHERE uname = \'$uname\'\"); $sql = mysql_query(\"UPDATE TABLE SET password = \'$password\' WHERE uname = \'$uname\'\"); ?>[/php:1:a66e04f4f4] Think this is what you mean. Checks to see if username is blank, if so, it only updates password. If password is blank, updates username. Else, updates both.
  3. ok, on your text fields, just do this and it will ahve input in them... <input type="password" value="$password" name="password"> <input type="text" value="$username" name="username">
  4. they have several gui\'s for sql on mysql.com... try one of them
  5. bah thats no good, thanks though.
  6. Any one know if there is a way to setup foreign keys and cascading foreign keys? would free up a lot of coding on my msg board so far i cant find any features for this on mysql, any one else know?
  7. think you need dcom drivers for 98 don\'t ya?
  8. Check out Navicat from http://www.mysqlstudio.com Best MySQL program out there to date, easily make, edit and manage databases/tables with this program. It\'s not free, there is a30 day free trial, but there are also cracks going around for this program if you feel like walkin on the wild side. But, I suggest buying it, it\'s worth it
  9. hehe I got it, just forgot my apostrohpe\'s lol.. $sql=mysql_query("SELECT * FROM counter WHERE ip!=\'$ip\'") or die(mysql_error());
  10. Blu_Smurf

    not equal

    Ok, I am making a site counter thats a site logger as well, now, I am trying to ge it it get all tables counter then with mysql_num_rows and spit out the number of all rows that are not equal to a users IP. I have tried it a number of ways, this one is the only way I don\'t get an error: $sql=mysql_query("SELECT ip!=\'$ip\' FROM counter") or die(mysql_error()); Im using $ip = $_SERVER[\'REMOTE_ADDR\']; to grab the ip btw Now, am I right in that syntax to use it? Im thinking it needs to be select * from counter where ip!=\'$ip\' but I get errors when I do that. Any suggestions? Edit: nm got it, I forgot to use the \' marks when using ip!=\'$ip\'
  11. if youre using a router, you need to set up a DMZ(demiliterised zone) on port 80 pointing to your internal IP address... But yeah, it can be a pain at times... I have had to use a redirect service before. www.mydomain.com then points to www.mydomain.com:8080 hehe
  12. Some times ISP\'s block port 80 access from the out side world. Also, routers, NAT\'s ad firewalls will block TCP/UDP access on port 80 unless you manually open it for incoming access.
  13. Try to open the log file, it will say that it is in use then open it immidiatly after and you can read it...
  14. hehe yeah that\'s why I said a few other things, I don\'t feel like pulling out my list of feathures lol... I wanna try to get it out in the GNU community some time soon and maybe get a job from it lol
×
×
  • 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.