ok, Let's suppose your database contains this table:
Table : ad (advertiserID,a dvertiserBanner ,startingDate,f inishingDate)
One way is to list all the ads that contain today's date (if you're changing the advertisement every 24 hours) and then show the resulted records accordingly.
An example query would be:
[CODE=mysql]
select * from ad
where curdate() between startingDate and finishingDate...
AramAz
Last Activity: Mar 30 '08, 09:56 PM
Joined: Nov 27 '07
Location:
-
Thank you very much. That was the last thing I would ever notice. You just made my day.
Regards,
Aram Azhari...Leave a comment:
-
What's wrong with my Procedure?
Hello eveerbody,
I'm trying to make a procedure that will take care of an insertion.
Unfortunately I get an error saying:
"Script line: 5 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END' at line 22"
I searched both on thescripts.com and other website and I can't get the right solution to this problem. It... -
Message Deleted. I didn't notice how old this post was.Leave a comment:
-
Thank you for your reply Plater,
Using a MemoryStream is as fast as using pointers, and it has an advantage:
- It is NOT unsafe code!
As you said, I already found my mistake but I will try to do it in the Memory Stream way and post a similar solution using such.
Regards,
Aram Azhari...Leave a comment:
-
I could, But that would take forever to complete the operation.
C# internal methods of GetPixel() SetPixel() are too slow to be used for image processing. It is more used for getting color of a point or painting which uses a very limited number of pixels.
What we're doing here is a lot of points and a lot of operations on them. For ex, if I have 2 pictures each size of 1024x768, and if I want to swap their blue channel it would take...Leave a comment:
-
Guys I found my problem. I was traversing through the data byte by byte. What I neeeded to do was to traverse pixel by pixel, meaning that I have increment the pointers by 3 and Change the loop to a one-third (before it was LeftB.Width*3 , now it is just LeftB.Width).
[CODE=java]
for (int y = 0; y < LeftB.Height; ++y)
{
for (int x = 0; x < LeftB.Width;...Leave a comment:
-
Bump.
Anyone please ?Leave a comment:
-
C# - APP: Image Processing - Copying channels between two bitmaps
I'm trying to use unsafe mode to do some operations on two different bitmaps.
-I loaded 2 images
-Called my Change method.
- Locked their Bitmap data as bmDataLeft and bmDataRight.
- Doing some operations on BGR channel bits.
The problem is that no operation between them is affected.
First look at my code:
...Code:public static Bitmap Change(Bitmap LeftBitamp,
No activity results to display
Leave a comment: