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 -
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 ?
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
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
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
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
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
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
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
--
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
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
> 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
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,
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
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,
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
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
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
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 -
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
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]>
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'];
$
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
*
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
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
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
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
[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
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
[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
[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
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
- 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 '
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
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
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,
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,
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
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
> 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
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
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
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
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
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.
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
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
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)
>
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
* 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
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,
> >
> &
51 matches
Mail list logo