RE: [PHP] Prev/Next
| From: | Maxim Maletsky | Date: | Mon, 16 Oct 2000 10:07:26 +0000 |
| Subject: | RE: [PHP] Prev/Next | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-20326@lists.php.net to get a copy of this message | ||
line 28:
echo '.$script_name.'?view='.($limit_low-$limit).';
you don't need to escape anything with single quotes (except for another
single quotes.(logic isn't it?)).
See now if works..
BTW, not only line 28, there are two calles, see the next ouput... you have
the same error twice...
-----Original Message-----
From: Website4S@aol.com [mailto:Website4S@aol.com]
Sent: Monday, October 16, 2000 6:58 PM
To: Maxim Maletsky
Subject: Re: [PHP] Prev/Next
Hi Well I converted what you sent into this:
<TABLE BORDER="1"
WIDTH="2000"><tr><TH>Delete_User</TH><TH>Surname</TH><TH>
First Name</TH><TH>Street Address</TH><TH>Street
Address2</TH><TH>City
</TH><TH>State / County</TH><TH>Country</TH><TH>Zip / Postal
Code</TH><TH>
Phone Number</TH><TH>Email Address</th><th>Billing Street
Address</th><th>
Billing Street Address2</th><th>Billing City</th><th>Billing State / County
</th><th>Billing Country</th><th>Billing Zip / Post
Code</th><th>Username
</th></tr>
<?php
$host="localhost";
$user="";
$passwd="";
$dbase="";
$Selstmt = "SELECT * FROM Member order by Surname";
$dbh=mysql_connect($host, $user, $passwd);
$query=mysql_db_query($dbase, $Selstmt);
$num_rows=mysql_num_rows($query);
$limit = 7;
if(!$view) $view = 0;
$limit_low = $view;
$limit_high = $view+$limit;
$query .=" LIMIT $limit_low,$limit";
for ($i=0; $i<$num_rows; $i++)
{
mysql_data_seek($query, $i);
$array=mysql_fetch_array($query);
printf("<tr><td><form method=post action='deluser.php3'><input
type='submit'
name='deleteuser' value='delete'><input type=hidden name=ID
value='%s'></form><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td
>
%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td
>
%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>",
$array["ID"],
$array["Surname"], $array["Fname"], $array["Address"],
$array["Address2"],
$array["City"], $array["State"], $array["Country"],
$array["Zip"],
$array["Phone"], $array["Email"], $array["BAddress"],
$array["BAddress2"],
$array["BCity"], $array["BState"], $array["BCountry"],
$array["BZip"],
$array["User"]);
}
echo '<TR><TD><CENTER>';
if($limit_low >= $limit)
{
echo '.$script_name.'/?view='.($limit_low-$limit).'; //
Line 28
}
echo ' ';
if($num > ($view+$limit))
{
echo '.$script_name.'/?view='.$limit_high.';
}
echo '</CENTER></TD></TR>';
mysql_close();
?>
</TABLE>
And it gives out a parse error on line 28, any ideas what this could be or
have I interpreted what you sent in the wrong way?
Cheers
Ade