Hello, I am having some issues inserting and updating with mySQL.
Database: asdf Table: test field: idfield (int, autoincrement) field: test (char) the query: insert into test set test = 'test' ; used in mascon or DBvisualizer correctly inserts the record. however, when used on the webserver, using apache: <? if(!MYSQL_CONNECT("$hostname","$user","$pword")){ echo "Connection Problem."; exit(); } $dbNamec = "asdf"; if(!MYSQL_select_db( "$dbNamec")){ echo "Connection Problem."; exit(); } //Insert Information into Customer Table $query = "Insert into test set test = 'work' ; "; $test = MYSQL_QUERY($query); $query = "select * from test order by idfield desc limit 1"; $result = MYSQL_QUERY($query); $number = MYSQL_NUM_ROWS($result); echo "<br>" . MYSQL_result($result,0,"test") ; ?> it produces no error of any kind, however does not insert the record. the second query sucessfully returns whatever i have manually inserted into the database. both mascon and the web use the same username : webuser why is it that mascon can update the table, but apache cannot ? Thanks for the help, Matthew --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php