when i need to get information from the mysql server i use this code
Code: Select all
$hostname = "localhost";
$database = "mydatabse";
$username = "root";
$password = "root";
$mysqlconnect = mysql_connect($hostname, $username, $password) or die(mysql_error());
mysql_select_db($database, $mysqlconnect );
$query_flists1 = "SELECT * FROM mytable WHERE sy_bab = '1' ORDER BY sy_publish DESC, sy_seq Desc LIMIT 0,6";
$flists1 = mysql_query($query_flists1, $mysqlconnect ) or die(mysql_error());
$row_flists1 = mysql_fetch_assoc($flists1);
$totalRows_flists1 = mysql_num_rows($flists1);
< display the result >
mysql_free_result($flists1);and if i have use pconnect insted of connect to i have also to use
mysql_close($mysqlconnect)
and i don;t use the close
what will happend with a 500 000 hit per day
feyd | Please use
Code: Select all
andCode: Select all
tags where approriate when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]