RE: [PHP-DB] Corn job anomaly

2016-09-27 Thread Ford, Mike
> -Original Message- > From: Karl DeSaulniers [mailto:k...@designdrumm.com] > Sent: 25 September 2016 09:59 > To: PHP List Database > Subject: Re: [PHP-DB] Corn job anomaly > > Now I am getting an error with mysql syntax. > > "SELECT otn.*, cf.* FROM ".ORDER_TABLE."

RE: [PHP-DB] Re: Formatting

2012-11-26 Thread Ford, Mike
-Original Message- From: Karl DeSaulniers [mailto:k...@designdrumm.com] Sent: 26 November 2012 08:48 To: php-db@lists.php.net Subject: Re: [PHP-DB] Re: Formatting Ethan, is this valid PHP? What is the ampersand for? What is it doing? Just curious. $args[] = $_POST[$k]; // Note

RE: [PHP-DB] SELECT

2011-10-21 Thread Ford, Mike
-Original Message- From: tamouse mailing lists [mailto:tamouse.li...@gmail.com] Sent: 20 October 2011 21:37 On Tue, Oct 18, 2011 at 5:36 AM, Ford, Mike m.f...@leedsmet.ac.uk wrote: -Original Message- From: Ron Piggott [mailto:ron.pigg...@actsministries.org] Sent: 17

RE: [PHP-DB] SELECT

2011-10-18 Thread Ford, Mike
-Original Message- From: Ron Piggott [mailto:ron.pigg...@actsministries.org] Sent: 17 October 2011 18:38 I need help creating a mySQL query that will select the correct introduction message for a website I am making. The way I have designed the table I can’t wrap my mind around

RE: [PHP-DB] Re: Stuck in apostrophe hell

2010-08-04 Thread Ford, Mike
-Original Message- From: Simcha Younger [mailto:sim...@syounger.com] Sent: 04 August 2010 08:19 paul_s_john...@mnb.uscourts.gov wrote: THE INPUT: $sql_insert_registration = sprintf(INSERT INTO Registrations ( Class_ID, prid, Registrant,

RE: [PHP-DB] losing MySQL resource

2009-11-11 Thread Ford, Mike
-Original Message- From: Nehemias Duarte [mailto:ndua...@aflac.com] Sent: 11 November 2009 14:25 To: Stan; php-db@lists.php.net Subject: RE: [PHP-DB] losing MySQL resource I was under the impression that session_start() had to be the FIRST thing ran in the script. Is this

RE: [PHP-DB] newbie: how to return one iteration *per unique date (DAY!)* in a timestamp column?

2009-08-05 Thread Ford, Mike
-Original Message- From: Govinda [mailto:govinda.webdnat...@gmail.com] Sent: 05 August 2009 01:41 Taking this: SELECT count(*) AS `CountUniqueDatesInMyTbl`, date(solarAWDateTime) AS `uniqueDate`, 'aweber_7solar_aw' AS `tableAlias` FROM aweber_7solar_aw GROUP BY

RE: [PHP-DB] Postgres query failing, not enough info for debugging...

2009-06-17 Thread Ford, Mike
On 16 June 2009 15:57, Carol Walter advised: Hello, I'm using PHP 5 and PostgreSQL 8.3.6. I have a query that is failing and I don't know how to troubleshoot the problem. The error message that it is giving is quite vague. The error message is as follows: Warning: pg_query_params()

RE: [PHP-DB] Re: PHP and table/view names with '$'

2009-04-23 Thread Ford, Mike
On 23 April 2009 11:36, Mark Casson advised: Hi Guys, Thanks to you both - you are spot on! Shame this is not better documented somewhere. I don't know how much better documented it can be than at http://php.net/language.types.string ... ;) Cheers! Mike -- Mike Ford, Electronic

RE: [PHP-DB] variable with NULL value

2007-05-04 Thread Ford, Mike
On 03 May 2007 16:22, OKi98 wrote: Hi, one more question. Why the variable, that contains NULL value appears to be not set. U -- because that's how it's defined?? (http://php.net/isset) Cheers! Mike - Mike Ford,

RE: [PHP-DB] weird comparsion

2007-05-03 Thread Ford, Mike
On 03 May 2007 12:30, OKi98 wrote: I know about identity operator (===) but with == operator 0 is false and foo is true No, that's not correct. , try this: $foo=0; $bar=bar; if ($foo) echo($foo is true, ); else echo($foo is false, ); if ($bar) echo($bar is true, ); else

RE: [PHP-DB] detecting negative numbers

2006-07-17 Thread Ford, Mike
On 17 July 2006 01:07, Dave W wrote: No, I get it. I just thought that there might have been some built in function like if(neg_num($quant - $amount)) or something like that. I know how to do it, but I thought that there might have been an alternate method. Just because I asked a simple

RE: [PHP-DB] PHPSESSID how to append and access

2006-05-25 Thread Ford, Mike
On 25 May 2006 12:12, Girish Agarwal wrote: Hi All, I am using header(Location: http://dv-medical/phpscripts/test.php;) function to hop from one Page to Another in My Web Application My Problem is I have been unable to get the exact syntax to append the Session ID to the

RE: [PHP-DB] Displaying results from a query properly.

2006-03-27 Thread Ford, Mike
On 24 March 2006 16:40, Alex Major wrote: Thanks, works like a charm (had to make is -2 instead of -1 as it added a space after each result). Hadn't thought of something so simple. On 24/3/06 16:22, Bastien Koert [EMAIL PROTECTED] wrote: Build it up as a string and remove the trailing

RE: [PHP-DB] Quick question

2005-12-09 Thread Ford, Mike
On 08 December 2005 20:53, Chris Payne wrote: Hi there everyone, How do I set the following items with ini_set()? I looked at the manual but when I try nothing happens: * file_uploads * upload_max_filesize * max_input_time * memory_limit *

RE: [PHP-DB] problem of transmiting variabl into another page?

2005-12-07 Thread Ford, Mike
On 02 December 2005 13:06, Bastien Koert wrote: ?php for ($j=ord('A'); $j = ord('Z'); $j++) { echo | ba href='alpha.php?artist=.chr($j).'.chr($j)./a/b ; } ? You need to use the ORD function to get the numerical ascii equivalent of the letter and the CHR function to go back the

RE: [PHP-DB] timestamp

2005-02-01 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm -Original Message- From: Balwant Singh [mailto:[EMAIL PROTECTED] Sent: 01 February 2005 08:08 on echoing $timestamp i m getting Fri Jan 28 19:53:09 2005 but on

RE: [PHP-DB] mysql - image storing

2005-01-18 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 18 January 2005 17:11, Joseph Crawford wrote: Jason, can you explain why stripslashes should not be used on data taken from the db? when you store data in the db i thought it

RE: [PHP-DB] php latest release!

2005-01-10 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 10 January 2005 09:28, JeRRy wrote: With PHP latest release from http://php.net/ do we require to update Zend Optimizer? Yes. People are claiming some scripts previously

RE: [PHP-DB] Trying to connext to MySQL with PEAR

2005-01-07 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 06 January 2005 21:10, Norland, Martin wrote: -Original Message- From: Ford, Mike [mailto:[EMAIL PROTECTED] Sent: Thursday, January 06, 2005 1:13 PM Subject: RE

RE: [PHP-DB] PHP query to mysql database returns emtpy data, but Query Browser shows records

2005-01-07 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 07 January 2005 03:25, Jason Walker wrote: Graeme - you were moving in the right direction. Since the data in the field is varchar(250), the only thing that changes is the

RE: [PHP-DB] Trying to connext to MySQL with PEAR

2005-01-06 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 06 January 2005 16:39, Jochem Maas wrote: Hutchins, Richard wrote: echo $dsn; $isPersistant = TRUE; doesn't effect the code but 'Persistant' is spelled 'Persistent' Oh

RE: [PHP-DB] _POST, _GET, _REQUEST not working

2004-12-23 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 23 December 2004 01:12, Keane, Warren A FIN:EX wrote: I did try if (empty($_GET)) { parse_str($_SERVER['QUERY_STRING'],$_GET); } which worked so I guess I should be able

RE: [PHP-DB] still Parse errors ,,, can you. impart me about it.

2004-12-23 Thread Ford, Mike
then on 102 thank you. Ford, Mike [EMAIL PROTECTED] wrote: To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 21 December 2004 07:58, amol patil wrote: hallo friend, i have developed simple and small database

RE: [PHP-DB] Parse errors ,,, can you. impart me about it.

2004-12-22 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 21 December 2004 07:58, amol patil wrote: hallo friend, i have developed simple and small database website using php ,html and java script. but i am getting these three

RE: [PHP-DB] _POST, _GET, _REQUEST not working

2004-12-22 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 20 December 2004 21:50, Warren wrote: Hello, I am running PHP 4.39 as a CGI under Tomcat 5.025, Linux 2.4.20-31.9. Configure = './configure'

RE: [PHP-DB] date conversions

2004-12-16 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 16 December 2004 06:00, neil wrote: Hi I am needing to convert a d/m/y date such as 30/11/2004 into the format that mysql can use ie. 2004-11-20 If I try the following:

RE: [PHP-DB] PHP 4.3.10RC2 - Any change in the way rows are fetch ed ?

2004-12-16 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 16 December 2004 12:51, Vincent KONIECZEK wrote: Hi there, I was testing PHP 4.3.10RC2 with a well-tested web application when I saw it failed badly. After a little

RE: [PHP-DB] mysql_array_array

2004-12-03 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 03 December 2004 13:15, Yemi Obembe wrote: $sql = SELECT * FROM arcadia WHERE email=$v; $sql_in = INSERT INTO arcadia ('email') VALUES ('$v'); Spot the difference: you

RE: [PHP-DB] Question: For no results

2004-12-03 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 03 December 2004 14:39, Stuart Felenstein wrote: I want to send back a message when no matches are found on my search page. Basically No matches found. I assumed that

RE: [PHP-DB] Question: For no results

2004-12-03 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 03 December 2004 15:06, Stuart Felenstein wrote: The closing ? of a PHP segment also implies an end-of-statement semicolon -- so the above is equivalent to: if

RE: [PHP-DB] Question: For no results

2004-12-03 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 03 December 2004 15:16, Stuart Felenstein wrote: --- Stuart Felenstein [EMAIL PROTECTED] wrote: The reason the close is there is because the next line of code is the

RE: [PHP-DB] Question: For no results

2004-12-03 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 03 December 2004 15:26, Stuart Felenstein wrote: --- Ford, Mike [EMAIL PROTECTED] wrote: Well, your taste seems to be to use { }, so :-endif is irrelevant. Alright it's

RE: [PHP-DB] Question: For no results

2004-12-03 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 03 December 2004 15:26, Stuart Felenstein wrote: --- Ford, Mike [EMAIL PROTECTED] wrote: Well, your taste seems to be to use { }, so :-endif is irrelevant. Alright it's

RE: [PHP-DB] Multi-User Update Problem

2004-12-01 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 30 November 2004 14:45, SCALES, Andrew wrote: Thanks very much for your help. The main difficulty I was having really was unlocking the record again if the user crashed out

RE: [PHP-DB] Transaction suddenly not working

2004-11-29 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 29 November 2004 13:19, Stuart Felenstein wrote: Now the printout of the query is this: 0: INSERT INTO Table1 (LurkID, ProfileName, Edu, WorkAuth, WorkExp, CarLev, Secu,

RE: [PHP-DB] PHP / Javascript question

2004-11-16 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 16 November 2004 03:03, Chris Payne wrote: This is OT, really, but because it's an easy answer: if ( document.removeitems.del.value == ) BUT because the tickboxes

RE: [PHP-DB] Re: Subject: Javascript Question (Was PHP / Javascri pt question)

2004-11-16 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 16 November 2004 15:12, Neil Smith wrote: That if (df[i].checked=true) { should of course read if (df[i].checked==true) { No it shouldn't -- it should read if

RE: [PHP-DB] Persistent Connections to Oracle databases

2004-11-15 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 11 November 2004 19:11, Patrick David wrote: My understanding of persistent connections was that using the ociplogon function a connection would be opened to the database and

RE: [PHP-DB] Forms list from database

2004-11-02 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 01 November 2004 21:11, Jason T. Davidson wrote: Here is the code: form name=form1 method=post action=staff_code/add_code.php table width=600 border=0 align=center

RE: [PHP-DB] Problems with mysql_num-rows()

2004-11-01 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 01 November 2004 05:01, Doug Thompson wrote: The variables are not being expanded. As a minimum, you need to escape the single quotes. $query = SELECT * from user where

RE: [PHP-DB] Convert plain text to HTML tagged text

2004-09-28 Thread Ford, Mike
On 28 September 2004 18:15, [EMAIL PROTECTED] wrote: To the list: I've googled and searched the manual, but I'm still looking for a simple solution to a simple problem. I have a MySQL database of text stories in longtext MySQL fields. These stories have simple returns (\r) in them and no

RE: [PHP-DB] MultSelect ListBox hell!

2004-09-24 Thread Ford, Mike
On 23 September 2004 20:53, Stuart Felenstein wrote: So here is what I have: //Here is defines the field variable and uses //CodeCharge function to grab the variable $s_Industry = CCGetParam(s_Industry, ); $s_LocationState = CCGetParam(s_LocationState, ); $s_TaxTerm =

RE: [PHP-DB] MultSelect ListBox hell!

2004-09-23 Thread Ford, Mike
On 22 September 2004 18:45, Stuart Felenstein wrote: Just to confirm, This is what I'm going to start with: Yeah, I'd say you've pretty much got it, except... //base sql statement $sql = select * from jobs where record_deleted = 'NO' ; if (isset($_POST['states'])){ Your SQL is going to

RE: [PHP-DB] Using PHP to generate SQL statement

2004-09-23 Thread Ford, Mike
On 23 September 2004 07:47, Ed Lazor wrote: I keep looking at the following code and thinking there's gotta be a better way. I've been in front of the computer all day tho and I'm drawing a blank. Any ideas? Seems to me we've just answered a very similar question to this (and I'd be

RE: [PHP-DB] MultSelect ListBox hell!

2004-09-22 Thread Ford, Mike
-Original Message- From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: 22 September 2004 15:27 [] //base sql statement $sql = select * from jobs where record_deleted = 'NO' ; if (isset($_POST['states'])){ //check to see if the states is an array (multiple items or just

RE: [PHP-DB] MultSelect ListBox hell!

2004-09-22 Thread Ford, Mike
-Original Message- From: John Holmes [mailto:[EMAIL PROTECTED] Sent: 22 September 2004 16:39 From: Ford, Mike [EMAIL PROTECTED] if (is_array($_POST['state'])){ This check isn't really necessary in PHP, since $_POST['state'] will *always* be an array if the form field

RE: [PHP-DB] MultSelect ListBox hell!

2004-09-22 Thread Ford, Mike
-Original Message- From: Stuart Felenstein [mailto:[EMAIL PROTECTED] Sent: 22 September 2004 16:45 --- Ford, Mike [EMAIL PROTECTED] wrote: if (is_array($_POST['state'])){ $sql .= (; $x = 0; foreach ($_POST['state'] as $state) if ($x == 0

RE: [PHP-DB] Re: Checkboxes in a table

2004-08-20 Thread Ford, Mike [LSS]
-Original Message- From: Ford, Mike [LSS] Sent: 21/08/04 01:57 foreach ($_POST['checkbox'] as $key=$irrelevant): // checkbox[$key] was checked endif; OK, it's 2a.m. here and I'm about asleep, whioch is why that last line didn't read endforeach

RE: [PHP-DB] Inserting a ' into mySQL

2004-08-20 Thread Ford, Mike [LSS]
-Original Message- From: Ron Piggott Sent: 21/08/04 01:53 [] One of the problems I am now having is if the user types an ' into their entry --- these ones do not get saved into the mySQL database. [] I can look at this and understand that if an ' is keyed why it wouldn't

RE: [PHP-DB] I have a CR-LF problem when pulling stuff out of my DB

2004-08-19 Thread Ford, Mike [LSS]
On 19 August 2004 17:02, Michael Cortes wrote: ctrl-m is a carriage return. Does anyone know what ctrl seqence is line feed? ctrl-j (CR and LF are ASCII codes 13 and 10, so ctrl+ the 13th and 10th letters of the alphabet respectively!) Cheers! Mike

RE: [PHP-DB] Check Boxes

2004-08-18 Thread Ford, Mike [LSS]
On 18 August 2004 11:24, randy wrote: $chkboxes = $_POST['ch']; $sql = 'SELECT '; foreach($chkboxes as $k = $v) { $sql .= $v; if($k (sizeof($chkboxes) - 1)) { $sql .= ', '; } } $sql .= ' FROM form'; $sql = 'SELECT ' . implode(', ', $chkboxes) .

RE: [PHP-DB] Check Boxes

2004-08-18 Thread Ford, Mike [LSS]
On 18 August 2004 15:53, John Holmes wrote: Ford, Mike [LSS] wrote: $chkboxes = $_POST['ch']; $sql = 'SELECT '; foreach($chkboxes as $k = $v) { $sql .= $v; if($k (sizeof($chkboxes) - 1)) { $sql .= ', '; } } $sql .= ' FROM form

RE: [PHP-DB] OCI8

2004-08-13 Thread Ford, Mike [LSS]
On 13 August 2004 13:29, yannick wrote: I have some trouble with Oracle Database and php... see this code: ? while (1) { $conn=OCILogon($username,$password,$database); Try OCIPLogon() rather than OCILogon(). $stmt=OCIParse($conn,select 50 as toto from dual);

RE: [PHP-DB] Date problem: data is current as of yesterday

2004-07-03 Thread Ford, Mike [LSS]
-Original Message- From: Karen Resplendo To: [EMAIL PROTECTED] Sent: 02/07/04 19:36 Subject: [PHP-DB] Date problem: data is current as of yesterday The database queries all the sources at night after everyone has gone home. That means the data was current as of yesterday. This little

RE: [PHP-DB] More problems with searching

2004-07-01 Thread Ford, Mike [LSS]
On 01 July 2004 18:36, Justin Patrin wrote: On Thu, 1 Jul 2004 12:28:46 -0500, Shiloh Madsen [EMAIL PROTECTED] wrote: After the very kind help i was given last night I have the query being built right, however the query does not work. Just to refresh, the gentlemen who had helped me

RE: [PHP-DB] [PHP]: session problem

2004-06-25 Thread Ford, Mike [LSS]
On 24 June 2004 16:44, H. J. Wils wrote: this is the code, but this code works on my hosting provider but not on my own server. I think i have to change settings in php.ini but dont know which... first page: session_start(); include connect.php; include functions.php;

RE: [PHP-DB] Image / file uploader

2004-04-30 Thread Ford, Mike [LSS]
On 30 April 2004 01:10, Craig Hoffman wrote: When I put single quotes in the PHP_SELF and I get this error: Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING and I can't use double quotes because its in an echo statement. What

RE: [PHP-DB] quotations in value field

2004-04-14 Thread Ford, Mike [LSS]
On 14 April 2004 15:21, Mikael Grön wrote: On Apr 14, 2004, at 15:14, H-Mac Moderator wrote: Mikael- I suspect you want htmlspecialchars, Not stripslashes. See: http://us4.php.net/manual/en/function.htmlspecialchars.php Well, I guess a combination of htmlspecialchars and some other

RE: [PHP-DB] How to redirect after a valid login

2004-03-15 Thread Ford, Mike [LSS]
On 14 March 2004 02:14, Benjamin wrote: What kind of error does it give you? Because in the snippet you gave us you wrote include mainmenu.php; // Which gives me an error ! And that should give you an error because it should be include( mainmenu.php ); //note parenthesies Nope.

RE: [PHP-DB] win32 Timestamp problem

2004-03-10 Thread Ford, Mike [LSS]
On 09 March 2004 20:36, J. Kevin C. Burton wrote: Hey all, after reading documentation on the Win32 bug regarding Timestamps not being able to go prior than 1970.. I am in need of a way to calculate someone's age. Has anyone found a fix or workaround for this bug? Or a way to calculate

RE: [PHP-DB] Two Column Sort

2004-03-05 Thread Ford, Mike [LSS]
On 04 March 2004 19:04, [EMAIL PROTECTED] wrote: On Thu, 4 Mar 2004 10:55:20 -, Ford, Mike [LSS] [EMAIL PROTECTED] wrote: On 03 March 2004 17:07, [EMAIL PROTECTED] wrote: Here's the php code for the sort command: echo tddiv align='center'font size='3'bCBC

RE: [PHP-DB] ocistatement

2004-03-05 Thread Ford, Mike [LSS]
On 05 March 2004 09:38, Torsten Lange wrote: Hello, I receive an array from an OCIFetchStatement() and want to address its elements by indices, which fails. The original select has two columns. How do I have to visualize that array? I want to load it into an option list. I tried also some

RE: [PHP-DB] Two Column Sort

2004-03-05 Thread Ford, Mike [LSS]
On 05 March 2004 14:49, Ken Colburn wrote: Mike - I've tried your options and I get either an error message, no sorting, or sorting that does not do both columns with B's at the top. It's my understanding that I must still use sort_field and sort_order (though I tried just ORDER BY). It

RE: [PHP-DB] Two Column Sort

2004-03-04 Thread Ford, Mike [LSS]
On 03 March 2004 17:07, [EMAIL PROTECTED] wrote: I'm re-raising an issue I never quite resolved which has become more critical. I want to sort a table on two columns. There are about 440 rows of which about 400 are blank in the first sort column (CBC); the other rows show B in that column.

RE: [PHP-DB] oracle: fetch a query result into an array

2004-02-18 Thread Ford, Mike [LSS]
On 18 February 2004 18:22, Torsten Lange contributed these pearls of wisdom: while(OCIFetch($stmt)) { $column_name = OCIResult($stmt,'COLUMN_NAME'); missing [] here -- should be: $column_name[] = OCIResult($stmt,'COLUMN_NAME');

RE: [PHP-DB] Inserting querydata as default value in form

2004-01-28 Thread Ford, Mike [LSS]
On 28 January 2004 18:05, Georg Herland wrote: Hi! I hav made a simle page to insert update and delete data in MYSQL. I try to put existing data into a standard form field to make editing easyer: input name=link TYPE=TEXT cols=40 value=$query_data[4] Problem is when the text data contains

RE: [PHP-DB] Quick Question: Line Breaks

2004-01-09 Thread Ford, Mike [LSS]
On 09 January 2004 03:58, Jacob Hackamack wrote: Hello, I have a couple of quick questions. When I execute this code on my php page (I know that the .PSD image isn¹t web ready, but Safari does what I need it to do :) ) it displays the entire source as one line. Is there anyway to have it

RE: [PHP-DB] inserting dynamic drop down menu data into mysql

2004-01-07 Thread Ford, Mike [LSS]
On 07 January 2004 15:12, Duane Barnes contributed these pearls of wisdom: I'm having a problem with a standard html form. I'm using a php function to populate a drop down menu on a standard form. I want the contents of the submitted form to insert into a mysql table. All of the variables

RE: [PHP-DB] Search Query

2003-12-18 Thread Ford, Mike [LSS]
On 18 December 2003 05:26, Ng Hwee Hwee wrote: Dear all, i need help with my search query statement.. what is wrong with my code? Nothing obvious that I can see, except a little inefficiency. Where do $keyword and $table come from? -- is this a register_globals issue? snip $word

RE: [PHP-DB] How do I get quotes around strings to display?

2003-10-22 Thread Ford, Mike [LSS]
On 22 October 2003 00:41, [EMAIL PROTECTED] wrote: $fieldarray = array(one,Two, three, four); $line = \.implode(\,\,$fieldarray) .\; Eck, eck, eck!! Definitely a construct crying out for single quotes rather than double: $line = ''.implode(',',$fieldarray) .''; Cheers! Mike

RE: [PHP-DB] Dynamic sites, to appear static...?

2003-09-04 Thread Ford, Mike [LSS]
On 04 September 2003 11:18, [EMAIL PROTECTED] wrote: I've been building web sites that use a database backend for some time now. I typically use the format. http://www.mysite.com/index.php?page=contact http://www.mysite.com/index.php?page=home http://www.mysite.com/index.php?page=aboutus

RE: [PHP-DB] include_path problem

2003-09-03 Thread Ford, Mike [LSS]
On 03 September 2003 01:32, Bruce Levick contributed these pearls of wisdom: Well yes I have restarted my webserver, and the php.ini file is under the windows directory (shown in phpinfo page) and I am definatelty editing it. The current value for my include_path is .;c:\php\includes

RE: [PHP-DB] Consider upgrading MySQL client .... how do I do this?

2003-09-03 Thread Ford, Mike [LSS]
On 03 September 2003 10:51, Vinoaj Vijeyakumaar contributed these pearls of wisdom: Hi, Just this morning I upgraded to MySQL 4.1.0 alpha and PHP 4.3.3. I'm also running Apache 2 on a WinXP machine. The main reason for the upgrade was so that I could make use of 4.1.0's sub-select

RE: [PHP-DB] include_path problem

2003-09-03 Thread Ford, Mike [LSS]
On 03 September 2003 14:10, Bruce Levick contributed these pearls of wisdom: There is an include_path for unix and an include_path for windows. They both differ slightly but aren't of the same value that is being returned in the php info page or the error that I am receiving. This is the

RE: [PHP-DB] include_path problem

2003-09-02 Thread Ford, Mike [LSS]
On 02 September 2003 08:00, Bruce Levick wrote: Hi guys, I am re-developing the look and feel of a site and trying to set it up localy. Its all setup and ready to go but I am getting a pear.php include failure. Warning: main(/PEAR.php): failed to open stream: No such file or directory

RE: [PHP-DB] To slash or not to slash....

2003-09-02 Thread Ford, Mike [LSS]
On 02 September 2003 16:45, Craig Cameron wrote: Ok simple problem I hope. Have the following code, used to store the location and a few details about meeting minutes. snip $connection = mssql_connect(server,user,password);

RE: [PHP-DB] Beta 2 of plPHP released.

2003-08-29 Thread Ford, Mike [LSS]
On 29 August 2003 05:27, Joshua D. Drake wrote: Hello, Beta 2 of plPHP has been released. This version contains many bug fixes. For example, if you write bad plphp code and try to execute it, the code will no longer crash PostgreSQL ;). It would be nice if you told us what plPHP

RE: [PHP-DB] weird php error

2003-08-29 Thread Ford, Mike [LSS]
On 29 August 2003 06:39, OpenSource wrote: Hi guys, This is weird to me.. I got this script --- ?php if ($_GET[login] == 'forgot') { echo Sorry I forgot my password; } else { echo you are

RE: [PHP-DB] Populating an array from mysql db

2003-08-28 Thread Ford, Mike [LSS]
On 28 August 2003 17:25, mike karthauser wrote: on 28/8/03 5:00 pm, CPT John W. Holmes at [EMAIL PROTECTED] wrote: Thanks for this - I ended up rehashing my query to this: ? $result = mysql_query(SELECT * FROM dates WHERE bookcode = '$bookcode' ORDER BY date1,$db);

RE: [PHP-DB] Maximum execution time of 30 seconds exceeded

2003-08-14 Thread Ford, Mike [LSS]
On 11 August 2003 07:02, Michael Cortes wrote: I am using the Konqueror browser and browing to http://localhost/my.php Howerver, the script I wrote, doing various queries and lookups, inserts, etc.. takes a while to complete. That is fine with me. I'll wait. However, the server

RE: [PHP-DB] Searching a file for text surrounded by brackets

2003-07-16 Thread Ford, Mike [LSS]
-Original Message- From: Jamie Saunders [mailto:[EMAIL PROTECTED] Sent: 16 July 2003 11:20 Hi, I need a way of searching a file for text between two brackets, below is an example of a couple of lines from the file I'm searching: trtdfont size=2{L_LOGIN}/font/td/tr trtdfont

RE: [PHP-DB] problem with starting a session

2003-07-15 Thread Ford, Mike [LSS]
-Original Message- From: Ahmed Abdelaliem [mailto:[EMAIL PROTECTED] Sent: 15 July 2003 08:54 i have a problem with starting a session in the page that validates the user input and sends it tothe database, when the user clicks register he gets this error Warning:

RE: [PHP-DB] error checking question

2003-06-27 Thread Ford, Mike [LSS]
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 26 June 2003 20:22 What I would like to do is somehow have a redundant error check on the server side and then display an error message above the form on the main page should fields be left blank or

RE: [PHP-DB] latest version of php only cgi?

2003-06-27 Thread Ford, Mike [LSS]
-Original Message- From: Doug Finch [mailto:[EMAIL PROTECTED] Sent: 26 June 2003 21:12 Is the newest version of php 4 only available as a cgi-based program? DF No. Cheers! Mike - Mike Ford, Electronic

RE: [PHP-DB] moving though an array..SOLVED

2003-06-26 Thread Ford, Mike [LSS]
-Original Message- From: Aaron Wolski [mailto:[EMAIL PROTECTED] Sent: 26 June 2003 16:12 Solved my problem! Here's the code in case anyone really cares :P $col = explode(,,$threadsColumn); $col_search = (; for ($i=0;$icount($col);$i++) {

RE: [PHP-DB] setting session variables via a form

2003-06-16 Thread Ford, Mike [LSS]
-Original Message- From: Hutchins, Richard [mailto:[EMAIL PROTECTED] Sent: 16 June 2003 17:08 session_start(); session_register(isRegistering); $_SESSION[isRegistering] = true; B't! If you're using the $_SESSION array, then you MUST NOT use

RE: [PHP-DB] Help Please!! Oracle/PHP connection

2003-06-11 Thread Ford, Mike [LSS]
-Original Message- From: Matthew Moldvan [mailto:[EMAIL PROTECTED] Sent: 11 June 2003 01:03 Have you tried the built in Oracle functions in PHP? http://us3.php.net/oracle That's only for Oracle up to version 7. For Oracle 8 or 9, use the OCI extension http://www.php.net/oci8.

RE: [PHP-DB] Is this query even possible?

2003-06-10 Thread Ford, Mike [LSS]
-Original Message- From: Susan Ator [mailto:[EMAIL PROTECTED] Sent: 10 June 2003 16:18 This is what I am trying to do: if ($FUNC==(USERPOST) || $FUNC==(MODU)) { $sql = UPDATE newdacs SET emailfwd='$emailfwd',

RE: [PHP-DB] Count database-values

2003-06-10 Thread Ford, Mike [LSS]
-Original Message- From: Becoming Digital [mailto:[EMAIL PROTECTED] Sent: 10 June 2003 12:15 I screwed up my own code. Silly me. It should read: Surely your first attempt is the right one? There's only ever going to be 1 Total, so why waste a while loop trying to read more than

RE: [PHP-DB] Is this query even possible?

2003-06-10 Thread Ford, Mike [LSS]
-Original Message- From: Matthew Moldvan [mailto:[EMAIL PROTECTED] Sent: 10 June 2003 16:50 As for the line breaks, I've used SQL formatted that way before and it hasn't cause me any problems. It's a matter of preference, but I prefer to keep my query strings as lean as possible

RE: [PHP-DB] while - if - problem

2003-06-05 Thread Ford, Mike [LSS]
-Original Message- From: Earl [mailto:[EMAIL PROTECTED] Sent: 04 June 2003 22:04 To: PHP-DB FYI this was beginning to bug me out... so I decided to try the trim function and walla... it worked. Thanks for ya'll assistance. I was going to say this even before you added

RE: [PHP-DB] Array Pointer

2003-06-04 Thread Ford, Mike [LSS]
-Original Message- From: Ian Fingold [mailto:[EMAIL PROTECTED] Sent: 03 June 2003 16:58 Ok I'm trying to write this function to up date some fields in my database so i'm grabbing some info from a query and throwing it into an array (with mysql_fetch_array). one of the values

RE: [PHP-DB] PHP sort from a database variable..?

2003-06-04 Thread Ford, Mike [LSS]
-Original Message- From: heilo [mailto:[EMAIL PROTECTED] Sent: 03 June 2003 23:35 sorry, needed some time to hack this one ::) as your print_r shows that you have to sort an array which includes objects (in this case an ingress-class - whatever this is). i tried to simulate

RE: [PHP-DB] Multiple inserts revisited

2003-05-29 Thread Ford, Mike [LSS]
-Original Message- From: Becoming Digital [mailto:[EMAIL PROTECTED] Sent: 28 May 2003 23:38 My other option, as I saw it, was to loop through the items, appending value data to the query text with each iteration. If that seems cryptic, here's a basic idea of what I mean. ?

RE: [PHP-DB] Re: deleting records using a checkbox

2003-03-21 Thread Ford, Mike [LSS]
-Original Message- From: Paul Burney [mailto:[EMAIL PROTECTED] Sent: 20 March 2003 15:22 on 3/20/03 1:45 AM, olinux at [EMAIL PROTECTED] appended the following bits to my mbox: [ and ] are illegal characters. #javascript I'm coming into this a bit late, so I'm not sure

RE: [PHP-DB] Re: Does Php support Flash files ?

2003-03-20 Thread Ford, Mike [LSS]
-Original Message- From: Matthew Moldvan [mailto:[EMAIL PROTECTED] Sent: 19 March 2003 18:32 I am assuming English isn't your first language. Yes, fuck is definitely swearing, cursing, or whatever else you would like to call it. And yes, it is considered rude in our culture.

RE: [PHP-DB] Final Date Question :-)

2003-02-20 Thread Ford, Mike [LSS]
-Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED]] Sent: 20 February 2003 01:52 OK here is a final date question. It's complex (Atleast to me :-( but i'm totally stumped. Here's what I need to do. Say September is Summer and October is winter, now getting the

RE: [PHP-DB] More help with mysql -- solved (bizarre)

2003-02-18 Thread Ford, Mike [LSS]
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 18 February 2003 08:26 If I remove the '|| die' part from the mysql_query() statement, it works fine. This is bizarre, but there it is. ie, if I have: $result = mysql_query(SELECT * FROM SOME_TABLE);

RE: [PHP-DB] Re: problems with variables

2003-02-04 Thread Ford, Mike [LSS]
-Original Message- From: Mark [mailto:[EMAIL PROTECTED]] Sent: 04 February 2003 14:38 Just a quick correction... if the q part is static, I believe you should use $(q$i) rather than ${$q . $i} Well, actually, I think you want ${'q'.$i} -- or even ${q$i} Cheers! Mike

  1   2   >