Re: [MySQL] InnoDB - Updating a parent table won't update the child table

2003-03-18 Thread Heikki Tuuri
March 18, 2003 8:02 AM Subject: [MySQL] InnoDB - Updating a parent table won't update the child table > Hi all, > I created 2 tables in MySQl with the following statements > == > CREATE TABLE employees ( > emp_id INT

[MySQL] InnoDB - Updating a parent table won't update the child table

2003-03-17 Thread Paul Larue
Hi all, I created 2 tables in MySQl with the following statements == CREATE TABLE employees ( emp_id INT NOT NULL AUTO_INCREMENT, emp_last_name TINYTEXT NOT NULL, emp_first_name TINYTEXT NOT NULL, emp_nick_name TINYTEXT

Re: Table won't update

2001-06-12 Thread Thomas Karcher
Hi, > The table sitesats won't update and shows no errors! (even though there are > two instances of echo(mysql_error())) > > > > if (!isset($areview)) { > echo("You must review the site"); } else { > if (!isset($apositive)) { > echo("You must review the site"); } else { > if (!isset($anegati

Re: Table won't update

2001-06-11 Thread Rolf Hopkins
Will the update statement work under the mysql prompt? - Original Message - From: "Vladimir Kravtsov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 12, 2001 8:39 Subject: Table won't update The table sitesats won't update and shows n

Re: Table won't update

2001-06-11 Thread Maurice Aubrey
Here are some ideas for an improved debugging methodology. First, take the query that you think should be working, substitute in hard-coded values, and test it through the mysql command-line client interface. So, for example, run the "update sitesats set..." query and use hard-coded values for $

Table won't update

2001-06-11 Thread Vladimir Kravtsov
The table sitesats won't update and shows no errors! (even though there are two instances of echo(mysql_error())) Any ideas?