Subversion-Projekte lars-tiefland.shop_ns

<?php

        $indexes = array( 2, 3, 4, 5, 6, 7 );

	mysql_connect("localhost","root","voyager");

	mysql_select_db("mediaran_de");

	foreach( $indexes as $index )

	{

	$sql="

	    SELECT

	        id,

	        bild_" . $index . "_url AS bild_url,

	        bildunterschrift_" . $index . " AS bild_unterschrift,

	        bild_position_" . $index . " AS bild_position

	    FROM

	        artikel

	´   WHERE

	        father > 0

	    AND

	        bild_" . $index . "_url <> ''

	";

	$res = mysql_query($sql);

	echo mysql_error()."\n";

	while($row=mysql_fetch_assoc($res))

	{

	    echo "Artikel " . $row["id"] . "\n";

	    $sql_i="

	        INSERT INTO

		    artikel_bild

		SET

		    artikel = " . $row["id"] . ",

		    bild_index = $index,

		    url = '" . mysql_real_escape_string( $row["bild_url"] ) . "',

		    position = '" . mysql_real_escape_string( $row["bild_position"] )."',

		    text = '" . mysql_real_escape_string( $row["bild_unterschrift"] )."'

            ";

	    $res_i = mysql_query( $sql_i );

	    echo mysql_error()."\n";

	}

	}

?>