$dblink = mysql_connect('localhost','matteo','hotchedda');
mysql_select_db("test");
$resl = mysql_query("SELECT * FROM prefix");
$num1=mysql_num_rows($resl);
$resm = mysql_query("SELECT * FROM name");
$num2=mysql_num_rows($resm);
$random1=rand(1,$num1);
$random2=rand(1,$num2);
$res = mysql_query("SELECT * FROM prefix WHERE id='$random1'");
for ($i = 0 ; $i < mysql_num_rows($res) ; $i++) $newsItems[] = mysql_fetch_object($res);
if (is_array($newsItems)){
for ($i = 0 ; $i < count($newsItems) ; $i++){
echo mysql_error();
echo "";
echo $newsItems[$i]->prefix;
echo "·";
}}
$resk = mysql_query("SELECT * FROM name WHERE id='$random2'"); echo mysql_error();
for ($j = 0 ; $j < mysql_num_rows($resk) ; $j++) $newsItemsk[] = mysql_fetch_object($resk);
if (is_array($newsItemsk)){
for ($i = 0 ; $i < count($newsItemsk) ; $i++){
echo mysql_error();
echo $newsItemsk[$i]->name;
}}
?>
Add a Prefix
| Add a Scientific Field