DaniWeb Forum Index > Web Development > PHP

Selecting same column multiple times

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Dec 2007

Posts: 52

Reputation: mgn2683 is an unknown quantity at this point

Solved Threads: 0

mgn2683

Offline

Junior Poster in Training

Selecting same column multiple times

Dec 23rd, 2008

Hi,

This may be hard to describe what I'm trying to do. I have a database table called assignments where there are columns: section, team, and candidate.

For each section, there are 3 teams- 1, 2, 3. The sections are listed alphabetically from A-V. There are 5 candidates per team, so a total of 15 per section. I need to display this for a printer friendly page using dynamic text. For instance:

Section A
Team 1
Candidate_1 Candidate_2 Candidate_3 Candidate_4 Candidate_5

In the database, each candidate has their own row. Modifying the table structure is not an option. Is there any way to pull all candidates from a specific team from different rows to be displayed? Many thanks.

•

Join Date: Jul 2008

Posts: 14

Reputation: mike_g is an unknown quantity at this point

Solved Threads: 3

mike_g

Offline

Newbie Poster

Re: Selecting same column multiple times

Dec 23rd, 2008

If I understand you right, then maybe a query like:

Help with Code Tags

PHP Syntax (Toggle Plain Text)

SELECT candidate FROM tablename WHERE team='$team'

Would pull a list/array of all candidates from a given team.

If I understand you wrong, then it might help if you could post your table schema.

Last edited by mike_g; Dec 23rd, 2008 at 3:42 pm.

•

Join Date: May 2008

Posts: 5

Reputation: AnDurugkar is an unknown quantity at this point

Solved Threads: 0

AnDurugkar AnDurugkar is offline

Offline

Newbie Poster

Re: Selecting same column multiple times

Dec 24th, 2008

following is the answer for your database pull

just query it

Help with Code Tags

PHP Syntax (Toggle Plain Text)

select * from assignments where team =$team and section = $section

Thats it

Regards

Last edited by peter_budo; Dec 29th, 2008 at 5:38 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

•

Join Date: Dec 2007

Posts: 52

Reputation: mgn2683 is an unknown quantity at this point

Solved Threads: 0

mgn2683

Offline

Junior Poster in Training

Re: Selecting same column multiple times

Dec 24th, 2008

I ran a query using this:

Help with Code Tags

PHP Syntax (Toggle Plain Text)

SELECT * 
FROM assignment
WHERE assignment.Team = $team and assignment.Section = $section

I kept receiving an error saying "1054 - Unknown column '$team' in 'where clause'

Is there any way to modify this?

•

Join Date: Jul 2008

Posts: 149

Reputation: mschroeder is on a distinguished road

Solved Threads: 25

mschroeder mschroeder is offline

Offline

Junior Poster

Re: Selecting same column multiple times

Dec 24th, 2008

$team and $section are php variables.

aka

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$team = 1;
$section = 'A';
 
$query = 'SELECT * 
FROM assignment
WHERE assignment.Team = '.$team.' AND assignment.Section = "'.$section.'"';
$team = 1;
$section = 'A';

$query = 'SELECT * 
FROM assignment
WHERE assignment.Team = '.$team.' AND assignment.Section = "'.$section.'"';

Last edited by mschroeder; Dec 24th, 2008 at 1:17 pm.

•

Join Date: Apr 2008

Posts: 297

Reputation: Aamit has a little shameless behaviour in the past

Solved Threads: 11

Aamit

Offline

Posting Whiz in Training

Re: Selecting same column multiple times

Dec 25th, 2008

can you post your table structure in mysql...
it help to understand and give correct answer to you..

bcoz..how you put your data in column section, team and candidates for 3 teams and for 15 candidates per section is confusing ...

so post your table structure....with example value

Last edited by Aamit; Dec 25th, 2008 at 3:12 am.