[thelist] Mysql - wont read first entry?
Anthony Baratta
Anthony at Baratta.com
Tue Oct 31 10:49:10 CST 2000
Adrian....
I'm unclear with your code if you are using Perl or PHP. It looks Perlish enough, so
here's how I would do it:
$db_query = "SELECT docId, docCat, docBusName, docAddress, docBusPhone, ";
$db_query .= "docDesc1, docDesc2, docDesc3, docState, docRegion, ";
$db_query .= "docSuburb, docHits FROM tblDockets WHERE ";
$db_query .= "docCat = '" . sqlEncode($form{'CATEGORY'})
$db_query .= "' AND docState='" . sqlEncode($form{'STATE'})
$db_query .= "' ORDER BY docSuburb";
my $db = &dbconnect;
my $dbh=$db->prepare($db_query);
$varReturnResult = $dbh->execute();
if ($varReturnResult)
{
while (($docid, $category, $busname, $address, $phone, $desc1,
$desc2,$desc3,$state,$region,$suburb,$hits) = $dbh->fetchrow_array())
{
@{$tempitemhash{$docid}} = ($docid, $category, $busname, $address, $phone,
$desc1,$desc2,$desc3,$state,$region,$suburb,$hits);
push (@itemorder, $docid);
}
}
YMMV
--
Anthony Baratta
President
KeyBoard Jockeys
South Park Speaks Version 3 is here!!!
http://www.baratta.com/southpark
Powered by Tsunami
More information about the thelist
mailing list