struggling here...with a table lookup....

[mjeaves]

Hello there,

Hope someone can help.

I have data arriving in a table, a Cron job is triggered when the data arrives.

----
table_1

id (unique)
name
message
author_id (this is the field i need to collect the data from another table)
---

One of the fields in the 'table_1' table needs to call data from the 'user' table where the data in author_id (table_1) and id (user) is an exact match...., the user table contains some of the following example fields:

----
user

id (unique) - THIS IS THE FIELD I NEED TO GET INTO THE 'author_id' field of table_1
name
age
etc
___

Looking around, I think I need to use preg_match, but am struggling

Any support/advice most welcome, I'm new to this forum :-)

[ronverdonk]

One of the fields in the 'table_1' table needs to call data from the 'user' table where the data in author_id (table_1) and id (user) is an exact match....,

I don't really understand what you mean by the above, such as "needs to call data", so please explain a bit more. Do you want to match the 2 columns in the 2 tables, like

SELECT * FROM table_1, user WHERE author_id = id

or are you looking for a different sort of match?

Ronald :cool:

[mjeaves]

I don't really understand what you mean by the above, such as "needs to call data", so please explain a bit more. Do you want to match the 2 columns in the 2 tables, like

SELECT * FROM table_1, user WHERE author_id = id

or are you looking for a different sort of match?

Ronald :cool:

Hi Ronald, thanks very much for getting back to me.

I need to make a lookup and store the 'id' field in the 'user' table into the 'author_id' field within 'table_1' so the data can be associated to the user where an exact match is made.

For example: the following data exists in the User table:

---
user

id (unique) - 10202
name - Colin
age - 23
etc - likes chips
___

and a new message is submitted which arrives in a new table, and automatically triggers a cron job...

the data arrives containing the following

----
table_1

id - 002
name - colin
message - i thought the film was great that i watched tonight
author_id - ??????
---

The data is looked up to match 'Colin' in 'table_1' with 'colin' in the 'user' table and a copy of 'id' in the 'user' table is entered into the 'author_id' field in 'table 1'

In a nutshell, this is an attempt for people to be able to post without logging in, they simply enter their username and comment into a form, which then looks up and associates the newly created record to the employees record.

This is for a very small internal company system.

Thanks for any help....