> I need help. I need to convert a Date column in MySQL where the date
is
> stored like "2003-01-15" to the following seconds "1042621252 ".
SELECT TO_UNIXTIME(date_column) AS formatted_column FROM yourtable WHERE
...
The TO_UNIXTIME() function will convert the date to the format you need
that
Hi,
I need help. I need to convert a Date column in MySQL where the date is
stored like "2003-01-15" to the following seconds "1042621252 ". I'm
connecting the database through PHP to third party solution that requires
this. Here is the only information that was given:
Is there a method for storing each users browser stats within a database
table.
So everytime someone visits the browser info is gathered and stored as a
unique row in the 'browser' table in the database.
Any advice??
Cheers
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visi
Shouldn't you be using $_GET or, since register_globals are set to off,
$order_by should contain "FIRSTNAME"
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forward"
mailto:[EMAIL PROTECTED]
http://accessingram.com
-Original Message-
From: Jerry [mailto:[EMA
Hi All,
This is a newbie question. I am using PHP Version 4.2.3 with
register_globals=off. I am trying to creating a simple address book with
mysql as the backend. I have a form that passes what the user wants to
query from the address book and it returns everything in a table with column
heading
On Wednesday 05 March 2003 13:20, Rajesh Fowkar wrote:
> On Tue, Mar 04, 2003 at 06:45:54AM -0800, Mark wrote:
> >It dopesn't seem like you got an answer to this.
>
> Spot on. Yours is the first reply.
Not surprising as this question really does not belong here.
> >To print locally,
> >you'll nee
This is very weird. What are you using to create this code?
If you remove all of the spaces (?) before $query, the code doesn't give
a parse error. It shouldn't give one either way, though, if those are
spaces or a tab before your $query = ... line.
Even if you remove all of the text and only le
Hi,
I am trying access DB Paradox via php/odbc.
Only get in W98/PWS or WME/PWS. And without success in Linux/php/odbc and
Windows 2K/php/odbc.
In W2K's Case, it appears following message:
Warning: SQL error: [Microsoft][ODBC DRIVER for Paradox] The table
external is not in the waited format., SQL
Sorry, I forgot to add the part at the bottom where I am calling the
function
=
$start = date('Ymd',strtotime($weekstart));
$query = "SELECT * FROM Rota WHERE date >= $start and date <= ($start +
INTERVAL 6 DAY) ORDER BY staff
Have you looked into the exec() function? Maybe exec("lpr something or
other") may work, though I haven't tried it myself ...
Regards,
Matthew Moldvan
---
System Administrator
Trilogy International, Inc
http://www.trilogyintl.com/ecommerce/
---
Hi, thanks for the help, I just had a look at the db and they are just the
default tables, so that must be it. I'll let them know to either change
them over or add validation.
Again, thanks for your help.
On Wed, 5 Mar 2003, 1LT John W. Holmes wrote:
> Date: Wed, 5 Mar 2003 10:07:04 -0500
> From
> One of our customers has written a php application that we are hosting.
>
> Basically, there is a province/state table which populates a combo box.
> When the form containing this combo box is submitted, the information is
> added into the database.
>
> The problem is that when nothing is selecte
12 matches
Mail list logo
