Quote:
|
Originally Posted by monkeylick
Looking for some help (paid if need be)....
I have an access database, it contains 4 columns.
Column "A" is simply 1-10000 in numerical order.
Column "B" is a 5 digit number
Column "C" is a 5 digit number
Column "D" is a 5 digit number
Here's what needs to happen...
User inputs column "B" into a text box.
User is given the information in Columns "C" and "D"
Important that user cannot see all 10000 codes. He must input B and receive the corresponding C and D.
I need to put this on a linux server so not sure if I need mysql? maybe javascript?
Any ideas or help is appreciated. I'm looking to get this fixed within the week. If this is "up your alley" ...contact me and we'll work out a deal.
Thanks!
|
Do you mean you have MS ACCESS database?
In Linux you need MySQL you can create the same database and table
create database mydatabase;
create table mytable (
A INT NOT NULL AUTO_INCREMENT,
B INT,
C INT,
D INT,
PRIMARY KEY(A)
);
then you can use user input to find the correct record
$sql="select * from mytable where B=$inputnumber;
$db_link=mysql_connect($hostname, $dbuser, $dbpassword)
or die("Unable to connect to the server!");
mysql_select_db($dbname)
or die("Unable to connect to the database");
$result=mysql_query($sql);
$num_row=mysql_numrows($result);
if($num_row !=0)
{
$row=mysql_fetch_row($result);
$A=$row[0];
$B=$row[1];
$C=$row[2];
$d=$row[3];
echo "A: ".$A.", B:".$B." , C:".$C." , D:">$D;
}
Please visit http://www.configure-all.com and find code examples you need
Good Luck |
