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 A Datasheet through php, fetch the value back to C Datasheet and UPDATE tags is like this: Dumpling, Noodle
blog_id / tags
16620 / ,how can this be realized? Can you give me some ideas?
b table and a table join will get the data, and then insert c table on it? So what's your difficulty?
it is assumed that the id of table An is associated with the bid of table B:
select GROUP_CONCAT(A.tag SEPARATOR ',') as tags,B.id from A join B where A.id = B.bidwant 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 ...
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)){ ?> ...
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...
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 ];?>...