Blu_Smurf

came back, any suggestions?

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.

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.

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">

they have several gui\'s for sql on mysql.com... try one of them

bah thats no good, thanks though.

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?

think you need dcom drivers for 98 don\'t ya?

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

hehe I got it, just forgot my apostrohpe\'s lol.. $sql=mysql_query("SELECT * FROM counter WHERE ip!=\'$ip\'") or die(mysql_error());

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\'

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

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.

Try to open the log file, it will say that it is in use then open it immidiatly after and you can read it...

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

lol yeah I was that way the other day myself... I am making one php system that\'s a msg board, shout out, admin program, login/register and a few other things as awell as news... Let me tell ya, it\'s not easy piecing everything together lol

Hehe we all ahve our days

as am i, never heard of that problem before

are the images in there own folder and if so, is there a .htacess folder in it or anything else that would restrict acess?

Perhaps you dont have a high speed uplink and the images are timing out?

Ok, I was playing on a windows xp box, and installed McAfee anti virus which installed the firewall in exchange... Well, I tried to access my webserver and no go, so i uninstalled the firewalla nd anti virus and I still cant connect to the webserver, and I havmt changed the conf file other then to change ports to see if something was blocking 80, and apache just wont work. So, I re-installed apache and still doesnt work, could there be something left from the firewall denying apache acess to the net?

can you elaborate a tad more? it\'s still early lol

but it\'s the dream weaver forum and kinda related... she wants to know how to do that in dream weaver

not using code view? php files dont come up if they are pure code in dream weaver i dont think, so you have to use code view

Warning: mysql_connect() [function.mysql-connect]: Access denied for user: \'root@localhost\' (Using password: NO) in /home/divxnnz/public_html/phoenixdown/forums/admin/db_mysql.php3 on line 34 no, his problem is, invalid username/password.... hes getting access denied, not code errors