Re: [PHP] Stumped - MDB2 & pgsql

2010-07-15 Thread Michael A. Peters
Michael A. Peters wrote: Michael A. Peters wrote: I need to switch from MySQL (where everything is peachy) to Postgresql - reason I need to switch is I need to use PostGIS and I don't see a need to run two databases. I got Postgresql installed (stock CentOS / RHEL 5) and installed the postgr

Re: [PHP] Stumped - MDB2 & pgsql

2010-07-15 Thread Michael A. Peters
Michael A. Peters wrote: I need to switch from MySQL (where everything is peachy) to Postgresql - reason I need to switch is I need to use PostGIS and I don't see a need to run two databases. I got Postgresql installed (stock CentOS / RHEL 5) and installed the postgresql php module and mdb2 d

Re: [PHP] Stumped I Tell You!

2008-07-25 Thread Daniel Brown
On Fri, Jul 25, 2008 at 3:41 PM, Jay Blanchard <[EMAIL PROTECTED]> wrote: > > I see you get whacked around the head here every so often...and if not > here I am sure that your SO handles it as needed. Yeah, but she's in Virginia Beach for the week, so there's a slight chance the bruising will

RE: [PHP] Stumped I Tell You!

2008-07-25 Thread Jay Blanchard
[snip]By the way, I didn't mean to insinuate that your use of the if() condition was incorrect[/snip] No worries. [snip] Someone needs to whack me upside the head every so often. In my case, that might be a patentable invention.[/snip] I see you get whacked around the head here every so oft

Re: [PHP] Stumped I Tell You!

2008-07-25 Thread David Giragosian
On 7/25/08, Daniel Brown <[EMAIL PROTECTED]> wrote: > > On Fri, Jul 25, 2008 at 3:07 PM, Jay Blanchard <[EMAIL PROTECTED]> > wrote: > > > > *slaps forehead soundly* I found that there was a missing greater than > > sign in a greater than or equal to requirement in an earlier query. > >The most

Re: [PHP] Stumped I Tell You!

2008-07-25 Thread Daniel Brown
On Fri, Jul 25, 2008 at 3:07 PM, Jay Blanchard <[EMAIL PROTECTED]> wrote: > > *slaps forehead soundly* I found that there was a missing greater than > sign in a greater than or equal to requirement in an earlier query. The most minuscule errors cause the greatest harm. By the way, I didn'

RE: [PHP] Stumped I Tell You!

2008-07-25 Thread Jay Blanchard
[snip] I'm sure you've already tried this, but did you copy the SQL query echo'd out and try it directly with MySQL to make sure there are rows returned? [/snip] Yes. *slaps forehead soundly* I found that there was a missing greater than sign in a greater than or equal to requirement in an e

Re: [PHP] Stumped I Tell You!

2008-07-25 Thread Daniel Brown
On Fri, Jul 25, 2008 at 2:36 PM, Jay Blanchard <[EMAIL PROTECTED]> wrote: > > I have several other queries running in this example and they all use > the same run/error check routine with no issues. I'm sure you've already tried this, but did you copy the SQL query echo'd out and try it direct

RE: [PHP] Stumped I Tell You!

2008-07-25 Thread Jay Blanchard
[snip] [snip!] > > $endBal = mysql_fetch_array($dbEnd); > echo mysql_num_rows($dbEnd); > print_r($endBal); > > Nothing gets returned from those last statements. Am I missing something > completely? Right here You're merging assignment. Maybe you meant this: [/snip] I have sever

Re: [PHP] Stumped I Tell You!

2008-07-25 Thread Daniel Brown
On Fri, Jul 25, 2008 at 1:55 PM, Jay Blanchard <[EMAIL PROTECTED]> wrote: [snip!] > > $endBal = mysql_fetch_array($dbEnd); > echo mysql_num_rows($dbEnd); > print_r($endBal); > > Nothing gets returned from those last statements. Am I missing something > completely? Right here You're

Re: [PHP] STUMPED: path/style vars in Windows with IIS

2004-12-13 Thread Ck
Hi Richard. Thank you for the reply. I was dragged to IIS kicking and screaming! I have been doing php development for almost 6 years, and this will be my first production-level experience with php through IIS... Unfortunately it is a hosted environment and there is a legacy coldfusion applicat

Re: [PHP] STUMPED: path/style vars in Windows with IIS

2004-12-13 Thread Richard Lynch
Ck wrote: > Hello. > > I am trying to get path/style variables working in windows with IIS on > a hosted environment. What I mean by path/style variables is the > following: Say I have a script "test.php" that can be accessed via: > > http://mydomain/controller.php > > ...I want to pass variables

Re: [PHP] Stumped

2003-11-30 Thread Brian V Bonini
On Sun, 2003-11-30 at 19:21, Robert Cummings wrote: > On Sun, 2003-11-30 at 18:45, Brian V Bonini wrote: > > Warning: Invalid argument supplied for foreach() in > > /usr/local/www/vhosts/pa.eastcoastbicycles.com/htdocs/mainfile.php on > > line 42 > > > > Warning: Invalid argument supplied for fore

Re: [PHP] Stumped

2003-11-30 Thread Robert Cummings
On Sun, 2003-11-30 at 18:45, Brian V Bonini wrote: > Warning: Invalid argument supplied for foreach() in > /usr/local/www/vhosts/pa.eastcoastbicycles.com/htdocs/mainfile.php on > line 42 > > Warning: Invalid argument supplied for foreach() in > /usr/local/www/vhosts/pa.eastcoastbicycles.com/htdocs

Re: [PHP] Stumped

2003-11-30 Thread Jason Wong
Please use a DESCRIPTIVE subject! On Monday 01 December 2003 02:51, Brian V Bonini wrote: > Warning: Invalid argument supplied for foreach() in > /usr/local/www/vhosts/pa.eastcoastbicycles.com/htdocs/mainfile.php on > line 42 > > Warning: Invalid argument supplied for foreach() in > /usr/local/www

Re: [PHP] stumped on mysql_num_rows

2003-06-13 Thread Jason Wong
On Saturday 14 June 2003 01:55, Global I.S. S.A. wrote: > The issue appears to be that no rows are being found with mysql_num_rows > using the SQL LIMIT offset. There should be rows found. Further, all > processing just halts, and no query is shown as per the code here: > > > // RUN THE QUERY TO R

Re: [PHP] Stumped @ MySql insert query

2003-06-13 Thread Zak Johnson
On 2003-06-13 14:42-0400, Pushpinder Singh Garcha wrote: > How is variable poisoning possible when using $_POST ?? I always felt > that the php compiler should check to see if the variable was part of > the POST Global array. At least this is is what I thought about the > $_POST global array.

Re: [PHP] Stumped @ MySql insert query

2003-06-13 Thread Pushpinder Singh Garcha
On Friday, June 13, 2003, at 02:22 PM, Zak Johnson wrote: $_POST variables are still subject to poisoning; in your case, SQL injection. How is variable poisoning possible when using $_POST ?? I always felt that the php compiler should check to see if the variable was part of the POST Global arr

RE: [PHP] Stumped @ MySql insert query

2003-06-13 Thread Jay Blanchard
[snip] $sql1 = "INSERT INTO `contacts` VALUES ( $_POST['company'], $_POST['pri_name'], $_POST['sec_name'], $_POST['assistant_1'], $_PO

Re: [PHP] Stumped @ MySql insert query

2003-06-13 Thread Zak Johnson
On 2003-06-13 14:15-0400, Pushpinder Singh Garcha wrote: > I am trying to execute a simple query using $_POST variables, so > that variable poisoning is not possible. note: I have register_globals > ON on my site. I am getting the error shown below . Please advise ... > as I can't seem to f

Re: [PHP] stumped on mysql_num_rows

2003-06-13 Thread Alex Earl
Can you give us the query too? Alex > Hello List, > The issue appears to be that no rows are being found with mysql_num_rows > using the SQL LIMIT offset. There should be rows found. Further, all > processing just halts, and no query is shown as per the code here: > > > // RUN THE QUERY TO RETRI

RE: [PHP] Stumped...

2003-01-08 Thread Sean Malloy
[mailto:[EMAIL PROTECTED]] Sent: Thursday, 9 January 2003 3:18 PM To: Stephen; PHP List Subject: RE: [PHP] Stumped... Don't write code which requires register_globals to be on. $variable = $_POST['$var']; -Original Message- From: Stephen [mailto:[EMAIL PROTECTED]] Sent: Thurs

RE: [PHP] Stumped...

2003-01-08 Thread Sean Malloy
Don't write code which requires register_globals to be on. $variable = $_POST['$var']; -Original Message- From: Stephen [mailto:[EMAIL PROTECTED]] Sent: Thursday, 9 January 2003 3:03 PM To: Timothy Hitchens (HiTCHO) Cc: PHP List Subject: Re: [PHP] Stumped... Ok, I

Re: [PHP] Stumped...

2003-01-08 Thread Stephen
- From: "Timothy Hitchens (HiTCHO)" <[EMAIL PROTECTED]> To: "'Stephen'" <[EMAIL PROTECTED]> Sent: Wednesday, January 08, 2003 9:30 PM Subject: RE: [PHP] Stumped... : The issue with the serialise option is that is you have then in a row : they are serialised

RE: [PHP] Stumped...

2003-01-08 Thread Timothy Hitchens \(HiTCHO\)
HiTCHO) > Cc: PHP List > Subject: Re: [PHP] Stumped... > > > How would I serialise it? I can make the numbers into an > array, but if I echo the array itself, I'd get "Array" and I > need the number in the db, not the word... > > > - Original

Re: [PHP] Stumped...

2003-01-08 Thread Stephen
phen'" <[EMAIL PROTECTED]> Cc: "'PHP List'" <[EMAIL PROTECTED]> Sent: Wednesday, January 08, 2003 9:09 PM Subject: RE: [PHP] Stumped... : What you can do it simply get the data and create an array serialise the : array and sent it to : the database ... the

RE: [PHP] Stumped...

2003-01-08 Thread Timothy Hitchens \(HiTCHO\)
Message- > From: Stephen [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 9 January 2003 12:00 PM > To: Timothy Hitchens (HiTCHO) > Cc: PHP List > Subject: Re: [PHP] Stumped... > > > I will later select them and display them to be edited, but > other then that, not reall

Re: [PHP] Stumped...

2003-01-08 Thread Stephen
AIL PROTECTED]> Sent: Wednesday, January 08, 2003 8:58 PM Subject: RE: [PHP] Stumped... : Do you require searching of this data eg... select via these numbers or : not?? : : : Timothy Hitchens (HiTCHO) : Open Platform Consulting : e-mail: [EMAIL PROTECTED] : : : -Original Message- : From:

RE: [PHP] Stumped...

2003-01-08 Thread Timothy Hitchens \(HiTCHO\)
Do you require searching of this data eg... select via these numbers or not?? Timothy Hitchens (HiTCHO) Open Platform Consulting e-mail: [EMAIL PROTECTED] -Original Message- From: Stephen [mailto:[EMAIL PROTECTED]] Sent: Thursday, 9 January 2003 11:56 AM To: PHP List Subject: [PHP] St

Re: [PHP] Stumped!

2002-12-16 Thread Chris Shiflett
--- Chris Shiflett <[EMAIL PROTECTED]> wrote: > --- [EMAIL PROTECTED] wrote: > > I keep getting a parser error and I can't figure > > it out. Here is the code and any help is greatly > > appreciated. > > > > $sql = "SELECT * FROM requests"; > > > > while ($result = mysql_fetch_array($query)) > >

Re: [PHP] Stumped!

2002-12-16 Thread Chris Shiflett
--- [EMAIL PROTECTED] wrote: > I keep getting a parser error and I can't figure > it out. Here is the code and any help is greatly > appreciated. > > $sql = "SELECT * FROM requests"; > > while ($result = mysql_fetch_array($query)) While this is not related to your parse error, it is a major logi

Re: [PHP] Stumped!

2002-12-16 Thread 1LT John W. Holmes
> I am trying to display a column from my database as a list. Each listing > needs to be a URL that links to another script that brings up all of the data > in the row to edit. I keep getting a parser error and I can't figure it out. > Here is the code and any help is greatly appreciated. > > $

Re: [PHP] Stumped.

2002-06-24 Thread 1LT John W. Holmes
> Are there any other reasons why header() would fail while output > buffering is off. What's the error message? It tells you exactly what file and line number started the output, so that's where you should look... ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubs

Re: [PHP] Stumped.

2002-06-24 Thread Gerard Samuel
Within the function before the header(), no there are no echo or print statements. I do have a few error checking that uses trigger_error() which displays a page, but no errors are being triggered. And just in case, I did check the error_handler file. There aren't any 'white space' before or a

Re: [PHP] Stumped on a function

2002-06-21 Thread Jason Soza
al Message - From: Jesper Brunholm <[EMAIL PROTECTED]> Date: Friday, June 21, 2002 2:02 am Subject: Re: [PHP] Stumped on a function > John Holmes wrote: > > Why don't you just use DATE_FORMAT() in your query, then you > don't have > > to do any extra PHP code

Re: [PHP] Stumped on a function

2002-06-21 Thread Jesper Brunholm
John Holmes wrote: > Why don't you just use DATE_FORMAT() in your query, then you don't have > to do any extra PHP code at all?? you might want a link to that: - look somewhat below the middle of the page >>function cleandate($indate)

RE: [PHP] Stumped on a function

2002-06-21 Thread John Holmes
Why don't you just use DATE_FORMAT() in your query, then you don't have to do any extra PHP code at all?? ---John Holmes... > -Original Message- > From: Jason Soza [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 21, 2002 3:50 AM > To: PHP-General Mailing List > Subject: [PHP] Stumped on

RE: [PHP] Stumped on a function

2002-06-21 Thread David Freeman
> function cleandate($indate) { > str_replace("-", "/", $indate); > return date("F j, Y", strtotime($indate)); > } I suspect that you actually need something like this: function cleandate($indate) { $indate = str_replace("-", "/", $indate); return date("F j, Y", strtotime

Re: [PHP] Stumped Newbie: Can't get results in db query eventhough everything checks - what am I missing?

2001-03-08 Thread Nicole Lallande
Thanks Joe - that showed me right away!! all better now -- on to the next step.. Nicole "Joe Sheble (Wizaerd)" wrote: > > I'd start by adding the mysql_error() function in your die() statement... > $result = mysql_query($sql,$connection) or die ("Couldn't get results: " . > mysql_error()); >

Re: [PHP] Stumped Newbie: Can't get results in db query even though everything checks - what am I missing?

2001-03-08 Thread Joe Sheble (Wizaerd)
I'd start by adding the mysql_error() function in your die() statement... $result = mysql_query($sql,$connection) or die ("Couldn't get results: " . mysql_error()); it might give more information to help you find the problem... At 10:15 AM 3/8/01 -0800, Nicole Lallande wrote: >Greetings, > >I

Re: [PHP] stumped on mailing a complete page

2001-03-05 Thread Chris Adams
On 3 Mar 2001 17:17:15 -0800, Brett <[EMAIL PROTECTED]> wrote: >I want to send a confirmation email upon receiving an order, and would like >to send the page that I display on the browser to the user. ob_start(); // do something mail('confirm@somewhere', 'confirmation', ob_get_contents()); ob_e

Re: [PHP] stumped on mailing a complete page

2001-03-03 Thread Simon Garner
From: "Brett" <[EMAIL PROTECTED]> > This question may have been asked a million times, but I have had no luck > searching for a difinitive answer. > > I want to send a confirmation email upon receiving an order, and would like > to send the page that I display on the browser to the user. > > I ca

Re: [PHP] stumped on mailing a complete page

2001-03-03 Thread kevin1
use $filearray = file("http://www.yourstite.com/yourscript.php?some_vars=whatever"); then $body = join (" ",$filearray); mail($to $subject,$body); or something like that. Maybe readfile() may be of use here to. You just want to read the page in as a string, so make sure that you use some m

Re: [PHP] stumped on mailing a complete page

2001-03-03 Thread Philip Murray
Hi, This might help, its a script that'll suck in a page from your site and send it as an HTML email. Its NOWHERE near perfect, and needs alot of fixing. But it works. It relys on HTML Mime Mail class from http://www.heyes-computing.net/scripts/. But I had to make a few changes to the class to m

Re: [PHP] stumped on mailing a complete page

2001-03-03 Thread Lewis Bergman
> This question may have been asked a million times, but I have had no > luck searching for a difinitive answer. > > I want to send a confirmation email upon receiving an order, and would > like to send the page that I display on the browser to the user. > > I can not figure out how to send a pa