Printable View
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 2Quote:
Originally 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>
Normally instead of "0 Radio" "Radio 1" "Radio 2" is the script for the radio displayQuote:
Originally Posted by Troll Hotel