Updating MySQL

LeZeNkO

Im having trouble with this script updating........what do i put into the update query?

<html> 

<heaitle></title> 
</head> 

<body> 

 <?php 
 require_once('test.css'); 
$link = mysql_connect("localhost", "root", ""); 
mysql_select_db("name", $link); 
$qry = mysql_query("SELECT nws FROM news ORDER BY nws DESC", $link); 
$update = mysql_query("UPDATE news AND nws, $link"); 

?><?php 

if (mysql_num_rows($qry) > 0) { 
    for ($j = 0; $j<mysql_num_rows($qry); $j++) { 

    ?><?php 

    for ($k = 0; $k<mysql_num_fields($qry); $k++) { 
        echo "<html><div align=center><textarea cols=40 rows=10>". mysql_result($qry,$j,$k) ."</div></textarea><input type=submit value=$update><br><br><br><br></html>";  }  ?> 

    ?><?php 

} 
} 

?> 

</body> 

</html>

LordShryku

What are you trying to update? That query makes no sense....

LeZeNkO

i wanna update

<?php

if (mysql_num_rows($qry) > 0) {

for ($j = 0; $j<mysql_num_rows($qry); $j++) {

    ?><?php  

    for ($k = 0; $k<mysql_num_fields($qry); $k++) {  
        echo "<html><div align=center><textarea cols=40 rows=10>". mysql_result($qry,$j,$k) ."</div></textarea><input type=submit value=$update><br><br><br><br></html>";  }  ?>  

    ?><?php  

}

}

Shinmeiryu

Which fields are you updating because you have also SET the update in the query. Fix your update query first.

LeZeNkO

All of em :o

mtimdog

I suggest you look here to find out how to use mysql's update command.