I've got two sets of four dropdowns - startDate,startMonth,startYear,startTime (as 24.00) and the same for endDate/Time - for user to select a start date/time and an end date/time, but don't know how to get the selected values into a datetime format to use in a recordset query using javascript or preferably php(5). I know I need to comb...
I have questions regarding MySQL date and querying with it. First: SELECT * FROM post WHERE DATE(Post_Date)="2009-03-25" returns 0 results SELECT * FROM post WHERE Post_Date="2009-03-25" returns 71 results SELECT * FROM post WHERE Post_Date>="2009-03-25" returns 379 results I understand that the second query returning 71 ...
I am currently using python 2.6 and I would like to use the win32 mysqldb module. Unfortunately it seems it needs the 2.5 version of Python. Is there any way to get rid of this mismatch in the version numbers and install mysqldb with python 2.6? ...
Hi, Which is the equivalent of mysql_data_seek using pdo objects? Can you give me an example? Thanks! ...
How can I load text from MySQL to an HorizontalList in Flex3 ? I am using : <mx:ControlBar x="10" y="40" width="460" height="230"> <mx:HorizontalList id="dataGrid" dataProvider="{dataArr}" labelField="lbl" iconField="src" itemRenderer="CustomIte...
Hi I'm starting out on php and I have the following script <?php $username = "firstleg_floa"; $password = "**"; $hostname = "***1"; $db = "firstleg_bank"; $guildUser = strtolower('grissiom'); $dbh = mysql_connect( $hostname, $username, $password) or die ("Unable To Connect"); $connectDB = mysql_select_db($db, $dbh); $results = mysql_q...
I am parsing RSS feeds with the format as specified here: http://www.feedparser.org/docs/date-parsing.html date tuple (2009, 3, 23, 13, 6, 34, 0, 82, 0) I am a bit stumped at how to get this into the MySQL datetime format (Y-m-d H:M:S)? ...
This is very similar to question 653714, but for MySQL instead of SQL Server. Basically, I have a complicated select that is the basis for several stored procedures. I would like to share the code across the stored procedures, however, I'm not sure how to do this. One way I could do this is by making the shared select a stored procedu...
I have table which will only contain information about files, so, as the file path is unique and can identify any entry, i thought i should use it as primary key. Although, i'm having a few problems like needing to specify a key length (error 1170). What should i do? Use an integer as primary key and every time i need to access informat...
Hello community, I have this database structure: TBL_A | TBL_B | TBL_C | TBL_D | TBL_E -------+---------+---------+---------+---------- id | id_tbla | id_tbla | id_tbla | id name | id_user | id_user | id_user | name_tbla ... | is_bool | | weight | id_user Here is what I'm trying to achieve : SELECT a.id...
Could someone please point me to a good beginner guide on safely running SQL queries formed partly from user input? I'm using Java, but a language neutral guide is fine too. The desired behaviour is that if someone types into the GUI something like very nice;) DROP TABLE FOO; The database should treat it as a literal string and sto...
How would I combine the following two quieries to produce a combination of the two? SELECT * FROM post_attributes WHERE name IN ('title', 'body'); SELECT id, url, created_at, name, value FROM posts, post_attributes WHERE posts.id = post_attributes.post_id ORDER BY id; The idea would be to extract the post number, it's url...
This seems rather simple but it has been giving me a headache. I have a column in my events table that is called 'date_time' and it's type is datetime. I need to write a query that will get events by day. Example of table ============================ | id | date_time | ============================ | 5 | 2009-03-27 14:16:00 ...
Let's say you have a bunch of MySQL tables, and you want your end users to be able to generate reports with that data with a PHP script. You can present the field names from those tables in a dropdown, so a user might be able to say, "first_name equals John." Great. But what if you want those field names to be a little more readable? For...
I have a table with a varchar column, and I would like to find all the records that have duplicate values in this column. What is the best query I can use to find the duplicates? ...
Hi guys, What is the difference between int and integer datatype in MySQL 5.0. Can anyone help. I don't understand what is the exact difference. Kind help needed. Thanks in advance. Sivakumar.P ...
Hi all, Using PHP, and MySql, I am trying to implement this rather snazzy in-place editor available here: tutorial: http://www.davehauenstein.com/code/jquery-edit-in-place/ js file: http://davehauenstein.com/code/scripts/jquery.inplace.min.js OK what is happening is, I click the element to edit the text. I clear the old text, and e...
Hi Guys, I am using MySQL 5.0 as back end with VB.NET as front end(Windows Applicaions). I want to take back up my database. I found one command through net as below. mysql> mysqldump -u root -p root accounts > accounts.sql My database name is "accounts". When i am trying to run the above command in mysql> prompt, it gives e...
How can I store an image in a MySQL database using VB.NET? Could you show some examples that use the INSERT command? ...
I want to make a database restore function that will parse a dump made with Php My Admin and will do the queries. I have already a mysql class that does the query, but it only knows to do a single query. So i am looking of a way to split the file content into single queries. I tried to play with preg_split ... but didn't managed to get...