Help with converting SQL query to Laravel

[ezyweb]

G'day folks!

I'm hoping someone can help me with the correct Laravel structure for the following query ...

UPDATE radreply SET value=(SELECT ip FROM radip WHERE allocated='$username') WHERE value='' AND username='$username'

Your help will be greatly appreciated.

Kerry

[Eduardo G.]

First, check this and this

Then, the easy way:

$ip = Capsule::table('radip')->where("allocated", $username )->value();

Capsule::table('radreply')
    ->where("value", '')
    ->where("username", $username)
    ->update(['value' => $ip]);

Start from there before going into subselect queries

Edited November 2, 2018 by egrueda

[Eduardo G.]

...or you can even make a join between radip and radreply