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
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
> 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
To
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.
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)
>
* 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,
> >
> &
39 matches
Mail list logo
