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
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 PROTECTED]
Sent: Thursday, June 19,
: [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
Next time ask on the MySQL list!
Navicat
Mascon
PHPMyAdmin (for web interface)
SQLYog
MyCC (from www.mysql.com)
The first two are very professional programs that offer a lot of features
including Reports and Query wizards. Similar to using Access on Windows
(interface wise), but without the
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: Angelo Zanetti [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 4:40 AM
Subject:
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
DBTools - www.dbtools.com.br
___
Ryan Marrs
Web Developer
Sandler Travis Trade Advisory Services, Inc.
248.474.7200 x 183
248.474.8500 (fax)
www.strtrade.com
-Original Message-
From: Michael Lewis [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003
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
Zanetti [EMAIL 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
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
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)
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
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);
Hi
Try running a grant query
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER
ON database_name.*
TO [EMAIL PROTECTED]
IDENTIFIED BY 'mypassword';
which will probably fix it
Peter
-Original Message-
From: Sparky Kopetzky [mailto:[EMAIL PROTECTED]
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
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
hi,
Ih ate people being so lazy..
open google and type the words: mysql postgres
and you get enough results, here i looked one up for you:
http://www.mmlabx.ua.es/mysql-postgres.html
http://www.mmlabx.ua.es/mysql-postgres.html
___
Mark Snijders, Developer
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
Where MySQL loses points in the daemon robustness department, it makes up
for it by apparently never corrupting its data files. The last thing you
want is your precious data files fouled randomly, and MySQL does well here.
In over a year of running MySQL, I haven't ever seen a single case of
: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 =
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
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 found that my what I had could actually do the
trick. Basically I didn't know that you could make a
delete statement like this:
DELETE FROM apliexpert WHERE ( id = 2 OR id = 7 OR
id = 1) AND softid = 3
So my code goes:
code
for ($index = 0; $index $total_records;
J,
Try this (it assumes that the softid you want to search for is in the
variable $softid):
$sql = SELECT Expert.*
FROM Expert
LEFT JOIN Apliexpert ON Expert.id = Apliexpert.exptid
WHERE Apliexpert.softid = '$softid'
ORDER BY Expert.Name;
--
I have a new project where i need show pages of report on demmand.
That
reports are created in the batch process, and the whole file size is about
5
Gb. (thats includes all the reports in a month, I need save about 12
month).
I think in two alternatives :
1. I save the links in
This is what I use to generate a comma delimited csv file:
$sql = SELECT * FROM table INTO OUTFILE 'file.csv'
. FIELDS TERMINATED BY \',\'
. ENCLOSED BY \'\\';
Hope this helps.
Ruth
- Original Message -
From: Snijders, Mark [EMAIL PROTECTED]
To: [EMAIL
I had the some problem and someone told me this
What is your problem exactly?
Have you investigated the MySQL manual under:
LOAD DATA INFILE
SELECT ... INTO OUTFILE ?
And it realy helped.
Cumprimentos
Bruno Pereira
[EMAIL PROTECTED]
-Original Message-
From: Snijders, Mark
while ($row= mysql_fetch_array($result)) //retrieve a row and store in
echo A HREF= .$row['UrlColumnName'].;
That's how I'd do it.
Ryan
-Original Message-
From: G [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 17, 2003 8:16 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql +php
: RE: [PHP-DB] mysql +php
while ($row= mysql_fetch_array($result)) //retrieve a row and store in
echo A HREF= .$row['UrlColumnName'].;
That's how I'd do it.
Ryan
-Original Message-
From: G [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 17, 2003 8:16 PM
To: [EMAIL PROTECTED
Thanks got it working
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Thanks for all the help everyone sent me on this. However, nothing seems to
make any difference whatsoever (except putting the 'localhost' part in
quotes). I am still getting permission denied errors based on the user
credentials.
I have entered a user into the user table with host='localhost',
On Fri, 14 Feb 2003 11:30:03 +0200
[EMAIL PROTECTED] (Evan Morris) wrote:
Thanks for all the help everyone sent me on this. However, nothing
seems to make any difference whatsoever (except putting the
'localhost' part in quotes). I am still getting permission denied
errors based on the user
Looks like is to do with MySQL permissions. Check your host's (the one you
are trying to connect from) permissions to the server.
To change permissions, from the MySQL prompt type;
GRANT ALL ON * TO username@host IDENTIFIED BY password;
Substitute in username, host and password for your ones.
:[EMAIL PROTECTED]]
Sent: 13 February 2003 14:01
To: Clarkson, Nick
Subject: Re: [PHP-DB] MySQL problem -- new to PHP
Well you opened up my question! Do you know where to learn PHPMyAdmin?
Thanks in advance,
Mark
Clarkson, Nick wrote:
Looks like is to do with MySQL permissions. Check your host's
If you cut and pasted your code, try to put localhost into quotes as well.
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
Pay It Forward
mailto:[EMAIL PROTECTED]
http://accessingram.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent:
When changing/adding permissions to the mysql db for specific users,
dont forget to do 'flush privileges'...
my 2 cents
On Thu, 2003-02-13 at 07:19, Evan Morris wrote:
Hi all
I am new to PHP (just basically started yesterday). I am currently having a
problem connecting to a MySQL database.
I have a question about MySQL, i use MySQL 3.23.55 together with PHP
4.3.0 on my windows XP system. Does the version of MySQL supports
InnoDB
tables? And how do i do it i have noticed that in PhpMyAdmin i
cannot choose this table format..., but i gues that has more to do
with
the
Agree fully
Try this:
$query = select * from category where id=$scrow-category;
$result = mysql_query($query) or die( mysql_error() );
If your query fails, and u still can't find the reason from the
information that mysql_error() give you, put a echo $query inbetween
to see which string
It means your query failed... it always means your query failed for some
reason (unless you typo a variable name...). Learn to use mysql_error()
in conjunction with mysql_query(). Also, like I said before,
mysql_db_query() is depreciated, you should be using mysql_query().
---John W. Holmes...
Hi Jordan
Made any recent changes to your network configuration? Can you access other
IP ports OK e.g. http port 80? Do you have any firewall protection on your
PC? Can you access MySQL from the command line OK?
Rich
-Original Message-
From: JordanW [mailto:[EMAIL PROTECTED]]
Sent: 28
Just a shot in the dark, but be sure the socket and port settings are
correct for your setup (whatever that might be since you did not include
that info in your post) and that mysql is actually running.
Be sure to scour
http://www.mysql.com/documentation/mysql/bychapter/index.html
especially
Jeremy,
This question probably should be posted to the MySql mailing list but here
goes.
Take a look at this link:
http://www.mysql.com/doc/en/Where_optimisations.html
Your example was not very explicit so I am not sure, but I believe you are
in need of a
WHERE clause. For example;
Select a,
It is safe to test if the divisor is zero:
replace
columnB/columnC
by
IF( columnC = 0, 0, columnB/columnC )
(the 0 could be anything else; this depends on your business logic)
Ignatius
- Original Message -
From: Jeremy [EMAIL PROTECTED]
To:
I need some help from you MySQL gurus out there. This is pure SQL by
the
way..no front-end.
Lets say you have a table that has 2columns.columnA,
ColumnB and columnC
I have something like this
Oh CRAP! You lost me... you said two columns but listed 3! ;)
if (columnA'7',
I'm pretty sure that the error is because you're not able to set a length
for the TEXT column type. I checked the MySQL manual and it does not show a
prototype with that optional parameter. Besides, if you want a TEXT of
(255), why not just use a VARCHAR (255)? They're essentially the same thing
You want to look at nl2br() function.
It takes newlines from a text like:
Hello
My name is
Aaron
Which when outputted normally would look like:
Hello my name is aaron
Using echo nl2br($dbquery); would produce:
Hellobrbr
My name isbrbr
Aaronbrbr
In your HTML code which then would output in
If you want all records, remove the where clause.
select * from mytable
Jim
---Original Message---
From: Edward Peloke
Date: Wednesday, January 08, 2003 02:03:04 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql wildcard
I have an query:
select * from offtime where
Well, if that is your only condition, why not use:
'select * from offtime' as your query?
I believe the % as a wildcard is standard SQL, so I would *think* it should
work in mysql, have you tried it?
-Brad
Edward Peloke wrote:
I have an query:
select * from offtime where type='$type'
then
You probably want something like:
select * from offtime where type like '{$type}%'
As a side note, are you making sure that $type does not contain any
malicious code?
Cheers,
Marco
--
php|architect - The Monthly Magazine for PHP Professionals
Come check us out on the web at
In a message dated 1/8/03 2:48:15 PM Pacific Standard
Time, [EMAIL PROTECTED] writes:
I have an query:
select * from offtime where type='$type'
then I just pass the type variable to the page. Is
there a wildcard in mysql like there is in sqlserver
that I can use to grab all the records? such
on 1/6/03 8:24 PM, David Chamberlin at [EMAIL PROTECTED] appended the
following bits to my mbox:
Is there any way to set the time format so that any time values in my
SELECT call are in a speicified format (e.g., HH:MM instead of HH:MM:SS).
Basically I've got a table of a variety of
Paul Burney wrote:
Why not add the TIME_FORMAT calls to the original query rather than
performing all the extra queries? Is your first select something like the
following?
That's what I'd like to do, but not sure how to do that in this context.
SELECT
This is a bit of a newbie question, but I couldn't find what I wanted
in
the documentation.
Is there any way to set the time format so that any time values in my
SELECT call are in a speicified format (e.g., HH:MM instead of
HH:MM:SS).
Basically I've got a table of a variety of different
Hi,
Does mysql user has rights to write in this directory or permissions over
this file?
Andrey
- Original Message -
From: conbud [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 03, 2003 11:00 AM
Subject: [PHP-DB] MySQL Database connection Problem
Hello can someone
On Friday 03 January 2003 17:00, conbud wrote:
Hello can someone give me some possible reasons this error happens when
I use the mysql client to add a tabe to a database.
mysql create table home (id int not null, heading blob not null,
- primary key (id), unique id (id));
ERROR 3: Error
Jason Wong wrote:
On Friday 03 January 2003 17:00, conbud wrote:
Hello can someone give me some possible reasons this error happens when
I use the mysql client to add a tabe to a database.
mysql create table home (id int not null, heading blob not null,
- primary key (id), unique id (id));
- Original Message -
From: conbud [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, January 03, 2003 11:11 AM
Subject: Re: [PHP-DB] MySQL Database connection Problem
Jason Wong wrote:
On Friday 03 January 2003 17:00, conbud wrote:
Hello can someone give me some
Hristov
- Original Message -
From: conbud [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, January 03, 2003 11:11 AM
Subject: Re: [PHP-DB] MySQL Database connection Problem
Jason Wong wrote:
On Friday 03 January 2003 17:00, conbud wrote:
Hello can someone give
what about the permissions? are they ok?
Andrey
- Original Message -
From: conbud [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 03, 2003 11:30 AM
Subject: Re: [PHP-DB] MySQL Database connection Problem
Andrey thanks, but I seen that already and theres over 80 gig left
On Friday 03 January 2003 17:11, conbud wrote:
Jason Wong wrote:
On Friday 03 January 2003 17:00, conbud wrote:
Hello can someone give me some possible reasons this error happens when
I use the mysql client to add a tabe to a database.
mysql create table home (id int not null, heading blob
SELECT * from table where
passwordfield=PASSWORD('$variablewithpassword') and
username='$usernametocheck' limit 1
Sabina Alejandr Schneider wrote:
Hello to everybody!! I'm writing to know if somebody knows how can I
validate a password that has been encrypted with the PASSWORD() mysql
Check this resource: http://www.mysql.com/doc/en/Passwords.html
Rich
-Original Message-
From: Sabina Alejandr Schneider [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 03, 2003 8:48 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Mysql Passwprd validation
Hello to everybody!! I'm writing
Does the user that the script runs as have full CRUD access to the
new tables? Have you set any restrictions on what that user can do to
the table(s)?
--- Jody Cleveland [EMAIL PROTECTED] wrote:
Hello,
I'm using a product called Squirrelmail for my web based email. In
it, it
uses a database
Does the user that the script runs as have full CRUD access to the
new tables? Have you set any restrictions on what that user can do to
the table(s)?
Boy, do I feel lost...
How would I check that?
Thanks!
Jody
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
Sorry. Stupid technospeak on my part.
When you connect to the database, you tell it to use a particular
username and password. When these new tables were created, did you
change the permissions in the mysql table for the user, or does that
account have access to all the tables/databases?
Sorry. Stupid technospeak on my part.
No problem, much ignorance on my part.
When you connect to the database, you tell it to use a particular
username and password. When these new tables were created, did you
change the permissions in the mysql table for the user, or does that
account have
--- Jody Cleveland [EMAIL PROTECTED] wrote:
Sorry. Stupid technospeak on my part.
No problem, much ignorance on my part.
When you connect to the database, you tell it to use a particular
username and password. When these new tables were created, did
you
change the permissions in the
This can be done using the 'timestamp' type for your column. Note that
this field will be updated to the current time any time the row is
modified (including when it is created).
An alternative is to do it on the scripting side with the MySQL NOW()
command like so:
INSERT INTO your_table
I'm trying to convert an ASP/Access tutorial to PHP/MySQL and have a
question regarding MySQL.
In Access one can create a date field and set the default to Date()
to
get
the current date but according to the mysql manual:
http://www.mysql.com/doc/en/CREATE_TABLE.html
Default values
probably b/c of grants/rights
did you run a -- grant all on *.* to user@localhost ? or something of the
sort. or set up root to have access
can you connect via command line?
HTH
Jeff
]
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] mysql-windows xp
turn off the xp firewall as well.
Jason
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 13, 2002 7:29 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql
]
jason.selph@h cc: [EMAIL PROTECTED]
p.com Subject: RE: [PHP-DB] mysql-windows xp
:[EMAIL PROTECTED]]
Sent: Friday, December 13, 2002 8:54 AM
To: SELPH,JASON (HP-Richardson,ex1)
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] mysql-windows xp
that didn't cause me any issues on my install. why do you have to turn
that off. i'm not doubting you, just curious
the option to Protect my
computer or network.
Jason
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 13, 2002 7:54 AM
To: SELPH,JASON (HP-Richardson,ex1)
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] mysql-windows xp
that didn't
]
Cc: SELPH,JASON (HP-Richardson,ex1)
Subject: RE: [PHP-DB] mysql-windows xp
by default on a new xp install the firewall is enabled. stops everything on
your network from getting thru. if port 3306 is blocked then accessing
mysql thru ip would be denied.
To disable internet connection firewall
Thanks for all the help. I finally got it running by running winmysqladmin
Eddie
-Original Message-
From: SELPH,JASON (HP-Richardson,ex1) [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 13, 2002 9:29 AM
To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] mysql-windows xp
-Richardson,ex1) [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, December 13, 2002 6:28 AM
Subject: RE: [PHP-DB] mysql-windows xp
I honestly can't give you an answer on that as I haven't installed mysql
on
XP. On linux there are 2 ways to connect to your server, socket
(/trtr);
}
}
-Original Message-
From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 05, 2002 3:26 PM
To: Ryan Jameson (USA); Art Chevalier; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL Array
I think he meant that he is only pulling one
501 - 600 of 916 matches
Mail list logo
