select fra mysql fra php. mysql_fetch_array er tosset
$handle = fopen("prices.txt", "r");writeSQL($handle);
fclose($handle);
function writeSQL($handle)
{
mysql_connect("localhost", "xxxxx", "xxxxxx");
mysql_select_db("xxxxxx") or die(mysql_error());
$ctr=0;
$line="";
while (false !== ($char = fgetc($handle)))
{
if($char=="\n")
{
$values=explode("\t",$line);
if($ctr++>0)
{
$result="";
$values[1]=str_replace(",",".",$values[1]);
$values[2]=str_replace(",",".",$values[2]);
$values[3]=str_replace(",",".",$values[3]);
// $stringsql="INSERT INTO prices(ProductID,Country,ConnFee,PriceDKK_OffPeak,PriceDKK_Peak) VALUES(1,'$values[0]',$values[1],$values[2],$values[3])";
$result="INSERT INTO destinations(DestinationUK) VALUES('$values[0]')";
//echo($stringsql."<br>");
//mysql_query($result) or die(mysql_error());
$result="SELECT DestinationID FROM destinations WHERE DestinationUK='$values[0]'";
echo($result."<br>");
while($row = mysql_fetch_array($result)) {
// $id=$row["DestionationID"];
// echo($id."<br>");
}
//$result="INSERT INTO prices(ProductID,DestinationID,ConnFee,PriceDKK_offPeak,PriceDKK_Peak) VALUES(1,'$id',$values[1],$values[2],$values[3])";
//mysql_query($stringsql1) or die(mysql_error());
}
$line="";
}
else
$line.=$char;
}
echo("insert done");
mysql_close();
}
Den skriver følgende fejl ud:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Group\Apache2\htdocs\prepaid\readPrices.php on line 31
Jeg har kopieret SQL-strengen ind i selve databasen, og der virker den fint. Men ikke fra php. Hvad gør jeg galt?
