[PHP-DB] help with mysql connect error

2007-02-08 Thread Tim McGeary
I am new to this list today, so if I should be sending this to another specific PHP list, please let me know. I am getting the following error via the PHP web page I am building: Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) in /va

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Tim McGeary
Stut wrote: Tim McGeary wrote: I am new to this list today, so if I should be sending this to another specific PHP list, please let me know. I am getting the following error via the PHP web page I am building: Warning: mysql_connect(): Can't connect to local MySQL server through socket

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Tim McGeary
Please include the list in replies. Sorry, I meant to, but hit the wrong button. Tim McGeary wrote: Stut wrote: Tim McGeary wrote: I am new to this list today, so if I should be sending this to another specific PHP list, please let me know. I am getting the following error via the PHP web

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Tim McGeary
Stut wrote: Tim McGeary wrote: Tim McGeary wrote: Stut wrote: Tim McGeary wrote: I am new to this list today, so if I should be sending this to another specific PHP list, please let me know. I am getting the following error via the PHP web page I am building: Warning: mysql_connect

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Tim McGeary
Stut wrote: Tim McGeary wrote: Oh, duh! Ok. I wrote this: mysql_connect($hostname, $username, $password) or die(mysql_error()); mysql_select_db($dbname) or die(mysql_error()); $result = mysql_query("SELECT * FROM Requestor_type") or die(m

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Tim McGeary
Stut wrote: Tim McGeary wrote: But I do have a MySQL 5 client: [EMAIL PROTECTED] html]# rpm -qa MySQL* MySQL-shared-compat-5.0.27-0.rhel3 MySQL-client-standard-5.0.27-0.rhel3 MySQL-python-0.9.1-6 MySQL-server-standard-5.0.27-0.rhel3 MySQL-devel-standard-5.0.27-0.rhel3 or are you saying that

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Tim McGeary
Stut wrote: Tim McGeary wrote: But I do have a MySQL 5 client: [EMAIL PROTECTED] html]# rpm -qa MySQL* MySQL-shared-compat-5.0.27-0.rhel3 MySQL-client-standard-5.0.27-0.rhel3 MySQL-python-0.9.1-6 MySQL-server-standard-5.0.27-0.rhel3 MySQL-devel-standard-5.0.27-0.rhel3 or are you saying that

Re: [PHP-DB] help with mysql connect error

2007-02-09 Thread Tim McGeary
Chris wrote: Tim McGeary wrote: Stut wrote: Ok, so I did the recommended process of: mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') -> WHERE Host = 'some_host' AND User = 'some_user'; mysql> FLUSH PRIVILEGES; This allows the CLI

[PHP-DB] handling a SELECT that returns nothing

2007-04-27 Thread Tim McGeary
I am writing a web php application that is processing a request form. There are multiple times when I need to check if a record exists (i.e. user record) and if so, check the inputted data against the data already in the database and confirm whether the inputted data should update the database.

Re: [PHP-DB] handling a SELECT that returns nothing

2007-04-27 Thread Tim McGeary
right now. So, it will return a positive integer no matter the query found any records at all, so you must use mysql_num_rows() in order to find out how many records the query returned. -Original Message- From: Tim McGeary [mailto:[EMAIL PROTECTED] Sent: Viernes, 27 de Abril de 2007 10:5

[PHP-DB] error logging MySQL syntax errors?

2007-04-27 Thread Tim McGeary
I am getting semi-ambiguous messages in the browser like: 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 '' at line 4 Is there a way in my PHP script to turn on a logging that is more specific about which M

Re: [PHP-DB] Question about database design

2007-10-24 Thread Tim McGeary
If you I missed anything or you have more specific questions, feel free to email me on or off list. Cheers, Tim Tim McGeary '99, '06G Senior Systems Specialist Lehigh University 610-758-4998 [EMAIL PROTECTED] Jason Pruim wrote: I sent this to the MySQL list but didn't rece