[PHP-DB] Re: mysql_real_escape_string

Ron Piggott wrote: > > The following PHP command > > $new_maintainers_notes = > mysql_real_escape_string($new_maintainers_notes); > > returned this error while running in a ***cron***. > > Warning: mysql_real_escape_string(): Access denied for user: > '[EMAIL PROTECTED]' (Using password: NO) >

Re: [PHP-DB] mysql_real_escape_string

u use localhost right? try ip instead. 127.0.0.1 - Original Message - From: "Ron Piggott" <[EMAIL PROTECTED]> To: "PHP DB" Sent: Saturday, April 28, 2007 6:44 AM Subject: [PHP-DB] mysql_real_escape_string > > The following PHP command > > $new_maintainers_notes = > mysql_real_escape_stri

Re: [PHP-DB] error logging MySQL syntax errors?

plz remind to send to us your aplication.. the problem may cause from your sintax don't match the version - Original Message - From: "Tim McGeary" <[EMAIL PROTECTED]> To: Sent: Saturday, April 28, 2007 12:15 AM Subject: [PHP-DB] error logging MySQL syntax errors? > I am getting semi-ambi

[PHP-DB] mysql_real_escape_string

The following PHP command $new_maintainers_notes = mysql_real_escape_string($new_maintainers_notes); returned this error while running in a ***cron***. Warning: mysql_real_escape_string(): Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) in /home2/actsmin/actsministries-www/m

RE: [PHP-DB] error logging MySQL syntax errors?

In case echo mysql_error(); gives you exactly what the browser gave you, what you need to be doing is echo'ing your SQL statement and checking if that statement is correct. Try your SQL statement in a query tool like phpmyadmin, but that still may say your syntax is wrong. Regards, Dwight > -

Re: [PHP-DB] error logging MySQL syntax errors?

put: echo mysql_error(); right after the sql query. -- Kevin Murphy Webmaster: Information and Marketing Services Western Nevada Community College www.wncc.edu 775-445-3326 On Apr 27, 2007, at 10:15 AM, Tim McGeary wrote: I am getting semi-ambiguous messages in the browser like: You h

[PHP-DB] error logging MySQL syntax errors?

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] querying results from postgresql

Kirk Wythers wrote: I am having trouble with a db query that was working not too long ago. I did upgrade from php4 to php5 and wonder if there are some differences that could explain my issue. Below is the code where I suspect things are breaking down. // build sql query from form values $se

[PHP-DB] querying results from postgresql

I am having trouble with a db query that was working not too long ago. I did upgrade from php4 to php5 and wonder if there are some differences that could explain my issue. Below is the code where I suspect things are breaking down. // build sql query from form values $select_query = "sele

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

Thanks! Tim Miguel Guirao wrote: The mysql_query function executes a query againts a DBM and just that, it delivers the query to the DBM, if the DBM can execute the query, it returns a positive integer, if the DBM can not execute the query, it returns 0 or false, can't remember exactly right n

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

The mysql_query function executes a query againts a DBM and just that, it delivers the query to the DBM, if the DBM can execute the query, it returns a positive integer, if the DBM can not execute the query, it returns 0 or false, can't remember exactly right now. So, it will return a positiv

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

The mysql_query function executes a query againts a DBM and just that, it delivers the query to the DBM, if the DBM can execute the query, it returns a positive integer, if the DBM can not execute the query, it returns 0 or false, can't remember exactly right now. So, it will return a positive i

[PHP-DB] handling a SELECT that returns nothing

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.