Best practise

[DangerM0use]

Hello all.

 

I'm just wondering what the best practise for this code is. I have several queries and I don't know whether it is best to have a seperate query for each one or to have one main query. Here is the code;

 

$file=file_get_contents("mydata.txt"); //read entire file into a string
$query=explode(";",$file); //breaks the sting into an array
foreach($query as $value) { //loops through the SQL statements
mysql_query($value); //execute the statements
}

mysql_query('update wes_ica_8 SET sss = (sss * 0.90)'); //change the value of column sss - decreasing by 10%
$query = "select * from wes_ica_8 LEFT JOIN wes_tut_f ON wes_ica_8.id = wes_tut_f.id";
$result = mysql_query($query);
while ( $row = mysql_fetch_array($result))
{
extract($row);
echo"$id: $dinosaur: $id: $fat<br>)";
}

mysql_close(); //close SQL connection
echo "DONE"; //confirmation text

 

Thanks

[DangerM0use]

Can anybody give me any info??

[haku]

What exactly is it that you want to do? Its hard to tell you anything without that info.