AW: sub-selects and php

2003-03-28 Thread Udo Schubert
>You did not show us your actual insert statement, but >You can not insert into a table listed anywhere in the select. sorry,man. i should have been given you the whole thing: here it comes: db one with table person (firstname,name,email,phone,fax,hashval,flag,etc...) and table hashvalue (

AW: sub-selects and php

2003-03-28 Thread Udo Schubert
>Does the PHP user have insert authority? grant insert,alter,select on theTable to phpuser; you mean this? php user is the user with whom the php file connects to the db right? i executed every statement from the shell as that user,too! best regards udo -- MySQL General Mailing List