Hello community,
I am creating a radio system of choice.
I have a worry in the code, can you help me?
Thanks for your helpPHP Code:<?php
$id= $_SESSION['uid'];
$req = mysql_query("SELECT * FROM users WHERE id='".$id."' AND radio");
$radio = mysql_result($req);
if($radio == 0) { echo 'Radio 0'; }
elseif($radio == 1) { echo 'Radio 1'; }
elseif($radio == 2) { echo 'Radio 2'; }
?>
Sorry for my english, i'm french
You're missing something after "AND radio".
SELECT radio FROM users WHERE id='".$id."'
I tried that but it shows me "Radio 0" While in the db that I put Radio 2Originally Posted by Exonize
Why this code ?its useless :P you can better useCode:if($radio == 0) { echo 'Radio 0'; } elseif($radio == 1) { echo 'Radio 1'; } elseif($radio == 2) { echo 'Radio 2'; }Also i dont know if youre asking for how to make the choice of radio but if so then you can easely make it with submit buttons here i made something you may find usefull :p just put the html in tpl or whatever you use :P you also can change the buttons to radio buttons so it looks better :DCode:echo 'Radio'.$radio;
Code:<?php if(isset($_POST['radio'])) { $channels = array(1, 2); if(in_array($_POST['radio'], $channels)) { mysql_query("UPDATE users SET radio = '"$_POST['radio']"' WHERE id = '"$id"' "); echo 'Channel has been changed succesfully to'.$_POST['radio']; } else exit('This is not an channel!'); } ?> <html> <form method="POST" action=""> <input type="submit" name="radio" value="1"> <input type="submit" name="radio" value="2"> </form> </html>
Last edited by Troll Hotel; 29-07-15 at 01:19 PM.
Normally instead of "0 Radio" "Radio 1" "Radio 2" is the script for the radio display
Reply With Quote