Dear All,
There is a sample that can't to insert any data ( via variable ) in
MS-SQL :
insert.php:
<form action="save.php" method="post">
<table border="0" align=center>
<input type="text" size="20" name="name" maxlength="8" value="<? echo
$GBName ?>"><br>
Job<input type=text" size="16" name="job"><br>
Subject<input type="text" size="30" name="subject"><br>
<input type="submit" value="SubMit">
</center>
</table>
</form>
save.php:
<a href=view.php">Search data</a>
</body>
</html>
<?
$date=date('Y-m-d H:i:s');
$link = mssql_pconnect("sql","sa","1234");
mssql_select_db("phpbook",$link);
$str = " INSERT INTO staff (name,job,subject)
VALUES('$name','$job','$date','$subject',)";
mssql_query($str,$link);
?>
After insert data by using save.php, I found no any data from the
Database system ( MS-SQL ), but I sure the Database System is no problem
!
So, how can I fix this kind of problem ( Sorry, I'm not familar with php
) ?
Many thank for your help !
Edward.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
