appreciate any help.
Code: Select all
$lttr = 'b';
$perpage = 10;
$q = mysql_query("select count(Name) from hotels_csv where Name LIKE '$lttr%' ") ;
$row = mysql_fetch_array($q);
$pages = ($row[0] + $perpage - 1) / $perpage;
for ($i = 0; $i <= $pages-1; $i++) {
$start= $i;
$start*= 10;
$numb=$i+1;
$db = mysql_connect('localhost', 'root', '');
mysql_select_db('hotel',$db);
$sql = "SELECT Name,Adress,Phone FROM hotels_csv where Name LIKE '$lttr%' order by name limit $start,10 ";
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$header='<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>Hotels</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Style-Type" content="text/css" />
<link href="style.css" rel="stylesheet" type="text/css" />
<link href="layout.css" rel="stylesheet" type="text/css" />
<style type="text/css">
.search_img {behavior:url(iepngfix.htc);}
</style></head>
<body id="page7">
<div id="main">
<div id="border">
<!-- header -->
<div id="header">
<div><!--Valid flash version 8.0-->
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,24"
width="766" height="474">
<param name="movie" value="flash/header_v8.swf?button=5" />
<param name="quality" value="high" />
<param name="menu" value="false" />
<param name="wmode" value="opaque" />
<!--[if !IE]> <-->
<object data="flash/header_v8.swf?button=5"
width="766" height="474" type="application/x-shockwave-flash">
<param name="quality" value="high" />
<param name="menu" value="false" />
<param name="wmode" value="opaque" />
<param name="pluginurl" value="http://www.macromedia.com/go/getflashplayer" />
FAIL (the browser should render some flash content, not this).
</object>
<!--> <![endif]-->
</object></div></div>
<!-- content -->
<div id="content">
<div class="row_2">;
$page="";
while($data = mysql_fetch_assoc($req))
{
$input='<h5>'.$data['Name'].'</h5><p> '.$data['Adress'].'<br /> '.$data['Phone'].'<div class="title_block" style="height: 16px"><img alt="" src="images/7page_title1.gif" /></div>' ;
$page=$page." ".$input;
}
if ($i==0){
$ourFileName = 'index-'.$lttr.'.html';
}
else{
$ourFileName = 'index-'.$lttr.'-'.$i.'.html';
}
$file = fopen($ourFileName, 'w') or die("can't open file");
$page=$header.$page.$link.'<a href="index-'.$lttr.'.html">1</a> | <a href="index-'.$lttr.'-1.html">2</a> | <a href="index-'.$lttr.'-2.html">3</a> | <a href="index-'.$lttr.'-3.html">4</a> | <a href="index-'.$lttr.'-4.html">5</a> | <a href="index-'.$lttr.'-5.html">6</a> | <a href="index-'.$lttr.'-6.html">7</a> | <a href="index-'.$lttr.'-7.html">8</a> | <a href="index-'.$lttr.'-8.html">9</a> | <a href="index-'.$lttr.'-9.html">10</a> | <a href="index-'.$lttr.'-10.html">11</a> | <a href="index-'.$lttr.'-11.html">12</a>
</div></div></div>
<!-- footer -->
<div id="footer">
</div></div></div></body></html>';
fwrite($file,$page);
fclose($file);
mysql_close();
}