Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by scitech
-
SQL in VB
Thanks I knew I would It just that I cannot get it to work- scitech
- Post #3
- Forum: Microsoft: Access Other topics
-
SQL in VB
I have two joined tables I use a macro to open a form (+ subform) with a filter query the dialog for user input from the first table works fine when I try to add another criteria from the second table to the query another dialog box opens (unexspected)and the query breaks down. The query works...- scitech
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
-
opening form with macro
I have two joined tables I use a macro to open a form with a filter query the dialog for user input from the first table works fine when I try to add another criteria from the second table to the query another dialog box opens (unexspected)and the query breaks down. The query works fine on it's...- scitech
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
-
paginate a search problem
The problem is that when I add a form to start a search the pagination stops working it displays the first page, the correct number of pages but on clicking next page it shows a blank page. The pager class works fine,but when I add if ($_POST['SurName'] ) { $queryItem =... -
pagination problem
Hi woody basically I copied your code straight across, just to see what would happen!. So I have no output before the session_start(). Just the two includes and the $page_name = 'update_form01.php'. I have read that session_start() must come at the very beginning of the page code. So I moved... -
pagination problem
Hi Woody The line 16 is the session_start() if(isset($_POST['Search'])) { session_start(); unset ($_SESSION); $_SESSION = $_POST; } -
pagination problem
Hi Woody Thanks for the Session() code, I've just started looking at Sessions. But I now get these error messages:- Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at c:\Inetpub\wwwroot\sql... -
pagination problem
hi Woody here is my code again, the original problem was that when I ran a query with a result that gave more than one page (from a LIMIT statement in the $query,which I have now removed) only the data for the first page would display. Folowing your advice I have put in some error checking code... -
pagination problem
hi woody All I have done is just change the above code(at the top here) so that the second query was exactly the same as the first,to find some errors, echo'ed both and the first ran fine but the second gave the you have an error....line 2 error. I have looked hard at the $queryItem[] area and... -
pagination problem
hi woody $query1 = "SELECT * FROM Addressbook WHERE ".implode(" AND ", $queryItem) or die(mysql_error()); echo $query1; $query = "SELECT * FROM Addressbook WHERE ".implode(" AND ", $queryItem) or die(mysql_error()); echo $query; If I run the code above as... -
pagination problem
Hi woody $query = "SELECT * FROM Addressbook WHERE ".implode(" AND ", $queryItem)." LIMIT $eu, $limit " or die(mysql_error()); echo $query; when I run this query I get:- SELECT * FROM Addressbook WHERE Surname="Hirschfeld" LIMIT 0,1 or if I leave the input blank I get "you have an... -
pagination problem
hi Woody I don't understand "SELECT * FROM addressbook WHERE ".implode(" AND ",$queryItem)." LIMIT $eu, $limit"; is my query SELECT * FROM Addressbook WHERE Surname='Hirschfeld' LIMIT 0,1 is the echo of the query when I run the query, I might want to search for postcode or firstname not just... -
pagination problem
Hi Woody Here is the echo SELECT * FROM Addressbook WHERE Surname="Hirschfeld" LIMIT 0,1 it all looks fine to me, this query should return more than 1 record, if i want to display two records on the page it does display the two records,but if I display 1 record and then click next all I get is... -
pagination problem
Hi woody Sorry that's my typo here, I have that code version, and I have tryed lots of adding and taking away spaces, for some reason it does not like the Where statement -
pagination problem
Hi Woody The echo $query, gives me the query with the values for the Limit section. My problem is that the code works fine when it is like this "SELECT * FROM addressbook LIMIT $eu, $limit"; It is when I have added the WHERE statement that it only displays the First(as chosen by the variable...
