Not sure what the problem is

[izwian]

I am trying to make a mod for a friend of mine for vBulliton. It will enable/disable a shoutbox. Code:

<?php

If (isset($_GET['sub'])) {
	echo "en:" . $_POST['en'] . "<br>\ndi:" . $_POST['di'];
}

$shost  = "localhost";    // Change to your MySQL host.
$dbuser = "********";        // Change to your database name.
$dbpass = "********";       // Change to your database password.
$dbname = "********";   // Change to your database name.
$dbtable = "vbshout"; // Change to your database table.

/*


-_-_-_-_-_-_-_-_-_-_-_-_-_-_-
-_- Leave the below alone -_-
-_- Unless you know what  -_-
-_-    you are doing.     -_-
-_-_-_-_-_-_-_-_-_-_-_-_-_-_-


*/

mysql_connect($shost, $dbuser, $dbpass);
mysql_select_db($dbname);
$sb = mysql_query("SELECT * FROM vbshout WHERE sb = '$sb'");

If ($sb = 1) {
	echo "Enabled<br><br>";
} Else {
	echo "Disabled";
}
?>

<form action="shout.php" method="POST">
	<center>
	Shoutbox enable/disable<br>
	<input type=radio name=en value="Enable">Enable Shoutbox<br>
	<input type=radio name=di value="Disable">Disable Shoutbox<br>
	<input type=submit name=sub value=Submit>
	</center>
</form>

[Edited out database connection values. -- NogDog]

[NogDog]

OK, so what is the problem you want us to solve?

[Horizon88]

Also, you probably ought to blank out those database credentials.

[Jack_McSlay]

not sure what exact problem you have but I saw some mistakes on your code:

$sb = mysql_query("SELECT * FROM vbshout WHERE sb = '$sb'");

- you're trying to input a previously unexistent variable called $sb.
- you did not fetch the result

If ($sb = 1) {

- $sb is a result handler
- even if it was a fetched column it would be wrong to use in a comparison, because a fetched column is either an array or an object
- you're not comparing $sb to 1, you're setting $sb to 1

[izwian]

I wasn't really concerned about the gathering of information as much as I was submitting it. As you can see in the first 3 lines, it checks it you clicked the button and echo's the values of the two radio controls. It is not doing this, and that is my problem.

[dagon]

$sb is a resource not a value, have a look at the manual for the next step