assign variable

[Alicia]

Hi guys,

 

I am trying to fit this variable into mysql query as below :

 

mySQL query :

UPDATE `mystore` SET `name` = \'p$rowno"\', `desc` = \'desc$rowno"\' <---- query I wanna edit to get the output I want

 

$rowno = number generated from for loop - i++ => output is 1,2,3 and etc

 

I want to replace p$rowno to $p1, desc$rowno to $desc1 and $p2 and so on when I loop the sql query.. how can I accomplish that ?

 

I tried to use this in the rowno loop :$$p$rowno but failed..

 

sorry if I made you guys confuse.. in short, i want the output to be something like this {'$desc'."$rowno"} <- i know this syntax is wrong.. please advise how to write a correct one..

 

thanks.

 

[MadTechie]

i think you mean this

$query = "UPDATE `mystore` SET `name` = \'p".$rowno."\', `desc` = \'desc".$rowno."\' ";
//OR
$query = "UPDATE `mystore` SET `name` = \'p{$rowno}\', `desc` = \'desc{$rowno}\' ";

[PFMaBiSmAd]

Single-quotes are not escaped in a query when they denote string data. They are only escaped when they exist inside of data.

[MadTechie]

LOL, good point, the sad thing is that was the first thing i noticed when i look but overlooked on the reply

 

update:

$query = "UPDATE `mystore` SET `name` = 'p".$rowno."', `desc` = 'desc".$rowno."' ";
//OR
$query = "UPDATE `mystore` SET `name` = 'p{$rowno}', `desc` = 'desc{$rowno}' ";

[Alicia]

but the output that I want in the sql query is something like $p1, $desc1, $p2, $desc2 and so on... how can I combine these two in the query?

[MadTechie]

this would make so much more sense as an array, however..try this

 

$query = "UPDATE `mystore` SET `name` = '${p{$rowno}}', `desc` = '${desc{$rowno}}' ";

 

untested