all of the information you people have given to me is great and useful,
however, I still have no comprehension as to how to make the conditional
"html" setup for the pages. my attempt is as thus:
#getdata.pl
--------
globals:
$PageLimit = "0";
$PageNumber = "1";
--------
open db:
$DSN = "DBI:mysql:database=mydb";
--------------
connect to db:
my $dbh = DBI->connect($DSN, "user", "passwd" ) || &PrintError;
------------------
grab data from db-table to fill declarations-:
$sth = $dbh->prepare(qq{SELECT P.PartNumber, P.AlternatePartNumber,
P.Description, P.Quantity, P.Condition, S.CompanyName, S.Seller_ID,
P.Part_ID, S.Note FROM table1 as P, table2 as S WHERE P.Seller_ID =
S.Seller_ID AND ( P.AlternatePartNumber like "%$PartialPartNumber%" OR
P.PartNumber like "%$PartialPartNumber%" ) ORDER BY P.PartNumber LIMIT
$PageLimit,20 }) || die $dbh->errstr;
print "<form name=Form4 action=/cgi-bin/submit.pl method=post>\n";
return 1;
print "<input type=hidden name=pagenumber value=$PageNumber>\n";
print "<input type=hidden name=partialnmbrsrch
value=$PartialPartNumber>\n";
print "<input type=submit value=\"Save Items for RFQ\">\n";
print "<input type=reset value=Reset>\n";
print "<form action=/cgi-bin/getdata.pl method=post>\n";
print " <script language=javascript>\n";
print " document.write <a
href='/cgi-bin/Search.pl?PageLimit=$PageNumber+20'>Next Page</a>\n";
$sth->execute() || die $dbh->errstr;
while ( ($ref = $sth->fetchrow_hashref() )) {
---------------------------------------
$sth->finish();
$dbh->disconnect || warn $dbh->errstr;
i hope this is what you need to help me? i had to piece this together, hope
it makes sense to you guys
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
