,
formation) VALUES ('$kwo', '$lsd', '$date', '$well', '$field', '$uni',
'$license', '$formation')
-Original Message-
From: Jason Wong [mailto:[EMAIL PROTECTED]
Sent: August 1, 2003 12:15 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL
On Saturday 02 August 2003 01:46, Jeff wrote:
I
Sorry, I just realized that's an older copy of the code, here is the updated stuff -
(It's just one more line, the line that's giving me greaf. :P )
?php
$link_id = mysql_connect(localhost,admin,***)
or die(Unable to connect to SQL server);
Myfault.. you should be using link_id instead of dbHandletry this:
$result = mysql_query($strSQL, $link_id) OR DIE(Error retrieving records.);
Quoting Jeff [EMAIL PROTECTED]:
K, that got my a bit further, now it shows half the page but stops at the
line:
$result = mysql_query($strSQL,
Oh, and another thing, in this book I have, they say to give the forum
action ?php echo $PHP_SELF ?.
Yet it dosn't give a value to $PHP_SELF.
IS this correct?
Jeff [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
K, that got my a bit further, now it shows half the page but stops at
Well, it worked for ONE submission I was so excited. :)
Then I went back to enter another test, and when I went back to the page, it
displayed everything up to that line again, but JUST output, Error
retrieving records.
??? Why woudl it work just once?
Mel Hodges [EMAIL PROTECTED] wrote
i installed php and apache fine on my pc, but mysql is giving problems. in
winmysqladmin, you cant create a adb on the databases tab. all that lets you
do is flush threads, flush processes, etc. so i had to create my database
through the mysql command line.
also, phpMyAdmin doesnt work, it
At 07:44 PM 7/31/2003 +0100, John Ryan wrote:
i installed php and apache fine on my pc, but mysql is giving problems. in
winmysqladmin, you cant create a adb on the databases tab. all that lets you
do is flush threads, flush processes, etc. so i had to create my database
through the mysql command
Hello,
I have the following PHP code:
$date = date(Y-m-d H:i:s);
$result = mysql_query(INSERT INTO Boats (Make, Model, Serial,
Stock, Extension, Cust_Name, Store, Date) VALUES
('$make', '$model', '$serial', '$stock', '$extension',
'$name', '$store', '$date')
:17 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL Date insert
Hello,
I have the following PHP code:
$date = date(Y-m-d H:i:s);
$result = mysql_query(INSERT INTO Boats (Make,
Model, Serial,
Stock, Extension, Cust_Name, Store, Date) VALUES
and see if you still get the error.
-Original Message-
From: Andrew D. Luebke [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 2:17 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL Date insert
Hello,
I have the following PHP code:
$date = date(Y-m-d H:i:s
From: Andrew D. Luebke [EMAIL PROTECTED]
$date = date(Y-m-d H:i:s);
$result = mysql_query(INSERT INTO Boats (Make, Model, Serial,
Stock, Extension, Cust_Name, Store, Date) VALUES
('$make', '$model', '$serial', '$stock', '$extension',
'$name', '$store',
here. Try changing the field name and give that a shot. I think I am
actually right here though.
Scott
-Original Message-
From: Hutchins, Richard [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 1:19 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] MySQL Date insert
Don't know about
:
Subject: [PHP-DB] MySQL Date insert
07/28/2003 02:16
;
Michele Petrovsky
- Original Message -
From: Andrew D. Luebke [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 28, 2003 2:16 PM
Subject: [PHP-DB] MySQL Date insert
Hello,
I have the following PHP code:
$date = date(Y-m-d H:i:s);
$result = mysql_query
From: NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED]
I actually think I know part of this answer... I don't think you
need to define a variable to insert into your date field. Inserting an
empty value into this filed will populate the field in the database with
the
current time, which it appears
John, thanks, now I feel stupid, it's always the silly little things that
get you. You were right, when I added the date to the existing insert I
forgot to put the ending parentheses back in. Thanks for the help.
Andrew.
At 11:26 AM 7/28/2003, CPT John W. Holmes wrote:
From: Andrew D. Luebke
I have just recently entered the world of PHP and MySQL. I'm used to code in
ASP with Access databases and since I am not very familiar with PHP, I have
run into a problem, which is probably quite easy to solve:
Connecting to the database requires a couple lines of code, which I would
rather not
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL Session
I have just recently entered the world of PHP and MySQL. I'm used to code in
ASP with Access databases and since I am not very familiar with PHP, I have
run into a problem, which is probably quite easy to solve:
Connecting to the database requires
-
From: Morten Twellmann [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, July 27, 2003 1:01 PM
Subject: [PHP-DB] MySQL Session
I have just recently entered the world of PHP and MySQL. I'm used to code
in
ASP with Access databases and since I am not very familiar with PHP, I
have
run
Hi there,
I have been trying to get a solution to this select query from all over the
web and have found no answer so I was hoping someone here could help out.
The date field of the database is imported from a text file with the date
format 'dd-mm- hh:mm:ss' and I only want to display the
A: [EMAIL PROTECTED]
Oggetto: [PHP-DB] MYSQL and PHP cast() function...
Hi there,
I have been trying to get a solution to this select query from all over the
web and have found no answer so I was hoping someone here could help out.
The date field of the database is imported from a text file
Thanks for that, but I get a NULL entry in the field then for all the dates.
- Original Message -
From: Moreno Riccardi [EMAIL PROTECTED]
To: Morgan Bardon [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, July 25, 2003 4:34 PM
Subject: R: [PHP-DB] MYSQL and PHP cast() function
:34 PM
Subject: R: [PHP-DB] MYSQL and PHP cast() function...
Try
$query2 = select Title, date_format(Date,'%d-%m-%Y) as Date, Artist,
Country,
RecordCompany, CatalogueNumber, Composer FROM recording where title
regexp
'$keyword';
Hi,
Moreno
-Messaggio originale-
Da
luglio 2003 17.39
A: Moreno Riccardi; [EMAIL PROTECTED]
Oggetto: Re: [PHP-DB] MYSQL and PHP cast() function...
Thanks for that, but I get a NULL entry in the field then for all the dates.
- Original Message -
From: Moreno Riccardi [EMAIL PROTECTED]
To: Morgan Bardon [EMAIL PROTECTED]; [EMAIL
, July 25, 2003 4:44 PM
Subject: Re: [PHP-DB] MYSQL and PHP cast() function...
Thanks for that, but I get a NULL entry in the field then for all the
dates.
What column type is the DATE column? Also, since DATE is a reserved word
in
MySQL, naming a column DATE probably wasn't a good idea
Hi
I have a table which contains 3 fields (ID, Title, Abstract) the title and abstract
fields have been fulltext indexes like this:
ALTER TABLE biblio ADD FULLTEXT (title,abstract);
that worked fine, however my problem is whenever I want to do a select statement only
comparing 1 of the
Full text searches only work against fulltext indexes.
http://www.mysql.com/doc/en/Fulltext_Search.html
This isn't a PHP issue.
Doug
On Fri, 18 Jul 2003 09:42:17 +0200, Angelo Zanetti wrote:
Hi
I have a table which contains 3 fields (ID, Title, Abstract) the title and abstract
fields have
I have:
WinNT_4.00 Server
Apache
PHP_5
MySQL_4
[myscript.php]
...
$link = mysql_pconnect();
...
-
If you run php.exe myscript.php,
you'll get message: Fatal error: Call to undefined function:
mysql_pconnect()...
HOW TO DECIDE THIS PROBLEM ?
--
PHP Database
I have:
WinNT_4.00 Server
Apache
PHP_5
MySQL_4
[myscript.php]
...
$link = mysql_pconnect();
...
-
If you run php.exe myscript.php,
you'll get message: Fatal error: Call to undefined function:
mysql_pconnect()...
HOW TO DECIDE THIS PROBLEM ?
Have you installed the
Have you installed the php_mysql module in PHP5, it is not
included by default now.
Where can I find this Library?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Apache 2.0.46 (Win32) PHP/5.0.0b2-dev w/ MySQL 4.1.0
I have a question about the mySQL extension in the aforementioned version of
PHP
Whenever I try to load the extension thru adding it to PHP.INI like so I get
an error
extension_dir = C:\Servers\PHP\extensions
.
.
.
extension = php_gd2.dll
Hello,
Does anyone know what would cause this message?
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result
resource in c:\program files\easyphp\www\bod-rse\bod\menu.php3 on line 49...
Here is the code:
?
$command = SELECT * FROM central_fakepaths WHERE menu != '0' ORDER
]
Subject: [PHP-DB] MySQL error
message...
06/30/2003 12:47
Hi,
I've never used a lock on a MySQL table so far, but need one now. Two
questions:
1. Do I set the lock by a normal query, but in the form of LOCK TABLE
tablename WRITE, instead of SELECT * FROM tablename WHERE x = 1?
2. Can I set the lock in one query, then perform multiple other queries
I have been searching inside the mailing lists regarding the a PHP code that
dump all or a selected databases from MySQL ...
and haven't managed to get a script like PhpMyAdmin does... please any ready
script or idea ...
?php exec(mysqldump -u root -ppassword -A backup.sql); ?
//Because it
Hi,
You have only to modify it to your environement
It works with mysql = 3.23.52
// Get all table names of the database
//
$sql = '
SHOW TABLES
FROM
test_db
;
$db-query($sql);
while($row = $db-fetchRow( 'DB_GETMODE_NUM'))
{
I use an db abstraction class. You have to replace this by yours. Of
course you got a Fatal error: Call to a member function on a
non-object because such an object dosen't exist in your script. First
you have to connect to a database using mysql_connect() and using
mysql_query and
thnks, i will give it a shot
Armand Turpel [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I use an db abstraction class. You have to replace this by yours. Of
course you got a Fatal error: Call to a member function on a
non-object because such an object dosen't exist in your
Hello Everybody!
I tried to connect with a mysql databasem , but It shows the follow error:
Warning: mysql_numrows(): supplied argument is not a valid MySQL result
resource in c:\inetpub\wwwroot\ejercicios\cap11\cursor.php on line 25
NĂºmero de filas en el resultado:
Warning:
Hi all.
I need to get a program (interface) for MySQL, I was using MySQL Front but they've
discontinued its use.
Any suggestions.
thanx in advance
-Angelo
, 2003 11:40 AM
Subject: [PHP-DB] MySQL editor
Hi all.
I need to get a program (interface) for MySQL, I was using MySQL Front but
they've discontinued its use.
Any suggestions.
thanx in advance
-Angelo
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
: [PHP-DB] MySQL editor
MySQL CONTROL CENTER from mysql.org (very nice)
SQLYOG from sqlyog.com
PHPMYADMIN from phpmyadmin.net (web interface)
- Original Message -
From: Angelo Zanetti [EMAIL PROTECTED]
To: [EMAIL
the crashing and slow speed (database wise)!!
What's wrong with continuing to use MySQL Front? I do. It's still my
favorite.
---John Holmes...
- Original Message -
From: Angelo Zanetti [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 4:40 AM
Subject: [PHP-DB] MySQL editor
: [PHP-DB] MySQL editor
Hi all.
I need to get a program (interface) for MySQL, I was using MySQL Front but
they've discontinued its use.
Any suggestions.
thanx in advance
-Angelo
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hello,
Not really the same purpose, but so powerfull :)
http://www.fabforce.net/dbdesigner4/
pierre
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
A free alternative that works very well is sqlyog. Google it as I don't have
the url handy (it may be www.webyog.com or .org). I also use MySQL Front as
it still works fine. But I'm switching over to sqlyog because I want to
ensure that I am compatible with future releases of MySQL.
Michael Lewis
10:48 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql Editor
A free alternative that works very well is sqlyog. Google it as I don't have
the url handy (it may be www.webyog.com or .org). I also use MySQL Front as
it still works fine. But I'm switching over to sqlyog because I want to
ensure
PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, 19 June, 2003 10:33
Subject: Re: [PHP-DB] MySQL editor
Not free, but mysqlmanager (www.ems-hitech.com) is by far the best I've
used. A free alternative (although not quite as featured) is probably
Mysqlcc
-Mike
- Original Message -
From
: [PHP-DB] MySQL editor
mysqlmanager (www.ems-hitech.com) is by far the best I've used.
They've changed the name to Navicat now. It really is fantastic software.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Michael Scappa [EMAIL PROTECTED]
To: Angelo
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Becoming Digital [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, 19 June, 2003 11:02
Subject: Re: [PHP-DB] MySQL editor
mysqlmanager (www.ems-hitech.com) is by far the best I've used.
They've changed
Message-
From: Achilles Maroulis [mailto:[EMAIL PROTECTED]
Sent: June 19, 2003 5:46 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL editor
MySQL CONTROL CENTER from mysql.org (very nice)
SQLYOG from sqlyog.com
PHPMYADMIN from
Digital [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, 19 June, 2003 11:02
Subject: Re: [PHP-DB] MySQL editor
mysqlmanager (www.ems-hitech.com) is by far the best I've used.
They've changed the name to Navicat now. It really is fantastic software.
Edward Dudlik
Becoming Digital
On Friday 20 June 2003 01:11, Creative Solutions New Media wrote:
With the exception of phpmyadmin is there anything else out there that will
allow you to work on your mysql stuff remotely?
They should all allow you to access a remote installation of mysql. Now can we
please move this topic to
With the exception of phpmyadmin is there anything else out there that
will
allow you to work on your mysql stuff remotely?
Any of the programs will. The real questions whether you have permission to
connect remotely, though... :)
---John Holmes...
--
PHP Database Mailing List
A question was raised on the MySQL list about implementing transactions with
PHP. I had planned on them for an upcoming project but I'd yet to figure out
how I'd coordinate things.
The original author's solution (slightly altered) was to make an array with all
the queries and loop through them,
Hello,
Would be grateful if someone couldkindly point me in the right direction.
Whenever I try to connect to mysql server, I get these messsage back
1.
mysql GRANT ALL PRIVILEGES ON *.* TO moses@% IDENTIFIED BY cludiana;
ERROR 1045: Access denied for user: '@127.0.0.1' (Using password: NO)
On Wed, 2003-06-18 at 08:16, [EMAIL PROTECTED] wrote:
Hello,
Would be grateful if someone couldkindly point me in the right direction.
Whenever I try to connect to mysql server, I get these messsage back
1.
mysql GRANT ALL PRIVILEGES ON *.* TO moses@% IDENTIFIED BY cludiana;
ERROR
Becoming Digital wrote:
A question was raised on the MySQL list about implementing transactions with
PHP. I had planned on them for an upcoming project but I'd yet to figure out
how I'd coordinate things.
The original author's solution (slightly altered) was to make an array with all
the queries
[EMAIL PROTECTED] wrote:
Would be grateful if someone couldkindly point me in the right direction.
Whenever I try to connect to mysql server, I get these messsage back
1.
mysql GRANT ALL PRIVILEGES ON *.* TO moses@% IDENTIFIED BY cludiana;
ERROR 1045: Access denied for user: '@127.0.0.1' (Using
but when i used mysql_error() i got : sorry database not found
and i have privileges in mysql/ user table .. as shown below... the point is
if i changed 192.168.0.111 to localhost .. i managed to get the data ...
as my dbconnect.php file includes
?
mysql_connect(192.168.0.111 , root , password)
Is there an automatic way to insert an XML file into a MySQL DB through say,
Load Data InFILE?
Or does one have to Pick apart the XML with PHP and insert data into the
fields one by one, record by record?
/T
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
A quick google search produced this:
Creating XML from MySQL (it also talks about importing XML)
http://www.zdnet.com.au/builder/architect/database/story/0,234918,20266023,00.htm
On Wed, 11 Jun 2003 21:53:56 -0500, [EMAIL PROTECTED] wrote:
Is there an automatic way to insert an XML file
but when i used mysql_error() i got : sorry database not found
as my dbconnect.php file includes
?
mysql_connect(192.168.0.111 , root , password) or die(SORRY CANNOT
CONNECT) ;
mysql_select_db(kt) or
die(sorry database not found);
?
and the user table of mysql database :
#
# Dumping data for
On Tue, 10 Jun 2003 16:47:26 +0300
nabil [EMAIL PROTECTED] wrote:
but when i used mysql_error() i got : sorry database not found
as my dbconnect.php file includes
?
mysql_connect(192.168.0.111 , root , password) or die(SORRY
CANNOT CONNECT) ;
mysql_select_db(kt) or
die(sorry database
i have the dbconnect.php as :
//
?php
mysql_connect(192.168.0.111 , root , pass) or
die (Couldn't connect to database);
mysql_select_db(DatabaseName) or
die(sorry database not found);
?
///
when i put localhost instead of the IP address of my machine (localy) i got
Sorry , when i put the IP instead of localhost i got the error...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
i have the dbconnect.php as :
//
?php
mysql_connect(192.168.0.111 , root , pass) or
die (Couldn't connect to database);
mysql_select_db(DatabaseName) or
die(sorry database not found);
?
///
when i put localhost instead of the IP address of my machine
hi,
i put a script together to scan a directory and its subdirectories for
all mp3 files. the tag informations and path then should be put into a
mysql database.
i included a script called mphp3.php from http://res.crea-bmb.de/mphp3/
which returns the needed tag info from one file.
the script
Hi,
Where do you get $info2 from?
I only see $info in this function.
.: Allowee
function scan_dir($dir)
{
$info = New mphp3(2);
$handle = @opendir($dir);
while ($file = @readdir ($handle))
{
if (eregi(^\.{1,2}$,$file))
{
continue;
}
hi allowee,
sorry, this was not meant to be. $info2 is supposed to be $info. my
fault. but that is not the actual problem.
Hi,
Where do you get $info2 from?
I only see $info in this function.
.: Allowee
function scan_dir($dir)
{
$info = New mphp3(2);
$handle =
hmmm,
maybe this code..
$info-load(/.$dir.$file);
if $dir = mp3s and $file = test.mp3
then it will load '/mp3s/test.mp3'
you got that directory?
I've seen the class and you are hiding the fopen error message, which could be
the problem.
.: Allowee
On Saturday 07 June 2003 11:11, Ole Hornauer
Hi,
Where do you get $info2 from?
I only see $info in this function.
I guess that the $info-values are formfieldvalues.
$info-[db-field] is normaly used within a whileloop for
outputing a select-statement.
In the case of formfieldvalues you can use $formfieldname.
.: Allowee
function
On Saturday 07 June 2003 11:20, Allowee wrote:
hmmm,
maybe this code..
$info-load(/.$dir.$file);
if $dir = mp3s and $file = test.mp3
then it will load '/mp3s/test.mp3'
you got that directory?
I've seen the class and you are hiding the fopen error message, which could
be the problem.
well, you are right. the dir '/mp3' does not exist. 'mp3' is a subdir
from my htdocs dir. so i think the right path should be
'mp3/someartist/somesong', right?
i fixed that, but the original problem is still the same :(
hmmm,
maybe this code..
$info-load(/.$dir.$file);
if $dir = mp3s
moin,
sorry, my php-knowledge is not the best.
what do you mean with formfieldvalues?
i think $info-value is used to get the id3-tag info from the class,
right? this worked for me in a more simple way without the recursive
scan:
?
include(mphp3.php);
$info = New mphp3(2);
]
Sent: 30 March 2003 04:12
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySql Help needed
Greetings!
I am building an application in PHP and am creating a global $connect_id for
MySql. I have MySql on a separate machine and am using the connect like
this:
$server = development.myservermachine.net
On Sunday 30 March 2003 11:11, Bruce Feist wrote:
I wonder why the PHP/MySql interface doesn't simply return dates as
dates instead of strings. *frowns*
How do you mean? PHP doesn't have a date type.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems
Jason Wong wrote:
On Sunday 30 March 2003 11:11, Bruce Feist wrote:
I wonder why the PHP/MySql interface doesn't simply return dates as
dates instead of strings. *frowns*
How do you mean? PHP doesn't have a date type.
Ummm That's a good reason! As I said, I'm a newbie to PHP, and
Greetings!
I am building an application in PHP and am creating a global $connect_id for MySql. I
have MySql on a separate machine and am using the connect like this:
$server = development.myservermachine.net;
$username = myname;
$password = mypassword;
$connect_id = mysql_connect($server,
I originally wrote:
when I retrieve a date from MySQL into PHP, it shows up as a string instead of a date data type
What's the best way of controlling date format?
John W. Holmes replied:
If you want a Unix timestamp, which is compatible with the date()
function in PHP, then use the
I'm experienced with SQL, but new to MySql and PHP, which I'm using
together to create a dynamic web site. Right now, I'm having minor
difficulties with date formatting. It seems that when I retrieve a date
from MySQL into PHP, it shows up as a string instead of a date data
type, with format
I'm experienced with SQL, but new to MySql and PHP, which I'm using
together to create a dynamic web site. Right now, I'm having minor
difficulties with date formatting. It seems that when I retrieve a
date
from MySQL into PHP, it shows up as a string instead of a date data
type, with
Could someone please point me in the correct direction for a decent
comparison of the two in respect of:-
Reliability
Scalability
Speed
Functionality
These are actually in order or importance to me (I know both are fairly fast).
I am also interested in how easy it would be to migrate
of it, is prohibited and
may be unlawful.
-Original Message-
From: Ben Edwards [ mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] ]
Sent: maandag 24 maart 2003 12:03
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL or Postgres
Could someone please point me in the correct direction for a decent
sorry the url I gave was of a weird language..
this one is better:
http://www.phpbuilder.com/columns/tim2705.php3
-Original Message-
From: Ben Edwards [mailto:[EMAIL PROTECTED]
Sent: maandag 24 maart 2003 12:03
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL or Postgres
Could
-
From: Ben Edwards [mailto:[EMAIL PROTECTED]
Sent: maandag 24 maart 2003 12:03
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL or Postgres
Could someone please point me in the correct direction for a decent
comparison of the two in respect of:-
Reliability
Scalability
Speed
Functionality
:34 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql timestamps
I hope you don't mind me bothering you like this but you seem to know
what
you're talking about, you replied to my post on php.db in case you are
wondering who the heck I am.
I tried the SELECT TO_UNIXTIME(your_column) FROM
Ben,
Subject: [PHP-DB] MySQL or Postgres
Could someone please point me in the correct direction for a decent
comparison of the two in respect of:-
Reliability
Scalability
Speed
Functionality
These are actually in order or importance to me (I know both
are fairly
There are other open-source databases besides MySQL and Postgres. My
experience has pointed me towards firebird / interbase:
http://firebird.sourceforge.net/
Same here - 24/7 operation and Windows or Linux servers
--
Lester Caine
-
L.S.Caine Electronic Services
--
I have a large sql file that I would like to load into mysql database from a
remote client. Is there a way through a php script to do this?
I have tried $query = contents of database.sql ; (where the contents of
the sql file was pasted into the query)
then $results = mysql_db_query(database,
I have a large sql file that I would like to load into mysql database
from
a
remote client. Is there a way through a php script to do this?
I have tried $query = contents of database.sql ; (where the
contents
of
the sql file was pasted into the query)
then $results =
how do i change the format of a MySQL timestamp (i.e hh:mm:ss DD/MM/
instead of MMDDhhmmss) retrieved from a mysql database with php?
thanks in advance
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
how do i change the format of a MySQL timestamp (i.e hh:mm:ss
DD/MM/
instead of MMDDhhmmss) retrieved from a mysql database with php?
Use
SELECT TO_UNIXTIME(your_column) FROM table ...
And then use date() in PHP to format the result to your liking.
Or, you can use DATE_FORMAT() in
Hello! I have problem with database, where have field with cyrillic char(1). I cant
select by this field, because MySQL dont understand this chars as different.
How can set default charset to win1251 or cp1251? I use MySQL on windows platform.
Thank You!
Hi all,
I have 2 tables that I need to extract data from, say PORTS and STATS.
PORTS contains a list of Sea Ports in PORT i.e. : -
PORTS.PORT
UK
FRANCE
GERMANY
NETHERLANDS
SPAIN
ITALY
STATS contains a few thousand records that with among other things has the elements
I just set up a test db using your info, and the query you have
worked ok. It provided a zero. Here's what I have (slightly modified
from yours, but not appreciably).
select ports.port, sum(stats.amount) as Total from ports left join
stats on ports.port=stats.to_port group by ports.port order by
Message-
From: Mark [mailto:[EMAIL PROTECTED]
Sent: 12 March 2003 15:36
To: Griffiths, Daniel
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL Query help please!
I just set up a test db using your info, and the query you have
worked ok. It provided a zero. Here's what I have (slightly modified
I'm having trouble getting the results I want. The database deals with
libraries and reports they've submitted. Here are the relevant tables with
the primary keys marked with a star (*):
+--+
| libinfo |
+--+
| lib_id* |
| lib_name |
| city |
displayexpt.php?softID=$softID displays a checkbox
list of experts for a given piece of software. The
admin needs to select each user he wants to delete.
This is then posted to deleteexpt.php?softID=$softID,
which must delete users from the apliexpert table with
a statement like this:
DELETE FROM
PROTECTED]
Subject: [PHP-DB] mysql delete loop
displayexpt.php?softID=$softID displays a checkbox
list of experts for a given piece of software. The
admin needs to select each user he wants to delete.
This is then posted to
deleteexpt.php?softID=$softID,
which must delete users from
701 - 800 of 1362 matches
Mail list logo