I have to search a database where all dates are stored in 'hundred year' format (10/27/2007 = 39380). I've looked all over but have not seen a function or any PHP code to do this. Thanks in advance for any help.
I was given the following code by the great JPADIE. It loads column names in an array then displays a checkbox and column name on the form for each occurance. I would like to add a 'reset' button that will remove any check in a box and redisplay the column names and empty boxes. As always...
I've spent 2 hours searching for an answer to what seems to be a simple function so I need the help of experts. I have a mySql table of students in a school. I have a page where I list all students (by default) in the school. In the heading, I have a dropdown which allows the user to select a...
I have a table containing members of a boy's choir. There are 4 types of claases within the choir. My PHP script lists the members fine. I have a field that I want to use to filter the list by whatever choir type the user selects. I fill the dropdown dynamically from a table of choir types...
I have created a function (works fine) that will display a dropdown list of a columns values in a table. I want to create a dynamic sql WHERE clause based on the fields on a form and the values in them. When I place this statement in an empty script the text box works fine...
In the script below I begin with the first checkbox selected. If I check the second box and click the submit button, the parameter list I build does not pick up the second checkbox. Any ideas. Thanks as always for the help.
Scott
<?
$order = "";
if (isset($_POST['first_name']))
$order .=...
My company will be developing a data warehouse (SQLServer) for marketing purposes. Myself and another programmer will be responsible for developing a user interface on the company intranet allowing users to view and analize the data collected. They will also need to enter data into tables.
As...
I have a customer that provided a CD containing pictures of their product. When I double-click a file on the CD the image is opened using 'Windows Picture and Fax Viewer' and looks beautiful. I put the pictues on the website but they look like crap with straight lines appearing wavy, etc. The...
I'm calling a script from my main menu without passing from and to date. The script will use today(from) + 30 days(to) if no date passed. This works fine, here is the code:
<?
$today = Date("Y-m-d");
$from = $_REQUEST["fromd"];
$thru = $_REQUEST["thrud"];
if...
This page shows data with an mySQL select based on a date. The default date is 'today' (and works fine) but the user can change the date via a pop up calendar. I need to have the page reload and execute the SQL select using the new date. The form piece of the script is:
<form...
I've read all the previous threads and hope someone has the definitive answer. I have a window that has 2 vertical frames. If the user clicks the plus(+) sign in the right frame I execute a script that adds a row to a table and displays an 'Updated' message. When the user clicks the 'Return'...
I have a form(1) that opens a popup(1) when a button is clicked. In that popup, the user can click a box with a minus(-) sign that should open another popup(2) which is smaller than popup(1). Problem is popup(2) opens in the same space as popup(1) and doesn't really popup at all. I'm using HTML...
I'm not sure of the best way to approach this application and I'd like a smart way to do it.
I have 2 tables, the first is a parts master list. The second contains equipment and all the parts that go into the equipment.
I'm thinking I want a screen with two frames. The left frame shows the...
I'm trying to get the hang of functions using PHP and JavaScript but I have a problem I can't fix. My HTML for a form starts with:
<html>
<head>
<? include("banner.html");
include("navigate.html");
include("custtitle.html");
require ("function.php")...
When populating my customer entry form I would like the Customer # field set to read only only if I'm not in 'ADD' mode. I use this code to set what script is to call based on my input variable:
if ($key == "**add")
{
$type="addCust.html";
}
else
{...
I suspect this won't be easy. I have a form to enter customers with 10 or so input fields. The form is described as:
<form method=POST action="updCust.html">
and the update button as:
<td><input type="submit" value="Update Customer" name="B1"></td>
This...
I checked FAQ and came up empty so here goes:
I would like a drop down list showing 2 rows from my Customer table(customer number and name). When the user clicks I would like to return only the customer #. I'm using PHP, mySQL and HTML.
Thanks in advance for your help.
Scott
Thanks to all for your help. Going from 20 years of RPG to this is quite a shock. I found nothing in the FAQ so here goes:
I've 2 fields on my page:
<input type="text" name="name" value="<? echo $line2 [Name]; ?>" size="33" tabindex="2" ></td>...
I am creating a website using HTML, PHP and mySQL. I can pass a parameter from 1 page to another using the URL but I don't know how to retrieve it in HTML or PHP. An example of the simpleist method would be great.
Also, I would like to make the column headings of a list page into buttons that...
I have an append query that uses 2 variables found on a form. When I run the query by itself it asks for the variable values and works fine. When I run it in my form nothing happens. Since the query works I won't show that but here is the subroutine that executes it:
Private Sub...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.