[PHP-DB] Problem with MySQL 4.0.4 beta

2002-10-13 Thread Rosen 

Hi,
I just installed MySQL server on WIndows 98 and when server starts the
window with mysqld-opt opens and stop responding. And server didn't start.
Any ideas for this?

Thanks,
ROsen




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] PMA Database ... not OK[ Documentation ]

2002-10-13 Thread Russell Griechen 

Does this mean that to use this version that I would have to pay for another
database and how would this impact the database that is powering my site?

The last couple of versions of PhpMyAdmin carries this:

Error
The additional Features for working with linked Tables have been
deactivated. To find out why click 'here'
Clicking on the Link...

PMA Database ... not OK[ Documentation ]
General relation features Disabled

Info revealed:
$cfg['Servers'][$i]['pmadb'] string
Starting with version 2.3.0 phpMyAdmin offers a lot of features to work with
master / foreign - tables. To use those as well as the bookmark feature you
will need to create a new db.

To use this functionality as superuser create a new database:
create a new database for phpmyadmin:
CREATE DATABASE phpmyadmin;
Note that controluser must have SELECT, INSERT, UPDATE and DELETE
privileges on this database. Here is a query to set up those privileges
(using phpmyadmin as the database name, and pma as the controluser):
GRANT SELECT,INSERT,UPDATE,DELETE ON phpmyadmin.* to 'pma''localhost';
do not give any other user rights on this database.
enter the databasename in $cfg['Servers'][$i]['pmadb']

Russell Griechen


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Database analysis tools

2002-10-13 Thread Benny 


I need to make pivot table for analysis  reporting.
Is there a database analysis tool for mysql like Microsoft OLAP ?

Regards;

Benny.



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Array Initialization

2002-10-13 Thread Rich Hutchins 

Please forgive me ahead of time, but I didn't want to subscribe to the
high-vol general list for a single question. Actually, I need this to prep
data to be passed to a db, so it's kind of close.

I have a variable number of hidden fields being passed from page A into page
B via POST. On page B, I want to take those hidden fields and turn them into
an associative array. I am able to get the data out of the $HTTP_POST_VARS
and make it look the way I want with the following code:

!-- BEGIN POST VARS --
!-- { mySelect = '40', mySelect_10 = 'Miami', mySelect_20 = 'New England',
mySelect_30 = 'Buffalo', mySelect_40 = 'New York' } --

foreach ($HTTP_POST_VARS as $key = $value) {
if (preg_match(/mySelect_/, $key ))
{
echo(Found a match.br);
$stripped = substr_replace($key, , 0, 9);
echo(Content ID=.$stripped.br);
echo(Its text value is: .$value);
echo(brbr);

$newInfo = array($stripped = $value);
}
}

print_r($newInfo);

The resulting sample HTML data looks like this:
Found a match.
Content ID=10
Its text value is: Miami

Found a match.
Content ID=20
Its text value is: New England

Found a match.
Content ID=30
Its text value is: Buffalo

Found a match.
Content ID=40
Its text value is: New York

Array ( [40] = New York ) //here's the problem

The problem is in the $newInfo = array($strippd = $value); and it's the
last line of the sample HTML code.

What I want to achieve is:
Array ( [10] = Miami, [20] = New England, [30] = Buffalo, [40] = New
York ).

Any ideas how to get there?

Thanks in advance.


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Array Initialization

2002-10-13 Thread John W. Holmes 

$newInfo[$stripped] = $value;

---John Holmes...

 -Original Message-
 From: Rich Hutchins [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, October 13, 2002 3:42 PM
 To: [EMAIL PROTECTED]
 Subject: [PHP-DB] Array Initialization
 
 Please forgive me ahead of time, but I didn't want to subscribe to the
 high-vol general list for a single question. Actually, I need this to
prep
 data to be passed to a db, so it's kind of close.
 
 I have a variable number of hidden fields being passed from page A
into
 page
 B via POST. On page B, I want to take those hidden fields and turn
them
 into
 an associative array. I am able to get the data out of the
$HTTP_POST_VARS
 and make it look the way I want with the following code:
 
 !-- BEGIN POST VARS --
 !-- { mySelect = '40', mySelect_10 = 'Miami', mySelect_20 = 'New
 England',
 mySelect_30 = 'Buffalo', mySelect_40 = 'New York' } --
 
   foreach ($HTTP_POST_VARS as $key = $value) {
   if (preg_match(/mySelect_/, $key ))
   {
   echo(Found a match.br);
   $stripped = substr_replace($key, , 0, 9);
   echo(Content ID=.$stripped.br);
   echo(Its text value is: .$value);
   echo(brbr);
 
   $newInfo = array($stripped = $value);
   }
   }
 
   print_r($newInfo);
 
 The resulting sample HTML data looks like this:
 Found a match.
 Content ID=10
 Its text value is: Miami
 
 Found a match.
 Content ID=20
 Its text value is: New England
 
 Found a match.
 Content ID=30
 Its text value is: Buffalo
 
 Found a match.
 Content ID=40
 Its text value is: New York
 
 Array ( [40] = New York ) //here's the problem
 
 The problem is in the $newInfo = array($strippd = $value); and it's
the
 last line of the sample HTML code.
 
 What I want to achieve is:
 Array ( [10] = Miami, [20] = New England, [30] = Buffalo, [40] =
New
 York ).
 
 Any ideas how to get there?
 
 Thanks in advance.
 
 
 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php