İptal Edildi

SQL Query, SIMPLE!

OK, this is not even a project. But I would be glad someone could just help me with this. My questions is:

How do i rewrite this SQL-query to also include the field song_id which is next to the songtitle-field in the table songs.

$result = mysql_query("SELECT DISTINCT songtitle FROM songs WHERE view_for_public='y' ");

But that clause doesn't give me the song_id field which I need. So..the same result as the above wuery but also with the song_id field included.

Beceriler: PHP

Daha fazlasını gör: n query, need sql help, t-sql with, t-sql in, t-sql;, sql, SQL Query, sql project , sql c, simple questions, simple query, query table, C# SQL, rewrite sql, sql select select, sql select, query query, sql query help, sql simple project, sql questions

İşveren Hakkında:
( 34 değerlendirme ) Stockholm, Sweden

Proje NO: #128433

Bu iş için 8 freelancer ortalamada $30 teklif veriyor

NickolaS

Hi, please, check PM

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(329 Değerlendirme)
7.5
eelance

very easy ,check pm.

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(349 Değerlendirme)
6.8
keyboard999

Hi Sir, Please check on pm.

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(115 Değerlendirme)
6.5
pinoywebdev

Hi. SQL Query in PMB.

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(37 Değerlendirme)
6.1
bewhite

Easy for me. Please look at the PMB.

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)
4.9
doomer

It's so easy for [login to view URL] check the PM.

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
Extremity

Check your PM

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
billfan88

hi I have ten years experience in SQL let's do it now best regards bill

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0