I am not very knowledgeable in coding and everything I've learned has been through online tutorials, unfortunately I can't figure this out after months of trying. I'd really really appreciate it if someone could please help me before I go crazy. Thank you so much in advance.
I am trying to make the output of for the new "buy and sell" leads of my site to scroll and pause onmouse over. Below is the code that displays the leads:
<?
$sqlLatestSuppliers = "SELECT FROM all_leads where leadstatus=1 order by LeadAddedDate desc LIMIT 7";
$resultLatestSuppliers = mysql_query($sqlLatestSuppliers, $conn);
if (@mysql_num_rows($resultLatestSuppliers)!=0){
$Latestleadcounter = 0;
while($rowLatestSuppliers = @mysql_fetch_array($resultLatestSuppliers))
{
if($rowLatestSuppliers['LeadType']=="Sell")
{
$getlead = "select from selling_leads, seller where selling_leads.sellingleadstatus=1 and seller.SellerID=selling_leads.SellerID and selling_leads.SellingLeadID=".$rowLatestSuppliers['LeadID'];
$row_getlead=mysql_query($getlead, $conn);
//echo $getlead;
//exit;
$row_LatestLead = @mysql_fetch_array($row_getlead);
?>
<tr
<?
if($Latestleadcounter==1)
{
echo " bgcolor='#ffffff'";
$Latestleadcounter=0;
}
else
{
echo " bgcolor='#EAF2F5'";
$Latestleadcounter=1;
}
?>>
<td> <a href="supplier/selling_lead.php?SellingLeadID=<?=$rowLatestSuppliers['LeadID']?>&SellerID=<?=$row_LatestLead['SellerID']?>&CategoryID=<?=$row_LatestLead['CategoryID']?>" target="_blank"><?= substr($row_LatestLead['Subject'], 0, 30)."..." ?></a></td>
<td align="center"><?=$rowLatestSuppliers['LeadType']?></td>
<td align="center"><?=$row_LatestLead['Country']?></td>
<td align="center"><?=date("m/d/Y",strtotime($rowLatestSuppliers['LeadAddedDate']))?></td>
</tr>
<?
}
else if($rowLatestSuppliers['LeadType']=="Buy")
{
$getlead = "select * from buyer_leads, buyer where buyer.BuyerID=buyer_leads.BuyerID and buyer_leads.buyingleadstatus=1 and buyer_leads.BuyerLeadID=".$rowLatestSuppliers['LeadID'];
$row_getlead=mysql_query($getlead, $conn);
//echo $getlead;
//exit;
$row_LatestLead = @mysql_fetch_array($row_getlead);
?>
<tr
<?
if($Latestleadcounter==1)
{
echo " bgcolor='#ffffff'";
$Latestleadcounter=0;
}
else
{
echo " bgcolor='#EAF2F5'";
$Latestleadcounter=1;
}
?>>
<td> <a href="buyer/buying_lead.php?BuyerLeadID=<?=$rowLatestSuppliers['LeadID']?>&BuyerID=<?=$row_LatestLead['BuyerID']?>&CategoryID=<?=$row_LatestLead['CategoryID']?>" target="_blank"><?= substr($row_LatestLead['Subject'], 0, 30)."..." ?></a></td>
<td align="center"><?=$rowLatestSuppliers['LeadType']?></td>
<td align="center"><?=$row_LatestLead['Country']?></td>
<td align="center"><?=date("m/d/Y",strtotime($rowLatestSuppliers['LeadAddedDate']))?></td>
</tr>
<?
}
}
}
?>
