php-windows Digest 28 Mar 2003 16:24:44 -0000 Issue 1657
Topics (messages 19173 through 19180):
Re: What does"Query was empty" mean?
19173 by: cpdm.efn.org
19175 by: quickshow
PHP as CSS Stylesheet - broken in IE6/PHP 4.3.x
19174 by: Isetro Savi
19176 by: Per Lundberg
19177 by: Isetro Savi
19179 by: Per Lundberg
Problem with FireBird date
19178 by: André Cupini
Re: stuck with distinct ! ! ! !
19180 by: toby z
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
your query variable is mis-named in the assignment statement:
$addtmt = "Insert into....
$addstmt is the variable you are passing to mysql_query()
the $addstmt variable is empty, hence the error.
--Christopher
Quoting quickshow <[EMAIL PROTECTED]>:
> i am php&mysql newbie.
> i have created a table like:
> =======================================================
> CREATE TABLE $data_dep(
> ID int(3) DEFAULT '0' NOT NULL auto_increment,
> department_name VARCHAR(10),
> department_desc TEXT,
> publishtime DATE,
> updatedby VARCHAR(8),
> updated TIMESTAMP,
> PRIMARY KEY (ID)
> )
> =======================================================
> when i use :
> $addtmt = "Insert into
> $data_dep(department_name,department_desc,editedby,publishtime)
> values(%s,%s,%S,%s)";
> mysql_query(sprintf($addstmt,$department_name,$department_desc,$editedby,$pu
> blishtime),$link);
>
> an error occured:
> Query was empty .
> ========================================================
> Must i insert
> ID int(3)
> department_name
> department_desc
> publishtime
> updatedby
> updated
> COMPLETELY?
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
------------------------------------------------------------
Visit http://www.efn.org for all your community networking needs
--- End Message ---
--- Begin Message ---
oh,what a stupid mistake i just made.
thx
<[EMAIL PROTECTED]> ??????:[EMAIL PROTECTED]
> your query variable is mis-named in the assignment statement:
> $addtmt = "Insert into....
>
> $addstmt is the variable you are passing to mysql_query()
>
> the $addstmt variable is empty, hence the error.
>
> --Christopher
>
> Quoting quickshow <[EMAIL PROTECTED]>:
>
> > i am php&mysql newbie.
> > i have created a table like:
> > =======================================================
> > CREATE TABLE $data_dep(
> > ID int(3) DEFAULT '0' NOT NULL auto_increment,
> > department_name VARCHAR(10),
> > department_desc TEXT,
> > publishtime DATE,
> > updatedby VARCHAR(8),
> > updated TIMESTAMP,
> > PRIMARY KEY (ID)
> > )
> > =======================================================
> > when i use :
> > $addtmt = "Insert into
> > $data_dep(department_name,department_desc,editedby,publishtime)
> > values(%s,%s,%S,%s)";
> >
mysql_query(sprintf($addstmt,$department_name,$department_desc,$editedby,$pu
> > blishtime),$link);
> >
> > an error occured:
> > Query was empty .
> > ========================================================
> > Must i insert
> > ID int(3)
> > department_name
> > department_desc
> > publishtime
> > updatedby
> > updated
> > COMPLETELY?
> >
> >
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
>
>
>
> ------------------------------------------------------------
> Visit http://www.efn.org for all your community networking needs
--- End Message ---
--- Begin Message ---
Hi there,
I recently upgraded to PHP 4.3.1 from 4.2.2 on XP/IIS 5.1. On a web
application I have, I use a dynamic stylesheet such as:
<link rel="stylesheet" type="text/css" href="/stylesheet.php">
In the old version of php, this worked fine. But after the upgrade, the
stylesheets do not take effect in IE6 w/all patches on 2K or XP when I
first enter a page. If I hit refresh, it then works for that page. The
next page I go to does not work again. If I downgrade back to 4.2.2, it
works fine. 4.3.1-4.3.2RC1 do not work in IE6. however, IE5, Mozilla,
and Opera all purr along with no problems at all - this is just an IE6
error.
Does anybody have an idea of why this might be happening? Thoughts
appreciated! Let me know if you need any other info.
Thanks,
Isetro
--- End Message ---
--- Begin Message ---
On Fri, 2003-03-28 at 05:24, Isetro Savi wrote:
> Hi there,
>
> I recently upgraded to PHP 4.3.1 from 4.2.2 on XP/IIS 5.1. On a web
> application I have, I use a dynamic stylesheet such as:
> <link rel="stylesheet" type="text/css" href="/stylesheet.php">
Do you have something like this in your PHP code?
header("Content-type: text/css");
--
Best regards,
Per Lundberg / Capio ApS
Phone: +46-18-4186040
Fax: +46-18-4186049
Web: http://www.capio.com
signature.asc
Description: This is a digitally signed message part
--- End Message ---
--- Begin Message ---
On Fri, Mar 28, 2003 at 10:45:10AM +0100, Per Lundberg wrote:
> On Fri, 2003-03-28 at 05:24, Isetro Savi wrote:
> > Hi there,
> >
> > I recently upgraded to PHP 4.3.1 from 4.2.2 on XP/IIS 5.1. On a web
> > application I have, I use a dynamic stylesheet such as:
> > <link rel="stylesheet" type="text/css" href="/stylesheet.php">
>
> Do you have something like this in your PHP code?
>
> header("Content-type: text/css");
I did not have that in the stylesheet, but putting it in did not help.
Thanks for the suggestion!
--- End Message ---
--- Begin Message ---
On Fri, 2003-03-28 at 13:15, Isetro Savi wrote:
> On Fri, Mar 28, 2003 at 10:45:10AM +0100, Per Lundberg wrote:
> > Do you have something like this in your PHP code?
> >
> > header("Content-type: text/css");
>
> I did not have that in the stylesheet, but putting it in did not help.
Does the stylesheet validate? (http://validator.w3.org)
I would guess this is a register_globals problem.
--
Best regards,
Per Lundberg / Capio ApS
Phone: +46-18-4186040
Fax: +46-18-4186049
Web: http://www.capio.com
signature.asc
Description: This is a digitally signed message part
--- End Message ---
--- Begin Message ---
Hello people,
First, sorry my english. It´s weak. I´m brazilian.
I´m have a problem when work with date in a Firebird "date" field. By
default, Firebird set up the date format as month/day/year. I need date in
day/month/year format. In a Linux, i just add to the php.ini the following
line:
ibase.dateformat = "%d/%m/%Y"
But in a machine with Apache+PHP+Firebird, it´s don´t work.
Anybody help-me please?
Thanks for attention.
--------------------------------
André Cupini - Programador
--------------------------------
[EMAIL PROTECTED]
--------------------------------
NeoBiz - fábrica de internet
http://www.neobiz.com.br
--------------------------------
--- End Message ---
--- Begin Message ---
hi n thnx eveyone
as i hate makin loooooooooooooong queries so i came up with a rather
silly but at the moment workin idea
i made three files
qry.php
ftch.php
dsply.php
fetched from all 11 tables in to 11 different queries n displayed em
all separately
i guess im a bit tooo dammed lazzy :$ to go fo an actual effort
thnx a mill everyone
toby
--- Uttam <[EMAIL PROTECTED]> wrote: > u hv not explained the actual
problem (even briefly)?
>
> regds
> -----Original Message-----
> From: toby z [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 27, 2003 13:08
> To: php hlp list
> Subject: stuck with distinct ! ! ! !
>
>
> hi guyz
>
> im trying a query that fetches all fields(ranging from 5 to 15)
> from
> 11 tables i m looking round for distinct at
> http://www.mysql.com/doc/en/SELECT.html
>
> n so faar i aint getting anything :(
>
> can n some1 plz hlp
>
>
> thnx a lot .....
>
> toby ....
>
> __________________________________________________
> Do You Yahoo!?
> Everything you'll ever need on one web page
> from News and Sport to Email and Music Charts
> http://uk.my.yahoo.com
>
__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--- End Message ---
