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
