Re: [PHP] Stumped - MDB2 & pgsql

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

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

[PHP] Stumped - MDB2 & pgsql

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 driver. Restarted the web s

Re: [PHP] Stumped I Tell You!

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!

[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!

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!

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!

[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!

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!

[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!

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

[PHP] Stumped I Tell You!

$getEnd = "select a.ACCOUNTID as CONTRACT, a.BALANCE/1 as BALANCE, b.STATUS, b.IMSI_ID as MDN, b.IMEI_ID as ESN, "; $getEnd .= "b.EQUIP_ID as MIN, b.MKT, b.MARKET_NAME "; $getEnd .= "FROM work.account_".$startDate." a "; $getEnd .= "JOIN work.customer_".$startDate." b "; $getEnd .= "ON ( b.CONT

[PHP] Stumped! 4.x to 5.1 problem!!

I have an extension that seems to create PHP variables correctly, and var_dump() doesn't seem to have a problem. but upon moving to 5.1.x it fails. Anyone have a suggestion? array(2) { [0]=> object(classfoo)#2 (1) { ["hostname"]=> string(3) "foo" } [1]=> object(classfoo)#3 (1)

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

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

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

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

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 to it like: http://mydo

[PHP] Stumped on a totally wierd problem

nevermind I got it. << snip >> I have something really wierd going on with a form that let's a user add/edit/delete data from a mysql database. It's like I can not edit any data that was not recently added or if it was added by another user. If I log into mysql directly under the same user I'm

[PHP] Stumped on a totally wierd problem

I have something really wierd going on with a form that let's a user add/edit/delete data from a mysql database. It's like I can not edit any data that was not recently added or if it was added by another user. If I log into mysql directly under the same user I'm using form the php script and run

Re: [PHP] Stumped

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

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

[PHP] Stumped

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/mainfile.php on line 57 42: foreach ($_GET as $secvalue) { 57

Re: [PHP] Stumped

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

[PHP] Stumped

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/mainfile.php on line 57 42: foreach ($_GET as $secvalue) { 57

Re: [PHP] stumped on mysql_num_rows

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

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

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

[snip] $sql1 = "INSERT INTO `contacts` VALUES ( $_POST['company'], $_POST['pri_name'], $_POST['sec_name'], $_POST['assistant_1'], $_PO

Re: [PHP] Stumped @ MySql insert query

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

[PHP] Stumped @ MySql insert query

Hello everyone, 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 figure out why ! // connect to the BD/Table et

Re: [PHP] stumped on mysql_num_rows

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

[PHP] stumped on mysql_num_rows

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 RETRIEVE EACH FOUND RECORD $queryResultHandle = mysql_

RE: [PHP] Stumped...

[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...

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...

- 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...

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...

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...

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...

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...

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

[PHP] Stumped...

Sorry for so many questions but this should be the last one for a while.   I have a form that I want to insert into a MySQL table. This form is based on how many entries a user wants to enter. For example, a user wants to type in 12 names, so 12 form fields appear. Or they want 50, 50 appear.

Re: [PHP] Stumped!

--- 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!

--- [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!

> 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. > > $

[PHP] Stumped!

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. $meetingNa

[PHP] Stumped: vars not passed!!!

I'm going mad. I've been trying to implement sessions so it will work backward on my older 4.0.3 server ( I'm working on a 4.1.2), with no success as of yet, but I think it's my 4.1.2 that's causing this, as the app in the following example works perfectly on the older one. Note, I have explicit

Re: [PHP] Stumped.

> 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.

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

[PHP] Stumped.

In a file with functions only, one of the functions is structured like -> function foo() { if (isset($_POST['submit'])) { /* DO SOME SQL */ header('location: x'); } else { /* SHOW A FORM HERE */ } } I noticed today that when I turned off outp

Re: [PHP] Stumped on a function

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

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

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 >

RE: [PHP] Stumped on a function

> 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

[PHP] Stumped on a function

I've been using the following function successfully for months, tonight I literally copied/pasted it to another page I was creating, called it exactly the same using the same data type, and I'm getting an incorrect result. The function is supposed to take a standard MySQL "CCYY-MM-DD" date format

[PHP] stumped

Hi, I need to find a solution to this. I am lost. To see what I talk about check vvmm.net/search.php3. I am using php 4 offline. Based on whatever the viewer select I get the below script to build the select statements accordingly. Everything is working fine now. I want to add another featu

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

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?

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

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

Greetings, I keep getting the message that I cannot get results. I have a simple user authentication code that uses a mysql database to authenticate from. Initially I had the code working when I had the mysql_connect variables in the code itself. When I moved the connection variables to an inc

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

Greetings, I keep getting the message that I cannot get results. I have a simple user authentication code that uses a mysql database to authenticate from. Initially I had the code working when I had the mysql_connect variables in the code itself. When I moved the connection variables to an inc

Re: [PHP] stumped on mailing a complete page

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

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

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

[EMAIL PROTECTED]> Sent: Sunday, March 04, 2001 2:22 PM Subject: [PHP] stumped on mailing a complete page > 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,

Re: [PHP] stumped on mailing a complete page

> 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

[PHP] stumped on mailing a complete page

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 page, like the l