₦airaland Forum

hi i want to update two columns at once in auctions table one column hold the productname d other the productimage, have tried selecting each one at a time but not liking it, any assistance, thanks

skyhighweb:
hi i want to update two columns at once in auctions table one column hold the productname d other the productimage, have tried selecting each one at a time but not liking it, any assistance, thanks

mysql ?

Donald3d:
mysql ?

yes

update table set col1=val1, col2=val2 where ......
You should be able to find this on google though.

i retrieve data from here

table name column data in it

sports team_id 1
teams nike
team_image nikeimmagelogo

and place inside here

table column data in it

auctions
team1 nike
team1_image nikeimmagelogo

plz note

teams = team1

while team_image = team1_image

and this the query i use to fill team1

// team1
$query = "SELECT team_id, team_image, teams FROM " . $DBPrefix . "sports";
$db->query($query, $params);
$TPL_team1_list = '<select name="team1">' . "\n";
while ($row = $db->fetch())
{
$selected = ($row['teams'] == $team1) ? 'selected="true"' : '';
$TPL_team1_list .= "\t" . '<option value="' . $row['teams'] . '" ' . $selected . '>' . $row['teams'] . '</option>' . "\n";
}
$TPL_team1_list .= '</select>' . "\n";



and this the query i use to fill team1_image

// team1_image
$query = "SELECT team_id, team_image, teams FROM " . $DBPrefix . "sports";
$db->query($query, $params);
$TPL_team1_image_list = '<select name="team1_image">' . "\n";
while ($row = $db->fetch())
{
$selected = ($row['team_image'] == $team1_image) ? 'selected="true"' : '';
$TPL_team1_image_list .= "\t" . '<option value="' . $row['team_image'] . '" ' . $selected . '>' . $row['teams'] . '</option>' . "\n";
}
$TPL_team1_image_list .= '</select>' . "\n";


i have to fill two form to manually insert both team1 and team1_image

i need both query to be just one so when i select team1, team1_image automattically get attached and inserted hope u understand what am saying.

Let me get home will help out

cbrass:
Let me get home will help out

ok thanks

I slept off when I got home yesterday, I looked through your code but I don't see where you are doing the update

skyhighweb:
ok thanks

wait i really need to know why you want to update the second table , the reason i asked is after going through your sql queries i cant find any WHERE CLAUSE so why do you really want to create two tables instead of a single table

cbrass:
wait i really need to know why you want to update the second table , the reason i asked is after going through your sql queries i cant find any WHERE CLAUSE so why do you really want to create two tables instead of a single table

theres already two tables only one get updated with the name but its image doesnt get updated

skyhighweb:
theres already two tables only one get updated with the name but its image doesnt get updated

OK you want the image column on the second table to update abi?

cbrass:
OK you want the image column on the second table to update abi?

yes, the query only update one table at a time i want it to update two tables at a time

skyhighweb:
yes, the query only update one table at a time i want it to update two tables at a time

well i think this concept should work

select from table source
while loop
{

Update table 1
update table 2
}

this will definitely work

with the way your code is , only one table will be updated, follow the pattern i did and you are fine

cbrass:
well i think this concept should work

select from table source
while loop
{

Update table 1
update table 2
}
?
this will definitely work

with the way your code is , only one table will be updated, follow the pattern i did and you are fine

can u include that for me in the code given? so i don't beat around d bush


table1 is team1
table 2 is team1_image

cbrass solution will work for you , inside the while loop, do the second db query.

webdeveloperqx:
cbrass solution will work for you , inside the while loop, do the second db query.

plz from the code given above alter it for me thanks

skyhighweb:
can u include that for me in the code given? so i don't beat around d bush


table1 is team1
table 2 is team1_image

ok brb

skyhighweb:
can u include that for me in the code given? so i don't beat around d bush


table1 is team1
table 2 is team1_image

try this it should work , though i didn't test it ,



$query = "SELECT team_id, team_image, teams FROM " . $DBPrefix . "sports";
$db->query($query, $params);
$TPL_team1_list = '<select name="team1">' . "\n";
while ($row = $db->fetch())
{
$selected = ($row['teams'] == $team1) ? 'selected="true"' : '';
$TPL_team1_list .= "\t" . '<option value="' . $row['teams'] . '" ' . $selected . '>' . $row['teams'] . '</option>' . "\n";
$selected = ($row['team_image'] == $team1_image) ? 'selected="true"' : '';
$TPL_team1_image_list .= "\t" . '<option value="' . $row['team_image'] . '" ' . $selected . '>' . $row['teams'] . '</option>' . "\n";
}
$TPL_team1_list .= '</select>' . "\n";
$TPL_team1_image_list .= '</select>' . "\n";

cbrass:
try this it should work , though i didn't test it ,



$query = "SELECT team_id, team_image, teams FROM " . $DBPrefix . "sports";
$db->query($query, $params);
$TPL_team1_list = '<select name="team1">' . "\n";
while ($row = $db->fetch())
{
$selected = ($row['teams'] == $team1) ? 'selected="true"' : '';
$TPL_team1_list .= "\t" . '<option value="' . $row['teams'] . '" ' . $selected . '>' . $row['teams'] . '</option>' . "\n";
$selected = ($row['team_image'] == $team1_image) ? 'selected="true"' : '';
$TPL_team1_image_list .= "\t" . '<option value="' . $row['team_image'] . '" ' . $selected . '>' . $row['teams'] . '</option>' . "\n";
}
$TPL_team1_list .= '</select>' . "\n";
$TPL_team1_image_list .= '</select>' . "\n";

didnt work almost the same with what i got

skyhighweb:
didnt work almost the same with what i got

Wait Did u write this code your self before?

and i also told you earlier that this code will not update your table in the db,

cbrass:
Wait Did u write this code your self before?

and i also told you earlier that this code will not update your table in the db,

Yeah it update it only update one table at a time

skyhighweb:
Yeah it update it only update one table at a time

If you wrote it your self then follow the example I gave you earlier, that will solve the issue you are having

cbrass:
If you wrote it your self then follow the example I gave you earlier, that will solve the issue you are having

ok have figure it out had to rewrite the codes again now working