Help building a query string (MySQL)

[KirkLogan]

I am unsure as to the best way to do this. 
 

I am building a query using the following loop:

 

for($i=0;$i<count($data); $i++) {
	$query .= "'{$fileop[$i]}', ";
}

 

My problem is, at this point in the loop, I do NOT want $fileop to output its contents (it is not even defined yet).

Rather i need $fileop to display exactly as is, so that the variable name is stored in the string rather than its value at this point in time. I do however want the value of $i to output within the brackets. 

 

I suppose what im asking is, is there a way to nullify store $fileop within a string so that I can call it later (within another loop) and have it actually reference the value when the query is called?

 

(or maybe im just ass backwards here and should take a different approach to this whole section)

[requinix]

Can't you just move the loop down to a point where $fileop has its values?

[KirkLogan]

I considered that but i run into problems as i will be using the query within a while loop to import .CSV file rows into a database. 

[Barand]

perhaps

 

 

<?php
for($i=0;$i<count($data); $i++) {
    $query .= "\$fileop[$i], ";
}
?>

[KirkLogan]

Thank you sir! That is exactly what I needed. 

[requinix]

There's also prepared statements to consider, which would actually be perfect for this.

[KirkLogan]

Prepared statements? Do you have a good reference so i can read about this?

[teynon]

http://lmgtfy.com/?q=PHP+prepared+statements

 

Jessica, sorry to steal your thunder. Seemed appropriate.

[requinix]

  On 3/5/2013 at 2:25 AM, teynon said:

http://lmgtfy.com/?q=PHP+prepared+statements

 

Jessica, sorry to steal your thunder. Seemed appropriate.