RE: [PHP-DB] Re: Array not supported for strings???

2002-01-08 Thread Ford, Mike [LSS]
-Original Message- From: Andy [mailto:[EMAIL PROTECTED]] Sent: 04 January 2002 20:24 To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: Array not supported for strings??? $stmt= SELECT country from $DB2.$geo_T1 where country_code = '$country_id[$i]' ;

RE: [PHP-DB] Oracle date conversion

2002-01-08 Thread Ford, Mike [LSS]
-Original Message- From: David C. Norris [mailto:[EMAIL PROTECTED]] Sent: 26 December 2001 17:00 Oracle DATEs are retrieved (by ora_fetch_into($cursor, $row, ORA_FETCHINTO_NULLS), for example) as plain dates (e.g., '26-DEC-01'), losing the time of day (as in '26-DEC-01 12:34:56').

RE: [PHP-DB] oracle connectivity problem

2002-01-08 Thread Ford, Mike [LSS]
-Original Message- From: Rajiv Khandelwal [mailto:[EMAIL PROTECTED]] Sent: 27 December 2001 10:59 hi, I am facing a strange problem. I have oracle 8.1.6 (server) installed on linux and am trying to access it thru PHP from a client machine (again Linux). I was successful in

RE: [PHP-DB] mysql_num_rows

2002-01-08 Thread Ford, Mike [LSS]
-Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: 06 January 2002 20:10 I am pretty sure that the query is correct. here is the actual query: $query=select distinct(nodeid), nodename from books where bookid=$bookid;

RE: [PHP-DB] mysql_num_rows

2002-01-08 Thread Ford, Mike [LSS]
-Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: 06 January 2002 20:10 I am pretty sure that the query is correct. here is the actual query: $query=select distinct(nodeid), nodename from books where bookid=$bookid;

RE: [PHP-DB] mysql_num_rows

2002-01-08 Thread Ford, Mike [LSS]
-Original Message- From: matt stewart [mailto:[EMAIL PROTECTED]] Sent: 08 January 2002 14:10 don't know if this makes a difference, but i've always used WHERE bookid = '$bookid'; - single quote round the $bookid variable - not sure if that's the problem, or if it's just good

[PHP-DB] Using OCI, can I retrieve multiple values from DELETE/UPDATE RETURNING?

2002-05-01 Thread Ford, Mike [LSS]
Using the Oracle OCI interface, as far as I can see if I do the following: $stmt = OCIParse($conn, 'DELETE FROM TITLES' . ' WHERE TAG0' . ' RETURNING ID INTO :T_ID'); there seems to be no way of picking up more than one ID when

RE: [PHP-DB] Retrieving a date from Oracle. Please help!

2002-05-23 Thread Ford, Mike [LSS]
-Original Message- From: maxim [mailto:[EMAIL PROTECTED]] Sent: 23 May 2002 17:00 Hi all! The problem is I can't get expected datetime value from SELECT query on Oracle table that has a field of type DATE. Seems like datetime looses its time part. The default format for

RE: [PHP-DB] Retrieving a date from Oracle. Please help!

2002-05-23 Thread Ford, Mike [LSS]
-Original Message- From: maxim [mailto:[EMAIL PROTECTED]] Sent: 23 May 2002 17:00 Hi all! The problem is I can't get expected datetime value from SELECT query on Oracle table that has a field of type DATE. Seems like datetime looses its time part. The default format for

RE: [PHP-DB] MySQL/PHP dropping characters

2002-09-24 Thread Ford, Mike [LSS]
-Original Message- From: Micah Stevens [mailto:[EMAIL PROTECTED]] Sent: 23 September 2002 18:09 I've been running into a strange problem on my server with scripts that take form input and reformat it into SQL. It only happens with statements that insert or update data, the

RE: [PHP-DB] getting mysql_fetch_row into array

2002-09-24 Thread Ford, Mike [LSS]
-Original Message- From: LSC Exhibits Department [mailto:[EMAIL PROTECTED]] Sent: 23 September 2002 18:17 Going through brain-lock here. From this query Select count(deptid) from maintenance group by deptid ,I get 11 rows. What I need to do is get an array like

RE: [PHP-DB] Oracle connection problem after call to unserialize()

2002-09-24 Thread Ford, Mike [LSS]
-Original Message- From: Valantis Kamayiannis [mailto:[EMAIL PROTECTED]] Sent: 24 September 2002 12:37 I made a class called OracleCon that is used to connect to an Oracle server and provide some certain queries to the database When i create an object of that class and serialize

RE: [PHP-DB] Session understanding

2002-09-26 Thread Ford, Mike [LSS]
-Original Message- From: Griffiths, Daniel [mailto:[EMAIL PROTECTED]] Sent: 26 September 2002 16:09 as long as that same session code is present at the top of all the included files that are put in later. basicaly you need to put the session code in every page (even if you only

RE: [PHP-DB] Current row of query

2002-09-26 Thread Ford, Mike [LSS]
-Original Message- From: Patrick Lebon [mailto:[EMAIL PROTECTED]] Sent: 26 September 2002 16:20 This is how im currently doing it... $rowNum = 0; while ( $row = mysql_fetch_array($result) ) { $rowNum++; if ($rowNum % 2) { $bgCol = #EADBC6; } else { $bgCol = #EFE1CE; }

RE: [PHP-DB] echo printing a cookie

2002-10-15 Thread Ford, Mike [LSS]
-Original Message- From: Steve Dodkins [mailto:[EMAIL PROTECTED]] Sent: 15 October 2002 14:22 To: Php-Db (E-mail) Hi I'm trying to print the contents of a cookie (php 4.2.3) the syntax below is wrong but what should it be? if ($_cookie[cookiename]== TRUE) { echopyour cookie

RE: [PHP-DB] Oracle problem

2002-10-16 Thread Ford, Mike [LSS]
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 16 October 2002 08:51 To: [EMAIL PROTECTED] Has anyone out there using PHP and Oracle come across this problem? I have a text area that allows free-form text that I store in a varchar2 column. I

RE: [PHP-DB] losing my session variables

2002-10-30 Thread Ford, Mike [LSS]
-Original Message- From: Peter Beckman [mailto:beckman;purplecow.com] Sent: 30 October 2002 04:09 To: Seabird Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] losing my session variables Put session_start() somewhere in your code. .. but make sure that somewhere is before you do any

RE: [PHP-DB] Passing multiple form variable in PHP

2002-11-12 Thread Ford, Mike [LSS]
-Original Message- From: Stephen Rhodes [mailto:stephen.rhodes;scils.co.uk] Sent: 12 November 2002 16:32 Wanting to use select multiple ... in a html form and pass multiple value into a php variable but does not work. I only get a single value. Can you tell me what I am doing

RE: [PHP-DB] HTML Forms question...

2002-11-19 Thread Ford, Mike [LSS]
-Original Message- From: Rich Gray [mailto:[EMAIL PROTECTED]] Sent: 20 November 2002 01:13 If you name the checkbox as name=system[] then PHP will automatically create an array of the checkbox values which can be subsequently accessed via $_POST['system'][n] - be warned however

[PHP-DB] RE: Access to Oracle db from PHP script

2002-11-28 Thread Ford, Mike [LSS]
Sorry, I think you'd be better off asking this on the php-db mailing list, so I've copied it into this reply -- I didn't set up the Oracle I connect to, and I just make use of connect functions written for the purpose by the Oracle expert on the next desk! I have find your e-mail at this

RE: [PHP-DB] php session

2002-12-02 Thread Ford, Mike [LSS]
-Original Message- From: Chris Barnes [mailto:[EMAIL PROTECTED]] Sent: 02 December 2002 02:14 On Mon, 2002-12-02 at 02:43, John W. Holmes wrote: No, it shouldn't. So, the links are correct on one page, and they disappear on the second page? Is there a reason you're

RE: [PHP-DB] RE: adding in arrays

2002-12-10 Thread Ford, Mike [LSS]
-Original Message- From: Martin Allan Jensen [mailto:[EMAIL PROTECTED]] Sent: 10 December 2002 12:41 But, now i need to make another loop where it takes the key [2000] and put's it into $year and takes the value 300 and put it into $value Can you help me with it, am really not

RE: [PHP-DB] Global variables

2002-12-10 Thread Ford, Mike [LSS]
-Original Message- From: Jim [mailto:[EMAIL PROTECTED]] Sent: 10 December 2002 18:51 Can I define a global variable in a function and then successfully reference it in the rest of the page? Yes. (Why didn't you just try it?) Cheers! Mike

RE: [PHP-DB] Update Query Help...

2002-12-11 Thread Ford, Mike [LSS]
-Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: 10 December 2002 20:02 I have definitely isolated the problem. If I change the column name that the match is being performed on from 'id-sys' to 'id_sys' I can execute the query without

RE: [PHP-DB] Final question of the week :-)

2002-12-11 Thread Ford, Mike [LSS]
-Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED]] Sent: 10 December 2002 23:10 I use the following code to collect date from multiple tickboxes on my form: if (count($selection) = 1) { for ($i=0;$icount($selection);$i++) { echo $selection[$i]; }};

RE: [PHP-DB] Sessions problems

2003-01-06 Thread Ford, Mike [LSS]
-Original Message- From: Sabina Alejandr Schneider [mailto:[EMAIL PROTECTED]] Sent: 05 January 2003 20:17 Hello everybody I was trying to use Sessions, but I had some problems. I have an old version of the Apache, that comes with the Red Hat 7.2. when executing this in

RE: [PHP-DB] sorting matrix

2003-01-13 Thread Ford, Mike [LSS]
-Original Message- From: xxx [mailto:[EMAIL PROTECTED]] Sent: 13 January 2003 14:25 Hy, I have a matrix with strings ex. 4 cols and many rows how could I sort the matrix after the 2nd field with maintaining the indexes order Like in a table name surname age address..

RE: [PHP-DB] Concatenate two strings

2003-01-15 Thread Ford, Mike [LSS]
-Original Message- From: Bruno Pereira [mailto:[EMAIL PROTECTED]] Sent: 15 January 2003 14:48 How can i join two strings. My code is something like: $valor1=bruno; $valor2=Pereira; $valor=$valor1 + + $valor2 Can someone help me. Thanks.

RE: [PHP-DB] getting client browser info

2003-01-20 Thread Ford, Mike [LSS]
-Original Message- From: Mignon Hunter [mailto:[EMAIL PROTECTED]] Sent: 20 January 2003 16:32 Question: Why is it that from an IE client I get the following: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) Why does it say mozilla ??? The clue here is in the next word:

RE: [PHP-DB] getting client browser info

2003-01-20 Thread Ford, Mike [LSS]
-Original Message- From: Mignon Hunter [mailto:[EMAIL PROTECTED]] Sent: 20 January 2003 17:05 Does anyone know of script or tutorial to point me to that can obtain client browser info, (got that part) but then using php, be able to use if statements to distinguish what they're

RE: [PHP-DB] getting client browser info

2003-01-20 Thread Ford, Mike [LSS]
-Original Message- From: Mignon Hunter [mailto:[EMAIL PROTECTED]] Sent: 20 January 2003 18:40 Ah, but I wasnt at a mozilla browser, I was accessing this script from a ie browser client. Let me repeat -- that was the IE browser *masquerading* as Mozilla-compatible. ALL versions

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

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] 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] 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] 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] 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] PHP sort from .... best solution?

2003-06-06 Thread Ford, Mike [LSS]
-Original Message- From: A. Lyse [mailto:[EMAIL PROTECTED] Sent: 05 June 2003 21:21 Thanks! But I got a problem with the code: The PHP file as it is with the code pasted into it will i'll past at the end of this post. The problem is I get the error: Warning: Invalid argument

RE: [PHP-DB] PHP sort from .... best solution?

2003-06-06 Thread Ford, Mike [LSS]
-Original Message- From: A. Lyse [mailto:[EMAIL PROTECTED] Sent: 06 June 2003 11:34 This was sent privately to me, but I'm redirecting the response back to the list in case it helps anyone else. Feeling kinda stupid. hehe. sorry I didnt label the lines. Probably no more stupid than

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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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 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] 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] 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] 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] 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] 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] 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] 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] [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] 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] 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] 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] 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] 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] Re: Checkboxes in a table

2004-08-20 Thread Ford, Mike [LSS]
-Original Message- From: Jasper Howard Sent: 21/08/04 00:49 just set the checked value of the check boxes to something like, true, and when you are going through the check boxes in the second script do something like this: Urrr -- you script will only ever see checkboxes which are

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