Posts by maydhyam

Pasta is my favorite food...

Do you like chocolate?

It started off with him wanting to see if he can fly Very high...since he got wings and all...and ended up with him being on the other side...:)

I don't know jbennet personally, but I have seen his avatar around alot...so I say 6

488

mad = (http://define.com/mad) Excited beyond self-control or the restraint of reason; inflamed by violent or uncontrollable desire, passion, or appetite; as, to be mad with terror, lust, or hatred; mad against political reform.

-1023

your entry should have been -1025

-1026

nice

step mom --> wicked

we journey through

Cool...I'll try that way...I'll keep you posted...

I will research on it. Thanks much...
:)

Hi Ezzarel,

I changed this part of the project from Java to PHP (which is a lot more convenient).
Thanks alot for the help though...
:)

Hi Nav33n,

I followed your advice and I got it to work. Thanks alot...
:)

I got the problem sorted out...honestly I did not do anything to it...what happened is that a technician came and installed the cd/dvd writer on the machine, I started the machine and loaded dreamweaver (like I do every morning) but dreamweaver said that it was reloading the cache...I didn't know that needed to happen!!! anyways, when I typed in the date in the format mysql has it stored (I was trying it without the calendar), it worked perfectly...so I tried using the calendar (with the date format syntax in the mysql syntax) and it didn't work....so i started hunting online for a calendar to enter the date in the format that mysql stores the date...and presto! i got 1, and now my caledar works like a charm...

Hello Everyone,

Scenario:
I have an application where users are required to register to gain access. I want to set an 'automatic timer' on their access so that after 1 month, their access level is set to NULL (which would not allow them to log into the application).

Question:

1. Can this be done in PHP?
2. If it can, could you guide me as to what is needed to do this?

Thanks Much
May

mail

plants
stay
ions

company

fade

Speedy Gonzales is not my name...:D

Have you ever been bitten by a snake?

:D:D:D
No

Have you ever seen a tornado...in real?

Haven't tried it...

Chai Tea?

Grandpa, who took the poodle and started to jump rope when all of a sudden he...

I vote for government in Trinidad...not USA...

Have you ever been involved in an accident?

Xbox 360

Coca Cola or Pepsi?

The pain was

leap
palm
sale

design

Hi kkeith29,

Thanks so much, it works now...I did try using the &&, but not !==, and since that didn't work, I posted it here...thanks again...:)

May

Hi All,

Could you help/guide me accordingly please...My intentions with this piece of code is for the relevant image to display with the respective user...my problem is that it doesn't work for the second user type (SysAdmin), it only works for 'Admin'...

<tr>
				
				
				
					<td width="255">
					<?
						if($arr[6] != 'Admin' || $arr[6] != 'SysAdmin') 
						{
					?>
						<div align="center"><img src="images/bill.png" alt="Bill" /></div>
					<?						
						}
						else						
						{
					?>
						<div align="center"><a href="underConstruction.php"><img src="images/bill.png" alt="Bill" /></a></div>					
					<?	
						}
					?>
					</td>
</tr>

May

It started off CW...took a while before looking CCW for me...

not a straight question,but if ur developing ur first site then
1.go to google search free template and choose one
2. made little changes like color, image etc.
3. put your contain in it its ready to upload on internet.

I think he meant http://www.shortsurvey.here.ws/

Long ago a friend of mine had a casette tape with their songs, and I really liked it...but I don't know the name of the tape nor the songs:(

Do you play any sport?

reality

phone

At least you could access it at work...it's totaly blocked here where I work!! :(

house

flats or apartment?
place to live..

Hi R0bb0b,

I echoed my $query and this is how it looks:

SELECT * FROM tsttbills where DATE_FORMAT(billDate, '%b-%e-%Y') between 'Nov-1-2007' and 'Nov-9-2007'

When I copied this query and pasted it into the MySQL Query Browser and ran it, I got the entire table of data displaying...

It's a French dish, sort of like a pie with cheese, eggs, onions, spinach and so on. Can taste real good.

It sounds yummy.....:)
I have to try and make it...will let you all know how it taste.....
:):):)

I've been to St. Croix several times -- I even lived there for a while working as a radio DJ.

Do you follow politics?

Cool...I live in Trinidad...

Politics is like a bitter lemon, I stay away from it...:D

Do you listen to Linkin Park?

Hello R0bb0b,

I was able to remove the testGCR.php code from the results page and I tested it with the following data:

• Start Date = Nov-1-2007
  End Date = Nov-1-2007
  I got all the records with the billDate = Nov-1-2007
  
• Start Date = Nov-2-2007
  End Date = Nov-2-2007
  I got all the records with the billDate = Nov-2-2007
  
• Start Date = Nov-1-2007
  End Date = Nov-9-2007
  I did not get all the records with the billDate between the start and end date stated above, instead I got all the data from the table...

Here is my sql query:

$query = "SELECT * FROM tsttbills where DATE_FORMAT(billDate, '%b-%e-%Y') between '$sDate' and '$eDate'";

That clip was sooooo boring, I had to stop it after a few seconds. The woman narriating that has a more boring voice than whats-his-name on tv who looks a lot like Henry Kissenger.

I agree, with you, she really was boring...not good for selling the equipment though, but the euipment is very useful as my yard also has alot of slopes, and can be really difficult to cut after the rain falls (the ground becomes water logged, and we can slip and fall easily)

2 slices of white bread, with a slice of avocado, a sprinkle of salt, and a cup of lipton tea with sugar no milk...

:-/ I have never tasted quiche...

In a world without walls and fences, who needs windows and gates?

Strange?!? :-/ ...I'm just editing my script with the changes you said to, and saving it in the folder on the server...and running it on the browser...I selected the dates from the pop-up calender, and click the generate button...that's all...

i have now added the ob_end_flush(); line at the end of the testGCR.php script, as well as set the code to only echo the data found, not to download it into the .csv...let me run that and let you know...

__________________________________________________________________________________
In my output, I am seeing the form as well as the results...can't figure out why, but still looking

Computer programmers do it byte by byte.

Hi R0bb0b,

Firstly, let me thank you for all that you've done till now, I am truely grateful for your guidance.... :)

Now the problem at hand:
I made the necessary changes and it works to an extent...here are the outcomes:

1. When I select the dates: Nov-1-2007 and Nov-9-2007, I am getting all the records in the table (which is wrong) but when I select the dates: Nov-1-2007 and Nov-1-2007, I get the records for that date only. :confused:
   
2. When I save the .csv file, I cannot open it in a MS Excel (this was working earlier on in this thread), I am getting a file is corrupt message, but the .csv file can only open in notepad/any text application. :confused:
   
3. The .csv file not only has the records from the table but also the entire code from the testGCR.php file. :confused:

If I am not mistaken, some of these problems we got before (earlier on in this thread), because that was the reason behind the change of the billDate data-type etc.

:confused: :confused: :confused:

2 questions though...

1. why did you use the ob_start()?
2. and why didn't you use the ob_end_flush()?

May

.
.
.
	include('./connect.php');
	global $conn;
			
	// Start our query of the database 
	$query = "SELECT * FROM tsttbills where DATE_FORMAT(billDate, '%b-%e-%Y') >= '$sDate' and DATE_FORMAT(billDate, '%b-%e-%Y') <= '$eDate'";
			
	$sql = mysql_query($query, $conn);	
	//echo $sql;
	echo $query . "<br /><br />" . mysql_num_rows($sql) or die("Error: ".mysql_error());					
.
.
.

the result displayed is 1

but the connection script works properly for all the other parts of the application...

Here is the code....and still nothing shows...

.
.
.
	include('./connect.php');
                global $conn;
			
	// Start our query of the database 
	$query = "SELECT * FROM tsttbills where DATE_FORMAT(billDate, '%b-%e-%Y') >= '$sDate' and DATE_FORMAT(billDate, '%b-%e-%Y') <= '$eDate'";
			
	$sql = mysql_query($query, $conn) or die("Error: ".mysql_error());	
	echo $sql;
.
.
.

I have those 2 statements already...and it doesn't echo anything...