insert functions

[sub01]

hey,
thanks for getting back.
I have a 2 steps problem...
I have to finish an insert form and an update one.
let's talk about the insert.
my problem is I can't manage to make it work:

I have one function which draws the form as soon as the page loads:

function insert_row($table,$data){
        $query = "DESCRIBE $table";
        $result = mysql_query($query);

    print "<DIV ALIGN=\"CENTER\">";
    print "<table border=1>\n";
    print "<FORM METHOD='POST' ACTION='$PHP_SELF'>";

    $counter = 0;  

    while ($row = mysql_fetch_array($result,MYSQL_NUM)) {
           $counter++;
           print "\t<tr>\n";
           print "<td><b>$row[0]</b></td>";

           if ($counter == 1 || $counter ==2) {
                print "<td>auto</td>";
           } else {
                print "<td><INPUT TYPE='text' NAME='data' VALUE='' SIZE=13 style=\"border-style: solid\"></td>";
           }
           print "\t</tr>\n";

    }

    print "</table>\n";   
    print "<br>";
print "<INPUT TYPE='submit' name='submit2' value='Insert a new Row' style=\"border-style:
solid\">";
        print "</FORM>";
        print "</DIV>";
}

then I have another which should insert the record(not working):

function insertnew_row($table,$data){
        $query = "DESCRIBE $table";
        $result = mysql_query($query);

    while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
                 print "<td><b>$row[0]</b></td>\n";
    }
    print $query;
    $result=MYSQL_QUERY("INSERT INTO $table(value) VALUES('".$_POST["data"]."')");
    print $result;

    #print "record added";
    #echo $query; // to show what sent

    } 

then I call the latter from a main page:

if($submit2){ 
     insertnew_row($table,$data);
}

thanks for your help..
sub

[Bunkermaster]

explain what you want to do and what error you get please 🙂

I gather you have a dynamic table update system right? explain how it should work.

[Bunkermaster]

add a or die after all mysql_fetch_*

$result = mysql_query($query) or die(mysql_error().__LINE__);

and give me error

[sub01]

You have an error in your SQL syntax near '' at line 1_LINE_

this for the insert.

thanks,m

[Bunkermaster]

try to put your query on multiple lines like this :

$sql = "INSERT INTO 
$table
(value) 
VALUES('".$_POST["data"]."')";
echo "<!--$sql-->";
$result=MYSQL_QUERY($sql);

then look in commented SQL query and check which line is wrong

[sub01]

this is all I get:

You have an error in your SQL syntax near '' at line 1
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/sub/public_html/lib3.php on line 117

m

[Bunkermaster]

the (value) looks a bit odd to me, can you paste the table definition please?