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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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
This code displays the first record in the limit query but when I click "next", the page is updated but no record is displayed.All the bits of code work independently, but now that I have got them together!!! classic problem. No error message is displayed. <?PHP include 'config.php'; include... -
display one row at a time
What I want to do is display the results of a query one at a time with a "button click" to move/display to the next row. i have been trying to use mysql_fetch_array, with a break to the loop. I have found many next/previous methods too complicated for me to understand so cannot adapt. Is there a... -
Update not working!
I'm trying to pass search results to text bxes in a form, which I can then change and then update the database. I cannot see where my error is! It is when I try to update that it goes wrong error message:- You have an error in your SQL syntax; check the manual that corresponds to your MySQL... -
Does not like mysql_fetch........
I'm trying to create an address book, search the table from a form either OR, AND whatever but why does this script not work? the error is in the fetch_array function, how can I fix this? <?PHP include 'config.php'; include 'opendb.php'; ?> <form method="POST" action="<?php echo... -
SET or Values?
I'm learning slowly but I cannot see why this code does not insert into the database, The page loads fine no errors at all, should I be useing VALUES? but thats not what's in the Tutorial I'm useing <html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type"... -
MYSQL/SQLite
I cannot connect to mySQL ( I have tryed and tryed what is the correct syntax?) ,phpinfo() gives support for SQLite but not MySQL, is this what the problem is? -
Mysql connection in XP
Just got XP and downloaded MySql, got them and dwmx up and running, DWeaver won't let me connect to the mysql stuff at all :- http error code 405 method not allowed I can get sql through the command line, it seems to be running in the services panel, as far as I can see all my paths etc are... -
CSS sizing for resolution
Is it possible to use %(percentage) for sizing of <div>'s so that resolutions all just fill the screen? Faq 215-4537 thanks BlindPete, gives some script that switches on resolution size to another CSS style page, but as I'm lazy and only want to maintain one style page, as this solution is a...- scitech
- Thread
- Replies: 13
- Forum: HTML, XHTML & CSS
