PHP - Previous and Next Links

Codewalkers Forums Sponsor:

Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

August 22nd, 2005, 04:47 AM

aryashahin

Join Date: Apr 2007

Posts: 1

Time spent in forums: < 1 sec
Reputation Power: 0

PHP - Previous and Next Links

hi guys...
ok... before i start just letting you know I am new to whole php/sql thing..
now i am developing my web site
>. http://www.maxdesings.5gigs.com
I am gona have lots of tuts ...
therefore i need to have page browser ( prev 6 7 8 9 10 next )
================
now i been following the tuts on this site...
http://codewalkers.com/tutorials/4/1.html

PHP - Previous and Next Links by Matt Wade
but I do get this message when i view my page
========================
Warning: mysql_query(): Access denied for user: 'maxdesig@localhost' (Using password: NO) in /home/maxdesig/public_html/tutorials/photography/index.php on line 16

Warning: mysql_query(): A link to the server could not be established in /home/maxdesig/public_html/tutorials/photography/index.php on line 16

Warning: mysql_query(): Access denied for user: 'maxdesig@localhost' (Using password: NO) in /home/maxdesig/public_html/tutorials/photography/index.php on line 22

Warning: mysql_query(): A link to the server could not be established in /home/maxdesig/public_html/tutorials/photography/index.php on line 22

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/maxdesig/public_html/tutorials/photography/index.php on line 23

=======================here is the code===============

php Code:

Original - php Code

 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="tut.css" rel="stylesheet" type="text/css">
</head>
 
<body>
 
<?php
if(!isset($start)) $start = 0;
 
$query = "SELECT * FROM table LIMIT " . $start . ", 10";
//do database connection
$result = mysql_query($query); //you should do error checking
//display data
 
//this code was wrong, I did not have the second query. Thanks to Plaggy Pig.
// need another query to get the total amount of rows in our table
$query = "SELECT count(*) as count FROM table"; 
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$numrows = $row['count'];
if($start > 0) 
   echo "<a href="" . $PHP_SELF . "?start=" . ($start - 10) . 
        "">Previous</a><BR>n";
if($numrows > ($start + 10)) 
   echo "<a href="" . $PHP_SELF . "?start=" . ($start + 10) . 
        "">Next</a><BR>n";
?> 
 
 
</body>
</html>

=====================

What am i doing wrong.??
if its database... could you please guide me through it???!!!
tanx

August 22nd, 2005, 07:25 AM

Milo

Join Date: Apr 2007

Location: Italy

Posts: 192

Time spent in forums: < 1 sec
Reputation Power: 2

RE: PHP - Previous and Next Links

The problem shoud be here :
Warning: mysql_query(): Access denied for user: 'maxdesig@localhost' (Using password: NO) in /home/maxdesig/public_html/tutorials/photography/index.php on line 16

If your user that connects to db has a login and a password when it says USING PASSWORD NO means that the function has no password to supply on connection to the db. Check the syntax and the spell of the variables u use in the connection.

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: