Re: [PHP-DB] mysql_connect dies silently

Did not see any attachment...? The upgrade might have been the problem. You might need to recompile or reinstall php... Christian Schlaefcke wrote: This looks like it is enabled. I recently upgraded mysql to version 4.1.4. Maybe this causes the problem. Do I have to reinstall PHP it is still th

[PHP-DB] select command denied to user

pls. help. i have grant all to one of my tables made in mysql. now when i want to retrieve the data through PHP, following error is coming = select command denied to user: '[EMAIL PROTECTED]' for table 'timeframe' = pls. advise what went wrong. with best wishes balwant -- PHP D

Re: [PHP-DB] MySQL: Problem optimizing multi-table row deletion ... errors out :(

If the threadID column is an int, you don't need to wrap the $threadID variable in quotes. HTH ~randy On Tue, 14 Sep 2004 00:05:56 +0200, -{ Rene Brehmer }- <[EMAIL PROTECTED]> wrote: > hi gang > > I'm working on optimizing the SQL for my forum system, but have run into a > problem trying to opt

[PHP-DB] MySQL: Problem optimizing multi-table row deletion ... errors out :(

hi gang I'm working on optimizing the SQL for my forum system, but have run into a problem trying to optimize the function for deleting a thread with accompanying stats data and posts from the database using 1 query. The current function, that works, looks like this: // delete all traces of a th

[PHP-DB] Help please, back to an error

Thanks to help here I was able to overcome some ivalid query errors. Now I'm back, (probably the same mistake) It's coming off of this line: $sql .= " And PostStart >= DATE_SUB(CurDate(), Interval ['search_fd1'] day )"; The 'search_fd1' is one of the form fields where a list of val

Re: [PHP-DB] mysql_connect dies silently

This looks like it is enabled. I recently upgraded mysql to version 4.1.4. Maybe this causes the problem. Do I have to reinstall PHP it is still the version I got with the installation of my distro (Fedora Core 2). I attached what phpinfo produced... Am Mo, den 13.09.2004 um 17:20 Uhr +0300 schri

Re: [PHP-DB] mysql_connect dies silently

Look at the phpinfo() page and see whether you find a section with information on MySQL. If it isnt there, it is likely to do with the way you compiled AMP. Christian Schlaefcke wrote: Am Mo, den 13.09.2004 um 9:27 Uhr -0400 schrieb John Holmes: From: "Christian Schlaefcke" <[EMAIL PROTECTE

Re: [PHP-DB] mysq query without subselects

Blackwater, On Sep 10, 2004, at 12:39 PM, blackwater dev wrote: Hello, I need to grab the max value of all of the data in a table grabbing the max total for each client. Example. T1 idtotal clientid 1 100 111 2 200 111 3 100 112

Re: [PHP-DB] Insert Query PROBLEMS

Aaron, I agree with what Mark said. But I just want to say what I noticed off hand... On Sep 10, 2004, at 11:13 AM, Aaron Todd wrote: I'm trying to run an INSERT query on my mysql database and it isnt working. Here is the query: $updatequery = "UPDATE `users` SET ('c

Re: [PHP-DB] mysql_connect dies silently

Am Mo, den 13.09.2004 um 9:27 Uhr -0400 schrieb John Holmes: > From: "Christian Schlaefcke" <[EMAIL PROTECTED]> > > > This is what I have in my php.ini > > > > error_reporting = E_ALL > > display_errors = On > > Have you looked at a phpinfo() page to ensure you're editing the correct > php.i

Re: [PHP-DB] mysql_connect dies silently

From: "Christian Schlaefcke" <[EMAIL PROTECTED]> This is what I have in my php.ini error_reporting = E_ALL display_errors = On Have you looked at a phpinfo() page to ensure you're editing the correct php.ini? In the first block, it tells you what php.ini file PHP is using. If it just lists a

Re: [PHP-DB] mysql_connect dies silently

This is what I have in my php.ini error_reporting = E_ALL display_errors = On display_startup_errors = On log_errors = On log_errors_max_len = 1024 ignore_repeated_errors = Off ignore_repeated_source = Off report_memleaks = On track_errors = On html_errors = On Tried both: error_log = /var/log/

Re: [PHP-DB] mysql_connect dies silently

If you have access to your php.ini file, take a look for the Error Reporting settings. It may be set to none, to to log the errors to syslogd or a file. Mark On Mon, 13 Sep 2004 12:48:33 +0200, Christian Schlaefcke <[EMAIL PROTECTED]> wrote: > Hi Folks, > > I have a problem getting a php script

[PHP-DB] mysql_connect dies silently

Hi Folks, I have a problem getting a php script running. It seems that the script just dies when calling the function mysql_connect("host", "username", "passwd"). I put two debugging echoes (one in front and one afterwards) in the script but only the first one appears. There are no errormessages.

[PHP-DB] Re: One to Many Select Statement

My suggestion is:   select u.username, g.group_name from usertable u inner join grouptable g on u.id=g.user_id;   ENJOY !!   Arné Klopper System Developer NetCB Solution(Pty) Ltd. www.netcb.com     ** Looking for clarification...Say that I have a user table and