Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - How many times?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

How many times?
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
Mart View Drop Down
Senior Member
Senior Member
Avatar

Joined: 30 November 2002
Status: Offline
Points: 2304 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Mart Quote  Post ReplyReply Direct Link To This Post Topic: How many times?
    Posted: 15 April 2003 at 2:24pm

Hi everyone, thanks for all your help in the past. Anyway I am making a MP3 database and tehy are split up into genres, which can be selected from the side. I need to get it to tell me how many times the genre is rock for instance, but how do i do it?

 

Thanks inadvance, Martin.
Back to Top
eagle00789 View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 24 March 2003
Location: Netherlands
Status: Offline
Points: 132 		Post Options Post Options   Thanks (0) Thanks(0)   Quote eagle00789 Quote  Post ReplyReply Direct Link To This Post Posted: 15 April 2003 at 3:13pm
so what you basicly want to do is count how many times a genre is selected?
Using forum at Gravenrode and here and here
Back to Top
glypher View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 25 March 2003
Location: United States
Status: Offline
Points: 38 		Post Options Post Options   Thanks (0) Thanks(0)   Quote glypher Quote  Post ReplyReply Direct Link To This Post Posted: 15 April 2003 at 3:14pm

decyphering your post i think this is what you're looking for:

select count(*) from tbl_x
where fld_genre like 'rock'

to expand that a bit:

select genus, count(*) from tbl_x
where fld_genre like 'rock'
group by fld_genre
order by count(*)
glypher said so.

GainesvilleBands.com
Back to Top
glypher View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 25 March 2003
Location: United States
Status: Offline
Points: 38 		Post Options Post Options   Thanks (0) Thanks(0)   Quote glypher Quote  Post ReplyReply Direct Link To This Post Posted: 15 April 2003 at 3:19pm

eagle, now that i'm rereading it /again/ you might be onto what he wanted.

martin: if that is actually what you wanted, you'd have to put a catcher on the directed page (the one the person is going to) that increments a counter into a database table.

SELECTION PAGE:
grab info out of database on how many times the genre's were selected.
Select ROCK ->

RESULT PAGE:
grab genre selected,
update database.
continue with page.

make sence?  no? well re-read it. like i had to do.
glypher said so.

GainesvilleBands.com
Back to Top
Mart View Drop Down
Senior Member
Senior Member
Avatar

Joined: 30 November 2002
Status: Offline
Points: 2304 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Mart Quote  Post ReplyReply Direct Link To This Post Posted: 16 April 2003 at 5:56am
Tell you what, go on http://www.minac.tk and you will see what i mean, just incase you don't where it says Drum and Bass at the side I want it to say something like Drum and Bass (** files) how do I do it?
Back to Top
ultramods View Drop Down
Groupie
Groupie
Avatar

Joined: 08 January 2003
Location: Scotland
Status: Offline
Points: 146 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ultramods Quote  Post ReplyReply Direct Link To This Post Posted: 16 April 2003 at 6:26am

You could try: 

sql="select count(*) as numberOfGenre from MP3Table where
genre=' " & genre & " ' "

response.write("Drum & Bass " & numberOfGenre )
Back to Top
Mart View Drop Down
Senior Member
Senior Member
Avatar

Joined: 30 November 2002
Status: Offline
Points: 2304 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Mart Quote  Post ReplyReply Direct Link To This Post Posted: 16 April 2003 at 9:29am

Its proabably just me (I havent much experiance with databases) but I cant get that last script to work!

Its in tblMP3 is this right:

sql="select count(*) as numberOfGenre from tblMP3.genre where
genre=' " & genre & " ' "
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670 		Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 16 April 2003 at 10:12am

sql="select count(*) as numberOfGenre from tblMP3 where
genre=' " & genre & " ' "

where do you get the .genre part from?
Blog | MPG Tracker
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.