Kod
$SQL = "SELECT * FROM `user` ORDER BY `login` ASC";
$RESULT = mysql_query($SQL);
$i = 1;
$j = mysql_num_rows($RESULT);
if(mysql_num_rows($RESULT) > 0){
while($read = mysql_fetch_object($RESULT)){
$ID[$i] = $read->ID;
$login[$i] = $read->login;
$i++;
};
};
$SQL = "SELECT * FROM `userproperties` ORDER BY `login` ASC";
$RESULT = mysql_query($SQL);
$i = 1;
if(mysql_num_rows($RESULT) > 0){
while($read = mysql_fetch_object($RESULT)){
$email[$i] = $read->email;
$regDate[$i] = $read->regDate;
$lastVisit[$i] = $read->lastVisit;
$visits[$i] = $read->visits;
$userStatus[$i] = $read->userStatus;
$posts[$i] = $read->posts;
};
};
$RESULT = mysql_query($SQL);
$i = 1;
$j = mysql_num_rows($RESULT);
if(mysql_num_rows($RESULT) > 0){
while($read = mysql_fetch_object($RESULT)){
$ID[$i] = $read->ID;
$login[$i] = $read->login;
$i++;
};
};
$SQL = "SELECT * FROM `userproperties` ORDER BY `login` ASC";
$RESULT = mysql_query($SQL);
$i = 1;
if(mysql_num_rows($RESULT) > 0){
while($read = mysql_fetch_object($RESULT)){
$email[$i] = $read->email;
$regDate[$i] = $read->regDate;
$lastVisit[$i] = $read->lastVisit;
$visits[$i] = $read->visits;
$userStatus[$i] = $read->userStatus;
$posts[$i] = $read->posts;
};
};
po odpaleniu pojawia sie blad:
Kod
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\system_newsow\panelViewUser.php on line 42
i niestety skrypt nie wykonuje drugiego zapytania.
mecze sie i niestety niemoge sobie nijak z tym poradzic.
prosze o pomoc.