How to update one table with values from another table

Asked Apr 01 '20 at 10:59

Active Apr 01 '20 at 20:27

Viewed 22 times

I have a table1 with user-information and a table2 with posts made by the users. Sometimes (and only sometimes) it happens that a post is created in Table2 without the user's postal code. I need to find the posts where the ex postal code is missing and then update them with the postal code from table1. In both tables I can use 'email' for reference. The first part is easy with:

if ($stmt = $mysqli->prepare("SELECT` email` FROM `ads` WHERE` postal_code` = '0' "))     {     
$stmt->execute();
$stmt->bind_result($email); 
while($stmt->fetch())
{
// here I would like to do the postal code update,  but it won't do         
}     
$stmt->close();
}

How do I get on with the second part of the project: updating the current record in Table2 "?

edited Apr 01 '20 at 20:27

Dharman

30,962
25
85
135

asked Apr 01 '20 at 10:59

riefart

What part is unclear for you: how to select the user info based on email or how to update the post? – Your Common Sense Apr 01 '20 at 11:15
The second part: How do I update the current record in Table2 with values from Table1? I can search for the postal code in table1 via email which I retrieved in table2. – riefart Apr 01 '20 at 12:10
Just a regular UPDATE query. What's the problem with it? – Your Common Sense Apr 01 '20 at 12:33
I first have to get the postal code by searching via email and then do update. I don't really know how the update-string should look like in php. – riefart Apr 01 '20 at 14:20
So the question is how to do an UPDATE query with mysqli? Here you go: https://phpdelusions.net/mysqli_examples/update – Your Common Sense Apr 01 '20 at 14:21
I know how to make an update, but value must be extracted from another table. That's where the problem lies. – riefart Apr 01 '20 at 15:04
But you kust said you can do a SELECT query that would "extract" any required value. So I just don't get it what the problem is – Your Common Sense Apr 01 '20 at 15:09
I have solved the problem – riefart Apr 01 '20 at 15:42

How to update one table with values from another table

0 Answers0