Toni Barskile wrote:
>
> Thanks for everyone's help w/the error message thing.
>
> I got my SQL statement working, but it's not returning any rows. I noticed
> that there's nothing in my compid field in the 2nd table. Does anyone know
> how I might go about automatically filling in the value in the 2nd table
> when someone enters data in the 1st table? I hope this question makes
> sense...
>
> Toni
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
I don't know what your db exactly is, or what you want to do... but
it pretty much sounds like something for a foreign key. If you don't
like that option, you'll have to change your code (PHP or sp,
wherever you do it) that inserts the data. That function should then
also insert/update the data in the other table.
--
* R&zE:
***************************
** Renze Munnik
**
** E: [EMAIL PROTECTED]
** M: +31 6 218 111 43
***************************
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]