encountered a problem today
$sql = $mysqli->query(
"SELECT .... "
);I have a query that I want to apply to two while, but only the first one has a response
<? while ($row = mysqli_fetch_array($sql)){ ?>
<? }?>
<? while ($row = mysqli_fetch_array($sql)){ ?>
<? }?>is there any way to implement the same query that can be applied to two while? In the same place.
you can save the results of fetch to an array and then cycle through the array.
$rows=array();
while($row=mysqli_fetch_array($result)) {
$rows[]=$row;
}
foreach($rows as $row) {
A
}
foreach($rows as $row) {
B
} or simply use mysqli_fetch_all , which is said to have some performance advantages:
$rows=mysqli_fetch_all($result, MYSQLI_BOTH); Note mysqli_fetch_all defaults to MYSQLI_NUM , which is different from mysqli_fetch_array , so add a second parameter.
add a sentence mysql_data_seek ($sql, 0)
before the second while. Excuse me if there is anything wrong with the grammar of php,.
<? while ($row = mysqli_fetch_array($sql)){ ?>
<? }?>
<? mysql_data_seek( $sql, 0 ); ?>
<? while ($row = mysqli_fetch_array($sql)){ ?>
<? }?>
want to check the hypothesis. I want the counterparty to access my database via php curl what can I do this? Is there a template you can refer to? this is due to the fact that the host is in parallel with mysql and all the mysql data are managed cent...
I found that the e-commerce merchandise list needs to be planned but I don t know where to refer to currently my merchandise list basically has names original sales displays benefits but I still have several major types one is commodity clas...
SELECT * FROM `product` AS p JOIN `store` AS s ON p.prod_id = s.prod_id my join has realized that I need store s name, icon and product s name, icon . What should I do? this is what I show: <? while($row = mysqli_fetch_array($data)...
SELECT * FROM `user_cart` as c JOIN `product` AS b ON c.prod_id = b.prod_id WHERE c.id = {$_SESSION["user-id"]} I have a value in product called from, which is either an or b , but what is shown now is ...
$product_name = $pdo->query( "SELECT * FROM `stock` as s JOIN `product` as p ON p.prod_id = s.prod_id WHERE s.order_id = {$first_order[ order_id ]} " ); $productNameArray = null; while ($row = mysqli...
check I can t even find the method on the website how to start AUTO_INCREMENT from 0 via php mysql lookup? not in this way: CREATE TABLE `admin` ( `x` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; is the way to ...
reason suppose I want to input all the data of a number table, how can I change the value of this field to B if there is A? INSERT INTO `wp_posts` (`ID`, `content`) VALUES (13335, <h3>< h3> r n[embed]https: www.instagram.com p Bc...
subject I now have a problem data table structure: 2158 2159 16620 2158 16620 2159 blog_id tags 16620 null I am now writing that the tags field of C datasheet is empty I want to associate C s blog_id associated B Datasheet-> to...
call for help I m really in a hurry right now. I m going to make a copy of RSS, for An and B (one of which is a facebook instant article). but I don t know anything about RSS! what I thought of create two number tables, and when you add a...
SQL $rs = $do->query( "SELECT t.name as name, tr.object_id as object_id FROM wp_terms as t JOIN wp_term_relationships as tr ON tr.term_taxonomy_id = t.term_id JOIN blog as b ON b.url = tr.object_id " ); UP...
suppose a web site has a backend, and the default is test.com admim (test.com is my own personal domain and must be encrypted to log in, so the test will have a test manager account, and there will be an official manager account), and you can add back-...
assume that the front end is <input type="hidden" name="cart_prod_id[]" value="<?=$row[ prod_id ];?>"> <input type="hidden" name="cart_quantity[]" value="<?=$row[ quan ];?>...