daveeboi
Last Activity: Oct 5 '07, 02:20 PM
Joined: Oct 2 '07
Location:
-
Oops, sorry I didn't see the adjustment. Just put that in and that has given pagenum an initial value now, when I clicked onto the 2nd page pagenum value was 22!... -
Sorry, I don't understand what you mean with the last post. Could you explain please....Leave a comment:
-
is it possible to use header location command for this purpose? I already have made up html detail pages and would like to use them.Leave a comment:
-
I implemented all of your suggestions yesterday but still couldn't crack the conundrun, my code as is ....
[PHP]<html>
<head>
<html>
<head>
</head>
<body>
<?php
$pagenum = $_GET['pagenum'];
echo"Statement after declare of pagenum";
echo $pagenum;
// Connects to your Database
// have my connection details here...Leave a comment:
-
When I put in this part of test code to see what the variable contained...
[PHP]$pagenum = $_GET['pagenum'];
echo"Statement after declare of pagenum";
echo $pagenum;[/PHP]
it produced the text line but no value what so ever for $pagenum. Any suggestions anybody?Leave a comment:
-
I still haven't conquered this problem, I spent most of the day yesterday and all of last night trying to sort this out but I am totally stumped. I think I'm just going to have to go with just having 1 results page and maybe just links on it to keep it small. Not ideal but at least it will work, unlike the myth that is pagination.Leave a comment:
-
I have put in ...
[PHP]<?php
$pagenum = $_GET['pagenum'];[/PHP]
at the top of my file andfollowed on with...
[PHP]if (!(isset($pagen um)))
{
$pagenum = 1;
}[/PHP]
And I also tested it further done the code with an echo statement to extract the page number. It appeared on first page as expected - yet proceeding page just had an unidentified index message and also printed...Leave a comment:
-
Still having problems with this. Anyone else evr had problems with an "unidentifi ed index" whilst trying to insert pagination?Leave a comment:
-
sorry if I offended you with the last comment but all I am saying is that, to me, the code you advised to put in has the exact same effect as the code I already had. It's just written a different way....Leave a comment:
-
Thanks for the reply but it made no difference just the exact same output!...Leave a comment:
-
It is kind of what I'm aiming for. In my previuos post you were kind enough to help out with also, I had a search form accessing my database to extract all relevent records for criteria. I have a link established for each search output which is..
[code=php]
echo "<div id=\"right\"><i mg src=\"".$info['image']."\"><a href=\"detail.p hp\">".$info['title']."</a></div>\n";...Leave a comment:
-
Paging Problems
When running the script below I am able to get all related table results and display them the way I want. When it came to my paging script I entered and limited the rows per page to 2 (for a 3 record result) I get the first 2 records on page fine, when click through to next I get notices about undefined variables. I really dont understand.
The code is,
[code=php]
<html>
<head>
</head>... -
PHP Detail page help
I have developed a search facility on my site which is now working as intended and produces pages of relevent records from the search. On the resuly pages I have created href links for records that I wish to use to forward users to a detailed html page for their item. I am planning on doing this using adetail.php script where the id will be taken and used to identify the corresponding file. Only problem is I've never done this before do I just... -
Thanks for the help, I eventually got the problem sorted by numbering my drop down list option values, so it must've been to do with that.Leave a comment:
-
Thanks for the title changeand the advice. I put some echo statements throughout my code to see what the variables were just before entering sql statements and all the variables passed should have given results but still give 'No Matches'. I have triple checked that all the names in the sql statements match that of table fields and now I am totally stuck. I really do not know what is wrong with my code at all....Leave a comment:
-
Sorry, that was a previous version of the statement the newest statement is..
("SELECT * FROM search WHERE (price BETWEEN '$min_price' AND '$max_price' AND bedrooms >= '$min_bedrooms' AND location = '$location' AND type = '$property_type ' AND keywords LIKE '%$keywords%') OR
(price BETWEEN '$min_price' AND '$max_price' AND bedrooms >= '$min_bedrooms' AND location = '$location' AND type = '$property_type ') ORDER BY...Leave a comment:
-
MySQL query not returning expected results.
..I have been strugling to get this part of my site working correctly even though I can't see anything wrong with my code. I am trying to search a database and display paged results. But everytime I perform a valid test expecting a few results to appear I am left with the No Matches message, so it's not a coding error as such. The code shown below is what I have for my search.php, please could someone put me out of my misery.
[code=php]... -
MySQL Search problem - help urgently needed...
I have been trying to fix this code for days now but all I get from searching my database table for records that should come up is the no records comment. Could anyone tellme if my MySQL statement is a valid working one or how it can be adjusted. The statement is...
("SELECT * FROM search WHERE (price BETWEEN $min_price AND $max_price AND bedrooms >= $min_bedrooms AND location = '$location' AND type = '$property_type ' AND...
No activity results to display
Leave a comment: