MySQL Query

[Imtehbegginer]

Wierd...

 

My code:

$str = mysql_query("SELECT str FROM characters WHERE char_name = '".$_POST['char_name']."'");
$dex = mysql_query("SELECT dex FROM characters WHERE char_name = '".$_POST['char_name']."'");
$con = mysql_query("SELECT con FROM characters WHERE char_name = '".$_POST['char_name']."'");
$int = mysql_query("SELECT _int FROM characters WHERE char_name = '".$_POST['char_name']."'");
$lvl = mysql_query("SELECT level FROM characters WHERE char_name = '".$_POST['char_name']."'");

 

The str in the characters table = 15, but when I do: <?php echo $str ; ?> I get "Resource #7" any ideas?

[sspoke]

query is not the result

 

query = pointer

[fert]

http://us2.php.net/manual/en/function.mysql-fetch-array.php

[sspoke]

$str = mysql_query("SELECT str FROM characters WHERE char_name = '".$_POST['char_name']."'");

$dex = mysql_query("SELECT dex FROM characters WHERE char_name = '".$_POST['char_name']."'");

$con = mysql_query("SELECT con FROM characters WHERE char_name = '".$_POST['char_name']."'");

$int = mysql_query("SELECT _int FROM characters WHERE char_name = '".$_POST['char_name']."'");

$lvl = mysql_query("SELECT level FROM characters WHERE char_name = '".$_POST['char_name']."'");

 

would be like

 

$ptr = mysql_query("SELECT * FROM characters WHERE char_name = '".$_POST['char_name']."'");

like loop for $chardata = mysql_fetch_array($ptr)

$str = $chardata['str']

$dex = $chardata['dex']

$con = $chardata['con']

 

 

[Imtehbegginer]

Works, thanks.