[PHP-DB] PHP and MySQL 5.0 stored procedures

2005-03-10 Thread Guy Harrison
Hi all, I'm new to PHP, but have been doing a lot of work with the MySQL 5.0 alphas looking at the stored procedure implementation. I wanted to work with stored procedures in the PHP mysqli interface, but it doesn't seem to be ready for them yet. The things I want to do with stored procedures th

Re: [PHP-DB] Grouping Data Together

2005-03-10 Thread Craig Hoffman
Found the problem - Craig On Mar 10, 2005, at 5:47 PM, Craig Hoffman wrote: Hello, I could use some assistance here. I'll try and explain this the best I can. I'm trying to get this query to work where it pulls up all the rows that are associated with a common id . For example let say you ha

[PHP-DB] Grouping Data Together

2005-03-10 Thread Craig Hoffman
Hello, I could use some assistance here. I'll try and explain this the best I can. I'm trying to get this query to work where it pulls up all the rows that are associated with a common id . For example let say you have data that you want to group together. For example: Group 1 would look l

Re: [PHP-DB] Variable Variable Array

2005-03-10 Thread Evert | Rooftop Solutions
Ryan Jameson (USA) wrote: Dynamic Variable sounds good. :-) I use them all the time, and they are often necessary. Probably not in this case though, I like to throw them in to confuse the newbs.. :-) J/K Try regular expressions, it confuses them even more :) Anyway, could you point me to a situa

RE: [PHP-DB] Variable Variable Array

2005-03-10 Thread Ryan Jameson \(USA\)
Dynamic Variable sounds good. :-) I use them all the time, and they are often necessary. Probably not in this case though, I like to throw them in to confuse the newbs.. :-) J/K <>< Ryan -Original Message- From: Martin Norland [mailto:[EMAIL PROTECTED] Sent: Thursday, March 10, 2005 1:53

Re: [PHP-DB] Variable Variable Array

2005-03-10 Thread Martin Norland
Evert|Rooftop Solutions wrote: Ryan Jameson (USA) wrote: I've been using "variable variables" for years with PHP. I'm not really sure this is really good practice. Sure, php allows it but I think you should try to avoid them. [snip] It's excellent practice to use dynamic variables* when you need t

RE: [PHP-DB] Variable Variable Array

2005-03-10 Thread Ryan Jameson \(USA\)
"echo ${$VarName}['second']; is what you want - you want to be very clear what order these things need to be analyzed in, especially when dealing with arrays and the likes." That was the problem!!! Thanks guys. <>< Ryan -Original Message- From: Martin Norland [mailto:[EMAIL PROTECTED]

RE: [PHP-DB] PHP and PostgreSQL

2005-03-10 Thread Van Ingen, Lane
I think from binary; it was installed as a part of Slackware, and I made no special efforts to compile. Version of PHP is 4.3.7 (thanks Mychael) Other: Linux kernel is 2.4.26 Apache version is 1.3.31 Looks like MySQL may already be configured in PHP (saw that in phpinfo() ) When

RE: [PHP-DB] Variable Variable Array

2005-03-10 Thread Bastien Koert
Do you mean something like this: http://www.weberdev.com/get_example-4065.html It creates a quick associative array from the resultset Bastien From: "Ryan Jameson (USA)" <[EMAIL PROTECTED]> To: Subject: [PHP-DB] Variable Variable Array Date: Thu, 10 Mar 2005 11:56:16 -0700 Hi Folks, I've been usin

RE: [PHP-DB] PHP and PostgreSQL

2005-03-10 Thread Mychael Scribner
save this to a php file and run it. I a attached file just in case. This will give you all of the information you will need for you php installation. -Original Message- From: Van Ingen, Lane [mailto:[EMAIL PROTECTED] Sent: Thursday, March 10, 2005 2:33 PM To: php-db@lists.php.net Subje

Re: [PHP-DB] PHP and PostgreSQL

2005-03-10 Thread Stephen Johnson
Did you compile php or did you install from a binary? If you compiled -- did you configure the PHP module --with-pgsql? I have not installed a binary in the past so I am not sure how you activate the pgsql module in that regard. The problem though is that the version of PHP you are running is no

[PHP-DB] PHP and PostgreSQL

2005-03-10 Thread Van Ingen, Lane
I am new to PHP. Trying to install it and PostgreSQL 8.0 on Slackware Linux 10.0.0 . I am getting the following error out of Apache: Fatal Error: Call to undefined function: pg_connect() After browsing your web site, I found http://us2.php.net/pgsql . But am unable to proceed because I am n

Re: [PHP-DB] Variable Variable Array

2005-03-10 Thread Martin Norland
Ryan Jameson (USA) wrote: Hi Folks, I've been using "variable variables" for years with PHP. $var = "myVarName"; $$var = "Some Val"; echo $myVarName; //outputs "Some Val" [snip] Example: $var['first']='bob'; $var['second']='frank'; $varName = "myVarName"; $$varName = $var; echo $$varName['second'];

Re: [PHP-DB] Variable Variable Array

2005-03-10 Thread Evert | Rooftop Solutions
Ryan Jameson (USA) wrote: Hi Folks, I've been using "variable variables" for years with PHP. I'm not really sure this is really good practice. Sure, php allows it but I think you should try to avoid them. $var = "myVarName"; $$var = "Some Val"; echo $myVarName; //outputs "Some Val" Today

[PHP-DB] Variable Variable Array

2005-03-10 Thread Ryan Jameson \(USA\)
Hi Folks, I've been using "variable variables" for years with PHP. $var = "myVarName"; $$var = "Some Val"; echo $myVarName; //outputs "Some Val" ... Today I am trying to assign an Associative Array value to a "variable variable". For some reason it doesn't take. Does anyone know why? Example

RE: [PHP-DB] Saving Data to a csv file

2005-03-10 Thread Bastien Koert
I wrote this a while ago for a pipe-delimited file download function force_download($file) { //$dir="/path/to/file/"; if (isset($file)) { header("Content-type: application/force-download"); header('Content-Disposition: inline; filename="' . $file . '"'); header("Content-Tran

[PHP-DB] Saving Data to a csv file

2005-03-10 Thread Lens Man
Hi, I'm trying to make a downloadable csv file from a address database based on PHP and MySQL. I have a script for getting the data (no problem so far) but I want to have the data delivered as a starting downlaod in csv format. Can anyone give me a helping hand? Thx in advance Lensman -- DSL K

[PHP-DB] reading a .txt file w/PHP and storing the data in mySQL

2005-03-10 Thread Art.M (Wikki)
Hi, new to the list and new period =) I found this great little gem while RTFM and I modified it slightly for my use. //http://www.w-ifc.com/test/SCORE.TXT'); // Loop through our array, show source; and line numbers too. //foreach ($lines as $line_num => $line) { // echo "Line #{$line_num} : "

[PHP-DB] sporadic "access denied"/"no db selected" errors executing simple query...

2005-03-10 Thread Robert Locke
Greetings, I have a problem which shows up *intermittently* when executing a simple query. Basically, mysql_query() returns no resource *some* of the time. When I trap the error using mysql_error(), I get the following: "No Database Selected" For kicks, I altered the query to use the full

Re: [PHP-DB] Forms...

2005-03-10 Thread Jochem Maas
Neil Smith [MVP, Digital media] wrote: At 07:52 10/03/2005 +, you wrote: Message-ID: <[EMAIL PROTECTED]> Date: Wed, 09 Mar 2005 20:37:36 +0100 From: Jochem Maas <[EMAIL PROTECTED]> if your into XHTML: Actually that's invalid XHTML (it won't validate) due to a typo I guess. true, yeah I added

Re: [PHP-DB] Forms...

2005-03-10 Thread Neil Smith [MVP, Digital media]
At 07:52 10/03/2005 +, you wrote: Message-ID: <[EMAIL PROTECTED]> Date: Wed, 09 Mar 2005 20:37:36 +0100 From: Jochem Maas <[EMAIL PROTECTED]> if your into XHTML: Actually that's invalid XHTML (it won't validate) due to a typo I guess. Each XML (aka XHTML) DOM element can only have a ~single~ a