проблем с mysql

[smz123]

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\Program Files\xampp\htdocs\futbol\box.php on line 16



кода е

$ls = mysql_query("SELECT * FROM voina WHERE user1 = '$userdata['username']' AND voina='1'");
$lss = mysql_num_rows($ls);

 

[human]

 $ls = mysql_query("SELECT * FROM voina WHERE user1 = '$userdata[username]' AND voina='1'"); 
$lss = mysql_num_rows($ls);

 

[smz123]

сега ми излиза бял екран и не излиза нищо

 

[human]

Добави echo $lss;

 

[alex95_bg_2]

 $ls = mysql_query("SELECT * FROM voina WHERE user1 = '".$userdata['username']."' AND voina=1") or die(mysql_error());
$lss = mysql_num_rows($ls);

 

[sentenello]

я пробвай така.

 $ls = mysql_query("SELECT * FROM voina WHERE user1 = "$userdata['username']" AND voina='1'"); 
$lss = mysql_num_rows($ls);

 

[smz123]

същото ето целия код

sentinello дава

Parse error: syntax error, unexpected T_VARIABLE in C:\Program Files\xampp\htdocs\futbol\box.php on line 16

<?php

include "config.php";


if ($userdata['user_active']>0)
{ 
$select = mysql_query("SELECT * FROM voina")or die(mysql_error());
$num = mysql_num_rows($select);
for ($i=0;$i<$num;$i++) {
$ot = mysql_result($select, $i, "user");
$dou = mysql_result($select, $i, "user1"); 
$poslanie = mysql_result($select, $i, "poslanie");
}

 $ls = mysql_query("SELECT * FROM voina WHERE user1 = '$userdata[username]' AND voina='1'");
$lss = mysql_num_rows($ls); 
echo $lss;


$i=1; # ?????
if ($i <= $lss) { # ??? ????????????? ?? ?? ?????? ?? ?????? =>
echo "Viete ste predizvikan ".$lss." puti<br><br>"; # => ??????? ???? ($lss ??????? ????? ???? ????. ?????)
} else {
echo "Ne ste predizvikfan<br><br>"; # ??? ?????? ? ?????? ... ??????? ?????
}

if (!$_GET['box']) {

$query = mysql_query("SELECT * FROM voina WHERE user1 = '$dou"); # ??????? ???? ????. ?? ????? ?? ???? ?????????
while ($mesage = mysql_fetch_array($query)) {



if ($mesage['voina'] == '1') {
$mesag = "<b>".$mesage['poslanie']."</b>"; # ???? ?? ??????? ?????. ????? ?? ?? ????????? ? ???????? ???
} else {
$mesag = "".$mesage['poslanie'].""; # ???? ?? ??????? ?????. ???? ???? ?? ???? ???????? ? ?? ????? ? ???????? ???
} 

$in .= "
<tr>
<td class='table'><a href='box.php?box=".$mesage['id']."'>".$mesag."</a></td>
<td class='table'>".$mesage['user']."</td>
</tr>";

}

echo "<table width='100%' align='center' cellspacing='0' cellpadding='0'>
<tr>
<td align='left' class='table'>Ot</td>
</tr>
$in
</table>";


} else {

$getbox = mysql_query("SELECT * FROM ".$db_prefix." voina WHERE id = '".$_GET['box']."'");
$boxx = mysql_fetch_array($getbox);

echo "<table>
<tr>
<td>ot:</td>
<td align='center'>".$boxx['user']."</td>
</tr>

<tr>
<td>poslanie:</td>
<td align='center'>".$boxx['poslanie']."</td>
</tr>



<tr>
<td><a href='box.php'><< vurni se</a></td>
</tr>
</table>";

$up = mysql_query("Update ".$db_prefix." voina SET voina = '0' WHERE id = '$_GET[box]'"); # ?????? ?? ?????? ?????? ?????. ?? ?? ???????? ? ???? ???? ?? ?? ????? ?? ???? ?????.

}

}

?>

 

[smz123]

няма значение +1 за human наи бързо реагира