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
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. How
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
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 =
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?
?php phpinfo(); ?
In the first block, it tells you what php.ini file PHP is using. If it
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.ini?
?php
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
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
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 PROTECTED]
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
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
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
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 optimize
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
14 matches
Mail list logo
