PHP Loop in MYSQL

[dizzy1]

Hi im using phpMyAdmin - 2.11.9.5 and trying to insert into MYSQl using a PHP array:

 

			 	 
					 	foreach( $array as $key => $Value){
						  echo "'".$Value."'";								
							if ($key != $sizeofarray){
								echo ",";
							}
						}								
				 	 )

 

 

Thanks In Advance

DIZZY

[jamesxg1]

Can you elaberate in more detail please.

 

Cheers

 

James.

[dizzy1]

I am trying to loop an array of results into the VALUES of a MySql, and then insert into the DB. I think my syntax is wrong around

 echo "'".{'$Value'}."'";	

 

 

More of the MYSQL Code:

 

$mysql = mysql_query(

" INSERT INTO 'TestTable'
(
foreach( $Array1 as $key => $Value){
	echo $Value;
		if ($key != $SizeOfArray1){
		echo ",";
		}
}

)

VALUES (

foreach( $Array2 as $key => $Value){
 echo "'".{'$Value'}."'";
	if ($key != $SizeOfArray2){
	echo ",";
	}
}
)


");

 

 

 

[premiso]

You are way off on your syntax:

 

<?php
$cols = ""
foreach( $Array1 as $key => $Value){
$cols .= $Value;
if ($key != $SizeOfArray1){
	$cols .= echo ",";
}
}
$vals = ""
foreach( $Array2 as $key => $Value){
$vals .= "'".{'$Value'}."'";
if ($key != $SizeOfArray2){
	$vals .= ",";
}
}
$sql = mysql_query(" INSERT INTO TestTable ($cols) VALUES ($vals)");
?>

 

Notice in the mysql_query statement you had single quotes ( ' ) around TestTable, in MySQL it should be backticks ( ` ) around column names and tables which are really only needed if you are using a reserved word.

 

Questions let me know.[/code]

[dizzy1]

wow i cant believe i didn't think of this, its brilliant. Thanks, i had to add a ; at the end of $cols = "" and $vals = "" but it works perfectly