Hi every body,
I got error while retrieving data from Mysql.
Can you please help me!
1)
I did not created any DSN,but I have given "localhost" as DSN;
2)
my login name as "gopi",password as "test";
3)Parse error: parse error in c:\program files\apache group\apache\htdocs\mysqlex2.php on line 4
Programme is:
<body>
<?php
mysql_pconnect ("localhost","gopi", "test") {
or die ("Could not connect");
}
mysql_select_db ("gopi") {
or die ("Could not select database");
}
$query = "SELECT name, salary FROM employee";
$result = mysql_query ($query) {
or die ("Query failed");
}
fetch rows in reverse order
for ($i = mysql_num_rows ($result) - 1; $i >=0; $i--) {
if (!mysql_data_seek ($result, $i)) {
printf ("Cannot seek to row %d\n", $i);
continue;
}
if(!($row = mysql_fetch_object ($result)))
continue;
printf ("%s %i<BR>\n", $row->name, $row->salary);
}
mysql_free_result ($result);
?>
</body>
Thank you,
Leela
