Jim, Mike :
thanks for reply.
getting desire result with strtotime.
John,
yess u r right.
sometimes in my script date is coming from database. in that case, use of
DATE_FORMAT() is the best option.
thanks
smita.
>From: "Ford, Mike [LSS]" <[EMAIL PROTECTED]>
>To: 'Smita Manohar'
In article <001201c25ea3$ede4cbf0$f7fea8c0@chris>, [EMAIL PROTECTED]
says...
> Hi there everyone,
>
> I've just setup Apache 2.0 under Windows XP and LOVE it, PHP and MySQL work fine and
>people are saying how fast the server is. However, I am stumped on one thing - how
>the heck does I set i
Yes, it is an amazing project. The main team of developers are very talented
and there are new contributions made daily. Checkout the snapshot release,
it's extremely feature packed. It is by far the best shop system I have
ever dealt with, let alone being open source, good stuff.
http://oscomme
> Just a small suggestion guys, but when posting messages to a mailling
> list,
> it's always a *good* idea to turn off the "Read Request" option!!!
I encourage everyone to send the receipt and clog up their email
account. That'll teach them. :)
---John Holmes...
--
PHP Database Mailing List
I really hope you just subscribed, because this question already been
asked today...and yesterday... You should search the archive before you
post.
Anyhow, the solution to your problem can be solved by using a
"processing" page that does the insert into the database and then
redirects to the main
> How can I select one random column from a MySQL table?
You can't, in one query. You can use the MySQL_ function to get a list
of all the columns, though, and then use PHP to select a random column
and construct an SQL statement.
If you need to do something like this, though, there is somethin
I have a page that maintains a very simple list of items. The page shows the
current items on the list and provides an field for the user to add
new items to the list. Everything works great. The only problem I'm having
is that each time the user clicks the Refresh button on the browser, I get
th
nope - an id is used for other things (like javascript, style sheets, DHTML
etc). They shouldn't affect your variable names.
HTH
Beau
// -Original Message-
// From: Michael Zornek [mailto:[EMAIL PROTECTED]]
// Sent: Wednesday, 18 September 2002 6:41 AM
// To: [EMAIL PROTECTED]
// Subje
Hi all,
How can I select one random column from a MySQL table?
Thanks, Taj
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Just a small suggestion guys, but when posting messages to a mailling list,
it's always a *good* idea to turn off the "Read Request" option!!!
Thanks,
-gav.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I did build it with --with-sybase, but then I forgot to install the new
version. Face turning red... Sorry for the false alarm. It now works
like a charm.
Avi
Adam Williams wrote:
> He's using microsoft sql server, not mysql.
>
> try --with-mssql
>
> On Wed, 18 Sep 2002, Jason Morehouse
He's using microsoft sql server, not mysql.
try --with-mssql
maybe?
Adam
On Wed, 18 Sep 2002, Jason Morehouse wrote:
> It means you haven't compiled mysql support into php. Recompile it using
> --with-mysql
>
> --
>
> Jason Morehouse (jm[@]netconcepts[.]com)
> Auckland
It means you haven't compiled mysql support into php. Recompile it using
--with-mysql
--
Jason Morehouse (jm[@]netconcepts[.]com)
Auckland, New Zealand
Linux: Because rebooting is for adding hardware.
On Tue, 17 Sep 2002 15:30:29 +, Avi Schwartz wrote:
> I have PHP4 and freetds installed
Hi there everyone,
I've just setup Apache 2.0 under Windows XP and LOVE it, PHP and MySQL work fine and
people are saying how fast the server is. However, I am stumped on one thing - how
the heck does I set it up so Mail will work? With my old server (Linux) it was
already configured, but fr
http://www.mysql.com/doc/en/Fulltext_Search.html
On Tue, 17 Sep 2002 20:34:37 +1200, Meltem Demirkus wrote:
>
>> Hi,
>> Is there any other efficient way (--except using LIKE)of searching a
> keyword
>> in mysql ...
>>
>> thanks
>>
--
PHP Database Mailing List (http://www.php.net/)
To unsubsc
I have PHP4 and freetds installed and I am trying to connect to a mssql
server. The problem I am having is that the mssql_connect() call generates
the following error:
Fatal error: Call to undefined function: mssql_connect()
Is there something I need to require?
Thanks,
Avi
--
Avi Schwartz
does the id attribute of an input tag override the name attribute when
trying to pull these vales on a subsequent php page? Does it make any
difference?
I ask cause I'm now PHP-ifing a form I designed in Dreamweaver and it added
ids attributes all over the place. Wonder if I should edit them, del
actually make that system("df -h");
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
this works here.
On Tue, 17 Sep 2002, Bo wrote:
> Any ideas of how to write a php script to determine the disk space left in
> my account at my web server?
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
+---
On Tue, 17 Sep 2002, Bo wrote:
> Any ideas of how to write a php script to determine the disk space left in
> my account at my web server?
>
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Any ideas of how to write a php script to determine the disk space left in
my account at my web server?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Does your process hang or simply is too long? Perhaps the limiting factor is
not the writing speed, but a memory requirement problem.
Try to compute how long it should take:
- do your row processing after a SELECT ... LIMIT 1000 clause
- time how long it takes, and extrapolate
Then you will know
Wouldn't the PEAR DB module give this same functionality?
-Original Message-
From: Gerd Busker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 17, 2002 4:12 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] DBI::Proxy
Ok, so the subject has something to do with perl, but read on:
I was w
You could check out the FULLTEXT searching in MySQL, too. It's in the
manual. It has some quirks, but works well on a large database.
---John Holmes...
> -Original Message-
> From: Cal Evans [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 17, 2002 8:04 AM
> To: Meltem Demirkus; [EM
it depends on how you design your database. When I know I will have this
situation, I design a table named keyWords. Put one work per record and
assign each word an ID number. Then I create a join table between keyWords
and whatever table they relate to. The join table only contains 2 fields,
t
Hi,
I've got a script that I've written that writes out a xml file from
mysql via php.
The file should contain 250,000 xml style records, but it takes so long
to generate the file the process has to be stopped before complete.
I can't use mysqldump because of some of the processing that is req
Thanks
That will work for me
Dan
"Ryan Jameson" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]...
I believe you'll have to do this:
"select * from master.sysdatabases"
:-)
<>< Ryan
-Original Message-
From: Dan Healy [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 15,
Ok, so the subject has something to do with perl, but read on:
I was wondering if it would be at all possible (usefull?) to have
a PHP database layer that can talk "DBI::Proxy". DBI::Proxy is a
perl module that can act as a database proxy for any database supported by
perl DBI/DBD.
It would
> Hi,
> Is there any other efficient way (--except using LIKE)of searching a
keyword
> in mysql ...
>
> thanks
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi,
Is there any other efficient way (--except using LIKE)of searching a keyword
in mysql ...
thanks
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
30 matches
Mail list logo
