Echo Specific Column

[Solar]

Say I have a forum with tables that look like this in the mysql database;

 

fidforumdesccat

1GeneralTalk About Anythinggeneral

2HobbiesTalk About Hobbiesgeneral

3HTML HelpGet help on HTMLhelp

 

How can I use this;

$sql="SELECT * FROM $tbl_name ORDER BY fid";

By grabbing just the one column for example general?

 

Thanks.

[dgoosens]

$sql="SELECT '<column_name>' FROM $tbl_name ORDER BY fid";

for instance

$sql="SELECT 'forum' FROM $tbl_name ORDER BY fid";

and if you want more than one column, concatenate them with a comma:

$sql="SELECT 'fid', 'forum' FROM $tbl_name ORDER BY fid";

[Alex]

$sql="SELECT '<column_name>' FROM $tbl_name ORDER BY fid";

for instance

$sql="SELECT 'forum' FROM $tbl_name ORDER BY fid";

and if you want more than one column, concatenate them with a comma:

$sql="SELECT 'fid', 'forum' FROM $tbl_name ORDER BY fid";

Why did you place the column names in quotes? That's not needed, perhaps you meant to use backticks (`)? Backticks aren't even required, and not suggested, unless you're using reserved words for your column names which you really shouldn't be doing in the first place.

[dgoosens]

Why did you place the column names in quotes? That's not needed, perhaps you meant to use backticks (`)? Backticks aren't even required, and not suggested, unless you're using reserved words for your column names which you really shouldn't be doing in the first place.

 

you are right...

they are not needed...

sorry about that

 

 

[Solar]

Oops, I understand that. Doh, silly me.

 

I know how to echo the specific column, what I meant was...

 

Echo the table I provided (Which I have coded) but only show the forum with the specific category for example;

 

fidforumdesccat

1GeneralTalk About Anythinggeneral

2HobbiesTalk About Hobbiesgeneral

3HTML HelpGet help on HTMLhelp

 

Will result into php coding;

fidforumdesccat

1GeneralTalk About Anythinggeneral

2HobbiesTalk About Hobbiesgeneral

 

<td bgcolor="#FFFFFF"><? echo $rows['forum']; ?><BR><span class="style1"><? echo $rows['desc']; ?></span></td>

 

But using;

$sql="SELECT * FROM $tbl_name ORDER BY fid";

Do I use a whereas in this statement?

[Alex]

You need to use a where clause. Example:

 

$sql="SELECT * FROM $tbl_name WHERE cat='general' ORDER BY fid";

[Solar]

Haha thanks! Works like a charm, of course when I tried I missed out the '