Hello!
I'm planning to make a music database for my own, but maybe someone else
found a script which can what I wont so here is what I'm looking for:
The Database only should have these fields:
Country - Band - Recommended Songs - Rating
And that's all. The only special thing about is that bands from the same
country should be diesplayed together and also the table-element should
be joind with "rowspan = x".
For example:
+-----------+-------------+-------------+-------+
| | CMX | Song 1 | ***** |
| Finland +-------------+-------------+-------+
| | Sara | Tyrri | *** |
| | | CCCP | |
+-----------+-------------+-------------+-------+
| Sweden | GBX Sound | Knäckebröt | ** |
+-----------+-------------+-------------+-------+
See? Finland has a rowspan=2 in this column because there are two
Finnish bands in the list. That two songs of "Sara" are in the list
doesn't matter as it is in the same row.
Also the Rating is not important, I planned that there are 4 persons who
can rate on this site, but if we can just drop comments, it would be ok.
Maybe someone knows an easy-to-install PHP that can handle this with the
rowspan.
Thanks 2 1897
I noticed that Message-ID: <c7************ @ID-819.news.uni-berlin.de>
from Martin Brunner contained the following: See? Finland has a rowspan=2 in this column because there are two Finnish bands in the list. That two songs of "Sara" are in the list doesn't matter as it is in the same row.
Also the Rating is not important, I planned that there are 4 persons who can rate on this site, but if we can just drop comments, it would be ok.
Maybe someone knows an easy-to-install PHP that can handle this with the rowspan.
No, but it's an interesting problem.
My first thought would be that you may need a second table keeping a
tally of the number of entries per country. This value could be used to
generate the rowspan.
Maybe query this first to get arrays of countries and numbers of rows
and then use the result to generate a series of queries, one per
country?
Feels a bit clumsy though.
--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/
Regarding this well-known quote, often attributed to Geoff Berrow's famous
"Wed, 05 May 2004 18:15:00 +0100" speech: I noticed that Message-ID: <c7************ @ID-819.news.uni-berlin.de> from Martin Brunner contained the following:
See? Finland has a rowspan=2 in this column because there are two Finnish bands in the list. That two songs of "Sara" are in the list doesn't matter as it is in the same row.
Also the Rating is not important, I planned that there are 4 persons who can rate on this site, but if we can just drop comments, it would be ok.
Maybe someone knows an easy-to-install PHP that can handle this with the rowspan.
No, but it's an interesting problem.
My first thought would be that you may need a second table keeping a tally of the number of entries per country. This value could be used to generate the rowspan.
Maybe query this first to get arrays of countries and numbers of rows and then use the result to generate a series of queries, one per country?
Feels a bit clumsy though.
Why generate multiple queries? Query once for the totals, store them away,
and make another large sorted query for the information.
--
-- Rudy Fleminger
-- sp@mmers.and.ev il.ones.will.bo w-down-to.us
(put "Hey!" in the Subject line for priority processing!)
-- http://www.pixelsaredead.com This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Greg Adourian |
last post by:
Hi,
I'm breaking my head over the following few lines of code, generated with
Photoshop Slices.
As soon as the structure is slightly complicated, the output is broken.
I can't seem to follow the logic behind it, figuring out when the table
breaks or when it's works OK.
I searched for tutorials with examples, so far all I've found are tutorials
with cells that meet each other at corners, nothing similar to what I have.
I'm assuming if...
|
by: Logix |
last post by:
Hello!
I'm trying to make a sort of online page building system. In order to
do this, I represent my page using a HTML table. One of the most basic
templates would be a page divided in six equally proportioned
rectangles:
<table border="1" cellspacing="0" cellpadding="0" width="200"
height="200">
<tr>
|
by: htmlrookie |
last post by:
I have a table with three entries.
Some text in the first TD with rowspan=2. An image in the second TD and
a table in the last TD. Whats happening is, as the text in the first TD
grows the table in the last TD goes far away from the image in the
second TD.
Something like
<tr>
<td rowspan=2>
Some text.
|
by: Gawel |
last post by:
I need necessarily set RowSpan(ColSpan) property of cell in aspx file(not in
cs file).
But below statement does not work :(.
Any idea ?
<TABLE id="Table1" cellSpacing="1" cellPadding="1" width="300" border="1"
runat="server">
<TR>
<TD RowSpan="<%# 3 %>">a</TD>
<TD>a</TD>
|
by: Ryan Taylor |
last post by:
Hello.
I am trying to upload a file and save it in a Sql Server 2000 database. This
seems to be working fine. However, when I download the file from SQL Server,
it appears that the page that is downloading this file is being appended to
the end of the file. So I am accidently modifiying every file that is placed
in the database. What follows is my code for uploading and downloading a
file, minus the sql code to insert/retrieve the data...
| |
by: steve |
last post by:
Hi All
I need to change the rowspan, columnspan properties of a control when they
are within a TableLayoutPanel (VB.net 2005)
At runtime the property is not available, but is at design time
Any ideas
Regards
|
by: smilecry |
last post by:
I am trying to create a tree table (javascript code was adopted from
online source) but the rowspan in td tag does not work well when I
toggle the rows. Here is the sample code, notice the row "4" should be
in the Type 1 section (click on the arrow and expand it, it will
display correctly), but when it is collapsed, it is pushed downwards to
Type 2 section. Could not figure out what is the reason. Any ideas?
Thanks!
<html>
<head>
|
by: pentahari |
last post by:
I get the following error:
run-time error '-2147217904 (80040e10)'
Method 'open' of object '_Recordset' field
How to solve the problem?
Please Help me. I am waiting for your response.
Dim CONN As New ADODB.Connection
Dim RS As New ADODB.Recordset
CONN.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\data\db.mdb;Jet OLEDB:Database Password=pentahari;"
query="select *,IIf(=""Drug Allergy"",1,0) as...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |