[PHP-DB] Variables de SESSION dentro de funciones PHP

2002-12-13 Thread Francisco José Saiz : : netPerceptions
Hola, tengo una función en PHP que me lee de un fichero una configuración de unas tablas de BBDD, quiero que el nombre de las tablas así como los datos de conexión, me queden residentes en unas variables de sesión. Cuando registro las variables dentro de la función, al acceder desde cualquier

RE: [PHP-DB] Variables de SESSION dentro de funciones PHP

2002-12-13 Thread Snijders, Mark
english please!!! ___ Mark Snijders, Developer Atos Origin Groenewoudeseweg 1, Room VN-515 5621 BA Eindhoven, The Netherlands * : [EMAIL PROTECTED] *:+31 (0)40 - 2785992 (tel) * : +31 (0)40 - 2788729 (fax) The information in this mail is intended

RE: [PHP-DB] Variables de SESSION dentro de funciones PHP

2002-12-13 Thread Ruprecht Helms
Hi Francisco José Saiz netPerceptions, would you be so kind and repeat your mail in english. Regards, Ruprecht -- Ruprecht Helms IT-Service und Softwareentwicklung Tel/Fax.: +49[0]7621 16 99 16 Homepage: http://www.rheyn.de email: [EMAIL

RE: [PHP-DB] Variables de SESSION dentro de funciones PHP

2002-12-13 Thread Michael Hazelden
through the magic of babelfish! I have a function in PHP that reads of a file a configuration to me of BBDD tables, I want that the name of the tables as well as the data of connection, I have left residents in session variables. When registry the variables within the function, when acceding from

RE: [PHP-DB] Variables de SESSION dentro de funciones PHP

2002-12-13 Thread Francisco José Saiz : : netPerceptions
Hi, I have made a PHP function that reads a tablename from a file. I want to keep the tablename value into a session var. I register the session vars and assign the value. But when I try to access outside the function the variable is empty. I do this: session_start(); function OneFunction {

Re: [PHP-DB] mysql-windows xp

2002-12-13 Thread Jeffrey_N_Dyke
probably b/c of grants/rights did you run a -- grant all on *.* to user@localhost ? or something of the sort. or set up root to have access can you connect via command line? HTH Jeff

RE: [PHP-DB] mysql-windows xp

2002-12-13 Thread Edward Peloke
how do you do this? I guess I could look it up in the help files. I don't need the firewall as it is behind one at home. -Original Message- From: SELPH,JASON (HP-Richardson,ex1) [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 8:45 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]

RE: [PHP-DB] mysql-windows xp

2002-12-13 Thread Jeffrey_N_Dyke
that didn't cause me any issues on my install. why do you have to turn that off. i'm not doubting you, just curious? Jeff SELPH,JASON

RE: [PHP-DB] mysql-windows xp

2002-12-13 Thread Edward Peloke
can't seem to find that line in the install file but I probably don't know what I am looking for IS this the install doc you meant? http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#In stalling Thanks, Eddie -Original Message- From: [EMAIL PROTECTED]

RE: [PHP-DB] mysql-windows xp

2002-12-13 Thread SELPH,JASON (HP-Richardson,ex1)
by default on a new xp install the firewall is enabled. stops everything on your network from getting thru. if port 3306 is blocked then accessing mysql thru ip would be denied. To disable internet connection firewall... I have not installed mysql on xp, but the same thing happens with irc,

RE: [PHP-DB] mysql-windows xp

2002-12-13 Thread SELPH,JASON (HP-Richardson,ex1)
I honestly can't give you an answer on that as I haven't installed mysql on XP. On linux there are 2 ways to connect to your server, socket or tcp. I am not sure on the windows version. I just know that trying to access anything on a firewalled machine, even from itself, via tcp with XP didn't

Re: [PHP-DB] Re: Newbie - Is this possible with mysql? can i fake it in php?

2002-12-13 Thread Mark
The problem is that you're printing $size, but size is the result code for the mysql_query() function. -- $size = mysql_query($query,$db) or die(query: . mysql_error()); -- You need to fetch the values as you did in the first query. --- Max Clark [EMAIL PROTECTED] wrote: Help- When I run

Re: [PHP-DB] HELP!! Warning: mysql_pconnect:

2002-12-13 Thread John Krewson
Try mysql_connect instead. Doesn't sound as if you are at the stage at which you would realize any gains from a persistent connection. I've just seen a lot of comments regarding strange happenings with pconnect - which I have no doubt will be addressed later. Don Briggs wrote: While

[PHP-DB] Dumping MySQL rows into a 2D array

2002-12-13 Thread George Pitcher
Hi all, I want to grab the resul from a db query and store it in an array so that I can selectively grab the data later. This is what I'm doing: $dbRowCount = mysql_num_rows( $result ); for ($i = 1; $i = $dbRowCount; ++$i) { while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {

[PHP-DB] Re: Dumping MySQL rows into a 2D array

2002-12-13 Thread Bastian Vogt
Hi, first leave out the loop with for ($i...). then use the loop with while and make sure that you create arrays. you're currently filling the same variables with different results each time. the last one always overwrites the ones bevor. so add those brackets: []: $dbRow['ev_id'][]=

RE: [PHP-DB] Re: Dumping MySQL rows into a 2D array

2002-12-13 Thread George Pitcher
Bastian, That's great - it does the trick perfectly. Many thanks. George -Original Message- From: Bastian Vogt [mailto:[EMAIL PROTECTED]] Sent: 13 December 2002 3:18 pm To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: Dumping MySQL rows into a 2D array Hi, first leave out the

RE: [PHP-DB] mysql-windows xp

2002-12-13 Thread Edward Peloke
Thanks for all the help. I finally got it running by running winmysqladmin Eddie -Original Message- From: SELPH,JASON (HP-Richardson,ex1) [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 9:29 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] mysql-windows xp

Re: [PHP-DB] Linux+php+remote MS SQL

2002-12-13 Thread John Krewson
We are currently running two report generation applications where PHP is running on Linux machines and queries data from Windows NT servers running MSSQL 7.0 We have reports that deal with millions of records, and whether they run for 4 minutes or 20, I have only seen robust results from the

[PHP-DB] setup issues again

2002-12-13 Thread Edward Peloke
I know this isn't db related but...I finally go mysql and apache running on my laptop now I am trying to get php working. I downloaded the php-4.2.3-installer this morning. Ran the install and am now going through the install instructions. I noticed it said to copy these lines into the apache

RE: [PHP-DB] Variables de SESSION dentro de funciones PHP

2002-12-13 Thread Francisco José Saiz : : netPerceptions
Thanks, I'll try it now. -Original Message- From: Leif K-Brooks [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 1:49 PM To: Francisco José Saiz :: netPerceptions Subject: Re: [PHP-DB] Variables de SESSION dentro de funciones PHP You're mixing register_globals off session

Re: [PHP-DB] Cool MySQL - Excel Shell Script

2002-12-13 Thread Mark
I was playing around with this, and created a DOS batch file that should be equivalent. Note it was about 15 minutes of work including debugging, so I can't guarantee success. It's nothing compliated, but if oyu need to get mysql data into excel often, this might help. --query.bat-- rem Show the

[PHP-DB] bulk miorting rows into mysql db

2002-12-13 Thread mikek
I have a few hundred rows of data to import into a mysql db. Its currently tab separated. What's the most straight forward way (ie i dont want to enter it line by line) of doing a bulk import? I have full admin rights to my dev server. Is there a method or software app that people can recommend

Re: [PHP-DB] bulk miorting rows into mysql db

2002-12-13 Thread Adam Williams
use mysqlimport, its a program that comes with MySQL. go to www.mysql.com and click on documentation to learn more about it. Adam On Fri, 13 Dec 2002, mikek wrote: I have a few hundred rows of data to import into a mysql db. Its currently tab separated. What's the

[PHP-DB] Selecting more than asked for

2002-12-13 Thread Alex Francis
I am using PHP and MySQL and in one section I am trying to SELECT for a table where unit_id = $variable. In that column I have several blank items. When I select a particular variable I get that plus all the blanks. I presume there is some way of getting just those which meet my criteria. --

Re: [PHP-DB] bulk miorting rows into mysql db

2002-12-13 Thread 1LT John W. Holmes
I have a few hundred rows of data to import into a mysql db. Its currently tab separated. What's the most straight forward way (ie i dont want to enter it line by line) of doing a bulk import? I have full admin rights to my dev server. Is there a method or software app that people can

RE: [PHP-DB] Selecting more than asked for

2002-12-13 Thread Hutchins, Richard
Try: SELECT some_column FROM some_table WHERE column_value IS NOT NULL AND unit_ID=$variable If that's kind of what you're looking for, there's good info in the MySQL manual about the WHERE condition and other sorting and selecting options. HTH -Original Message- From: Alex Francis

[PHP-DB] Re: select only where 2 things are true

2002-12-13 Thread rolf vreijdenberger
SELECT jouw_id FROM A AS A1, A AS A2 WHERE A1.merkid=1 AND A2.merk_id=2 AND A1.jouw_id=A2.jouw_id this is a self join! thanks to vincent @ www.yapf.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysql-windows xp

2002-12-13 Thread Tyler Whitesides
Hi, If you want MySQL to work in XP, make sure that you have the proper version (XP/2000/NT) and in the advanced settings of your firewall, make sure to allow TCP port 3306 to have full internet access from inside as well as out. Good luck, Tyler - Original Message - From: SELPH,JASON