u can have the query as
$query = " select * from $table where nameId = 31 " ;
$result = mysql_query ( $query ) ;
$i = 0 ;
while ( $row = mysql_fetch_array( $result , MYSQL_NUM ) )
{
$array[$i][0] = $row[0] ;
$array[$i][1] = $row[1] ;
$array[$i][2] = $row[2] ;
Hi there,
I have a table that keeps names for different language codes.
In a short example:
nameId name languageCode
31 House EN
31 Wohnung DE
32 Piece En
32 Stuck De
33 Car EN
33 PKW DE
What I would like is to have a query that returns for example:
nameId = 31
Names = House - Wohnung
Maybe I can
Hi,
Is it "security safe and possible" to use my server to
query another server, outside the local zone, and make
updates to another server using a PHP page from my
server?
I'm just wondering.
So in other words I'd have a DB setup to hold users
domains, db names, db usernames, db passwords etc o
Hi,
Is it "security safe and possible" to use my server to
query another server, outside the local zone, and make
updates to another server using a PHP page from my
server?
I'm just wondering.
So in other words I'd have a DB setup to hold users
domains, db names, db usernames, db passwords etc o
hello,
i have a page where the user selects a category. they are
directed to a page that takes them to subactegory and displays the
subcategory according to category id.
my question is can i from there direct them to a particular
page from a list of a number of different pages according to the
?
Gurhan
-Original Message-
From: Leif K-Brooks [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 08, 2002 2:17 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Is this possible in mysql?
I need to add up the (integer) values of columns, and return the added up
value as one column to php
list($sum)=mysql_fetch_assoc(mysql_query('SELECT SUM(salary') FROM employes;'));
Best regards,
Andrey Hristov
On Friday 08 March 2002 09:17 pm, you wrote:
> I need to add up the (integer) values of columns, and return the added up
> value as one column to php. Is this possible? Or is there som
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Is this possible in mysql?
>
> I need to add up the (integer) values of columns, and return the added up
> value as one column to php. Is this possible? Or is there something else
> to do it? (I'd rather not have to mysql_fetch_ar
I need to add up the (integer) values of columns, and return the added up
value as one column to php. Is this possible? Or is there something else
to do it? (I'd rather not have to mysql_fetch_array() in a while loop and
add it up there, it might be a lot of rows)
--
PHP Database Mailing List
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 06, 2002 10:00 AM
Subject: Re: [PHP-DB] Is this possible?
> It looks to me like you should be dividing the data differently; something
> like
>
> (quantity, item, option, price)
> VALUES
> (1, '6inch', '&
Lilleødegård [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 11:33 AM
To: Rick Emery; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Is this possible?
My table look like this:
Pricetable: (varetabell)
(varenr, type, pris)
VALUES
(1, '6inch', 29),
(1, '
FROM varetabell, pristabell WHERE
> pristabell.varenr=varetabell.varenr AND pristabell.type='6inch' AND
> pristabell.type='footlong'
>
>
>
> - Original Message -
> From: "Rick Emery" <[EMAIL PROTECTED]>
> To: "'Raymond
It looks to me like you should be dividing the data differently; something
like
(quantity, item, option, price)
VALUES
(1, '6inch', '', '29),
(1, '6inch', 'meny', 51),
(1, 'footlong', '', 45),
(1, 'footlong', 'meny', 66),
and so forth...
"Raymond lilleødegård" <[EMAIL PROTECTED]> wrote in mess
Hi Raymond,
> I have this tricky case, at lest for me : )
>
> I'm trying to get some data out of two tables and listing the data in a
> product/price site. But. :
>
> I have one table with productinfo and one with prices.
> And it is several columns with the same id in the pricetable, because
varetabell.varenr, varetabell.innhold,
pristabell.pris FROM varetabell, pristabell WHERE
pristabell.varenr=varetabell.varenr AND pristabell.type='6inch' AND
pristabell.type='footlong'
- Original Message -
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "'
Yes, you can do that easily.
It is easier to answer your question if you show us your table structure.
-Original Message-
From: Raymond Lilleodegard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 11:16 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Is this possible?
Hi!
I
Hi!
I have this tricky case, at lest for me : )
I'm trying to get some data out of two tables and listing the data in a
product/price site. But. :
I have one table with productinfo and one with prices.
And it is several columns with the same id in the pricetable, because every
product have
17 matches
Mail list logo
