, February 25, 2003 6:48 PM
Subject: Re: [PHP] mysql trouble
you don't have a password for root in mysql_connect
- Original Message -
From: Luis A [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 1:04 AM
Subject: [PHP] mysql trouble
hi pasl i got a troblem here
Quoting Luis A [EMAIL PROTECTED]:
### hi pasl i got a troblem here
###
###
### if some one can help me ?
###
### take a look at this
### ?php
### // process form
### $link = mysql_connect(localhost, root);
you need to have the password as the third argument
$link = mysql_connect(localhost,
take a look at this
?php
// process form
$link = mysql_connect(localhost, root);
mysql_select_db(mydb,$db);
$sql = INSERT INTO agenda (nombre, direccion, telefono, email) +
VALUES ('$nombre', '$direccion', '$telefono', '$email');
$result = mysql_query($sql);
You use a period (.) to
[EMAIL PROTECTED]
To: Luis A [EMAIL PROTECTED]
Sent: Tuesday, February 25, 2003 6:48 PM
Subject: Re: [PHP] mysql trouble
you don't have a password for root in mysql_connect
- Original Message -
From: Luis A [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February
### ?php
### // process form
### $link = mysql_connect(localhost, root);
you need to have the password as the third argument
$link = mysql_connect(localhost, root, password);
Also, why is it in a variable?
Just make it:
mysql_connect(localhost, root, password);
Sometime there are users
are being initialized.
To capture the values from a form use $_POST['name'] where name is the
name of the field on the form.
HTH
-Original Message-
From: Luis A [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 25, 2003 4:21 PM
To: [EMAIL PROTECTED]
Subject: [PHP] to paulm Re: [PHP] mysql
On Wed, 19 Feb 2003, Larry Brown wrote:
How do you determine whether or not it is faster/more efficient to run a
complicated query or to run multiple simple queries and join / manipulate
the results with PHP?
By empirical methods ...
--
PHP General Mailing List (http://www.php.net/)
To
My apologies for the prior html version, I forgot to change back to txt.
Larry S. Brown
Dimension Networks, Inc.
(727) 723-8388
On Wed, 19 Feb 2003, Larry Brown wrote:
How do you determine whether or not it is faster/more efficient to run a
complicated query or to run multiple simple
On Tue, 18 Feb 2003 09:23:52 -0800, you wrote:
Greetings all,
Is there an easy way to pull out the schema of a MySQL for viewing??
You want the tables and the relationships between them? Not easy to get
the links because of the lack of foreign keys in MySQL.
If you want a table, DESC
On Tuesday, February 18, 2003, at 12:23 PM, Phillip S. Baker wrote:
Is there an easy way to pull out the schema of a MySQL for viewing??
If you have access to the command line (either directly or via the
system() function), try this:
bash 2.05 $ mysqldump -t databasename --user=username
On Tuesday, February 18, 2003, at 12:39 PM, David Otton wrote:
You want the tables and the relationships between them? Not easy to get
the links because of the lack of foreign keys in MySQL.
You can add a comment to your table with the COMMENT modifier, which
gives you 60 characters to
Change your query:
select dayofmonth(Posted) as DOM_Posted,
month(Posted) as M_Posted,
year(Posted)as Y_Posted,
hour(Posted) as HH_Posted,
minute(Posted) as MM_Posted,
Name,
Prayer
from prayer
tnx it worked just like i wanted it to...
- Original Message -
From: Barajas, Arturo [EMAIL PROTECTED]
To: 'Sunfire' [EMAIL PROTECTED]
Sent: Tuesday, February 18, 2003 7:59 PM
Subject: RE: [PHP] mysql select and date functions
Have you tried naming the fields?
$query=mysql_query
Change your query:
selectdayofmonth(Posted) as DOM_Posted,
month(Posted) as M_Posted,
year(Posted)as Y_Posted,
hour(Posted) as HH_Posted,
minute(Posted) as MM_Posted,
Name,
Prayer
from prayer
Try user = 'root', password = ''.
It's a security breach, so you would want to change it ASAP. Look for the SQL GRANT
and REVOKE commands.
--
Un gran saludo/Big regards...
Arturo Barajas, IT/Systems PPG MX (SJDR)
(427) 271-9918, x448
-Original Message-
From: Tim Burgan
At 14:31 12.02.2003, Tim Burgan said:
[snip]
The problem is that I don't know what my USERNAME or PASSWORD for MyDQL are.
How do I find this information out?
[snip]
You need to ask your SysAdmin...
--
O
--- Daniel Page [EMAIL PROTECTED] wrote:
Would it be possible to store PHP code in a MySQL table,
then via a web page, connect to the DB, recover the code
that corresponds to a certain id number, then include
that code for execution?
Yes, and since your example demonstrates that you know how
Did you reload MySQL after you added the new user?
Stephen Craton wrote:
It's me again, trying to get some more help.
My boss is hosting sites now for games and I need some help with setting up
phpMyAdmin privelages for certain MySQL users and such. Right now, my
problem is setting up a new
, 2003 12:29 PM
Subject: Re: [PHP] MySQL Username and Passwords
Did you reload MySQL after you added the new user?
Stephen Craton wrote:
It's me again, trying to get some more help.
My boss is hosting sites now for games and I need some help with setting
up
phpMyAdmin privelages
[EMAIL PROTECTED]
Sent: Sunday, February 09, 2003 12:29 PM
Subject: Re: [PHP] MySQL Username and Passwords
Did you reload MySQL after you added the new user?
Stephen Craton wrote:
It's me again, trying to get some more help.
My boss is hosting sites now for games and I need some
]
To: Stephen Craton [EMAIL PROTECTED]
Cc: PHP List [EMAIL PROTECTED]
Sent: Sunday, February 09, 2003 12:29 PM
Subject: Re: [PHP] MySQL Username and Passwords
Did you reload MySQL after you added the new user?
Stephen Craton wrote:
It's me again, trying to get some more help
SELECT DISTINCT(gallery.design) FROM gallery
:
I want to limit to 1 the same names returned from the query like:
[CUT]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi Robbert,
Is there an easy way to find out what the auto_incremented
number is so I can use it to update the other table?
Sure, have a look at mysql_insert_id:
http://php.net/mysql_insert_id
Cheers
Jon
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
: RE: [PHP] mysql auto increment question
Hi Robbert,
Is there an easy way to find out what the auto_incremented
number is so I can use it to update the other table?
Sure, have a look at mysql_insert_id:
http://php.net/mysql_insert_id
Cheers
Jon
--
PHP General Mailing List (http://www.php.net
Chris Shiflett wrote in message:
Your query returns two rows because you have two rows in
the database that match the condition:
host='localhost'
--
Chris
..
Chris,
I was under the impression that the mysql database had as default user when
installed:
- Original Message -
From: CDitty [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, February 01, 2003 11:26 AM
Subject: [PHP] MySQL/PHP Associative Array Insert
A co-worker is teaching me to move to the next level in php. I have
started using associative arrays for my scripts,
--- Anthony Ritter wrote:
I installed mysql 3.23.55 and wanted to check the user
table in the mysql db.
The query was:
SELECT User FROM user WHERE host='localhost';
This is a PHP list. There are mailing lists for MySQL that
you should check out if you are having trouble
understanding
Yes Chris,
When you add the item to the database, make sure to leave out the single
quotes inside the brackets of the associative array. For example:
Instead Of:
$item['itemID']
Do This:
$item[itemID]
Example Query:
$query = SELECT * FROM items WHERE '$item[itemID]';
Hope that helps.
To: [EMAIL PROTECTED]
Subject: RE: [PHP] MySQL/PHP Associative Array Insert
Yes Chris,
When you add the item to the database, make sure to leave out the single
quotes inside the brackets of the associative array. For example:
Instead Of:
$item['itemID']
Do This:
$item[itemID
put your password in the mysql_connect. mysql_connect(localhost, root,
yourpassword);
or create a new user in mysql that has no password and minimal permissions.
-Original Message-
From: Gibbs, Liam - SXIA [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 29, 2003 9:46 AM
To:
If you're using root, then you must use the root password in mysql_connect().
- Original Message -
From: Gibbs, Liam - SXIA [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, January 29, 2003 8:45 AM
Subject: [PHP] MySQL Madness
First off, when executing this command:
If MySQL is configured on your system correctly, you need a password in
your script. I'm curious, though, why you're accessing it as root?
Usually I create a user account in mysql and grant only the priviledges
needed for that account. It may be a mute point, but if a bug were to
crop up and
hi..
i came across the same problem before and it was well lets say i probably
dont have any hair left (from pulling it out) hehe.. anyways you need to go
into the grant tables and look to see what is set up for users.. most likely
you dont have a root@localhost user because as far as i understand
MySQL infact perfectly understands what localhost is, example:
GRANT ALL PRIVILEGES ON dbname.* TO bob@localhost IDENTIFIED BY 'password';
The above will work fine, and aslong as you connect in your PHP with the username
bob, and host localhost with pass password you'll be fine.
On
ok sorry to repeat everything already said
- Original Message -
From: Adam Voigt
To: Sunfire
Cc: Gibbs, Liam - SXIA ; [EMAIL PROTECTED]
Sent: Wednesday, January 29, 2003 1:00 PM
Subject: Re: [PHP] MySQL Madness
MySQL infact perfectly understands what localhost
I am guessing that you installed the php from a redhat rpm; if so then you
just need to install the php-mysql rpm. You can download from:
http://rpmfind.net//linux/RPM/redhat/8.0/i386/php-mysql-4.2.2-8.0.5.i386.htm
l (or any of a number of other places).
Cheers,
Steven Balthazor
-Original
Anyone out there have anything to share as to using PHP4+MySQL4. I've been
hearing good things on the MySQL list about v4.0 and I'm thinking of
upgrading, since I run a rather small server.
There's really no change from the PHP side. PHP just sends the data and
receives something back The only
On Wednesday 22 January 2003 18:52, 1LT John W. Holmes wrote:
There's really no change from the PHP side. PHP just sends the data and
receives something back The only change in PHP is that mysql_connect() now
supports additional flags to connect over SSL.
Nope, I only forgot to remove a
On Wednesday 22 January 2003 18:52, 1LT John W. Holmes wrote:
There's really no change from the PHP side. PHP just sends the data
and
receives something back The only change in PHP is that
mysql_connect()
now
supports additional flags to connect over SSL.
Nope, I only forgot to remove
Networks, Inc.
(727) 723-8388
-Original Message-
From: Daniel Elenius [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 14, 2003 5:22 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] MySQL problem with RedHat 8
Yes, mysql.so is in /usr/lib/php4. The php.ini file has this in it:
[daniel
http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#Work
ing_with_NULL
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Con
trol_flow_functions
Regards,
Daniel Kushner
_
Need hosting?
IFNULL! thanks
-Original Message-
From: Daniel Kushner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 16 January 2003 1:51 PM
To: Sean Malloy; PHP General
Subject: RE: [PHP] MySQL Query - Not PHP Specific
http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#Work
Make sure that the shared module is in the correct directory.
Check your php.ini file to make sure but it is most likely at /usr/lib/php4
make sure that you have mysql.so
- Original Message -
From: Daniel Elenius [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, January 14, 2003 3:58
Yes, mysql.so is in /usr/lib/php4. The php.ini file has this in it:
[daniel@p85 etc]$ grep mysql php.ini
;extension=php_mysql.dll
extension=mysql.so
mysql.allow_persistent = On
mysql.max_persistent = -1
mysql.max_links = -1
; Default port number for mysql_connect(). If unset, mysql_connect()
the thing that may make difference in performance (as i think) is whether
you make it a fixed -CHAR- or a variable -VARCHAR- it's preferable that you
make separate char columns, so that PHP will not have to explode every
record!
Regards,
Khalid Al-Kary,
Hi,
I got a question about using
I see what you mean Khalid, but I only retrieve 1 entry at the time, so
exploding wouldn't be the biggest problem I suppose.
Furthermore, if I use char columns, and some of those columns have lots
of empty cells, isn't it a waste of space/lookup-time?
So I think I have to reformulate the
-Original Message-
From: Simon Dedeyne [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 9:03 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP] Mysql/php database performance question
So I think I have to reformulate the question: which is
better 5 varchar columns of size 50
keeping those 5 columns with a lot of empty cells in the last columns
is better as it is means exactly for that. Just don't make it a not null
field.
--
Maxim Maletsky
[EMAIL PROTECTED]
Khalid El-Kary [EMAIL PROTECTED] wrote... :
the thing that may make difference in performance (as i
char of greater size than 3 is converted to varchar anyways
Where's the pain? The trade off between char and varchar is speed vs
table size. Are just trying to be as fast as possible? If the db is
small, I wouldn't worry about it and do what ever way you want (i.e.
what's a microsecond or
-Original Message-
From: Marek Kilimajer [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 11:04 AM
To: Matt Schroebel
Cc: Simon Dedeyne; [EMAIL PROTECTED]
Subject: Re: [PHP] Mysql/php database performance question
char of greater size than 3 is converted to varchar
PROTECTED]
Subject: Re: [PHP] Mysql/php database performance question
char of greater size than 3 is converted to varchar anyways
Are you sure? I've been reading up on this stuff over the last few
days, and my understanding is that char is stored fixed width with
trailing spaces
-Original Message-
From: Marek Kilimajer [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 11:45 AM
To: Matt Schroebel
Cc: Simon Dedeyne; [EMAIL PROTECTED]
Subject: Re: [PHP] Mysql/php database performance question
Sure, just tried it (32-bit platform, might be 7 for 64
in one table
Matt Schroebel wrote:
-Original Message-
From: Marek Kilimajer [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 11:45 AM
To: Matt Schroebel
Cc: Simon Dedeyne; [EMAIL PROTECTED]
Subject: Re: [PHP] Mysql/php database performance question
Sure, just tried it (32-bit
Matt Schroebel wrote:
-Original Message-
From: Marek Kilimajer [mailto:[EMAIL PROTECTED]] Sent: Friday,
January 10, 2003 11:45 AM
To: Matt Schroebel
Cc: Simon Dedeyne; [EMAIL PROTECTED]
Subject: Re: [PHP] Mysql/php database performance question
Sure, just tried it (32-bit platform
I'm coming in a little late on this thread, but I would suggest
structuring you data differently.
I would have two tables: words and meanings. Then you won't have any
null fields and you won't limit yourself to just 5 definitions. It will
also be a heck of a lot easier to setup a full text
What about transactions ? In all the discussion noone points that
PostgreSQL uses them. Maybe noone uses transactions so they have no
matter.
--
Krzysztof Dziekiewicz
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
That did it thanks!
V
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I'm just deciding which DB to use for my projects and I'm not clear with one
thing... When considering a database for web, is MySQL good enough? I read
it only supports table locking, which is not very satisfying in such a
multiuser environment as the internet..
PostgreSQL has transactions
is MySQL good enough? I read it only supports table locking,
which is not very satisfying in such a multiuser environment
as the internet..
Read all of http://www.mysql.com/doc/en/ANSI_diff_Transactions.html
You'll find an explanation of what atomic operations are and how they
compare to true
I'm just deciding which DB to use for my projects and I'm not clear with
one
thing... When considering a database for web, is MySQL good enough? I
read
it only supports table locking, which is not very satisfying in such a
multiuser environment as the internet..
PostgreSQL has
See MySQL 4.x. They also have subselects now (HUGE!). As for an
Well, not really. Nested queries are scheduled for 4.1. 4.0 is in
gamma, 4.1 isn't even available for download as alpha. You'll have to go
with Postgres for now if you need subselects.
Regarding row locking and transactions,
Not to cause a flame war, but, MySQL and PostgreSQL are both excellent
choices, MySQL tends to be a lighter less feature rich database while
PostgreSQL tends to have more features, perform better under load, etc.
You can read a lot about the two databases at google.com and also at
postgresql.org.
Not to cause a flame war, but, MySQL and PostgreSQL are both excellent
choices, MySQL tends to be a lighter less feature rich database while
PostgreSQL tends to have more features, perform better under load, etc.
Under differing types of load, yes. MySQL is more hit-based, while
PostgreSQL
Assuming you are using a textarea/textarea to allow your users to
input their text you need to either use the nl2br (converts new lines to
br) or use pre/pre tags, following are short examples:
print nl2br($data); or
print 'pre';
print $data
print '/pre';
You can find out more about the nl2br
what appeared when you printed the text of your query:
$query = update bloggers set cache='$blog', title='$title' where url='$address';
print $query;
I'm thinking that your single quotes preventd $blog, $title, $address form being
expanded.
- Original Message -
From: Jesse Lawrence
On Monday 06 January 2003 00:27, Jesse Lawrence wrote:
I've been scratching my head over the following code
for a while now. It's supposed to check a given
weblog for specific tags, and if they're present,
update the weblog's table in my database. I believe
the problem is around the
No, the query is working fine... all variables are printing correctly.
This is what has me confused. Everything seems to be as it should, it's
just not updating the db table.
Rick Emery wrote:
what appeared when you printed the text of your query:
$query = update bloggers set cache='$blog',
]
To: [EMAIL PROTECTED]
Sent: Sunday, January 05, 2003 11:50 AM
Subject: Re: [PHP] Mysql update problems
No, the query is working fine... all variables are printing correctly.
This is what has me confused. Everything seems to be as it should, it's
just not updating the db table.
Rick Emery wrote:
what
On Wednesday 01 January 2003 00:21, John Hinton wrote:
Stuck on this join temp
From one table I need to
mysql_query(CREATE TEMPORARY TABLE temp TYPE=HEAP SELECT DISTINCT
field1, field2 FROM $table);
both field1 and field2 have various repeating data and I need to return
only the first
Youy are unlikely to egt balanced asvice on this in the MySQL or
Postgress lists -after all those people have already made thier decision.
I haven't used Postgress much - but basically...
Mysql - available on loads of hosting packages, very large user base.
PostgreSQL - better adherance to
Both databases work well for what they are intended to do.
Either database will have good basic performance, however PostgreSQL has
had more advanced features and stability in the past some of which MySQL
has worked on gaining.
Last I heard there was still issues with complex operations and
You accidentally published this to the wrong email list. I assume you meant to send
this
to the MySQL email list.
- Original Message -
From: Miro Kralovic [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, December 23, 2002 9:10 AM
Subject: [PHP] MySQL vs PostgreSQL
Hi,
I'm just
Miro, et al --
...and then Miro Kralovic said...
%
% Hi,
Hello!
%
% I'm just deciding which DB to use for my projects and I'm not clear with one
% thing... When considering a database for web, is MySQL good enough? I read
% it only supports table locking, which is not very satisfying in such
What's wrong with
select left(myfield, 500) from mytable;
?
Quentin
-Original Message-
From: Micah Bushouse [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 17 December 2002 3:22 p.m.
To: [EMAIL PROTECTED]
Subject: [PHP] MySQL select a field's first X bytes
Is there a way in MySQL to
Thanks a lot!
I'm just blind!
Quentin Bennett [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
o.nz...
What's wrong with
select left(myfield, 500) from mytable;
?
Quentin
-Original Message-
From: Micah Bushouse [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 17 December 2002 3:22
Well, are you getting a valied response from the database?
Perhaps it would be nice to add some error handling into your code...
i.e.:
$mysql_result = mysql_query($query, $mysql_link)
or die(Invalid query: $query);
or echo out mysql_error();
GWAD Mailinglist wrote:
Hi,
I have following
$mysql_result = mysql_query($query, $mysql_link);
I am not sure if this is your only problem or not, but mysql_result(); is a
function in php. Using a function name as a variable seems like it will
just lead to confusion to me. I'd try to avoid it.
-- line 36 while($row =
You need to do some error handling, as in:
$mysql_result = mysql_query($query, $mysql_link);
// get each row
-- line 36 while($row = mysql_fetch_row($mysql_result))
Make sure $mysql_result is a valid resource as PHP
is telling you it's not. Here's one way:
if
-- line 36 while($row = mysql_fetch_row($mysql_result))
Anyway, where do you define $row?
HTH
-Craig
DOH! it's been a long one...
-Craig
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
thanks for the reply,
but that didn't help
ERROR 1064: You have an error in your SQL syntax near 'mysqldump -h
localhost -u xxx -p xxx backup.sql' at line 1
any ideas?
Adam Voigt [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Take off the backup.sql and see
Shaun wrote:
I am trying to backup my database can someone please tell me why the
following commande wont work?
mysqldump -h localhost -u username -p databasename backup.sql
Changing username and databasename to valid values on my database, I
get this line to work here. What error are you
Your not trying to run that from within MySQL are you?
You do know that mysqldump is an entirely seperate command then the mysql
console (where you would for instance type, USE DB; SELECT blah FROM table) right?
On Mon, 2002-12-09 at 10:26, Shaun wrote:
thanks for the reply,
Shaun wrote:
ERROR 1064: You have an error in your SQL syntax near 'mysqldump -h
localhost -u xxx -p xxx backup.sql' at line 1
It sounds like you are not running it from the command prompt but from
within mysql. Unless the omission of the redirection sign but not
backup.sql was intentional,
Quote:
It sounds like you are not running it from the command prompt but from
within mysql.
Reponse:
I suspect as much.
On Mon, 2002-12-09 at 11:15, Chris Hewitt wrote:
Shaun wrote:
ERROR 1064: You have an error in your SQL syntax near
Indeed, now it works, I put the form tag by mistake...
Thanks,
Adrian
- Original Message -
From: rija [EMAIL PROTECTED]
To: Adrian Partenie [EMAIL PROTECTED]
Sent: Tuesday, December 03, 2002 11:30 PM
Subject: Re: [PHP] mysql, php, checkbox
There are form/form tags around input type
1. there is a MySQL mailing list, details can be found on mysql.com
2. i just did a really simple search on php net for mysql table, and got
the following amongst a few results:
mysql_field_table()
mysql_list_tables()
mysql_tablename()
it would be good if you could search the php (and mysql)
Hi,
Friday, December 6, 2002, 2:08:42 AM, you wrote:
h I am really sorry but i can't find any good mySQL good mailing list...
h How can i make a little php function to check if a table exists ?
h Thanks a lot,
h Hacook
function table_exists($table){
return (@mysql_query('SELECT
Thanks for the info... As it turns out, I am just a blithering idiot...
I
didn't know that I had to create a separate user... As I said, that shows
my newbieness...
Hey we don't always castrate blithering idiots here. Only those who
pretend not to be one.
However, this has lead me to
, November 28, 2002 5:54 PM
Subject: RE: [PHP] mysql, php, checkbox
I'm displaying the content of a mysql table with autoincrement index.
I
want to be able to select the each row from the table using the check
boxes. In order to do that, i want to assign to each checkbox the
name=index
Thanks for the info... As it turns out, I am just a blithering idiot... I
didn't know that I had to create a separate user... As I said, that shows
my newbieness...
However, this has lead me to another question... The default database,
mysql, comes with a users file already... How do I
mysql-database contains all the system tables and users.
Users are only inserted there and defined for which database they are made.
As Jason suggested, look at mysql.com they have a fine manual with tutorials
and long descriptions which lead to easy solutions to create users.
i.e. search
On Tuesday 03 December 2002 23:09, Chase wrote:
I am the first to admit that this question belongs on a MySQL newsgroup
instead of here, but I can't seem to find a newsgroup that will answer
me...
www.mysql.com
Here is a newbie question. I am running a Win2K Advanced Server with IIS
5?,
Perhaps you should try and do some error checking on the mysql_select_db()
function, like printing out mysql_error().
Also, for the permissions issues, mysql has a very comprehensive online
documentation on user permissions. Check them out, you may also wish to try
and connect to the database
I did that and it didn't output anything...
- Original Message -
From: Brad Bonkoski [EMAIL PROTECTED]
To: Stephen [EMAIL PROTECTED]
Cc: PHP List [EMAIL PROTECTED]
Sent: Sunday, December 01, 2002 2:55 PM
Subject: Re: [PHP] MySQL Error
Perhaps you should try and do some error checking
I'm displaying the content of a mysql table with autoincrement index.
I
want to be able to select the each row from the table using the check
boxes. In order to do that, i want to assign to each checkbox the
name=index of selected row.
I assign to the checkboxes the value of selected id, but
http://www.phplens.com/ might be something you could use.
Michael P. Carel [EMAIL PROTECTED] wrote in message
002d01c295b8$f0301800$[EMAIL PROTECTED]">news:002d01c295b8$f0301800$[EMAIL PROTECTED]...
hi to all;
sorry for posting this mysql question again. im searching for a report
builder for
Hello,
Snijders, Mark [EMAIL PROTECTED] wrote:
hello,
For connection data between my site, and another site, I need to export my
MySql data to a XML file.
Does anybody know any excisting scripts for this? so I don't have to make
it
all myself?
Have you checked the latest version of
From now on ask this on a MySQL list, please.
1.How many tables can be created inside a database? There is a maximum
number?
Only limit is how many files your file system will allow in one
directory.
2.Is it possible to erase a table?
Yes
---John Holmes...
--
PHP General Mailing List
On Friday 22 November 2002 02:12, Jule Slootbeek wrote:
I have a problem,
i know this is not the MySQL mailinglist, but i hope you guys can help
me.
when i type mysqladmin variables the port comes up as 0 and doesn't let
people connect to my db remotely.
does anyone know why this problem is,
In article 003001c28a86$cab1dce0$[EMAIL PROTECTED],
[EMAIL PROTECTED] says...
I have php (as an apache module) and mysql up and running on Windows in the same
computer, but they seem to be unconnected.
How do I configure php.ini, my.ini, etc for a php script to find and query a
database in
1001 - 1100 of 1710 matches
Mail list logo