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

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 wha

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 m

[PHP] PhP / MySQL problem

2007-08-29 Thread debussy007
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 mad

Re: [PHP] PHP & MySQL Problem

2007-05-21 Thread Christian Haensel
* Have a great coding-day :o)) Chris - Original Message - From: "Richard Lynch" <[EMAIL PROTECTED]> To: "Christian Haensel" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, May 22, 2007 2:42 AM Subject: Re: [PHP] PHP & MySQL Problem On Mon, May 21, 2007 2

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
y, May 21, 2007 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']; $

Re: [PHP] PHP & MySQL Problem

2007-05-21 Thread Zoltán Németh
Howcome people don't get that programming > sometimes really IS leaning back and closing your eyes *gr* :oP > > Thanks for trying to help me :o) > > Chris > > - Original Message - > From: "Zoltán Németh" <[EMAIL PROTECTED]>

Re: [PHP] PHP & MySQL Problem

2007-05-21 Thread Christian Haensel
at I've had before... but there should be changes *g* actually there seems to be no problem with your query (besides that you should check posted values first in order to avoid SQL injection) you said in your first letter that "$_POST['var'] don't reach the script&q

Re: [PHP] PHP & MySQL Problem

2007-05-21 Thread Zoltán Németh
elevant part is not the query but rather the form itself... greets Zoltán Németh > > I hope anybody can find some sense in what I'm writing here... hardly makes > sense to me :oP > > Cheers! > > > > > > > > - Original Message -

Re: [PHP] PHP & MySQL Problem

2007-05-21 Thread Christian Haensel
n there. So no changes to what I've had before... but there should be changes *g* I hope anybody can find 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: &q

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'] do

[PHP] PHP & MySQL Problem

2007-05-21 Thread Christian Haensel
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 script... I have about 20 to 25 form fields which are all taken i

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 s

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 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

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,

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 ple

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 unsubs

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

[PHP] php-mysql problem

2007-04-03 Thread Me2resh Lists
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 with that please ?

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 th

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 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 products

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 de

Fw: [PHP] php mysql problem

2006-05-02 Thread Satyam
- Original Message - From: "Ross" <[EMAIL PROTECTED]> To: Sent: Tuesday, May 02, 2006 12:00 PM Subject: [PHP] php mysql problem Just say I have a db CREATE TABLE `mytable` ( `id` int(4) NOT NULL auto_increment, `fileName` varchar(50) NOT NULL default '

[PHP] php mysql problem

2006-05-02 Thread Ross
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 delete them gaps appear. 1, 3, 7. I need

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 NUL

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: http://www.p

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 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 = "SE

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? [/sni

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 716.856.

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: > > http://co

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 mysql

[PHP] php-mysql problem

2004-05-13 Thread Jianping Zhu
I have redhat 9.0 and Server version: Apache/2.0.40. i have installed rpms php-4.2.2-17.2.i386.rpm php-mysql-4.2.2-17.2.i386.rpm After i create a database called mydb and serveral tables in mysql, I tried to run following testdb.php script --

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

2004-04-25 Thread Lasse Laursen
Code - 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, > > > &

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 lin

[PHP] PHP /MySQL problem on SMP machines

2004-04-25 Thread Lasse Laursen
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 PHP processes are running as FastCGI under Zeus with these compile options: ./configure --with-curl \ --enable-sockets \ --enable-dbx \ --with-jpeg-dir \ --with-jpeg \ --pr

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 ) is not converted to the $submit variable when I NE> if

[PHP] PHP,MySQL problem

2004-01-14 Thread Nicolai Elmqvist
Sorry, I should have done that from the beginning, but here it is. I have looked further on the variables and it seams like the name attribute "sumbit" (in the ) is not converted to the $submit variable when I press the button. If I make a var_dump() in the beginning and end of the code, $submit is

RE: [PHP] PHP, MySQL problem

2004-01-14 Thread Humberto Silva
004 0:11 To: [EMAIL PROTECTED] Subject: [PHP] PHP, MySQL problem Hi I have just started working with PHP and MySQL and have gone through 3 tutorials on how to add and delete records from a database. Nearly everything is working, as it should except for the communication between HTML and PHP. If

[PHP] PHP, MySQL problem

2004-01-13 Thread Nicolai Elmqvist
Hi I have just started working with PHP and MySQL and have gone through 3 tutorials on how to add and delete records from a database. Nearly everything is working, as it should except for the communication between HTML and PHP. If I try to add a record to my database by pushing a "submit" the tex

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 inc

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 runni

[PHP] PHP-Mysql problem

2003-12-11 Thread Robin Kopetzky
Good Afternoon!! 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 MySq

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

2001-12-07 Thread Javier Muniz
AIL PROTECTED]] Sent: 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 w

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) >

[PHP] PHP + MySQL problem (strange behavior)

2001-12-05 Thread Javier Muniz
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 (int) now, i have a row that has a starttime of 60, whe

[PHP] PHP / mySQL Problem

2001-02-28 Thread Michael Gorner
Hello, First a bit of background, I'm running apache 1.3.12, php 4.03 and MySQL 3.23.22 under the Windows platform. My problem is simply that when I write stuff to database tables full stops are represented as copyright symbols when I view the data again. This is probably me just being stupid -