Recent content by scitech

Thanks I knew I would It just that I cannot get it to work

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...

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...

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 =...

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...

Hi Woody The line 16 is the session_start() if(isset($_POST['Search'])) { session_start(); unset ($_SESSION); $_SESSION = $_POST; }

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...

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...

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...

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...

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...

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...

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...

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

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...