MSSQL and PHP

[tejwa206]

Hello all I am attempting to write an update form for a customer table all seems fairly simple except the fact the query does nothing (no errors returned nothing) when I return to the record all data is still the same.

All other basic functionality works (search engine and adding records)

Here is the code scope for updating

mssql_connect("server01","username","pwd")
or die ("FAILED: " .mssql_get_last_message());

mssql_select_db('cust')
or die ("FAILED: " .mssql_get_last_message());

// sql update query
mssql_query("UPDATE cust
set contact_name = '$contact_name',
address = '$address',
company = '$company',
phone = '$phone',
city = '$city',
vol = '$units',
state = '$state',
email = '$email',
zip = '$zip',
serial_number = '$serial_number'
WHERE co_id = '$co_id';
")
or die ("Query Failed: " .mssql_get_last_message());

When I do the query in SQL Analyzer everything works.

Any ideas? Thanks in advance..

[tejwa206]

Actually now the updates work. A minor mistake.

Now the problem is

Everytime I go to the original page to lookup my changes to the record "nothing comes up". However doing a direct query reveals everything is indeed in tact from the update but the search page is unable to find the new record or any records... Any ideas?

[tejwa206]

Ok... So everything is working except the fact that when php does an update to SQL server it adds wierd block looking characters to the database table record I have updated.

Why does PHP do that?