How to query MYSQL when clicked?
- by Sam
Hello,
I have a while statement, echoing my whole database that match a WHERE parameter. How can I make it so when I click on something (anything for the moment), it updates that specific row. Here's my code.
while($request = mysql_fetch_array( $request_db )) {
echo "<tr><td style=\"width:33%;padding:1px;\">";
echo $request['SongName'];
echo "</td><td style=\"width:33%;\">";
echo $request['Artist'];
echo "</td><td style=\"width:33%;\">";
echo $request['DedicatedTo'];
echo "</td><td style=\"width:33%;\">";
echo "UPDATE A ROW's 'Hasplayed' value to '1'.";
echo "</td></tr>";
}
echo "</table>";
Thanks!
