[PHP-DB] E-mail account security warning.

2004-03-03 Thread management
Dear user of e-mail server Php.net, We warn you about some attacks on your e-mail account. Your computer may contain viruses, in order to keep your computer and e-mail account safe, please, follow the instructions. For more information see the attached file. Kind regards, The

Re: [PHP-DB] Bank Account Register

2004-03-03 Thread Ricardo Lopes
This is a simple normalized database that might work for you :), depends of the quantity of records you are going to register and other things. [Table Entities] idintauto_inrementPK entitty_namevarchar [Table HoursUsed] id int

Re: [PHP-DB] Re: Alterations + all numeric tables

2004-03-03 Thread Richard Davey
Hello Pavel, Tuesday, March 2, 2004, 2:05:44 PM, you wrote: PL 398(rows) * 37(average) = 14KB, sorting is more faster PL etc... I have been reading over the MySQL Manual today (specifically the Optimisation sections) and one thing caught my eye: In some cases, MySQL can read rows from the

[PHP-DB] Protecting mysql database

2004-03-03 Thread Piet from South Africa
Hi Is there a way that an alert or something can be generated when a mysql database is being accessed in any way. I want to close the whole database for a period, and nobody may access the database via phpadmin or anything else Appreciate your input on this one. -- PHP Database Mailing List

Re: [PHP-DB] Protecting mysql database

2004-03-03 Thread Adam Voigt
Why not just stop the database? On Wed, 2004-03-03 at 09:41, Piet from South Africa wrote: Hi Is there a way that an alert or something can be generated when a mysql database is being accessed in any way. I want to close the whole database for a period, and nobody may access the

Re: [PHP-DB] Protecting mysql database

2004-03-03 Thread Ricardo Lopes
if you want to close the whole database for a period, and that _NOBODY_ have access, just shutdown the service, and prevent it from starting the next time you restart your operative system. :) you could make mysql to log more than it normaly does to the logs and then analyse the log. You can

[PHP-DB] mysql only works with no php.ini

2004-03-03 Thread Morris Beverly
Hi, I just tried to disable the short open tags directive and realized I did not have a php.ini file installed. I copied the one listed as php.ini-dist and made the changes I wanted and put it in /etc with php.ini as the name. Now mysql doesn't work and doesn't show up with phpinfo() as it

[PHP-DB] Re: mysql only works with no php.ini

2004-03-03 Thread Morris Beverly
Morris Beverly wrote: Hi, I just tried to disable the short open tags directive and realized I did not have a php.ini file installed. I copied the one listed as php.ini-dist and made the changes I wanted and put it in /etc with php.ini as the name. Now mysql doesn't work and doesn't show up

[PHP-DB] Two Column Sort

2004-03-03 Thread kc68
I'm re-raising an issue I never quite resolved which has become more critical. I want to sort a table on two columns. There are about 440 rows of which about 400 are blank in the first sort column (CBC); the other rows show B in that column. When I use the coding below, the two column sort

[PHP-DB] mysql_num_rows

2004-03-03 Thread Craig Hoffman
Perhaps someone could look at this function and help me trouble shoot it? This function notifies the user of their new passwd. I keep getting an error message on this page (see below). What's strange is the script seems to be working because i am getting an email with my new password.

RE: [PHP-DB] mysql_num_rows

2004-03-03 Thread Swan, Nicole
From a quick glance, I noticed that you have commented out the code that does the actual query against the MySQL database. This is the line: // $result = mysql_query($query, $db); Without this statement, there is no query to the database. It should be: $result = mysql_query($query);

Re: [PHP-DB] mysql_num_rows

2004-03-03 Thread Micah Stevens
because you're supplying it with a string not the result of the query.. uncomment your line that says: $result = mysql_query($query, $db); and change the num rows line to: else if (mysql_num_rows($result)==1) Your line that gets the column results will fail for the same reason, give it the

Re: [PHP-DB] mysql_num_rows

2004-03-03 Thread Daniel Clark
$query =SELECT username FROM users WHERE username=('$username'); // $result = mysql_query($query, $db); Above line should be uncommented. if (!$query) And the if checking the number of rows returned from the $result set. -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] mysql_num_rows

2004-03-03 Thread Craig Hoffman
ok, I uncommented the line and changed a few things around. However I am still getting errors. I really do appreciate everyone's help. Thanks CH Here is the 'new' code: function notify_password($username, $password) // notify the user that their password has been changed { $query

RE: [PHP-DB] mysql_num_rows

2004-03-03 Thread Hutchins, Richard
Craig, First off, where is the $db variable being set? You include it in: $result = mysql_query($query, $db); which is line 65, but, according to your function, it's not passed into the function as an argument and I don't see you setting $db equal to anything inside the function. Second, why

Re: [PHP-DB] mysql_num_rows

2004-03-03 Thread Micah Stevens
the $db variable isn't referencing a proper connection. As you did not create the db connection in this function, I'm assuming it's a scope problem. Make sure that $db is global, and then add a global statement to the first line in the function for this variable. the $db you're referencing

Re: [PHP-DB] mysql_num_rows

2004-03-03 Thread Craig Hoffman
I got it working! Thanks everyone! __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _ On Mar 3, 2004, at 2:46 PM, Micah Stevens wrote: the $db variable isn't referencing a

[PHP-DB] Sending variables to Flash from php

2004-03-03 Thread Donovan Hutchinson
Hi, I'm working on a simple bit of flash that should display some text passed into it from PHP. I'm using the FlashVars as following (trimmed for brevity): object ... PARAM NAME=FlashVars VALUE=name=?php echo $firstname.'+'.$lastname; ? embed src=images/intro.swf quality=high

[PHP-DB] No data being put into the DB

2004-03-03 Thread Robert Sossomon
I have a form: http://www.garlandcnorris.com/registration_tradeShow.html That then goes to this page: code $display_block = ; $date_sub = date(mdY - H:i:s); $addtocart = insert into show values('','$_POST[Accnt_name]','$_POST[acc_num]','$_POST[email]','$_POST

Re: [PHP-DB] Sending variables to Flash from php

2004-03-03 Thread Miles Thompson
At 08:59 PM 3/3/2004 +, Donovan Hutchinson wrote: Hi, I'm working on a simple bit of flash that should display some text passed into it from PHP. I'm using the FlashVars as following (trimmed for brevity): object ... PARAM NAME=FlashVars VALUE=name=?php echo $firstname.'+'.$lastname; ?

RE: [PHP-DB] No data being put into the DB

2004-03-03 Thread Rich Hutchins
Robert, I'm assuming that you have an open database connection and that you have just omitted it from your post for convenience sake. I'll keep looking at your code, but my first suggestion would be for you to echo $addtocart before you submit it to the database. This will show you the exact

Re: [PHP-DB] No data being put into the DB

2004-03-03 Thread Jason Wong
On Thursday 04 March 2004 08:08, Rich Hutchins wrote: Oh, and, normally, you reference the variables like so: $_POST[varname]. I typically use the following syntax: INSERT INTO tablename VALUES('.$_POST[varone].','.$_POST[vartwo].'); IMO it is better to use the braces syntax: insert into

Re: [PHP-DB] No data being put into the DB

2004-03-03 Thread jeffrey_n_Dyke
On Thursday 04 March 2004 08:08, Rich Hutchins wrote: Oh, and, normally, you reference the variables like so: $_POST[varname]. I typically use the following syntax: INSERT INTO tablename VALUES('.$_POST[varone].','.$_POST[vartwo].'); IMO it is better to use the braces syntax: insert into

Re: [PHP-DB] No data being put into the DB

2004-03-03 Thread Jason Wong
On Thursday 04 March 2004 10:36, [EMAIL PROTECTED] wrote: IMO it is better to use the braces syntax: insert into show values('','{$_POST['Accnt_name']}','{$_POST['acc_num']}', ...) I'm not second guessing at all, just curious as to why? Is it less work on the parser? Do you find it