PHP - Problem: Mysql Tables Rows - One Row Per Page + Condition

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=321443.0

Hi Everyone,

I am working on developing a blog/comment system for my website. I have 3 tables, the first a blog post table with a row/primary key of id that is auto incremented as each new article is created via a form. The second table is a comments table with a row of article_id and the third table is a category table with an article_id row as well.

From the main blog page I have links that will take users to each individual blog post using $_GET like so:

Code: [Select]
http://www.mydomain.com/blog/article/?id={$row['id']}
From here I would like to be able to display the comment for that particular article below the article and also have a sidebar with links to blog categories which will then display each post according to whether they are in that category or not.

My question is two-fold:

First, what is the best way to pull the id field from the blog/post table, form, or url and enter it into the article_id rows of the second two tables? Should I use a hidden field, the URL id via $_GET, using a join, or what?

Secondly:

What is the best way to compare and display those rows so that the appropriate comments are being shown for the correct article, etc.

This is my first time doing this so I am grateful for any help or suggestions.

Thanks,

kaiman

Hi,

So i'm having a little trouble trying to simplify some code I already have.

Code: [Select]
$result = mysql_query("SELECT images, cat_id FROM image_cat");

while ($row=mysql_fetch_array($result))
{
$cat_id=$row['cat_id'];
echo $cat_id;
$imgresult = mysql_query("SELECT * FROM images WHERE cat_id='".$cat_id."'");
while ($col=mysql_fetch_array($imgresult))
{
echo $col['img_id'];
}
}

Okay, so this works, however i'm sure I can bring it together under one query, though i'm truly stumped as to how?
I thought I could do a simple join:

Code: [Select]
$result = mysql_query("SELECT image_cat.cat_id, images.img_id WHERE image_cat.cat_id=images.image_cat");

This works, but repeats the image category on each loop. I could remove this via php if statements, but there must be a simpler/mysql solution.

If it doesn't make any sense I need to get

Img cat 1
-img 1
-img 2

img cat 2
-img 3
-img 4

etc etc

That join will give

img cat 1
-img 1
img cat 1
-img 2
img cat 2
-img 3

Hope that makes sense?? And any help would be amazing!
Thanks.

Hi..

I tried this code:

Code: [Select]
<?php
     error_reporting(0);
   date_default_timezone_set("Asia/Singapore"); //set the time zone  
$con = mysql_connect('localhost', 'root','');
  mysql_select_db("mes", $con); 
if (!$con) {
    echo 'failed';
    die();
}

$sql = "SELECT PCODE, total FROM kanban_checker ORDER BY PCODE";
$res = mysql_query($sql, $con) or die(mysql_error());

while($row = mysql_fetch_assoc($res)){
    $PCODE = $row['PCODE'];
    $total = $row['total'];
}
  $sql = "SELECT 
                P28, P28_max, P28_min,
                P30, P30_max, P30_min,
                P32, P32_max, P32_min,
                P33, P33_max, P33_min,
                P35, P35_max, P35_min,
                P35M, P35M_max, P35M_min,
                P35W, P35W_max, P35W_min,
                P38, P38_max, P38_min,
                P41, P41_max, P41_min,
                P42, P42_max, P42_min,
                P43, P43_max, P43_min,
                P46, P46_max, P46_min
                FROM parameter_settings";
        $res_pcode = mysql_query($sql, $con);
        
  $row = mysql_fetch_assoc($res_pcode);
            $P28 = $row['P28'];
            $P28_max = $row['P28_max'];
            $P28_min = $row['P28_min'];
        
            $P30 = $row['P30'];
            $P30_max = $row['P30_max'];
            $P30_min = $row['P30_min'];
            
            $P32 = $row['P32'];
            $P32_max = $row['P32_max'];
            $P32_min = $row['P32_min'];
            
            $P33 = $row['P33'];
            $P33_max = $row['P33_max'];
            $P33_min = $row['P33_min'];
            
            $P35 = $row['P35'];
            $P35_max = $row['P35_max'];
            $P35_min = $row['P35_min'];
           
            $P35M = $row['P35M'];
            $P35M_max = $row['P35M_max'];
            $P35M_min = $row['P35M_min'];
            
            $P35W = $row['P35W'];
            $P35W_max = $row['P35W_max'];
            $P35W_min = $row['P35W_min'];
            
            $P38 = $row['P38'];
            $P38_max = $row['P38_max'];
            $P38_min = $row['P38_min'];
            
            $P41 = $row['P41'];
            $P41_max = $row['P41_max'];
            $P41_min = $row['P41_min'];
            
            $P42 = $row['P42'];
            $P42_max = $row['P42_max'];
            $P42_min = $row['P42_min'];
            
            $P43 = $row['P43'];
            $P43_max = $row['P43_max'];
            $P43_min = $row['P43_min'];
            
            $P46 = $row['P46'];
            $P46_max = $row['P46_max'];
            $P46_min = $row['P46_min'];
            
            $P47 = $row['P47'];
            $P47_max = $row['P47_max'];
            $P47_min = $row['P47_min'];             
       if($PCODE = $P28 || $total = $P28_min){
            echo $P28_min;
        }
        elseif($PCODE = $P30 || $total = $P30_min){
            echo $P30_min;
        }
        elseif($PCODE = $P32 || $total = $P32_min){
            echo $P32_min;
        }
        elseif($PCODE = $P33 || $total = $P33_min){
            echo $P33_min;
        }
        elseif($PCODE = $P35 || $total = $P35_min){
            echo $P35_min;
        }
        elseif($PCODE = $P35M || $total = $P35M_min){
            echo $P35M_min;
        }
        elseif($PCODE = $P35W || $total = $P35W_min){
            echo $P35W_min;
        }
        elseif($PCODE = $P38 || $total = $P38_min){
            echo $P38_min;
        }
        elseif($PCODE = $P41 || $total = $P41_min){
            echo $P41_min;
        }
        elseif($PCODE = $P42 || $total = $P42_min){
            echo $P42_min;
        }
        elseif($PCODE = $P43 || $total = $P43_min){
            echo $P43_min;
        }
        elseif($PCODE = $P46 || $total = $P46_min){
            echo $P46_min;
        }
        elseif($PCODE = $P47 || $total = $P47_min){
            echo $P47_min;
        }
        else{
            echo '';
        }
?>

for display data if total = min.

The problem is, in this condition he satisfied if condition even though $total is not equal to $P28_min.

Thank you

When I use the following code, it doesn't print out "test" until after I refresh the page.

unset($_SESSION["product"]);

if ( !empty($_SESSION["product"]) && ($_SESSION["product"] != NULL)) {
echo "test";
}

When I use:

var_dump($_SESSION["product"]);

It shows:

array(0) { } 

I'm wondering it that's the problem. That it's array(0) when it should be array().

This portion is kind of stumping me. Basically, I have a two tables in this DB: users and users_access_level (Separated for DB normalization)

users: id / username / password / realname / access_level
users_access_level: access_level / access_name

What I'm trying to do, is echo the data onto an HTML table that displays users.username in one table data and then uses the users.access_level to find users_access_level.access_name and echo into the following table data, I would prefer not to use multiple queries if possible or nested queries.

Example row for users: 1234 / tmac / password / tmac / 99
Example row for users_access_level: 99 / Admin

Using the examples above, I would want the output to appear as such:

Username: Access Name: Tmac Admin
I am not 100% sure where to start with this, but I pick up quickly, I just need a nudge in the right direction.

The code I attempted to create just shows my lack of knowledge of joining tables, but I'll post it if you want to see that I did at least make an effort to code this myself.

Thanks for reading!

Hi..

I got problem in logic on my problem in select option.

Here is my scenario.

I have select option which has a compound list:

example:

P28
P30
P32
P33
P35


and I have tables which has a total count of
compound that was already transact.

for example I already transact
10 P28 compound.

it will save in kanban_checker table field Total.

and I have parameter_settings table which has the maximum and minimum per compound:

fields----------data
P28------------P28
P28_max-----10
P28_min------6
P30------------P28
P30_max-----10
P30_min------6
P32------------P28
P32_max-----10
P32_min------6
P33------------P28
P33_max-----10
P33_min------6


now the logic is:

if P28 total = P28_max then notify that he already reach the maximum..it will not produce P28 because he already reach the maximum.

if P28 total = P28_min then produce P28.

same with other compound.

Now, I got a problem in coding and logic, because in the select option I'm not the one who code it.. I just one who need to add the additional function..

here is the code for select option and the function that was created by other,

Code: [Select]
$smarty->assign('text_name1','Compound Code');
 $smarty->assign('compoundIndexValue', array('0',  'P28',  'P30',  'P32',  'P33',  'P35',  'P35M',  'P38',  'P40', 'P41',  'P42',  'P43', 'P46', 'P47', 'PXX', 'P35W'));

 <tr>
            <td class="tdMainText">{$text_name1}</td>
           
            <td> <select class="tdMainElement" id="selCompound"  onchange="isSelected('selCompound','txtLotCode')" onclick="clearNotify()" onblur="this.focus();" onkeypress="return false">{html_options values=$compoundIndexValue output=$names selected="0"} </select> </td>
            </tr>

<script type="text/javascript">
function isSelected(obj1, obj2) {

     if (!document.getElementById(obj1).disabled) {
         document.getElementById(obj1).disabled = true;
     }       
             
     if (document.getElementById('clear').disabled) {
         document.getElementById('clear').disabled = false; //enable it
     }

     if ((document.getElementById('chkDownGrade') != null)) {
        if (!document.getElementById('chkDownGrade').disabled) {     
           document.getElementById('chkDownGrade').disabled = true;
        }
     }
     
     
     if (document.getElementById(obj2).disabled) {
         document.getElementById(obj2).disabled = false;
     }
         document.getElementById(obj2).focus();
         document.getElementById(obj2).focus();
         
     //notify("Gain Maximum Total"); 

}

function disable() {
             if (!document.getElementById('clear').disabled) {
                 document.getElementById('clear').disabled = true;
             }
             else { 
                 document.getElementById('clear').disabled = false;
             }

}

function clearNotify() {
   
   if (document.getElementById('notice') != null) {
      document.getElementsByTagName('body')[0].removeChild(document.getElementById('notice')) //>> clear the box    }
   }
</script>


and here is the code that I tried to add:

Code: [Select]
$compound = mysql_real_escape_string($_POST['compound']);
        $sql = "SELECT
                P28, P28_max, P28_min,
                P30, P30_max, P30_min,
                P32, P32_max, P32_min,
                P33, P33_max, P33_min,
                P35, P35_max, P35_min,
                P35M, P35M_max, P35M_min,
                P35W, P35W_max, P35W_min,
                P38, P38_max, P38_min,
                P41, P41_max, P41_min,
                P42, P42_max, P42_min,
                P43, P43_max, P43_min,
                P46, P46_max, P46_min
                FROM parameter_settings";
        $res_pcode = mysql_query($sql, $con);
       
        while($row = mysql_fetch_assoc($res_pcode)){
            $P28 = $row['P28'];
            $P28_max = $row['P28_max'];
            $P28_min = $row['P28_min'];
       
            $P30 = $row['P30'];
            $P30_max = $row['P30_max'];
            $P30_min = $row['P30_min'];
           
            $P32 = $row['P32'];
            $P32_max = $row['P32_max'];
            $P32_min = $row['P32_min'];
           
            $P33 = $row['P33'];
            $P33_max = $row['P33_max'];
            $P33_min = $row['P33_min'];
           
            $P35 = $row['P35'];
            $P35_max = $row['P35_max'];
            $P35_min = $row['P35_min'];
           
            $P35M = $row['P35M'];
            $P35M_max = $row['P35M_max'];
            $P35M_min = $row['P35M_min'];
           
            $P35W = $row['P35W'];
            $P35W_max = $row['P35W_max'];
            $P35W_min = $row['P35W_min'];
           
            $P38 = $row['P38'];
            $P38_max = $row['P38_max'];
            $P38_min = $row['P38_min'];
           
            $P41 = $row['P41'];
            $P41_max = $row['P41_max'];
            $P41_min = $row['P41_min'];
           
            $P42 = $row['P42'];
            $P42_max = $row['P42_max'];
            $P42_min = $row['P42_min'];
           
            $P43 = $row['P43'];
            $P43_max = $row['P43_max'];
            $P43_min = $row['P43_min'];
           
            $P46 = $row['P46'];
            $P46_max = $row['P46_max'];
            $P46_min = $row['P46_min'];
           
            $P47 = $row['P47'];
            $P47_max = $row['P47_max'];
            $P47_min = $row['P47_min'];
        }
       // $sub_lotcode = substr($lotCode, 9, 4);
           
        $sql = "SELECT PCODE, total FROM kanba_checker WHERE PCODE = '$sub_lotcode' ORDER BY PCODE";
        $res_kanban = mysql_query($sql, $con);
       
        $row_kanban = mysql_fetch_assoc($res_kanban);
       
        $PCODE = $row_kanban['PCODE'];
        $total = $row_kanban['total'];
       
        if($compound = $P28 || $total == $P28_max){
         echo "<script type='text/javascript'>alert(P28 gain total maximum)</script>";   
        }
        else{
           
        } 


but I don't know if my code and my logic is correct.

I think  I did to add function.

But I don't know how..

I hope someone can help me or guide me to solve my problem.

Thank you so much..

I have a cart script, and I need to display the products the user has added.  This is a school assignment and I'm very stuck on this seemingly 'little' error.

Right now, I have two tables:

For time's sake, I am showing duplicate products with different prod_id's:
Table: products
prod_id category sub_category thumb_href image_href title desc summary manufacturer price 17 sofa leather red_leather_sofa_small.jpg red_leather_sofa_main.jpg Red Leather Sofa [BLOB - 134B] [BLOB - 59B] Balenty 999.99 18 sofa leather red_leather_sofa_small.jpg red_leather_sofa_main.jpg Red Leather Sofa [BLOB - 134B] [BLOB - 59B] Balenty 999.99 19 sofa leather red_leather_sofa_small.jpg red_leather_sofa_main.jpg Red Leather Sofa [BLOB - 134B] [BLOB - 59B] Balenty 999.99
And this is the cart table that holds temporary cart items (storing the product ID to pull later):
Table: cart
temp_cart_item cart_id (assigned by session_id() ) prod_id user_id 22 jier11u0e7cl2ghosjodpaark2 17 asdfasdf 23 jier11u0e7cl2ghosjodpaark2 17 asdfasdf 24 jier11u0e7cl2ghosjodpaark2 35 asdfasdf 25 jier11u0e7cl2ghosjodpaark2 5 asdfasdf 26 jier11u0e7cl2ghosjodpaark2 19 asdfasdf
SO, user 'asdfasdf' is logged in and has selected 5 items for his cart - two of which are the same (prod_id 17).  Basically,

I need to compare the prod_id's of each table and output all products (and quantities) matching the temporary cart prod_id.

What I have now to loop through and display the cart items are (bear with me):


echo "<h1>Cart</h1>";
}
// Display welcome and navigation links
displayWelcome();
displayNav();

// Getting the prod_id's from the table cart to compare with the product table
$cart_id = session_id();
$user_id = ($_SESSION['login_username']);
$query = "SELECT prod_id FROM cart WHERE cart_id='$cart_id' AND user_id='$user_id'";
$result = mysqli_query($cxn,$query) or die("<h2 class=\"warning\">Whoa! Problem with the cart script here!</h2>");
$nrows = mysqli_num_rows($result);
if($nrows < 1)
{
echo "<h2>Your cart is empty</h2><p><a href=\"catalog.php\">Go back to the catalog</a></p>";
}
else {  // Continue to gather products for all the product IDs in the products DB table...
echo "<h4>$nrows items in your cart</h4>";
while($row = mysqli_fetch_array( $result )) {
$user_id = ($_SESSION['login_username']);
$product = $row['prod_id'];

// Is the query my problem?
$query = "SELECT * FROM products WHERE prod_id='$product'";
$result = mysqli_query($cxn,$query) or die("<h2 class=\"warning\">Whoa! Problem with the cart script here!</h2>");
$nrows = mysqli_num_rows($result);
if($nrows < 1) { // If the item doesn't exist, display an error
echo "<h2>That is not a valid product, or any of the items you had in your cart are missing or have been deleted.</h2><p><a href=\"catalog.php\">Go back to the catalog</a></p>";
// Protect from continually displaying an error by deleting the invalid cart record
$deletequery = "DELETE FROM cart WHERE prod_id='$product'";
$deleteresult = mysqli_query($cxn,$deletequery) or die("<h2 class=\"warning\">Whoa! Problem with the cart script here!</h2>");
exit();
}
while($row = mysqli_fetch_array( $result )) {  //  Then disply them in a table
echo "<h2>Items in Your Cart:</h2>";
echo "
<table id=\"products\">
<thead>
<tr>
<th class=\"col1 headercol\" scope=\"col\">Thumbnail</th>
<th class=\"col2 headercol\" scope=\"col\">Summary</th>
<th class=\"col3 headercol\" scope=\"col\">Manufacturer</th>
<th class=\"col4 headercol\" scope=\"col\">Price</th>
</tr>
</thead>

<tbody>\n";
$query = "SELECT SUM(price) FROM products WHERE prod_id='$product' GROUP BY price";
$priceResult = mysqli_query($cxn,$query) or die("<h2 class=\"warning\">Whoa! Problem with the cart script here!</h2>");
// keeps getting the next row until there are no more to get
// Print out the contents of each row into a table
echo "<tr>
<td class=\"col1\">"; 
echo "<a class=\"imgHref\" href=\"detail.php?prod_id=".$row['prod_id']."\" title=\"".$row['title']."\"><img src=\"../images/".$row['thumb_href']."\" alt=\"".$row['title']."\" /></a>";
echo "</td>\n"; 
echo " <td class=\"col2\">"; 
echo "<h3 class=\"title\"><a href=\"detail.php?prod_id=".$row['prod_id']."\" title=\"".$row['title']."\">".$row['title']."</a> <span class=\"inlineh3\">by <a href=\"categories.php?manufacturer=".$row['manufacturer']."\" title=\"View all products by ".$row['manufacturer']."\">".$row['manufacturer']."</a></span></h3>";
echo "<p class=\"summary\">".$row['summary']."</p>
<p class=\"descHeading\">&#38;#9758; <em>Full Description:</em></p>
<p class=\"desc\">".$row['desc']."</p>";
echo "</td>\n"; 
echo " <td class=\"col3\">"; 
echo "<p class=\"manufacturer\"><a href=\"categories.php?manufacturer=".$row['manufacturer']."\" title=\"View all products by ".$row['manufacturer']."\">".$row['manufacturer']."</a></p>";
echo "</td>\n"; 
echo " <td class=\"col4\">"; 
echo "<p class=\"price\">$".$row['price']."</p>";
echo "</td>
</tr>\n"; 
}
while($priceRow = mysqli_fetch_array( $priceResult )) {
echo "<tr class=\"short\"><td class=\"col1\"><h3><a href=\"clear_cart.php\">Empty Cart</a></h3></td><td class=\"col2\"></td><td class=\"col3 nobackground\">Total:</td><td class=\"col4\">$".$priceRow[0]."</td></tr>";
}
echo "</tbody>
</table>";
echo "<p class=\"submitOrder\"><form action='submit_order.php' method='post' id='form'>
  <input type='submit' name='pButton' value='Submit Order'>
  <input name='order_total' type='hidden' id='order_total' value='".$priceRow[0]."' />
</form>
</p>";
}
}



And so the cart.php looks something like this (this example asdfasdf has 6 items in his cart):



So you can see that it only displays ONE item, even though asdfasdf DOES have 6 items in his cart (proven by checking database).  And the price is not accurate, either.

Can anyone help me in where my problem might be?  Is it my query?  Or my while clause?

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=359434.0

I am trying to write some data from multiple SQL tables to a page. In the first table is a list of places. I then have more tables that are named after the different places. For example, say my first place in the list is called Place1. I have a table named Place1 with data that corresponds to place1. The data contained in the table named Place1 is a list of things to do in this place. It has 21 columns and each one is something to do in the morning, afternoon, and at night for each day of the week in the place Place1. What I am trying to do is display a sort of weekly calendar as a table on a webpage that lists all of the places in one column and then lists seven days of the week as 7 more columns. Then in each data cell I would want to list the things to do in the morning, afternoon and at night for the certain day of the week and for the place. The problem is that I am creating a CMS to allow other users with no coding knowledge to update events for other places, so I have to display data that could have been altered.

The only solution I know of is to do a while loop that gets all of the place names and while there are still place names, write the place names to the page and set a variable equal to the place name. Inside the while loop I would create another while loop that each time the first while loop is executed uses the variable set in the first while loop to know which table to reference and then make a call to that table pulling out the 21 columns and writing them to the page. Each time the outer while loop executes, it would (hopefully) write the place name, and then set the variable as the current place name so that the inner while loop uses the variable to write the rest of the information about that place.

I don't know if that would even work and if it did, I know it cannot be the best way to do this. I am pretty stuck here and don't really have a good solution so if anyone proposes a solution that is radically different to anything I have done, I am open to everything. Thank you!

im wondering how to get php to read the latest row (instead of show them all) and when another one comes it replaces it once the page refreshes

Ok I am trying to delete some rows from a database. I have done this before with success so I thought I could use the same method just modify it a little and it would work. Man was I wrong. Any help on this is much appreciated below is my code.

Code for the Query to get the data from the database and for displaying the results in a table:
Code: [Select]

//GET DATA
$sql = "SELECT * FROM `".$tblname."` ORDER BY $orderby $sort LIMIT $startrow,$limit";
$result = mysql_query($sql) or die(mysql_error());
$result2 = mysql_query($sql);

//START TABLE AND TABLE HEADER
echo "<form name='form1' method='post' action=''><table style='font-size:9.5px;'>\n<tr><th>Delete</th>";
$array = mysql_fetch_assoc($result);
foreach ($array as $key=>$value) {
if($config['nicefields']){
$field = str_replace("_"," ",$key);
$field = ucwords($field);
}

$field = columnSortArrows($key,$field,$orderby,$sort);
echo "<th>" . $field . "</th>\n";
}
echo "</tr>\n";

//reset result pointer
mysql_data_seek($result,0);

//start first row style
$tr_class = "class='odd'";

//LOOP TABLE ROWS
while($row = mysql_fetch_assoc($result)){


echo "<tr ".$tr_class.">\n<td><a
 href='remove_rec.php?id=". $rows['ID'] . "'><p>Delete</p></a>";
echo "</td>";
foreach ($row as $field=>$value) {
echo "<td>" . $value . "</td>\n";
}
echo "</tr>\n";
//switch row style
if($tr_class == "class='odd'"){
$tr_class = "class='even'";
}else{
$tr_class = "class='odd'";
}

}

//END TABLE
echo "</table>\n</form>";

Here is the code that should delete the row:
Code: [Select]
$tblname = 'tablename';
// get value of id that sent from address bar
$id=$_GET['ID'];

// Delete data in mysql from row that has this id
$sql="DELETE FROM $tblname WHERE ID='$id'";
$result=mysql_query($sql);

// if successfully deleted
if($result){
echo "Deleted Successfully";
echo "<BR>";
echo "<a href='leads3.php'>Back to Results</a>";
}

else {
echo "ERROR";
}

When I click on the link to delete a record it redirects me to the appropriate page with the "Deleted Successfully" message but when I go to view the results the row was not deleted. Any help on this would, again, be greatly appreciated.

I have a MySQL query that returns rows containing date_add column like below:

DATE(date_add)
2014-01-07
2014-01-07
2014-01-07
2014-01-07
2014-01-08
2014-01-15
2014-01-20
2014-01-20
2014-01-20
2014-01-26
2014-01-28
2014-02-16
2014-02-16
2014-02-16
2014-02-16
2014-02-16
2014-02-16
2014-02-16
2014-02-18
2014-02-18
2014-03-08
2014-03-08

How can I have pagination based on dates and show rows with the same date in a page and not just based on predefined limit number?

First off I know this will be a problem with my code but I honestly have looked at it for too long. If anyone can shed a bit of simple light on it that would be great.

$count should return about 8 or 9 or so but just returns 1 - I can only print out the number 1 if I do a direct echo of the mysql_num_rows() instead of putting it into the $count variable. Its really confusing, the database is all set up correctly as earlier on in the page I get all the information from the database and print out a table with it. There is something wrong here!

Problem only occurs when $count = mysql_num_rows($result1); is written.

Code: [Select]
//Following user presses button with name applyChanges.

if(isset($_POST['applyChanges']))
{
$result1 = mysql_query("SELECT * FROM music") or die ("Could not get result1");
$count = mysql_num_rows($result1) or die ("Could not count rows"); //Changed this to an echo without $count and prints a 1. - Should be greater than 8
echo "$count";

for($i=0; $i<$count; $i++)
{
$query2 = "UPDATE music SET name='$name[$i]' WHERE path='$path[$i]'";
$result2 = mysql_query($query2);
}
}
Thanks,
Matt