PHP Query Help

[Durbz]

I am getting a weird error with mysql queries I am trying to send.

Here is my code
[php]

<?php if(isset($_SESSION['id'])) { echo " Set your main character "; if(!isset($_POST['mainchar'])) { $accid = $_SESSION['id']; echo "

			</center>
		</form>
		</table>";
		} else {
		$accid = $_SESSION['id'];
		$name = $_SESSION['name'];
		$charid = mysql_query("SELECT `id` FROM `characters` WHERE `name`='".$name."'") or die(mysql_error());
		$main = mysql_query("UPDATE `accounts` SET `mainchar`=".$charid." WHERE `id`=".$accid."'") or die(mysql_error());
				echo $name. "has been set as your main character.";
	}
} else {
echo "You must be logged in to set a main characters. You can do this with the panel to the left.";

}
?>

Select character:	"; $s = mysql_query("SELECT * FROM `characters` WHERE `accountid`= ".$accid." ORDER BY `id` ASC") or die(mysql_error()); while($c = mysql_fetch_array($s)) { echo " ".$c['name'].""; } echo "

[/php]

The first part gets the character names so you can select them, which works fine.
The next part is suppose to set the mainchar field to the character id of which character you choose… this is giving me an error.

Any help is appreciated because I’m lost.

[cogga28]

ok i have made some changes try this
[php]
// first query
$s = mysql_query(“SELECT * FROM characters WHERE accountid = $accid ORDER BY id ASC”) or die(mysql_error());
while($c = mysql_fetch_array($s)) {}
// second query
$charid = mysql_query(“SELECT id FROM characters WHERE name = $name.”) or die(mysql_error());
$main = mysql_query(“UPDATE accounts SET mainchar= $charid WHERE id = $accid”) or die(mysql_error());
[/php]