select

$sql="query strings";
$result=mysql_query($sql);
$row=mysql_num_rows($result);

if($rows==0){
die;
}
else{
while($row=myswl_fetch_array($result)){
$a1=$row["field name1"];
$a2=$row["field name2"];
}

insert data

$con=mysql_connect ("localhost", "id", "ps") or die ('I cannot connect to the database because: ' . mysql_error());
print ("connection is seccuess");

mysql_select_db('worloka3_test');
$last_name = addslashes($_POST['last_name']);
$first_name = addslashes($_POST['first_name']);
$age = addslashes($_POST['age']);

$sql = << INSERT INTO member
(
last_name,
first_name,
age
)
VALUES
(
'$last_name',
'$first_name',
$age
)
EOS;

print "

".$sql;
$result = mysql_query($sql);

print "
".$result;

mysql_close($con);
?>

charactor code

windows -> SHIFT JIS
PHP -> EUC-JP

connect to sql by php

$con=mysql_connect ("localhost", "your id", "your ps") or die ('I cannot connect to the database because: ' . mysql_error());
print ("connection is seccuess");
mysql_close($con);
?>