> -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 woul
> -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 t
> -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 w
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
--
On 18 August 2004 15:53, John Holmes wrote:
> Ford, Mike [LSS] wrote:
>
> > > $chkboxes = $_POST['ch'];
> > > $sql = 'SELECT ';
> > > foreach($chkboxes as $k => $v)
> > > {
> > > $sql .= $
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(', ',
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");
> OCIDefineByName($stmt
-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
snipp
osted an example of this to the list). But both ways can be considered valid
approaches -- it just depends on what seems better (or more elegant, if you like!) to
you.
> - Original Message -
> From: "Ford, Mike [LSS]" <[EMAIL PROTECTED]>
>
> > On
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 h
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";
>
>
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. W
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 s
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 parenthesi
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 cal
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).
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
> list. I tried also some e
On 04 March 2004 19:04, [EMAIL PROTECTED] wrote:
> On Thu, 4 Mar 2004 10:55:20 -0000, Ford, Mike [LSS]
> <[EMAIL PROTECTED]> wrote:
>
> > On 03 March 2004 17:07, [EMAIL PROTECTED] wrote:
> >
> > > Here's the php code for the sort
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 col
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');
>
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:
> Problem is when the text data contains a space ie "Look
> here". Then only the
> first w
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 ha
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
> vari
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?
>
> $wor
On 11 December 2003 11:52, Constantin Brinzoi wrote:
> I know it is possible to search a database like this:
>
> SELECT * FROM x_table WHERE name="%part_of_name%"
>
> but I don't know for sure the correct command.
>
> Could you tell me the right syntax?
SELECT * FROM x_table WHE
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) .'"';
C
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=abo
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 i
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
>
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\includ
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.
>
>
> $connection = mssql_connect("server","user","password");
> mssql_select_db("Docume
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 direc
On 29 August 2003 06:39, OpenSource wrote:
> Hi guys,
>
> This is weird to me..
> I got this script
> ---
> if ($_GET[login] == 'forgot')
> {
> echo "Sorry I forgot my password";
> } else { echo "you
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 ac
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",$
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 serve
> -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:
>
> {L_LOGIN}
> {L_LOGOUT}
>
> So I'll need
> -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: sess
> -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 Info
> -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
> -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;$i
> -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
s
> -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/oc
> -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 possib
> -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 t
> -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',
> >
> -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 t
> -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: Invali
> -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 yo
> -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 s
> -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
> -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 mea
> -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 no
> -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 cu
> -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
>
> -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 S
> -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
--
> -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
ver
> -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
> t
> -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 wo
> -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.
http://www.php.net/ma
> -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
> -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 executin
> -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;$i
> echo $selection[$i];
>
> }};
>
> $selection is the I
> -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 witho
> -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
---
> -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 reall
> -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 rea
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 lin
> -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 warn
> -Original Message-
> From: Stephen Rhodes [mailto:stephen.rhodes@;scils.co.uk]
> Sent: 12 November 2002 16:32
>
> Wanting to use 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 wrong
> ???
> -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 befo
> -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.
> -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) {
> echo"
> -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 = "
> -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 yo
> -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 se
> -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 $a=ar
> -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 dat
> -Original Message-
> From: Brian [mailto:[EMAIL PROTECTED]]
> Sent: 29 May 2002 21:56
>
> ..., and since PHP is free, there really isn't a
> single company
> in charge of fixing such a problem.
No, but if you're absolutely sure it's a *PHP* bug, there is a bug-reporting system at
htt
> -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
> -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
Using the Oracle OCI interface, as far as I can see if I do the following:
$stmt = OCIParse($conn, 'DELETE FROM TITLES'
. ' WHERE TAG<0'
. ' RETURNING ID INTO :T_ID');
there seems to be no way of picking up more than one ID when multi
> -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 ju
> > -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";
>
> -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";
> $r
> -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 succes
> -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
> -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]'
>
89 matches
Mail list logo
