I can... Hard to know why without more info but a starting point would be to turn on the query log in MySQL and see what queries it is receiving.
_________________________________________________ Fraser Stuart Logistics IT 77-85 Phone: +61 2 9335 1235 Roberts Rd Mobile: +61 419 233 732 Greenacre NSW [EMAIL PROTECTED] Australia 2190 www.toll.com.au _________________________________________________ | -----Original Message----- | From: C. Reeve [mailto:[EMAIL PROTECTED]] | Sent: Thursday, 19 December 2002 8:06 AM | To: MySQL List | Subject: MySQL and PHP question | | | Hi, | | Why is it that I can not use two mysql queries in the same PHP | file. I have | tried to do this several times trying to put my site together and have had | nothing but problems. | | The recent one is this: | | I use a SELECT statement to get some info from a table, then I modify that | info and use an UPDATE statement to update another table. The update does | not work (all variables used by PHP contain the proper values as does the | info selected from the table). | | I get no errors as it appears the update worked, but the table was not | updated. | | I have also found that I can not do two select statements in the same PHP | file, as the second one will not contain any data . The query | does not fail, | there is just no data. | | Any info is appreciated. | | TIA | | | | | | --------------------------------------------------------------------- | Before posting, please check: | http://www.mysql.com/manual.php (the manual) | http://lists.mysql.com/ (the list archive) | | To request this thread, e-mail <[EMAIL PROTECTED]> | To unsubscribe, e-mail | <[EMAIL PROTECTED]> | Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php | | --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
