PHP - Best Way Of Making A Duplicate Row In Mysql?

Hello everyone.

I'd like to know how to duplicate a product through a php back-office.

That product consists of an ID in the "products" table of my DB. Then we have another table called "sub_products" that links its sub-products through a column named "product_id".

So I have product with ID "1000", and sub-products associated with it on another table with ID's "2021", "2022", "2023".

What's the routine I can use to duplicate both the product and its sub-products? I need to duplicate them because they fit 2 categories so I'm changing the category column during this duplicate.

Could really use some help. Thank you in advance! 

Hello,

i've got this code, to insert some form data into my db, it checks for a value if it exists already, it won't insert, now i want to add another value to check, but i don't know how.

This is my code:

Code: [Select]
<?php
if(isset($_POST['submit'])){
   if (strlen($_POST['code']) == 12 && substr($_POST['code'],0,6) == '610147'){
      $code = $_POST['code'];
      $select_query = mysql_query("SELECT * FROM jupiter WHERE code = '$code'");
      if(mysql_num_rows($select_query) == 0){
         $remote_addr = $_SERVER['REMOTE_ADDR'];
         $secret = $_POST['euro'];
         mysql_query("INSERT INTO jupiter(code,euro,ip,date,used) VALUES('$code','$secret','$remote_addr',CURDATE(),'n')");
 
      }
  Print "<font color='green'>OK</font>"; 
} else { 
    
Print "<font color='red'>Error</font>"; 
}
   
}?>
This checks if "code" already exists, now i want to also have it check for "ip"

Can someone help me out here please.

Thanks !

while ( $categories = $category_result -> fetch_assoc() )
 {
   $menu_sql = "select * from menu where category_id = {$categories['category_id']}";
   
   $menu_result = $handle -> query( $menu_sql );
   
   $category2 = strtoupper($categories['category']);
   
   echo '<h3 id="' . $category2 . '">' . $category2 . '</h3>';
   
   
      while ($menu = $menu_result -> fetch_assoc())
      {
         
         echo $menu['item_name'] . ' ';


         $size_sql = "select distinct size from size where category_id = {$categories['category_id']} order by size desc";
         $size_result = $handle -> query( $size_sql );
         
         while ($size = $size_result -> fetch_row())
          {
            echo $size[0] . ' ';
         }
         
         //get base type from base_type table for the pizza category
         $type_sql = "select type from base_type where category_id = {$categories['category_id']}";
         $type_result = $handle -> query( $type_sql );
         
         while ($type = $type_result -> fetch_row())
          {
            echo $type[0] . ' ';
         }         
         
         
         //get price for each item from menu if it is not null   
         $price_sql = "select price from menu where item_name = '{$menu['item_name']}'";
         $price_result = $handle -> query( $price_sql );
         
         while ($price = $price_result -> fetch_row())
          {
            echo $price[0] . ' ';
            
            if( is_null( $price[0] ) )
            {
            //get price from size table if price is null in menu table;

                    //$categories = $category_result -> data_seek(0);               
               
               $size = "double";
               $category_id = $categories['category_id'];
               $item_id = $menu['item_id'];
               $type = 'deep';
               
               echo $menu['item_id'];
                   
               
               $price_size_sql = "select price from size where size = '$size' and category_id = $category_id and item_id = $item_id";
               $price_size_result = $handle -> query( $price_size_sql );
               
               while ($price_size = $price_size_result -> fetch_assoc())
               {
               
                  echo " {$price_size['price']} ";
                  
               }
            }
            
         }         
                     
         echo '<br />';
      
      }
    echo '<br />';
 }


I get duplicate vakues for $category_id = $categories['category_id'];
               $item_id = $menu['item_id'];

dont know whats wrong it works for pizzas but not burgers, please help me.

The only 2 tables relevant to what I want to do are "User" and "Scores." Basically this database holds high scores for a project I've been working on. I only want to display 10 scores, all from different users. No 2 or more scores from the same user. This is my db structure within phpmyadmin:

Quote

database -> table -> X / User / Score / X / X / X / X / X / X / X / X


If possible I'd like to run a query where it checks for duplicate entries by the same user and only show the highest score. The current query I'm running is below:

$result = mysql_query("SELECT * FROM table ORDER BY Score DESC LIMIT 0, 10");

Is this possible? I can only seem to find information regarding the INSERT IGNORE clause and that obviously won't help me as the users and scores are already in the database. Thanks.

Hello,

i am inserting some form data into my mysql db, i happen to get some duplicates so i want to check first if the entry exists already before i insert.

my current code:

Code: [Select]
<?php

if(isset($_POST['submit']))  { ?>
<?php 
if (strlen($_POST['code']) == 19 && substr($_POST['code'],0,7) == '5541258')  { 
     mysql_query("INSERT INTO table(code,secret,ip,date) VALUES('$_POST[code]','$_POST[secret]','$_SERVER[REMOTE_ADDR]',CURDATE())");
Print "<font color='green'>The code will be checked now</font>"; 
} else { 
    
Print "<font color='red'>The code is invalid</font>"; 
}
?><?php } ?>
I would like to use the value 'code' to check if the entry exists, that one is unique for each entry. How would i do that ?

Thanks !