create table members (
logon_idvarchar(15) NOT NULL,
email_addr varchar(30) NOT NULL,
member_type char(1),
email_verified char(1),
logon_pwvarchar(15),
date_added date,
last_login
I think you are asking for mysql_pconnect(localhost,root)
-Original Message-
From: Cory at SkyVantage [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 22, 2006 2:20 PM
To: MySQL-List
Subject: Connection Buffer
Is there anything I can put into the my.cnf file to buffer
connection
(leave
When doing an insert using NULL in the insert request,
what really is being written in the column?
Is the word NULL being written?
Is any real space being consumed?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
*fbsd_user* said that he has *100 input fields plus 40
different drop
downs.*
And everybody is arguing that they prefer *one single insert*.
Is it just me... or are you thinking at a table with 140 columns ?
Thinking at such a monster... all the above discussion is ok !
But who does a table with 140
PROTECTED]
Sent: Tuesday, March 14, 2006 6:39 PM
To: Mysql
Subject: Re: Very large from
At 4:24 pm -0500 14/3/06, fbsd_user wrote:
user has to use the power bar to move deeper into the form
Out of curiosity, what's the power bar?
From a db perspective one single insert is preferable, IMO. Firstly
you
Have to develop form with over 100 input fields plus 40 different
drop downs. Seeking advice on technique to use. Thinking about
single form where user has to use the power bar to move deeper into
the form. This has benefit that every thing is written to the
database at one time, but the draw back
I understand the save the page form data into the session. But I
don't know what you mean by just pass it from page to page. Would
that mean having all the fields in regular form fields to accept the
entered data and also hidden corresponding fields to hide page 1
data in as page 2 is entered and
of resources (including lists at
http://www.php.net/mailing-lists.php),
not to mention examples of code, irc channels etc.
Regards
fbsd_user wrote:
Have to develop form with over 100 input fields plus 40 different
drop downs. Seeking advice on technique to use. Thinking about
single form where user has
like that before. It looks to me like
fbsd_user is trying to use the OR operator outside an if
statement.
Is the mentioned in the php manual somewhere Michael?
I've not tested this - but it looks like you are mixing sending
the
mysql query and testing for the result of the query at the same
time
Now I know what I am going to talk about is not directly related to
this mysql list, but I am in need of some concept ideas.
To set the background. Its a very common practice in the
registration process of a new user to verify the users email address
is valid by sending a email to the entered
In my mysql 4.4 table definition the default attributes are (ON
UPDATE CURRENT_TIMESTAMP). Reading the manual my understanding is
this is saying that the auto timestamp update feature is active. The
manual does not say what the trigger is to make the timestamp in the
row to be bumped to the
Trying to bump the count_of_logons by 1 using this update.
Phpmyadmin shows the count staying at zero.
I think that this SET count_of_logons = 'count_of_logons + 1'
is not coded correctly, but I get no errors so can not tell.
Anybody have any ideas?
The table def has count_of_logons
Subject: Re: users browser caching the screen
fbsd_user wrote:
Now I know what I am going to talk about is not directly related to
this mysql list, but I am in need of some concept ideas.
To set the background. It’s a very common practice in the
registration process of a new user to verify
Using this code I get this error message.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL
result resource in /usr/local/www/data/mls_verifyemail.php on line
49
What code should I use to check if the update worked or not?
$query = UPDATE members SET email_verified='X' WHERE
*_/ **
** _/ Postal: 148 Frome Street,
_/ ** Adelaide SA 5001
Australia
invent
---
-Original Message-
From: fbsd_user [mailto:[EMAIL
0596-00402-8.
Regards
Keith
In theory, theory and practice are the same;
In practice they are not.
On Sun, 12 Mar 2006, fbsd_user wrote:
To: Mysql mysql@lists.mysql.com
From: fbsd_user [EMAIL PROTECTED]
Subject: Checking for good update
Using this code I get this error message
10, 2006 2:24 PM
To: [EMAIL PROTECTED]
Cc: Mysql
Subject: Re: Reusing connections.
fbsd_user [EMAIL PROTECTED] wrote on 03/10/2006 02:18:49
PM:
In my reading of mysql tutorials I see many examples of mysql
access
with out first doing a connect. Comments say something about
reusing
open
mysql_connect(localhost,root)
or die(Unable to connect to MySQL server);
$err mysql_connect(localhost,root);
if ($err != 0) {
Under what conditions will the die clause be taken.
What is in $err if there is a error?
Are these 2 statements basically doing the same thing?
$sql = SELECT logon_id
FROM members
WHERE logon_id = '$logonid' AND logon_pw =
'$logonpw';
$result = mysql_query($sql) or die('Query failed. ' .
mysql_error());
print $result; shows Resource id #3
Where can I find meaning for what this
In my reading of mysql tutorials I see many examples of mysql access
with out first doing a connect. Comments say something about reusing
open connections for faster processing and less resources usage
overhead. What are they talking about what code do I need to make
this happen?
--
MySQL
You need a login id and password unless this is test DB added under
ID root
You have to use the same login id as the one you created the
db/table with.
mysql_connect('localhost', 'Login id', 'pw') or die(mysql_error())
mysql_connect('localhost', 'root') or die(mysql_error())
-Original
You are doing this
mysql_connect
mysql_query
And you need to do this
mysql_connect
mysql_select_db
mysql_query
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thank you.
I went with your solution and the create table worked.
Tested inserting on primary key and it worked.
Need to load more data before I can test alt indexes.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 08, 2006 3:39 AM
To:
What I am trying to do here is have 3 separate primary keys.
Creating a mysql select on either of the Logon_id, email_addr,
or last_name fields will do a single read to the matching value.
Like having 3 different indexes into the same table.
I don't want those 3 field concatenated together as
24 matches
Mail list logo