php-windows Digest 10 Jun 2004 03:48:18 -0000 Issue 2278
Topics (messages 23941 through 23947):
Query problem
23941 by: Jesper Palmqvist [Talarforum i Skandinavien AB]
Can't load DLL
23942 by: Scott Reynolds
23943 by: Gerardo Rojas
23944 by: Gerardo Rojas
Where is mysqli in PHP5rc3?
23945 by: memoimyself.yahoo.com.br
Re: Arrrrrrrrrrrg. Session management expert needed.
23946 by: memoimyself.yahoo.com.br
Webyog releases SQLyog 3.71 & SJA 2.0
23947 by: Karam Chand
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
Hi
This is more oriented into the field of SQL, any suggestions?
I am searching for a query that yields what my code below does "in the
sql"
In a "three table join" I am looking for the rows that have the highest
value of "COUNT(we_employee.IDe)", in case two (or more) rows have the
same value - it doesn't matter what row is returned.
/*
email_cp = "email contactperson"
name_first_wee = "first name sales reference"
name_last_wee = "last name sales reference"
IDe = index of table "we_employee" (sales references)
IDc = index of table "company" parent table of "comp_person"
IDp = index of table "comp_person" (contact persons)
$sql = "SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(email_cp, '@', -1), '.',
-2) AS domain, COUNT(we_employee.IDe) AS listed, name_first_wee,
name_last_wee, email_w_wee, IDp, comp_person.IDc FROM ((company INNER
JOIN comp_person ON company.IDc = comp_person.IDc) INNER JOIN
we_employee ON company.IDe = we_employee.IDe) WHERE active = 'Yes' GROUP
BY domain, we_employee.IDe ORDER BY domain, listed DESC";
$res = mysql_query($sql);
while($m = mysql_fetch_array($res)) {
if ($domain != $m["domain"]) {
$upd[$m["domain"]] = $m["email_w_wee"];
}
$domain = $m["domain"];
}
--- End Message ---
--- Begin Message ---
I'm running PHP 4.3.6 on Windows XP Pro IIS 5.1.
I had this working before then I rebuilt my box and now it doesn't work.
Here's the error: unknown(): Unable to load dynamic library
'./extensions\php_curl.dll - the specified module could not be found.
I have the dll enable in the php.ini file. any thoughts?
Thanks
--- End Message ---
--- Begin Message ---
Either the reference to the directory is wrong, or use the same "/" througout the path.
--
Gerardo S. Rojas
mailto: [EMAIL PROTECTED]
-----Original Message-----
From: Scott Reynolds [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 09, 2004 10:10 AM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] Can't load DLL
I'm running PHP 4.3.6 on Windows XP Pro IIS 5.1.
I had this working before then I rebuilt my box and now it doesn't work.
Here's the error: unknown(): Unable to load dynamic library
'./extensions\php_curl.dll - the specified module could not be found.
I have the dll enable in the php.ini file. any thoughts?
Thanks
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
actually i have the same problem, I put the dll's i needed into the C:\winnt\system32
dir. This works, but is not the correct thing to do! If you find out, let me know?
--
Gerardo S. Rojas
mailto: [EMAIL PROTECTED]
-----Original Message-----
From: Reynolds Scott - sreyno [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 09, 2004 11:00 AM
To: Gerardo Rojas
Subject: RE: [PHP-WIN] Can't load DLL
Yes. It doesn't matter which dll I enable I get the same error (can't load that dll..)
_____
From: Gerardo Rojas [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 09, 2004 10:58 AM
To: Reynolds Scott - sreyno
Subject: RE: [PHP-WIN] Can't load DLL
ok, do you actually have the dll in the extensions dir?
--
Gerardo S. Rojas
mailto: [EMAIL PROTECTED]
-----Original Message-----
From: Reynolds Scott - sreyno [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 09, 2004 10:57 AM
To: Gerardo Rojas
Subject: Re: [PHP-WIN] Can't load DLL
here's the path stated in the ini file.
extension_dir = "./extensions"
The extensions dir is located under c:/PHP/extensions
I've tried to put the full path into the ini file but I get the same error
(text is different because of path).
Thanks for you help.
**********************************************************************
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination,
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.
--- End Message ---
--- Begin Message ---
The mysqli DLL file is not present in the PHP5rc3 for Win32 package, nor is it
bundled.
Can't find it in the PECL package either. Did they just forget to put the DLL in the
package
or is there a more esoteric explanation to this?
Erik
--- End Message ---
--- Begin Message ---
Hello Ross,
First of all, do you have a firewall on your test server? If you do, beware that some
firewalls (e.g. ZoneAlarm 4) play havoc with session data. Disable the firewall (if
you can)
and, presto, your sessions start working as expected. Of course then your machine will
be
exposed, but that's another problem...
One other thing: do you realize that, under normal circumstances, each and every time
a
user closes all browser windows on his computer and starts up the browser again a new
session is started on the server? This basically means that if one of your users for
some
weird reason closes his browser (or if his browser crashes, which happens all the time
with IE), then starts it again and goes back to your site, a new session will have
been
started.
Hope this helps,
Erik
On 7 Jun 2004 at 10:15, Ross Honniball wrote:
> Sessions are driving me crazy.
>
> I am tracking screens a user has visited using an array within the
> $_SESSION array.
>
> And it nearly works.
>
> I call session_start() before any output in each script and before trying
> to access any $_SESSION data.
>
> The huge headache I am having is that php seems to fire up a NEW session in
> certain situations (the result being that it can NOT find the previous
> screens a user has visited).
>
> Anyone had any similar problems and found a solution?
--- End Message ---
--- Begin Message ---
Webyog has released SQLyog 3.71 & SQLyog Job Agent (
SJA ) v2.0
Some of the major features added in SQLyog 3.71 are -
-- SQLyog Notification Services - This new feature
allows delivery of formatted resultset(s) over email
at scheduled intervals.
-- SQLyog Database Synchronization Tool now supports
2-way synchronization.
-- Now you can execute SJA jobs from SQLyog using
Tools -> Job Manager.
-- Improved Online Help.
-- Fully compatible with MySQL versions 3.23.58 to
5.x.
You can download a full featured Trial version of
SQLyog at http://www.webyog.com/sqlyog/download.html
Regards,
Karam
__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
--- End Message ---
