Problem updating MySQL....

LeZeNkO

Now I havent actully had alot with updating MySQL so ill just give you the script and if someone can help me it'll be great

<html>



<body>


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

 $qre = mysql_query("UPDATE nws set news='$tehnews' where number='1' ", $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><textarea cols=40 rows=10 name=tehnews>". mysql_result($qry,$j,$k) ."</textarea><input type='submit' value=$qre><br><br><br><br></html>";  }
       $sNws = $_POST['nws'];

    ?><?php

}
}

?>

 </body</html>

Any ideas??

Sharif

What is the error or the problem you are experiencing?

LeZeNkO

Connecting to database on the mysql_auery line [The update one]

Sharif

Well what is the error you are getting?

razz

Your problem appears in these lines.

"SELECT nws FROM news ORDER BY nws DESC"

"UPDATE nws set news='$tehnews' where number='1'

The format is:

SELECT field FROM table

AND

UPDATE table SET field='xxx'

You have nws as a field in the first line but a table in the second, while news is a table in the first and field in the second.

razz