Re: number of record
| From: | Nashirak Bosk | Date: | Mon, 04 Sep 2000 00:47:12 +0000 |
| Subject: | Re: number of record | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-2395@lists.php.net to get a copy of this message | ||
Well if it is in a MYSQL Table then it is very easy.
Try this:
MYSQL_QUERY ("SELECT Name FROM $table ORDER BY Date WHERE $Name = A);
I think that should work but dont hold me to it because I have never
tried it before.
Hope this helps.
Nashirak
Cong Thanh Nguyen wrote:
> Hi all !
>
> I have a table with 2 columns : Date and Name.
> All of records are sorted ( order by Date).
> I want to select Date,Name and number of record in table(not in result).
> ex:
> I have a table:
> Date Name
> 9/5/2000 A
> 9/3/2000 B
> 9/2/2000 A
> 9/1/2000 D
>
> order by date :
> Date Name
> 9/1/2000 D
> 9/2/2000 A
> 9/3/2000 B
> 9/5/2000 A
> numbering records:
> Number Date Name
> 1 9/1/2000 D
> 2 9/2/2000 A
> 3 9/3/2000 B
> 4 9/5/2000 A
>
> I want to select records having Name=A.
>
> result of query:
> Number Date Name
> 2 9/2/2000 A
> 4 9/5/2000 A
>
> How can I do ?
>
> Thanks for your help.
> Cong
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net
> For additional commands, e-mail: php-windows-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net