[PHP] Compare 2 resultsets of db-query

2002-06-10 Thread Danny Kruitbosch
Hi, I've two queries on the same table. They have the following structure: Query1: SELECT FIELD1, COUNT(FIELD2) AS TOTAL from TABLE GROUP BY FIELD1 Query2: SELECT FIELD1, COUNT(FIELD2) AS SUB from TABLE WHERE FIELD2=1 GROUP BY FIELD1 Now I want to print a table that prints the values of

Re: [PHP] Compare 2 resultsets of db-query

2002-06-12 Thread Danny Kruitbosch
Analysis Solutions wrote: Hey Danny: On Mon, Jun 10, 2002 at 10:09:12PM +0200, Danny Kruitbosch wrote: Query1: SELECT FIELD1, COUNT(FIELD2) AS TOTAL from TABLE GROUP BY FIELD1 Query2: SELECT FIELD1, COUNT(FIELD2) AS SUB from TABLE WHERE FIELD2=1 GROUP BY FIELD1 Now I want to print

Re: [PHP] Compare 2 resultsets of db-query

2002-06-12 Thread Danny Kruitbosch
Analysis Solutions wrote: On Wed, Jun 12, 2002 at 04:54:30PM +0200, Danny Kruitbosch wrote: Analysis Solutions wrote: Hey Danny: On Mon, Jun 10, 2002 at 10:09:12PM +0200, Danny Kruitbosch wrote: Query1: SELECT FIELD1, COUNT(FIELD2) AS TOTAL from TABLE GROUP BY FIELD1 Query2: SELECT

[PHP] md5 php vs. md5 perl

2002-06-16 Thread Danny Kruitbosch
Hi, I'm trying to rewrite a perl finction to php. The function uses Digest::MD5. PHP md5() returns a 32 char hex number. The perl Digest::MD5 function returns a 16 char (ascii??) string. Can I also get this from PHP? If so how do I do that? My ultimate goal is to have compatible PHP/Perl

[PHP] translate perl unpack to php equivalent

2002-06-16 Thread Danny Kruitbosch
Hi, How would I translate this perl unpack statement to the php equiv. my ($salt, $xor) = unpack('a2 a*', $something) Thanks! Danny -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php