What format do you want?
You can use
select convert(char(10),date_field,101)
and you will get mm/dd/, or look at the convert function in the SQL
Server Books Online, or
u can use php function date and format whatever you want.
Radovan
Matt Brown [EMAIL PROTECTED] wrote in message
Hi Mohammad Saad,
[...] or should I use conventional method of writing database queries
if you want to use mysql you can use phpMyAdmin
[...]but still is there any other better way out, are
Oracle Reports supported in PHP?
I dont think that php has a feature to support Oracle Reports. But
Building on John idea with a few of my own (from a real word system I've
developed...)
Creating a blank MDB from scratch is particularly painful - so, like John
said - start with a ready made template.
Next make a copy with a unique name (there are loads of ways of doing this,
timestamps,
The relationsionship can be maintained by window.opener from within the
child wildow - parent window, and the simply the name of the window you
assigned can be used when going from the parent window - child window.
hth
jeff
Jason Wong [EMAIL PROTECTED] wrote on 11/13/2002 10:46:32 PM:
On Thursday 14 November 2002 07:32, [EMAIL PROTECTED] wrote:
Is this even possible? I have a menu that is generated from a table.
What is your menu -- a set of a tags? or a selector box? I suspect you
mean
the latter ...
Not a
Hi
Never forget to include enctype=multipart/form-data into your formtag
Bye
Coert
Jason Wong wrote:
On Thursday 14 November 2002 04:47, Seabird wrote:
Hi everyone,
I don't get my upload to work properly. It's a tutorial of the web, but it
doesn't function (unless I made a mistake).
HOW
1. Are you 100% sure register_globals is turned on?
2. You session_register your variable before you change it. Replace
$ShoppingCart with $_SESSION[ShoppingCart] every time you use it. This way
you are modifying the session variable actually in the session, not just
the one time.
I have recently been creating reports using PHP's pdf libraries.
Somewhat time consuming to develop them from scratch and the client has
to have the acrobat reader, but they look slick, I must say. Another
option is to create RTF or PDF templates and simply replace certain
areas with your
I have to agree on the PDF.
Currently my host does not provide for PDF capabilities as of yet but I
believe they are going to be compiling with support for PDF soon.
When they do, look out. The success of some of our commercial apps will
rise for sure as this reporting options becomes
hmm, I guess that would work. There is no way to have mySQL check for
integrity for me is there? I read in a SQL book a while ago about
wrapping multiple inserts in a select statement, that way if any part of
the statement failed the whole thing would be rolled back. From my
research
hmm, I guess that would work. There is no way to have mySQL check for
integrity for me is there? I read in a SQL book a while ago about
wrapping multiple inserts in a select statement, that way if any part of
the statement failed the whole thing would be rolled back. From my
research
10 Seconds searching in the MySQL Manual:
http://www.mysql.com/doc/en/ANSI_diff_Transactions.html
You have to use InnoDB tables, but this will work.
On Thu, 2002-11-14 at 11:26, Anthony wrote:
hmm, I guess that would work. There is no way to have mySQL check for
integrity for me is there?
For PDF capabilities for a host that doesn't provide them check out
http://www.ros.co.nz/pdf
They have some free php scripts that you can upload to your server to create
PDF on the fly.
It might not be able to do everything, but I've found it very useful on one
of my sites.
- Original
Hi to all,
I have an Access DB with a table call newchecklist. On this table I have a
field call PDF where I have many PDFs.
What I'm trying to do is to move all these PDFs into different folders.
For example, if I have a folder name VA, so my query will be:
SELECT STATE FROM newcheklist WHERE
Peter, thanks for your reply. I'm 100% unsure that register_globals is
turned on. I've not tried any of your points as for some reason my code
works and my errors have somehow disappeared. It simply doesn't make any
sense. Although I did email my web host to see if register_globals were
turned
On Thursday 14 November 2002 23:17, [EMAIL PROTECTED] wrote:
Jason Wong [EMAIL PROTECTED] wrote on 11/13/2002 10:46:32 PM:
On Thursday 14 November 2002 07:32, [EMAIL PROTECTED] wrote:
Is this even possible? I have a menu that is generated from a table.
What is your menu -- a set of a
Just wrote an app that does this myself. Loads inmages/movies/audio and
what not into a database. I've posted the code below, feel free to try
it out. This file does all the uploading. It took me a while to figure
out how to do this, so don;t worry it it seams like it's tough. I
actualy
I have been seeing a lot of talk about file uploads.
I wrote the following code and it works well when uploading images. The
actual image is not stored in the database just the name of the image.
When you want to view the image just query the database and include the
database variable in your IMG
Hey all,
Been trying too figure this out all day.
First off I'll explain what I am TRYING to do.
I am creating a Search Engine Tracking Report that lists keywords and
the Search Engines used on that keyword along with the count total for
that search Engine - example:
Keyword
http://www.php.net/manual/en/function.rename.php
You are just moving files on a file system from one place to another right?
rename(/old/path/to/file/filename.pdf,/new/path/newfilename.pdf) or die(can't
move file);
Can't remember what variable/function holds the last error for rename,
In article OF48D424BD.87A6C8FB-ON88256C70.0080DCAD-
[EMAIL PROTECTED], [EMAIL PROTECTED] says...
Is this even possible? I have a menu that is generated from a table.
Typically, the menu items are links
to html pages. I would like to have the link bring up a list of items from
another table in
Thanx, I found out I forgot to pass it to my db.
Jacco
--
http://seabird.jmtech.ca
Attitude is Everything!
But Remember, Attitudes are Contagious!
Is Yours worth Catching
David Robley [EMAIL PROTECTED] wrote in message
news:MPG.183f2f6ec46a84169897c8;news.php.net...
In article [EMAIL
Hi Gavin,
Have you tried escaping your input? Take a look at the following:
http://ca.php.net/manual/en/function.mysql-real-escape-string.php
It should help you take care of the problem.
Marco
--
php|architect - The magazine for PHP Professionals
The first monthly worldwide
23 matches
Mail list logo