Upgrading PHP + MySQL

2007-10-23 Thread David Zentgraf
Hi, I have a CentOS 3 server that I need to update to MySQL 5 + PHP4. I downloaded and installed the MySQL client and server RPM packages for Red Hat 3, including the Shared Compatibility Libraries which provide /usr/lib/libmysqlclient.so.10, .12, .14 and .15, which seems to be the recomm

Restrict inserts to meet certain conditions?

2007-09-29 Thread David Zentgraf
Hi, Is it possible to restrict Inserts and Updates to meet certain conditions? In one of my tables lets say field A, B and C can be NULL, but not all at once. Depending on what type of item I want to store, A needs to be NULL, but B and C need values, for other types A needs a value but B