How2 Variable PHP inside while sql
Posted: Sun Aug 17, 2008 4:21 am
Hello all,
I need to define some VARIABLE php inside sql while cicle when I execute follow code:
$Vars = "SELECT word_id, `$language` FROM wordsite";
$VarsResult = mysql_query($Vars);
$VarsNumber = mysql_numrows($VarsResult);
$iVars = 0;
if ($VarsNumber < 1) {
print "no result";
}
else {
while ($VarsNumber > $iVars) {
$Word_id = mysql_result($VarsResult,$iVars,"word_id");
$Word = mysql_result($VarsResult,$iVars,"$language");
Word_id = "$Word"; // not work!!!
##############################
how to define so many variable how much the records are?
##############################
$iVars++;
}
}
print "$Word_id";
?>
Can you help me?
Thanks all.
I need to define some VARIABLE php inside sql while cicle when I execute follow code:
$Vars = "SELECT word_id, `$language` FROM wordsite";
$VarsResult = mysql_query($Vars);
$VarsNumber = mysql_numrows($VarsResult);
$iVars = 0;
if ($VarsNumber < 1) {
print "no result";
}
else {
while ($VarsNumber > $iVars) {
$Word_id = mysql_result($VarsResult,$iVars,"word_id");
$Word = mysql_result($VarsResult,$iVars,"$language");
Word_id = "$Word"; // not work!!!
##############################
how to define so many variable how much the records are?
##############################
$iVars++;
}
}
print "$Word_id";
?>
Can you help me?
Thanks all.