Hi,
The query code seems fine to me - did you try to otput $query to see if all
the variables you are using are OK. May be $order,$stationid or $orderNewsID
is misspeled or is not set properly.
HTH
Dobromir
-Original Message-
From: Jay Paulson <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <
Use boolean field, it takes only values Yes/No, 0/1, True/False.
Bartek Pawlik
Poland
- Original Message -
From: Jordan Elver <[EMAIL PROTECTED]>
To: MySQL Mailing List <[EMAIL PROTECTED]>; PHP DB Mailing List
<[EMAIL PROTECTED]>
Sent: Tuesday, October 02, 2001 11:23 AM
Subject: [PHP-DB
Hi all,
I was trying to develop a appln. using IMAP proto. I found
that lot of the structures were not defined properly where by i had
problems while inserting the values into the database and also while
extracting them from dbase.
Can anybody give me any reference to the imap str
Scott Fletcher wrote:
> Do you meant to say that it took me several days to figure out that PHP
> doesn't support multiple databases? PHP said it will work with almost any
> databases but it failed to meant to say that only "with" one databases, but
> not multiple databases at the same time.
Hi,
MySQL doesn't support this kind of fields - if you want to have a field that
have only two values like 0/1 you should use char(1) or enum(0,1).
Dobromir Velev
-Original Message-
From: Bartek Pawlik <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>;
[EMAIL PROTECTED] <[EM
Hi everybody,
I have a PHP application using an Oracle database. This database has
been built before the application was rewritten in PHP, so I couldn't
switch to MySQL :-/
Now the (small) problem is, in the database is a field of type DATE,
which apparently stores the date _and_ time of the ent
http://www.php.net/manual/en/features.file-upload.multiple.php
Its Me wrote:
> is there a way i can upload more than one file in the same page
> -ofcourse in 2 different form fields-???
>
>
> --
Just use SQL query like this:
"select to_char(date_in_db, 'DD.MM. HH24:MI') as d, next_column from table"
Marek F.
> -Original Message-
> From: Karsten Dambekalns [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 02, 2001 2:00 PM
> To: PHP Database
> Subject: [PHP-DB] Fo
hello,
I would like to use sybase stored procedures and need to know, in what
way they are supportet in PHP. In the manual, one can read that stored
procedures are not yet fully supported. Does anybody have any newer
information on what Sybase features can be used with PHP4?
Thank you very much
Okay, one relevant issue is that PHP sets default cursor type to Dynamic.
While this is a nice, potentially bidirectional and sensitive-to-change
cursor it can be very expensive, some ODBC drivers don't support it
(OpenLink's do) and Dynamic cursors typically dont work with tables lacking
a primar
Hi,
SELECT TO_CHAR(FIELD,'DD/MM/ HH24:MI:SS') FROM TABLE
-Stathis.
Karsten Dambekalns wrote:
>
> Hi everybody,
>
> I have a PHP application using an Oracle database. This database has
> been built before the application was rewritten in PHP, so I couldn't
> switch to MySQL :-/
>
> Now th
On Tue, Oct 02, 2001 at 03:39:42PM +0200, Marek Fábry wrote:
> Just use SQL query like this:
>
> "select to_char(date_in_db, 'DD.MM. HH24:MI') as d, next_column from table"
Thanks, works perfectly :-)
Karsten
--
Why do we have to hide from the police, daddy?
Because we use emacs, son. They
Is there a free web hosting services that support PHP and MySQL?
Thx,
Francisco
>From the IBM CLI Reference:
SQL_ATTR_ODBC_CURSORS (DB2 CLI v5)
This connection attribute is defined by ODBC, but is not supported by DB2
CLI. Any attempt to set or get this attribute will result in an SQLSTATE of
HYC00 (Driver not capable).
A 32-bit option specifying how the Driver Manager us
You shouldn't need to install MySQL to use MS Access. Seems like they are
giving you excuses to avoid any extra work on their part. I would suggest
you switch web-hosting companies if they are behaving this way.
Hostpro.com is one that supports PHP and Access.
PS: I am not affiliated to hostpro
Hi Mark,
Thanks for the investigation! Will add your comment to the db2 drivers of
adodb.
Regards, John
"Mark Newnham" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> From the IBM CLI Reference:
>
> SQL_ATTR_ODBC_CURSORS (DB2 CLI v5)
> This connection attrib
$a=odbc_connect("mydsn","myid","mypwd") or die("Database is down");
echo "$a";
When I execute this script, I got $a being "Resource id #1".
but $a should be an integer in order to do a query like
$b=odbc_exec($a,"select * from mytable");
the dsn I created is a system DSN, as suggested my
If you attempt to echo out a Resource Id it tells you it's name :)
This should still work in an exec.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Original Message
Here is the full script:
$a=odbc_connect("mydsn","myid","mypwd") or die("Database is down");
echo "$a";
$b=odbc_exec($a,"select * from mytable");
echo odbc_error ();
FYI, if I execute only the first 2 lines, there is no problem, meaning that
the server is accesss
Does this DSN test successfully in the ODBC Administrator?
If so, try an odbc trace - see what's going on.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Original Mess
start here: http://www.freewebspace.net/
-Original Message-
From: Francisco Carvalho [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 11:11 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Free PHP/MySQL webhosting
Is there a free web hosting services that support PHP and MySQL?
Th
Hello,
How can i make a double LEFT JOIN?
Now i have got:
SELECT table1.id FROM table1 LEFT JOIN (table2 LEFT JOIN table3 ON
table2.id=table3.id) ON table1.id=table2.id
but this gives an error
Tnx,
Bas
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTE
Remove the parentheses
SELECT table1.id FROM table1 LEFT JOIN table2 LEFT JOIN table3 ON
table2.id=table3.id ON table1.id=table2.id
-Original Message-
From: Bas Jobsen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 3:00 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Howto make a
Remove the parentheses
SELECT table1.id FROM table1 LEFT JOIN table2 ON table1.id=table2.id LEFT
JOIN table3 ON table2.id=table3.id
-Original Message-
From: Bas Jobsen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 3:00 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Howto make a
> Remove the parentheses
> SELECT table1.id FROM table1 LEFT JOIN table2 LEFT JOIN table3 ON
> table2.id=table3.id ON table1.id=table2.id
I still got:
MySQL retourneerde: You have an error in your SQL syntax near 'LEFT JOIN
table3 ON
table2.id=table3.id ON table1.id=table2.id' at line 1
--
PHP
SELECT table1.id FROM table1 LEFT JOIN table2 ON table1.id=table2.id LEFT
JOIN table3 ON table2.id=table3.id
-Original Message-
From: Bas Jobsen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 3:13 PM
To: Rick Emery; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Howto make a double L
> SELECT table1.id FROM table1 LEFT JOIN table2 ON table1.id=table2.id LEFT
> JOIN table3 ON table2.id=table3.id
Well, oke now i have:
table1:
id|no
1|1
2|1
table2:
id|no
1|1
1||1
table2:
id|no
1|1
1||1
1||1
The result i want tot have is:
id|sum(table2.no)|sum(table3.no)|
1|2|3
2|0|0
my query:
Dates in MSSQL are stored as:
mon dd hh:miAM (or PM)
and ODBC converts them to:
-mm-dd hh:mi:ss.mmm(24h)
so:
select * from Internetlog where convert(varchar, LogTime, 121) like
'%2001-10-02%'
-Original Message-
From: Matthew DeChant [mailto:[EMAIL PROTECTED]]
Sent: Monday, Octo
please show the REAL output from your query and what it should REALLY look
like
-Original Message-
From: Bas Jobsen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 3:38 PM
To: Rick Emery; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Howto make a double LEFT JOIN
> SELECT table1.id
Hi Rick,
> please show the REAL output from your query and what it should REALLY look
> like
table1:
id|no
1|1
2|1
table2:
id|no
1|1
1|1
table3:
id|no
1|1
1|1
1|1
using:
SELECT DISTINCT(table1.id) AS test, SUM(table2.no) AS tot, SUM(table3.no)
FROM table1 LEFT JOIN table2 ON table1.id=tabl
Hi,
I run a webhosting service and am about to offer MySQL to .PHP customers; and
am wondering if there is a way with in Apache Virtual Host directives to ...
- enable/disable safe mode (we have some scripts on our https server and we
need to be able to set up new websites etc, but we want to
Hello,
I'm trying to store HTML (that is cut-n-paste from source)
into a textarea field on a web page. As it's submitted to
the php page that processes it, the database column that
it ends up with strips the "<" and ">" out of the html
so that it doesn't end up in the source.
Example I ca
Does anyone have any recommendations on a Credit Card Processing solution to
use with PHP? I researched CyberCash's "CashRegister" deal about 6 months
ago -- now Verisign has taken over CyberCash, and have replaced CashRegister
with "PayFlowPro" --
Looking at the pricing, etc... don't know if it
I have a problem that seems like it should be a snap to fix, but leaves me
feeling frustrated to no end...
I have a table (HTML) -- 2 Columns. In the right-hand column I store a URL
(ie. http://someonesdomainname.com/path/anotherpath/file.html)
The problem is -- when I pull the URL in -- it *pu
How can I get Versign's PayFlowPro to work with PHP? I'm using Win2k
version.
Thanks.
Jason
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e
not that this has *anything* to do with databases, but try the "nowrap"
directive in the containing the URL, i don't think it will work,
otherwise you will need to use something like the PHP function "wordwrap()"
enjoy
/beau
// -Original Message-
// From: Jason Caldwell [mailto:[EMAIL
try using the htmlspecialchars() function instead - works for me :)
// -Original Message-
// From: Nally, Tyler G. [mailto:[EMAIL PROTECTED]]
// Sent: Wednesday, 3 October 2001 6:29 AM
// To: '[EMAIL PROTECTED]'
// Subject: [PHP-DB] Storing HTML in database
//
//
// Hello,
//
// I'm tr
I have a page of jobs with AuthStatus set to 0. Basically I want to list
each job title with a checkbox next to it. This I have done.
What I really don't understand is how do I make it so that the rows in my
table for all the different records when ticked are updated to 1?
Please help.
Matt
Hiya Matt
you have to set the value of the checkbox to 1, and give it a unique
name.
if the user has checked the box when they submit the form then the
checkbox' name will have a value of 1. if they didn't check it it won't
have a value at all.
Hope this helps!
Dave
-Original Message--
Go payflow pro. Its awesome. Substantially the fastest
processor out there in my opinion.
I use it with PHP and its awesome. I've used Miva,
Cybercash (before it was Verisign), and many others.
> -Original Message-
> From: Jason Caldwell [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday,
Matt,
Assuming that you have a variable number of records being displayed out of
the database:
As you write out the HTML, give each checkbox a name containing the ID# of
the record that is being written out. Ex:
Use code like the following to Write and Read the web form...
id;
www.f2s.com
www.freesql.org
"Francisco Carvalho" <[EMAIL PROTECTED]> wrote in message
1193DA4C9CB3D411A2BB000102CAA88EF406BF@MAIL2">news:1193DA4C9CB3D411A2BB000102CAA88EF406BF@MAIL2...
> Is there a free web hosting services that support PHP and MySQL?
> Thx,
> Francisco
>
--
PHP Database Mail
Hi,
Just set the width of the cell the URL is placed in.
Something like
$url...
HTH
Dobromir Velev
-Original Message-
From: Jason Caldwell <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Wednesday, October 03, 2001 2:20 AM
Subject: [PHP-DB] HTML or PHP?
>I have a pr
Without spaces, the URL won't line break...
I recommend one of two things...
1) Use a for() or while() loop with substr(), to print out, say, 50
characters per line, then break to the next line, until reaching the end
of the string...
2) Use an ellipsis ("...") to cut out the middle of the URL
you'll have to use wordwrap() !
the browser won't be able to brake it down unless it have spaces in it
"Jason Caldwell" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I have a problem that seems like it should be a snap to fix, but leaves me
> feeling fru
45 matches
Mail list logo