29-01-2005, 14:11
|
|
|
חבר מתאריך: 09.03.04
הודעות: 27
|
|
התקנתי והפקודות
התקנתי והפקודות שהשתמשתי בהם הן:
<?php
$mysql_link=mysql_connect('localhost','root','pav1 47')
or die("ERROR: cannot connect to MySQL server.");
echo "connected successfully to MySQL server.";
mysql_close($mysql_link);
if (mysql_select_db('test',$mysql_link))
echo "DB selected.";
else
echo "Could not select the DB.";
$result=mysql_query("SELECT * FROM members",$mysql_link);
$result=mysql_query("SELECT id,name FROM players WHERE age>=18");
if (!$result)
echo "ERROR: error occured in MySQL query.";
else //if the query was ok...
{
while ($row=mysql_fetch_array($result))
echo $row['name']." (".$row['id'].") is over 18.<BR>\n";
}
?>
|