[Solved] I need to join two tables in php [closed]

Question

This code did not suddenly stop working, it never could have worked with its present query syntax. Change the query to this –

$q2 = $pdo -> prepare('INSERT INTO allbets (user, bet, komanda, teams, cof, data, image) VALUES ($user, $bet, $komanda, $teams, $cof, $data, (SELECT `users2`.`image` FROM `users2` WHERE `username` = ?));

Do yourself a service and error checking to your PHP code and to your PDO. This will let you know where to look when errors occur.

Accepted Answer

This code did not suddenly stop working, it never could have worked with its present query syntax. Change the query to this –

$q2 = $pdo -> prepare('INSERT INTO allbets (user, bet, komanda, teams, cof, data, image) VALUES ($user, $bet, $komanda, $teams, $cof, $data, (SELECT `users2`.`image` FROM `users2` WHERE `username` = ?));

Do yourself a service and error checking to your PHP code and to your PDO. This will let you know where to look when errors occur.