Search results for query: *

Thanks for the help. However, I found the solution I was looking for. The way I wanted is as follows: SELECT * from tablename WHERE transtime <= current - interval(45) minute to minute; Anyways, thanks for your time and response.

If I have a field/column, transtime datetime year to minute, how do I go about SELECTING/RETRIEVING records/rows that have the transtime older than CURRENT - minutes? Thanks

Hi All, What I have is a field called transtime (datetime year to second)m i.e., YYYY-MM-DD HH:MM:SS. What I would like to know how to SELECT/RETRIEVE is any records/rows that have 45 mins older than current time. In other words, if my transtime is 45 mins past, I would like to display them...

Is there a way to capture/see what SQL command the user is running/using inside of the MySQL database? Meaning if the user said his app is running really slow, how can I see what his SQL is doing? Again, thanks for the help.

Thank you Sleipnir214 +:-)

I am new with MySQL and would like to know a way to show/display all of my indexes within a database. Or at least to show whether a table has indexes or not. Thanks for the help. Jay

All of these are very well said and are valid. The thing to know is that not all people are not alike. A true leader must know his followers and true followers learn to know his leader. It is like the head and the body--one can not truly function without the other. I truly believe that some...

Hi all, I am new with MySQL and really need your help. Questions: 1. How to create a new database I used: %>mysqladmin create mytestdbs? 2. How to grant a username/pw to that database? I used: GRANT select,insert,delete,update on mytestdbs.* to...

Hi all, I am new with PHP, and I really need help with this. I copied a simple guest.php from a site, and it worked the first few times, but after that I kept getting this message: Warning: Failed opening '/home/jxiong/public_html/guest.php' for inclusion (include_path='.:/usr/share/php') in...

Hi all, I am new with Crystal Reports and REALLY don't know how to create a simple report with just one Parameter field. I mean how do I go about adding/making the Parameter field work with my report? Any help would be greatly appreciated. Thanks much in advance. Jay

Can someone kindly point me to or help with a sample of javascript that will work with database? I am trying to find a sample but could not locate any at all. I know how to do it using vbscript, but not js. Thanks in advance for the help.

Hi I am new at this forum and also new with JavaScript. What I would like to have is a sample of javascript that will display 3 items as a select box with Multiple=&quot;true&quot; and then once the user finished selecting some items, I would like to know what items the user had selected. Also...