Re: [PHP] PhP / MySQL problem

2007-08-29 Thread Ludovic André
Hi, I created a form asking username, password, country, etc. On the submit of this form I make a sql connection and update the database, add the user. The problem is that whenever the field 'password' is filled in, it (I don't know what) is asking to confirm the change of the password. I

Re: [PHP] PhP / MySQL problem

2007-08-29 Thread Richard Lynch
On Wed, August 29, 2007 2:03 pm, debussy007 wrote: I created a form asking username, password, country, etc. On the submit of this form I make a sql connection and update the database, add the user. The problem is that whenever the field 'password' is filled in, it (I don't know what) is

Re: [PHP] PhP / MySQL problem

2007-08-29 Thread debussy007
I'm using FF. But it asks to confirm the change of password of my MySQL users. If I comment the php/mysql lines in the .php files, I do not have such a pop-up. Ludovic André wrote: Hi, I created a form asking username, password, country, etc. On the submit of this form I make a sql

Re: [PHP] PHP MySQL Problem

2007-05-21 Thread Zoltán Németh
2007. 05. 21, hétfő keltezéssel 09.26-kor Christian Haensel ezt írta: Good morning friends, I have a script that collects data from a form and puts together a mysql query to search a database. Now, everything worked fine until I added a few new form fields... now the $_POST['var'] don't

Re: [PHP] PHP MySQL Problem

2007-05-21 Thread Christian Haensel
Németh [EMAIL PROTECTED] To: Christian Haensel [EMAIL PROTECTED] Cc: php-general@lists.php.net Sent: Monday, May 21, 2007 9:36 AM Subject: Re: [PHP] PHP MySQL Problem 2007. 05. 21, hétfő keltezéssel 09.26-kor Christian Haensel ezt írta: Good morning friends, I have a script that collects data

Re: [PHP] PHP MySQL Problem

2007-05-21 Thread Zoltán Németh
some sense in what I'm writing here... hardly makes sense to me :oP Cheers! - Original Message - From: Zoltán Németh [EMAIL PROTECTED] To: Christian Haensel [EMAIL PROTECTED] Cc: php-general@lists.php.net Sent: Monday, May 21, 2007 9:36 AM Subject: Re: [PHP] PHP

Re: [PHP] PHP MySQL Problem

2007-05-21 Thread Christian Haensel
I'm writing here... hardly makes sense to me :oP Cheers! - Original Message - From: Zoltán Németh [EMAIL PROTECTED] To: Christian Haensel [EMAIL PROTECTED] Cc: php-general@lists.php.net Sent: Monday, May 21, 2007 9:36 AM Subject: Re: [PHP] PHP MySQL Problem 2007. 05. 21

Re: [PHP] PHP MySQL Problem

2007-05-21 Thread Zoltán Németh
Sent: Monday, May 21, 2007 9:58 AM Subject: Re: [PHP] PHP MySQL Problem 2007. 05. 21, hétfő keltezéssel 09.43-kor Christian Haensel ezt írta: Right, here we go... this page has about 1000 lines of code, so here the relevant stuff. $s_query = SELECT * FROM database WHERE kategorie

Re: [PHP] PHP MySQL Problem

2007-05-21 Thread Christian Haensel
10:16 AM Subject: Re: [PHP] PHP MySQL Problem 2007. 05. 21, hétfő keltezéssel 10.04-kor Christian Haensel ezt írta: I thought so, too. But the part where it receives the data is this: $s_marke = $_POST['marke']; $s_modell = $_POST['modell']; $s_preis_von = $_POST['preis_von']; $s_preis_bis

Re: [PHP] PHP MySQL Problem

2007-05-21 Thread Richard Lynch
On Mon, May 21, 2007 2:26 am, Christian Haensel wrote: Good morning friends, I have a script that collects data from a form and puts together a mysql query to search a database. Now, everything worked fine until I added a few new form fields... now the $_POST['var'] don't reach the

Re: [PHP] PHP MySQL Problem

2007-05-21 Thread Christian Haensel
a great coding-day :o)) Chris - Original Message - From: Richard Lynch [EMAIL PROTECTED] To: Christian Haensel [EMAIL PROTECTED] Cc: php-general@lists.php.net Sent: Tuesday, May 22, 2007 2:42 AM Subject: Re: [PHP] PHP MySQL Problem On Mon, May 21, 2007 2:26 am, Christian Haensel wrote

Re: [PHP] php-mysql problem

2007-04-03 Thread Jochem Maas
Me2resh Lists wrote: hi i need help regarding a sql query in my php app. the query is : $SQL = SELECT DISTINCT(EMail) FROM mena_guests WHERE Voted = 'yes' LIMIT $startingID,$items_numbers_list; i want to sort this query by the number of the repeated EMail counts. can anyone help me

Re: [PHP] php-mysql problem

2007-04-03 Thread clive
Me2resh Lists wrote: the query is : $SQL = SELECT DISTINCT(EMail) FROM mena_guests WHERE Voted = 'yes' LIMIT $startingID,$items_numbers_list; the only php I see it $SQL,$startingID,$items_numbers_list. This is a mysql question. -- PHP General Mailing List (http://www.php.net/) To

RE: [PHP] php-mysql problem

2007-04-03 Thread Jim Moseby
i need help regarding a sql query in my php app. the query is : $SQL = SELECT DISTINCT(EMail) FROM mena_guests WHERE Voted = 'yes' LIMIT $startingID,$items_numbers_list; i want to sort this query by the number of the repeated EMail counts. can anyone help me with that please ? A)

Re: [PHP] php-mysql problem

2007-04-03 Thread cajbecu
clive wrote: Me2resh Lists wrote: the query is : $SQL = SELECT DISTINCT(EMail) FROM mena_guests WHERE Voted = 'yes' LIMIT $startingID,$items_numbers_list; the only php I see it $SQL,$startingID,$items_numbers_list. This is a mysql question. so, you don`t know the answer, right?

Re: [PHP] php-mysql problem

2007-04-03 Thread Jochem Maas
cajbecu wrote: clive wrote: Me2resh Lists wrote: the query is : $SQL = SELECT DISTINCT(EMail) FROM mena_guests WHERE Voted = 'yes' LIMIT $startingID,$items_numbers_list; the only php I see it $SQL,$startingID,$items_numbers_list. This is a mysql question. so, you don`t know the

Re: [PHP] php-mysql problem

2007-04-03 Thread clive
cajbecu wrote: clive wrote: Me2resh Lists wrote: the query is : $SQL = SELECT DISTINCT(EMail) FROM mena_guests WHERE Voted = 'yes' LIMIT $startingID,$items_numbers_list; the only php I see it $SQL,$startingID,$items_numbers_list. This is a mysql question. so, you don`t know the answer,

Re: [PHP] php-mysql problem

2007-04-03 Thread clive
if I asked you whether your wife/girlfriend enjoyed having sex with your best friend while you are at work then you may or may not know the answer but it is hopefully clear that this is not the list to ask such a question (but no doubt that there is a list somewhere that caters to that kind of

Re: [PHP] php mysql problem

2006-05-02 Thread tedd
At 11:00 AM +0100 5/2/06, Ross wrote: Just say I have a db CREATE TABLE `mytable` ( `id` int(4) NOT NULL auto_increment, `fileName` varchar(50) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; when I add items they go id 1,2,3 etc. Whn I

Re: [PHP] php mysql problem

2006-05-02 Thread Wolf
Depending on your needs, here is another tack to think about (I know, everyone else will be gasping and running for air...) A few years ago I had to make a shopping cart. I had an archaic system that would not share information with my web/db server, so I had to write a query to dump the

Re: [PHP] php mysql problem

2006-05-02 Thread John
Ross wrote: This is my database now...I will use the item_id for the order but what if I want to change item_id 3 to item id 1? How can I push all the items down one place? How can I delete any gaps when items are deleted. CREATE TABLE `board_papers` ( `id` int(4) NOT NULL auto_increment,

Re: [PHP] php mysql problem

2006-05-02 Thread John
Ross wrote: This is my database now...I will use the item_id for the order but what if I want to change item_id 3 to item id 1? How can I push all the items down one place? How can I delete any gaps when items are deleted. CREATE TABLE `board_papers` ( `id` int(4) NOT NULL auto_increment,

Re: [PHP] php mysql problem

2006-05-02 Thread Richard Lynch
On Tue, May 2, 2006 5:00 am, Ross wrote: CREATE TABLE `mytable` ( `id` int(4) NOT NULL auto_increment, `fileName` varchar(50) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; when I add items they go id 1,2,3 etc. Whn I delete them gaps

RE: [PHP] php - mysql problem

2006-04-14 Thread Jay Blanchard
[snip] $sql = SELECT * FROM `table1` LEFT JOIN `table2` USING `id` WHERE ... GROUP BY `table1`.`id`; mysql_query($sql); the problem is, that, when in table2 is not matching data using that id, i lose that id from output array. but i don`t want to.. is there any posibility to keep that id?

Re: [PHP] php - mysql problem

2006-04-14 Thread cajbecu
thanks for your posting, but I have: table1 id name value table2 id x y i want to id name value x y but there is no id from table 2 that is in table2.id and i want the resource to bu something like this: id(from table 1) name value (empty) (empty) Jay Blanchard wrote: [snip] $sql =

RE: [PHP] php - mysql problem

2006-04-14 Thread Jay Blanchard
[snip] table1 id name value table2 id x y i want to id name value x y but there is no id from table 2 that is in table2.id and i want the resource to bu something like this: id(from table 1) name value (empty) (empty) SELECT table2.* FROM table1 LEFT OUTER JOIN table2 ON(table1.id =

RE: [PHP] php - mysql problem

2006-04-14 Thread Jay Blanchard
[snip] SELECT table1., *table2.* FROM table1 LEFT OUTER JOIN table2 ON(table1.id = table2.id) [/snip] Oops, typo. SELECT table1.*, table2.* FROM table1 LEFT OUTER JOIN table2 ON(table1.id = table2.id) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP] php - mysql problem

2006-04-14 Thread cajbecu
thanks a lot for your posting, [cut] Posted by Fred Mitchell on December 11 2004 2:47pm [Delete] [Edit] Let's say you are doing a LEFT JOIN with a table that shares a column name in common with another table, and that you are selecting for instances where the join is missing, that is IS

Re: [PHP] php-mysql problem

2004-05-13 Thread Oliver Hankeln
Hello, [snip] but i got error message with: http://coopunit.forestry.uga.edu:8080/testdb.php the error is: Fatal error: Call to undefined function: mysql_connect() in /var/www/html/testdb.php on line 13 How can Fix this problem? Thanks [/snip] Your PHP is compiled without

Re: [PHP] php-mysql problem

2004-05-13 Thread Jianping Zhu
Thank you for your response. I get the php rpm distributed with redhat 9.0. Do I have to recompile phd instead from source code with mysql support? Thanks On Thu, May 13, 2004 at 06:15:23PM +0200, Oliver Hankeln wrote: Hello, [snip] but i got error message with:

Re: [PHP] php-mysql problem

2004-05-13 Thread John Nichel
Jianping Zhu wrote: Thank you for your response. I get the php rpm distributed with redhat 9.0. Do I have to recompile phd instead from source code with mysql support? Thanks You need to install the php-mysql rpm. It will be on one of your Red Hat Discs. -- John C. Nichel KegWorks.com

Re: [PHP] PHP /MySQL problem on SMP machines

2004-04-25 Thread Curt Zirzow
* Thus wrote Lasse Laursen ([EMAIL PROTECTED]): Hi all, We just installed PHP 4.3.6 on FreeBSD 5.2.1 on some SMP machines and we are experiencing some weird problems. ... The database backend is MySQL 4.0.18 and is run on a seperate dedicated server. What mysqlclient is php linked to?

Re: [PHP] PHP /MySQL problem on SMP machines

2004-04-25 Thread Lasse Laursen
- Original Message - From: Curt Zirzow [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, April 25, 2004 5:52 PM Subject: Re: [PHP] PHP /MySQL problem on SMP machines * Thus wrote Lasse Laursen ([EMAIL PROTECTED]): Hi all, We just installed PHP 4.3.6 on FreeBSD 5.2.1 on some SMP

RE: [PHP] PHP, MySQL problem

2004-01-14 Thread Humberto Silva
So, does anybody know what I the problem might be? Hi, Well you need to post the code so one can see what's the problem Humberto Silva World Editing Portugal -Original Message- From: Nicolai Elmqvist [mailto:[EMAIL PROTECTED] Sent: quarta-feira, 14 de Janeiro de 2004 0:11

Re: [PHP] PHP,MySQL problem

2004-01-14 Thread Richard Davey
Hello Nicolai, Wednesday, January 14, 2004, 12:14:09 PM, you wrote: NE Sorry, I should have done that from the beginning, but here it is. I have NE looked further on the variables and it seams like the name attribute NE sumbit (in the form) is not converted to the $submit variable when I NE if

Re: [PHP] PHP-Mysql problem

2003-12-11 Thread Blake Schroeder
This is a good tutorial and it starts off with installiing php and mysql http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html Robin Kopetzky wrote: Good Afternoon!! I just installed RedHat Linux 9.0 with Apache/Php/MySql for a project. I have Apache and PHP

Re: [PHP] PHP-Mysql problem

2003-12-11 Thread Ray Hunter
I just installed RedHat Linux 9.0 with Apache/Php/MySql for a project. I have Apache and PHP running. However, PHP does not have the Mysql module?? installed and this is the key to our project. Could someone point me in the right direction to recompile PHP with proper MySql module

RE: [PHP] PHP + MySQL problem (strange behavior)

2001-12-07 Thread Javier Muniz
: Wednesday, December 05, 2001 4:59 PM To: Javier Muniz; '[EMAIL PROTECTED]' Subject: Re: [PHP] PHP + MySQL problem (strange behavior) On Thu, 6 Dec 2001 08:32, Javier Muniz wrote: Hello, I'm having trouble determining what's going wrong with a MySQL query that I'm doing from PHP. Now before

Re: [PHP] PHP + MySQL problem (strange behavior)

2001-12-05 Thread David Robley
On Thu, 6 Dec 2001 08:32, Javier Muniz wrote: Hello, I'm having trouble determining what's going wrong with a MySQL query that I'm doing from PHP. Now before you go blaming MySQL read on :) I have a table with the following columns: id (int) name (varchar 20) starttime (int) duration