协助我竞标网站 [英] Help me with the bidding site

问题描述

朋友，我需要一个投标网站，因为我有一个投标栏，我希望每当一个项目的任何投标增加该项目的价格时，换句话说，我想在"NO_OF_BIDS"中提及该项目的投标数量

Friends I need help with bidding site as i have a bidding column and i want that when ever any one bid on a project it increments for that project, in others words wants to mention number of bids on a project in "NO_OF_BIDS" column for specific project.

推荐答案

首先，您必须维护带有bid列的数据库表.

喜欢

Hi,

First you''ve to maintain database table with bid column.

like

<br />
 Table name:ProjectsTab<br />
  Columns:pid,pname,bidcnt,......<br />

在上表中，您可以指定特定项目的投标数.

如果用户点击完成了出价过程，则您必须增加数据库中的Dib计数

使用sql查询

In the above table you can specify bid count on specific project.

whn user click completes bid process you''ve to increase that dib count in database

with sql query

 create proc increbidcnt(@pid int)
as begin
declare @tmp=0;
@tmp=select bid from ProjectsTab where pid=@pid;
 update ProjectsTab set bidcnt=@tmp+1 where pid=@pid
end

这里''我只是给出想法而不仅仅是确切的代码.

一旦您有了清楚的主意，就可以尝试使用自己的代码.

最好的

Here ''m giving just idea only not exact code .

once you get clear idea then you can try in your own code.

All the Best

我认为您可以借助数据库来做到这一点.创建一个具有ID，ProjectID，Bids的表.因此，当有人竞标时检查ProjectID是否匹配，如果匹配，则增加指定项目的``投标''列的竞标计数.增加出价计数后，将其显示在您的页面中.

I think you can do this with a help of a database. Create a table with ID, ProjectID, Bids. So when someone bids check if the ProjectID matches and if it does, increase the bid count of the specified project Bids'' column. After increasing the bid count display it in your page.

这篇关于协助我竞标网站的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！