<?php
include ('/home/david/mysqldata.php');
$handle = mysql_connect ("127.0.0.1", $MYSQL_NAME, $MYSQL_PASSWORD);
mysql_select_db ("mytest", $handle);
$result = mysql_query ("SELECT * FROM ABC", $handle);
if (mysql_num_rows ($result) == 32) {
for ($i = 0; $i < 1024-32; $i++) {
$r = rand () % 4;
mysql_query ("INSERT INTO ABC VALUES ('" . rand ()%12 . "','" . rand ()%12 . "','" . $r . "')", $handle);
mysql_query ("INSERT INTO DEF VALUES ('" . rand ()%12 . "','" . rand ()%12 . "','" . $r . "')", $handle);
mysql_query ("INSERT INTO HIJ VALUES ('" . rand ()%12 . "','" . rand ()%12 . "','" . $r . "')", $handle);
//mysql_query ("INSERT INTO results VALUES ('" . rand ()%4 . "')", $handle);
}
}
$result = mysql_query ("SELECT * FROM ABC WHERE ABC.r01 = 3", $handle);
while ($row = mysql_fetch_row ($result))
echo $row [0] . " " . $row [1] . "<br>\n";
mysql_close ($handle);
?>