haibec

Hi,Write a dynamic query in a loop that Itrates 1 to 5000.append the loop index to the query like 'user' + i, user random function to generate the randon password.If you need exact code let me know.Hope this helps.Good LuckHemendra Singh ShaktawatMindfire Solutionswww.mindfiresolutions.com

Hi guys!I have two table User includes field ID,username and Infor includes field ID,Gold . I want make a trigger : add 1000 gold for users have ID>=10 . PLease help me.!

Hi...!I have table User includes fields : username, password,name. I want insert concurent 5000 user have username from user1 to user5000 and password is values random . Please help me .!

You can use % (mod operator) to see if a number is odd or even.if ($no % 2 != 0)echo "odd";elseecho "even";Probably you can also use (but it's a little harder to understand):if ($no & 1)echo "odd";elseecho "even";

Try this:SELECT COUNT(DISTINCT(users.ID)) AS num FROM users, orders WHERE users.ID=orders.ID AND orders.ID>=500The field you will get back will be called "num", and should contain the number of users who have bought at least one product with a price at least 500.

I don't understand, could you rephrase that?

do you really have that many visitors that you need to run your site on two different servers? i'm not sure if this is what you want really but here it is. <?php$rand = mt_rand(1,2);if($rand == "1") { //redirect to other server}else{ //stay at this server}?>you will have to fill in the if statements with how you want to redirect the user.

Hi Guys!I have two table Member includes : ID , Name and Product includes ID,ProductID,Name,Price . Both table related by ID . Make stuation : with a Member only buy maximum are 3 product . I want query exact amount member have Product and Price >=500$

read this http://www.west-wind.com/presentations/loa...Windows2003.asp

Hi Guys!I have 2 webserver running PHP . I want make a code : With User have a number access is a odd number then that user will redirect to webserver1. If user have a number access is a even number then that user will redirect to webserver2. help me

Hi Guys!I have two Webserver installed Apache , My Website has Coded by PHP . My server running Windown 2003 Standard. I want design my webserver to follow LoadBlancing . Please help me.

Hi Guys!I have problem : I have Table User with fields : ID, NAME, LEVEL,ID_LOT1,ID_LOT2,ID_LOT3 . I my Table User, With field LEVEL has values : 0,1,2,....,1x,2x,3x... I want make a procedure use to give an award for members . With members have LEVEL = 1x (11,12,...19) will insert are values into ID_LOT1 , With members have LEVEL = 2x will insert are values into ID_LOT1,ID_LOT2 (with this member will two ID_LOT),....with member have LEVEL=3x will insert are values into ID_LOT1,ID_LOT2,ID_LOT3 . After i want make a procedure LOTTERY run random all ID_LOT and choice are values random. ! Very difficul for me, Help me

Well, still assuming this is MS SQL Server or Access, and depending on what you want to do with the result, you can say something like (Access syntax this time):

SELECT  [Level], COUNT(*) AS NumUsersAtLevel FROM User WHERE ([Level] BETWEEN 1 AND n) AND (Lastlogout BETWEEN #18 Aug 2006# AND #20 Aug 2006#)GROUP BY [Level]ORDER BY [Level]

Well, if this is MS SQL Server you can say something like:

SELECT * FROM User WHERE (Level BETWEEN 1 AND n) AND (Lastlogout BETWEEN '18 Aug 2006' AND '20 Aug 2006')

what kind of project...can you be more specific

Hi Guys!I have a table User includes : ID, Level, Lastlogout . I want create a function have mission : Scan all user from level 1 to level N already logout in space time : Example : from 08/18/2006 to 08/20/2006 . Please help me!

Hello Haibec,Wrox have a good starter auction website coded in ASP. You can download code from their book, Beginning ASP 3.0, at the following address: http://media.wiley.com/product_ancillary/3...AD/3382Ch15.zipHope this helps!

What? You aren't making any sense?ASp.Net is free to download and install the framework.Are you looking for source code to projects or what?

Please tell me about some pages has source code about Auction ! Thank all

I have two Table : Student include field : ID ,NAme,classs an a Table :Point include ID ,Point, name,class . I want when Update a table ,exemple : Student then The table Point so-so updated!Please help me

That's not what I was asking when I said "what's the problem". I understand what you want to fix. I said that if the email uses the default address for the server (mailer.daemon@domain.com or something like that) then Yahoo might junk it. So the solution is to make sure that your emails have a legitimate email address as the 'from' address. Maybe I'm having a hard time understanding you, but then you seemed to ask "how do I set the from address to be a default address" and I replied with "you set the address". Do you not know how to set the from address when you send an email?You should probably paste your code that sends the email.

Well.. I guess a solution would be to always set the from address. What's the problem?

Make sure you set the from address. If the from address defaults to the sendmail agent on the server, it will probably get blocked.

Please tell me about websites have code free ASP.Net. Thank

Hi Guy!I have register.asp i use ASPEMail send email active their account . But with Yahoo that email not in INBOX in addition in to BULK ( Yahoo check it is spam) . Please help me . I want it send in to INBOX. hu...hu..huu