EvanMartin

I'm trying to make a web interface for my music server. Basically what it's going to do is list all the music files in a directory. Then when a song is clicked PHP executes a shell command, for example "sudo play /var/www/music/System Of A Down - BYOB.mp3" and my server plays the song. So far I've been trying system() and exec() but it do doesn’t seem to work. Any suggestions?

I worked it out myself $query = "UPDATE apps SET ative = 'active' WHERE id = '$id'"; mysql_query($query);

Ok i'm helping out with a website provideing free webhosting... Ive created a application from that submits the details into a mysql database then displays them on our managment page so we can enter the details into our cpannle and activate there account. http://www.reaction.net.nz/application/app.php http://www.reaction.net.nz/application/management/index.php Im haveing troble with the activate bit. I have a form on the top at the top of the managment page that u enter the id. Then i want that to find the line that has the id specfiyed then change the account to "active". Can someone write the script to do that... Thanks again Evan (Note that i will be passwording the managent page when it works)

Here is the link to the script [url=http://main.synthetic.net.nz/mysql.php]http://main.synthetic.net.nz/mysql.php[/url]

Hmmm, That just about works... but it displays the oldest rather than the newest, Thanks tho  :P

Im making a script to display the newest threads from my forum. I need to know how i can get the newest threads names in order. Here's what i have so far..... [quote]<?php mysql_connect("********", "*******", "*******") or die(mysql_error()); mysql_select_db("******") or die(mysql_error()); $forum_post = mysql_query("SELECT * FROM forum_thread") or die(mysql_error());  while($row = mysql_fetch_array( $forum_post )) { $topic1 = $row['title']; $topic2 = $row['title']; $topic3 = $row['title']; $topic4 = $row['title']; $topic5 = $row['title']; $topic6 = $row['title']; $topic7 = $row['title']; } echo "<table border='1'>"; echo "<tr> <th colspan=\"2\">&nbsp;Recent Forum Threads</tr><tr>"; echo "<tr> <th><img src='http://homepages.xnet.co.nz/~jems.martin/images/arrow.gif'></th> <th>$topic1</th> </tr>"; echo "<tr> <th><img src='http://homepages.xnet.co.nz/~jems.martin/images/arrow.gif'></th> <th>$topic2</th> </tr>"; echo "<tr> <th><img src='http://homepages.xnet.co.nz/~jems.martin/images/arrow.gif'></th> <th>$topic3</th> </tr>"; echo "<tr> <th><img src='http://homepages.xnet.co.nz/~jems.martin/images/arrow.gif'></th> <th>$topic4</th> </tr>"; echo "<tr> <th><img src='http://homepages.xnet.co.nz/~jems.martin/images/arrow.gif'></th> <th>$topic5</th> </tr>"; echo "<tr> <th><img src='http://homepages.xnet.co.nz/~jems.martin/images/arrow.gif'></th> <th>$topic6</th> </tr>"; echo "<tr> <th><img src='http://homepages.xnet.co.nz/~jems.martin/images/arrow.gif'></th> <th>$topic7</th> </tr>"; echo "</table>"; echo "<P/\>"; ?>[/quote] That displays the newest thread fine but dosent display the the 2nd newest 3rd newest 4th newest ect Any help will be greatly appreciated.. Thanks Evan!