http://www.php.net/manual/en/function.number-format.php
bastien
> Date: Sun, 16 Dec 2007 17:17:41 +0600
> From: [EMAIL PROTECTED]
> To: php-db@lists.php.net
> Subject: [PHP-DB] sql problem
>
> my problem in the following code
>
> INSERT INTO `test` (
There are two ways to do what you ask:
1 - run your first query (just the classes no sections) and before the loop
to display the results open a new - different connection to the DB then
in the loop where you are displaying the results after displaying each class
run a query to find all of it's se
i think the newer versions of MYSQL allow for subselects and I think that is
what you want.
see www.mysql.net
-Original Message-
From: mayo [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 15, 2004 11:56 PM
To: php-db
Subject: [PHP-DB] sql, problem with join and presentation
Currently
The following will list movies seen by each member:
SELECT membername,movietitle FROM member,movie WHERE
member.memberid=movie.memberid
This one lists all members who have seen these 3 movies.
SELECT membername FROM member,movie WHERE member.memberid=movie.memberid &&
movietitle="Star Wars" && mo
tak 31. avgust 2001. 10:04
> To: Robert Vukovic; [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] SQL problem
>
>
> Hi,
> Are there any error messages?
> Just a guess - may be this will work
>
> Select $tbl_virtual.thumb1,$tbl_descriptions.short_desc FROM
>
-Original Message-
From: Robert Vukovic <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Friday, August 31, 2001 7:34 AM
Subject: RE: [PHP-DB] SQL problem
>> Table was created with this
>>
>> CREATE TABLE `descriptions` (
>> `id_prop
> Table was created with this
>
> CREATE TABLE `descriptions` (
> `id_property` bigint(20) NOT NULL default '0',
> `short_desc` varchar(255) default NULL,
> `long_desc` text,
> KEY `id_property`(`id_property`),
> PRIMARY KEY (`id_property`),
> UNIQUE KEY `id_property_2`(`id_property`)
A quick glance suggests to me that it is a nonstandard proprietary
extension to SQL that provides a way to set a kind of a variable and use it
in a subsequent nonstandard proprietary SQL-looking statement that is
awfully procedural. You'll probably want to either consult the
documentation for the
@a is here an internal 'session' variable used in sql databases (atleast
mysql).
simple usage :
select @a:=1;
-> 1
select @b:=10;
-> 10
select @a + @b;
-> 11
These variables are used to hold temporary numbers and characters, so the
interaction between the script language and the database can
""Fai"" <[EMAIL PROTECTED]> wrote in message
9h90l2$1op$[EMAIL PROTECTED]">news:9h90l2$1op$[EMAIL PROTECTED]...
> SELECT @A:=SUM(salary) FROM table1 WHERE type=1;
> UPDATE table2 SET summmary=@A WHERE type=1;
>
> What does @A: mean?
>
> Thank you very much!
They're writing the sum to an SQL vari
10 matches
Mail list logo