- Joined
- Mar 26, 2012
- Messages
- 1,465
- Reaction score
- 131
PHP:
$hostname="SERVERNAME\SQLEXPRESS";
$dbname="User";
$username='SERVERNAME';
$password='MYPASSWORD';
$first_bind = $conn->prepare("UPDATE Account SET Birthday = '23-01-1978 00:00:00' WHERE UserID = 'test'");
$update = $first_bind->execute;
When I run this script manually in SQL Server the database updates so I assume it is something to do with php. Anyhow the issue is that everything else updates with no problems but, the datetime field will not update or even insert into the database. Any suggestions would be greatly appreciated.