Posts by maydhyam

We Are Microsoft
Resistance is futile!
YOU WILL BE ASSIMILATED

I just saw this video which is a concept for a future browser. What do you think about it?

Sorry, but I can't view it as it's streaming...
but I came across this concept and thought it looked really cool...

I think the problem lies here

$sql = mysql_query($query, $conn);

it doesn't echo anything, but if I remove the $conn, I get the "Resource ID#6" error being displayed...:confused: :confused: :confused:

I added it here:

.
.
.
			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 $query . "<br /><br />" . mysql_num_rows($sql);	
.
.
.

and this is the result:

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

*sigh*...ok, so I looked over the syntax in the db manager program, and I realized that I actually copied it twice and then tried to execute that...:$ :icon_redface: :$

It works, and I am getting the 10072 records returned...

here is the error message:

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 'SELECT * FROM tsttbills where DATE_FORMAT(billDate, '%b-%e-%Y') >= 'Nov-1-2007' ' at line 1

Error No. 1064

In my DB Manager.......you mean MySQL Query Browser?

if that's what you mean.....then here is the error message:

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 'SELECT * FROM tsttbills where DATE_FORMAT(billDate, '%b-%e-%Y') >= 'Nov-1-2007' ' at line 1

Error No. 1064

Did that and I am still getting:

Result:

Er....well, I changed this:

my input box on the form

<a href="javascript:NewCal('sDate','[U]mmmddyyyy[/U]')"><img src="images/cal.gif" width="16" height="16" border="0" alt="Pick a Start Date"></a>

and echo statement:

echo "SELECT * FROM tsttbills where DATE_FORMAT(billDate, [U]'%b-%e-%Y'[/U]) >= '" . $_POST['sDate'] . "' and DATE_FORMAT(billDate, [U]'%b-%e-%Y'[/U]) <= '" . $_POST['eDate'] . "'";

result:

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

I have done what you said to, and here is the result:

SELECT * FROM tsttbills where DATE_FORMAT(billDate, '%e-%m-%Y') >= '11-1-2007' and DATE_FORMAT(billDate, '%e-%m-%Y') <= '11-1-2007'

that is what was echoed...

I am having a cup of coffee...

Really, then you are in for a treat. It's a movie.

Cool, I'll look for it...thanks

I have never seen it...what station/network is it on?

yes i did, this is what I see after clicking the generate button...

Result:

why does it matter how old i am? i've worked in plenty of business, and to be honest, nothing in that "memo" was true for any place i've worked.

Well I think you are very lucky to be able to work in places where the memo doesn't apply...(I am not being sarcastic), I actually know a couple of people who work in places like that, but I also know a whole lot more people who work in places where the memo definitely applies.....so, it sorta applies to some persons, as well as it doesn't apply to others...

I have been reading this thread, and was wondering what can I tell flaco....from a girl's perspective....I was left by my ex-boyfriend...I didn't know he left until I thought it was strange...he stopped communicating with me completely, and when I confronted him about it, he responded as though we never had any relationship...he was my first boyfriend, and we were going out for 5 years...

There is a proverb: "Beauty is in the eye of the beholder" - It basically means that the only thing that should matter about a person is their personality. Not what they look like. Just because they are "beautiful" on the outside doesn't mean they are on the inside; it's the way they behave. To find their inner beauty, you can just hang out together, get to know the person, and let the person get to know you...and just remember, if they hurt you again, just look them in their face and smile, if you can...thank them for getting to know them, and leave, because you know that they would be missing out on knowing a great person like you! I have done that with my ex, and since then I feel much better about myself...

I thought it was funny, and rather applicable in some instances where I currently work... I also found this 1 to be really applicable too...

Here is the competition:
NOTICE:
PLEASE NOTICE!!!!!

You may have noticed the increased amount of notices for you
to notice. And, we have noticed that some of our notices have
not been noticed. This is very noticeable. It has been noticed
that the responses to the notices have been noticeably
unnoticeable. Therefore, this notice is to remind you to notice
the notices and to respond to the notices because we do not want
the notices to go unnoticed.

From the Notice Committee for Noticing Notices

So this is my changed chunk of code:

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

and nothing shows for the result...

Why don't you post your code, then we may be able to assist...

replace echo $sql;
with echo $query;

Here is the output:

SELECT * FROM tsttbills where DATE_FORMAT(billDate, '%e-%m-%Y') >= '1-11-2007' and DATE_FORMAT(billDate, '%e-%m-%Y') <= '1-11-2007'

trend
tour
send

Reincarnation

sports car

IE or Firefox?

care

No

Did you ever own a black & white tv set?

Benevolent beaver's without their offspring stopped spanking New Zealand polices therefore failed to annex Australia.

understand their dilemma

coin
inside
send

smattering

Dogs??? Can't live without them...:D

Have you ever been to the Caribbean?

spirit
tally
spill

tarpaulin

Motherland

PHP or Java?

animals.

4605

Nice find!

Does anyone still listen to the radio?

Alot of my friends, family, myself included still do...

I commented off most of the code for it to echo the sql...here is the edited code:

.
.
.
			function parseCSVComments($comments) 
			{ 
				// First off escape all " and make them "" 
				$comments = str_replace('"', '""', $comments); 
				if(eregi(",", $comments) or eregi("\n", $comments)) 
				{ // Check if I have any commas or new lines 
				return '"'.$comments.'"'; // If I have new lines or commas escape them 
				} 
				else 
				{ 
					return $comments; // If no new lines or commas just return the value 
				} 
			} 
			
			// Start our query of the database 
			$query = "SELECT * FROM tsttbills where DATE_FORMAT(billDate, '%e-%m-%Y') >= '$sDate' and DATE_FORMAT(billDate, '%e-%m-%Y') <= '$eDate'";
			
			$sql = mysql_query($query, $conn);			
			 
			echo $sql;
			/*
			$numberFields = mysql_num_fields($sql); // Find out how many fields we are fetching 
			
			if($numberFields) 
			{ // Check if we need to output anything 
				for($i=0; $i<$numberFields; $i++) 
				{ 
					// Create the headers for each column, this is the field name in the database 
					$head[] = mysql_field_name($sql, $i); 
				} 
				$headers = join(',', $head)."\n"; // Make our first row in the CSV 
			
				//while($info = mysql_fetch_object($sql)) 
				//{ 	
					//print_r($info);	
					//echo "<br />";
				//}
				
				while($info = mysql_fetch_object($sql)) 
				{ 
					foreach($head as $fieldName) 
					{ // Loop through the array of headers as we fetch the data 
						$row[] = parseCSVComments($info->$fieldName); 
					} // End loop 
					$data .= join(',', $row)."\n"; // Create a new row of data and append it to the last row 
					$row = ''; // Clear the contents of the $row variable to start a new row 
				} 
				
				// Start our output of the CSV …

When I echoed the query statement, I am getting a runtime error on the browser, and all the browser windows closed after...here is the code:

gcrFunction.php

<?
include('./connect.php');

error_reporting(E_ALL ^ E_NOTICE);

function validateData()
{
	global $conn;
	
	$sDate=$_POST['sDate'];
	$eDate=$_POST['eDate'];
	//echo $sDate;
	//echo $eDate;

	$btn=$_POST['btnSubmit'];
		
	if(isset($btn))
	{				
		if(!$sDate)
		{
			echo '<center><font face=Verdana color=Red size="2"><b>Start Date field is empty!</b></font></center></td>
				  </tr><tr bgcolor="#ffffff"><td>
				  <table width="760" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#FFFFFf">
				  <tr><td width="760" bgcolor="#336666" scope="col">&nbsp;</td></tr></table></td></tr><tr bgcolor="#ffffFF">
				  <td><p align="center" class="style30 style4" >&copy;ITT Department. </p></td></tr></table>';
			die("Problem 1");
		}
		else if(!$eDate)
		{
			echo '<center><font face=Verdana color=Red size="2"><b>End Date field is empty!</b></font></center></td>
				  </tr><tr bgcolor="#ffffff"><td>
				  <table width="760" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#FFFFFf">
				  <tr><td width="760" bgcolor="#336666" scope="col">&nbsp;</td></tr></table></td></tr><tr bgcolor="#ffffFF">
				  <td><p align="center" class="style30 style4" >&copy;ITT Department. </p></td></tr></table>';
			die("Problem 2");
		}
		else
		{
			
			function parseCSVComments($comments) 
			{ 
				// First off escape all " and make them "" 
				$comments = str_replace('"', '""', $comments); 
				if(eregi(",", $comments) or eregi("\n", $comments)) 
				{ // Check if I have any commas or new lines 
				return '"'.$comments.'"'; // If I have new lines or commas escape them 
				} 
				else 
				{ 
					return $comments; // If no new lines or commas just return the value 
				} 
			} 
			
			// Start our query of the database 
			$query = "SELECT * FROM tsttbills where DATE_FORMAT(billDate, '%e-%m-%Y') >= '$sDate' and DATE_FORMAT(billDate, '%e-%m-%Y') <= '$eDate'";
			
			echo $query;			
			
			$sql = mysql_query($query, $conn);			
			 
			//echo $sql;
			
			$numberFields = mysql_num_fields($sql); // Find out how many fields we are fetching 
			
			if($numberFields) 
			{ // Check if we need to output anything 
				for($i=0; $i<$numberFields; $i++) 
				{ 
					// Create the headers for each column, this …

Actually, he is.
When the questions get specific, it becomes very difficult to keep track of which poster asked which question, hence the rule:"Do not piggyback threads (aka "hijack" threads) by posting your question as a reply to another question."

Oho, I see...thank you hughv for the reminder...hmmm...oh well...moving along...
:)

I know it has a built-in video card, but for what I want to do, the built-in looks like crap (sorry if it isn't) but thanks :)
And I will start a new thread

Hi,

Actually you are not hijacking a thread, this thread is all about how to build a computer...all are welcome...everyone can learn from everyone here...so you can keep on...

Maydhyam

That's why whenever you are looking at videos online it has to buffer before playing....the buffering is the download to the temporary folder...

very happily typing

I would like to think yes, you can download through a Proxy Server (I have been able to download stuff here in the office...and it's through the server), as well as it is definitely easier to track what you are downloading, when you downloaded it, how much bandwidth you used...

I am still getting the entire table of data, and the data within the dates selected...

And you thought you were having a bad day!!!

A guy is sitting at the bar just staring at his drink for half an hour when this big trouble-making biker steps next to him, grabs his drink, gulps it down in one swig and then turns to the guy with a menacing stare as if to say, 'What'cha gonna do about it?'

The poor little guy starts crying.

'Come on man I was just giving you a hard time,' the biker says. 'I didn't think you'd CRY.' 'I can't stand to see a man crying.'

'This is the worst day of my life,' says the little guy between sobs. 'I can't do anything right. I overslept and was late to an important meeting, so my boss fired me. When I went to the parking lot, I found my car was stolen and I don't have any insurance.

I left my wallet in the cab I took home.

I found my wife in bed with the gardener and my dog bit me.

So, I came to this bar trying to work up the courage to put an end to my life, and then you show up and drink the poison.'

The following is the description of a software application for download.....

Network Packet Analyzer CAPSA is an advanced network traffic monitoring, analysis and reporting tool, based on Windows operating systems. It captures and analyzes all traffic transport over both Ethernet and WLAN networks and decodes all major TCP/IP and application protocols. Its advanced application analysis modules allows you to view and log key communication applications such as emails, http traffic, instant messages and DNS querries. The powerful filtering module allows you to focus on the information that you are looking for. The comprehensive reports and graphic views enable you to understand network performance and bandwidth usage quickly, to check network health and identify problems in a few simple steps.

It's amazing how easy it is to obtain these types of applications...

Wow, that was superb, I am feeling much more enlightened now...ok, so I'll get a pricesheet and begin to put together a list of parts...I am so excited...:)

Hey Major Major,

Thanks for the info, but I think I got lost with your jargon...:$ ...please excuse me for my ignorance...but would you care to explain in layman's terms...:)

Thank you kindly...
May

No you don't have to change anything but your query. Here is the function documentation with all of the date format symbols. The calendar function just needs to be consistent.
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format

Thanks for that link....I understand now what you were trying to say before...
:):):)

Question

Could I change "SELECT * FROM tsttbills where DATE_FORMAT(billDate, '%e-%m-%Y') >= '$sDate' and DATE_FORMAT(billDate, '%e-%m-%Y') <= '$eDate'" to "SELECT * FROM tsttbills where DATE_FORMAT(billDate, '%Y-%m-%e') >= '$sDate' and DATE_FORMAT(billDate, '%Y-%m-%e') <= '$eDate'" ???

Would that require me changing the date format in the javascript or something? because there is the little calendar icon next to the input box that I would click and select the date, the date is then displayed in the input box in that format....

Our IT guy is too stupid to block sites like this. he hadn't even blocked myspace or facebook or youtube till i told him it was killing our bandwidth.

LOL

We are allowed 1 hour per day (10 minute intervals) for the socializing sites (facebook and myspace included) but since facebook got the chat feature, it's totally blocked now :D:D:D

Here is the result after i ran the script....the dates i entered for the search were: 1-11-2007 and 9-11-2007...

Hey thanks Maydhyam, although i ll have to go home and check out the link as the site is restricted form my workplace...but i ll definitely have a look at it, cheers

Raj

It is also restricted in my workplace as well...well, Happy Reading...
:):):)

I like this description of the topic in our earlier discussion within this thread.....Just came across it and thought I'd share....

*AN ENTHUSIASTIC COMPUTER PROGRAMMER OR USER:

this is the original meaning of the word hacker. A hacker is someone who enjoys learning and exploring computer and network systems, and consequently gains a deep understanding of the subject. such people often go on to become programmers or administrators or system security consultants. Since they spend most of their time pointing out and securing against system security holes, are sometimes referred to as white-hat-hackers.

*A PERSON WHO TRIES TO GAIN UNAUTHORIZED ACCESS TO A COMPUTER OR TO DATA HOLD ON ONE:

This is the most conventionally understood meaning of the word hacker as propagated in Hollywood films and tabloid newspapers. A lot of people who are quite happy to call themselves hackers by the first definition regard the second group with suspicion, calling them "crackers," as they specialize in "cracking" system security. Such crackers, who spend all their time finding and exploiting system security holes, are often known as black-hat hackers.