没有分是不是就不给帮忙啊，

liuxiabao 2003-08-07 11:02:25

愿意帮忙的就请给我指明错误吧
下面那两个有@的函数好像是有问题的

<?php
require_once('main1.php');
?>
<?php
show_title("浏览记录");
//$hostname='localhost';
//$username='liuxiabao';
//$password='19811225';
//$link_id=@mysql_connect($hostname,$username,$password);

$dbname="liuxiabao";
$tablename="msg_board";
$num_to_show=5;

mysql_select_db($dbname);
$sort_field=$arr_request['sort_field'];
$sort_direction=$arr_request['sort_direction'];
$sort_record=intval($arr_request['init_record']);

$str_sql="select * form $tablename where flag_deleted='N' ";
$num_records=@mysql_num_rows(mysql_db_query($dbname,$str_sql));
//上面那个有@的函数那部分有问题
if(!$sort_field) {
$sort_field='key_msg_board';
$sort_direction='ASC';
}
$str_sql.="order by $sort_field $sort_direction";
$str_sql.="limit $init_record, $num_to_show";

$fields=mysql_list_fields($dbname,$tablename);
$num_fields=mysql_num_fields($fields);
$result=mysql_db_query($dbname,$str_sql);

show_msg($tablename."中现有".$num_records."条记录:");
echo('<table border=2 ><tr>');
for($i=0; $i<$num_fields; $i++) {
$field=mysql_field_name($fields,$i);
if($field !='flag_deleted') {
echo("<th>$field<br>");
$link_order="sort_field=$field & sort_direction=ASC";
echo("<a href=\"$PHP_SELF?$link_order\">升序</a>");
echo(" ");
$link_order="sort_field=$field&sort_direction=DESC";
echo("<a href=\"$PHP_SELF?$link_order\">降序</a>");
echo("</br></th>");
}
}
echo("<th>操作</th>");
echo("</tr>");
for($i=0; $i<$num_to_show; $i++) {
echo("<tr>");
$record=@mysql_fetch_object($result);
//上面那个有@的函数那部分有问题
for($j=0; $j<$num_fields; $j++) {
$field=mysql_field_name($fields,$j);
if($field !='flag_deleted') echo('<td>'.$record->$field.'</td>');
}
echo("<td>");
$link_order="action=update&key_msg_board=$record->key_msg_board";
echo("<a href=\"13.php?$link_order\">修改</a>");
echo(" ");
$link_order="action=deleted&key_msg_board=$record->key_msg_board";
echo("<a href=\"13.php?$link_order\">删除</a>");
echo("</td>");
echo("</tr>");
}
echo('</table>');

$prev_record=$init_record-$num_to_show;
if($prev_record<0) {
$prev_record=0;
}
$next_record=$init_record+$num_to_show;
if($next_record>$num_records) {
$next_record=$num_records;
}
echo('<br>');
$link_order="init_record=$prev_record&sort_field=$sort_field&sort_direction=$sort_direction";
echo("<a href=\"$PHP_SELF?$link_order\">上一页</a>");
echo(" ");
$link_order="init_record=$next_record$sort_field=$sort_field&sort_direction=$sort_direction";
echo("<a href=\"$PHP_SELF?$link_order\">下一页</a>");
echo(" ");
$link_order="action=insert";
echo"<a href=\"13.php?$link_order\">插入记录</a>";
echo"</br>";
show_foot();
?>

愿意帮忙的就请给我指明错误吧

...全文