<?php
error_reporting(E_ERROR);
ini_set('session.cache_limiter','public');
session_cache_limiter(false);
session_start();
include "db_connect_nb.php";
$qry = "SELECT * from selections";
$res = mysqli_query($link, $qry);
$nr = mysqli_num_rows($res);
echo " nr = " . $nr . "<br>";
$nx = 0;
for ($i = 0; $i < $nr; $i++) {
if ($i == 0){
echo "entered loop<br>";
}
$s = mysqli_fetch_array($res,MYSQLI_ASSOC);
$qryo = "select * from proj_opts where pid = " . $s['pid'] . " and ruid = " . $s['ruid'];
echo "qry from opts " . $qryo . "<br>";
$reso = mysqli_query($qryo);
$npo = mysqli_num_rows($reso);
echo "npo = ". $npo . "<br>";
if ($npo != 0) {
$qryu = "UPDATE sel_opts set selno = " . $s['selno'] . " where pid = " . $s['pid'] . " and ruid = " . $s['ruid'];
echo "qry for uptade sel_opts = " . $qryu;
$resu = mysqli_query($link, $qryu);
$nx++;
}
}
echo $nx . " records updated.";
exit;
?>
$reso = mysqli_query($qryo);
Should be$reso = mysqli_query($link,$qryo);
This is going to result in a null return from the mysqli_query which is not going to return any results for the num_rows call.ASKER
PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.
TRUSTED BY
eg change:
Open in new window
to:Open in new window