PupStar

First of all congratulations on the takeover. It has been a long time coming. I hope this does not mean we will see the eventual squeezing out of the dedicated members who kept oscommerce alive in the form of Phoenix. Without their hard work and commitment oscommerce would have gone the way of zencart, cube cart and creloaded. Can I ask does V4 = https://www.trueloaded.co.uk/ Or a slimmed down non commercial version of???

@ecartz Thanks Matt but I must admit that the logic way over my head lol

@raiwa Thank you but unfortunately it made no difference

@Jack_mcs @raiwa Thanks for the help and sorry about the late reply, the day job is taking its toll during this lockdown I have modified the code and now there are no errors or notices however nothing is being copied to the new table. <a href="update_live_categories.php?categories_id=$row[categories_id]"><button class="btn btn-primary" type="submit">Update Categories</button></a> <?php $databaseHost = 'localhost'; //your db host $databaseName = 'tbl_temp_products'; //your db name $databaseUsername = 'root'; //your db username $databasePassword = '';// db password $mysqli = mysqli_connect($databaseHost, $databaseUsername, $databasePassword, $databaseName); $id = 1; $sql="select parent_id, categories_id from tbl_temp_categories where (categories_id='$id')";// check id is already copied $result=mysqli_query($mysqli,$sql); if (mysqli_num_rows($result) > 0) { // output data of each row $row = mysqli_fetch_assoc($result); if($id==$row['categories_id']) { echo "Already copied"; //error message if already copied }else{ $query = "INSERT INTO categories SELECT parent_id, categories_id FROM tbl_temp_categories WHERE categories_id=$id"; if (mysqli_query($mysqli, $query)) { echo "New record created successfully"; } else { echo "Error: " . $query . "" . mysqli_error($mysqli); } } } ?>

@raiwaNot sure why it would need a form as once you click the button it should just copy data from one table to another.

I am having a very boring lockdown sunday afternoon so having a play about. Working locally not specifically on oscommerce but using osc tables. I am trying to copy categories from one table to another. <a href="update_live_categories.php?id=$row[categories_id]"><button class="btn btn-primary" type="submit">Update Categories</button></a> <?php $databaseHost = 'localhost'; //your db host $databaseName = 'tbl_temp_products'; //your db name $databaseUsername = 'root'; //your db username $databasePassword = '';// db password $mysqli = mysqli_connect($databaseHost, $databaseUsername, $databasePassword, $databaseName); $id = $_GET['categories_id']; $sql="select * from tbl_temp_categories where (categories_id='$id')";// check id is already copied $result=mysqli_query($mysqli,$sql); if (mysqli_num_rows($result) > 0) { // output data of each row $row = mysqli_fetch_assoc($result); if($id==$row['categories_id']) { echo "Already copied"; //error message if already copied } } else{ $query = "INSERT INTO categories SELECT * FROM tbl_temp_categories WHERE categories_id=$id"; if (mysqli_query($mysqli, $query)) { echo "New record created successfully"; } else { echo "Error: " . $query . "" . mysqli_error($mysqli); } } ?> This script is throwing 1 notice and 1 error on this line $id = $_GET['categories_id']; and on this line $query = "INSERT INTO categories SELECT * FROM tbl_temp_categories WHERE categories_id=$id"; Any ideas on a resolve? Thank you

Thanks Malcolm, back to the drawing board

oh no, sorry to hear that. I did not know

@JcMagpie Just wondering if you have tried this on the latest version of Phoenix, I have but got this error

@@BrockleyJohn ok did a fresh copy of the files, not sure what happened but its now working spot on :) Thanks

@@BrockleyJohn, ok grabbed them files and nothing has changed and no errors urgh

@@BrockleyJohn I am using the latest version of Edge which I downloaded 02/10 I have placed 4 test orders for the same customer and still no 'All Orders' tab

@@BrockleyJohn I have installed this and I dont seem to have an 'All Orders' tab showing even though there are 3 test orders placed. Am I missing something? Thanks Mark

@@auzStar oh yes the vertical centering is ok.

yes to the above. I found that changing left: 50%; to left: 38%; solved the centralising issue