İ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: 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, sql query field, project sql query, simple project sql, project query, sql query project

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

Proje NO: #128433

8 freelancers are bidding on average $30 for this job

NickolaS

Hi, please, check PM

in 0 gün içinde30$ USD
(329 Değerlendirme)
7.5
eelance

very easy ,check pm.

in 0 gün içinde30$ USD
(349 Değerlendirme)
6.8
keyboard999

Hi Sir, Please check on pm.

in 0 gün içinde30$ USD
(115 Değerlendirme)
6.5
pinoywebdev

Hi. SQL Query in PMB.

in 0 gün içinde30$ USD
(37 Değerlendirme)
6.1
bewhite

Easy for me. Please look at the PMB.

in 0 gün içinde30$ USD
(5 Değerlendirme)
4.9
doomer

It's so easy for [url removed, login to view] check the PM.

in 0 gün içinde30$ USD
(0 Değerlendirme)
0.0
Extremity

Check your PM

in 0 gün içinde30$ USD
(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 30$ USD
(0 Değerlendirme)
0.0