Hello, im trying to pull .swf files from MySQL by using PHP, ive set everything in the database up with an ID and licked it properly. Im not sure if the 'type' has to be anything special, right now its just a 'VARCHAR' and when altering the javascript part of it that that flash automatically generated-- in the i tried to echo it out by ...
Is there anything built into Ibatis that helps prevent SQL Injection attacks? I'm not looking for a list of ways outside of Ibatis to do this, and am just wondering if Ibatis has anything to prevent SQL Injection. ...
I have using VPS that had to be re-imaged. my DB was part of it and it was being backup up as the app wasn't in production yet. However, there is some data that I wish to recover on it. the VPS provider is giving me a backup of the image (Ubunto Linux) that has all the files. Is there a way I can recover my data? ...
I want to select records in my table when it matches a row that ends with a particular value. eg. if 'oop' is found at the end of a particular record it select the record Pls how can i go about it thanks ...
i have one table store post id and it's tags like : Post_id | Tags -------------------------------------- 1 | keyword1,keyword2,keyword3 I want to loop though each row at this table and do : put the keyword1,keyword2,keyword3 in new table : word_id | word_value ------------------------- 1 | keyword1 2 ...
I have the following table and trigger but the trigger isn't setting the create_dt value to now() on the insert event: CREATE TABLE `user` ( `user_id` int(10) NOT NULL auto_increment, `user_name` varchar(255) NOT NULL default '', `password` varchar(255) NOT NULL default '', `first_name` varchar(255) NOT NULL default '', `last_...
I have a table of items which I'm getting from a few different online stores, like Ebay/Amazon, etc. Before today, I wanted to simply group each item based on the year it was made and the manufacturer who made it. So, the results would look something like this total year manufacturer 100 1999 man_a 32 2002 man_b Now, I wan...
I currently have two tables, one with documents, and another with ratings doc_id | doc_groupid | doc_name | doc_time and then rating_id | rating_docid | rating_score where rating_score is either -1 or 1. What I need to do is have a single query that retrieves every column in the document table WHERE groupid = #, but also has colum...
I have a PHP application that works well in every browser except Internet Explorer. The application generates reports based on MySQL data. Certain fields of each report are clickable and will redirect the user to another page/report after POST using the PHP header() call. In Safari, Firefox, Opera, etc. when the user clicks the Back b...
I store all of my login information for databases in files outside of the public tree in variables such as $hostname = '172.0.0.0'; $dbname = 'myname_mydbname'; $username = 'myname_user'; $pw = 'password'; That's pretty standard. The problem is that this particular hosting I am working with requires the myname_ to be appended to t...
I'm developing an application that allows users to input into VARCHAR(255) fields in mySQL, so security is a major concern. I am having trouble understanding quote(). If I use quote('test'), the data returns as '\'test\'' on SELECT, which is undesirable. How do I unquote this data? If I bypass quote(), I can peek into phpmyadmin and...
I have a query that looks something like SELECT to_number FROM sent_texts WHERE to_number NOT IN(SELECT mobile FROM action_6_members); A WHERE is applied to the result set after the query is complete. What would the effect be (improve/degrade) if the sub query contained WHERE mobile = to_number A HAVING is applied to the result se...
The environment: Mac OS X 10.6.4 $ ruby -v ruby 1.8.7 (2009-06-12 patchlevel 174) [universal-darwin10.0] $ rails -v Rails 2.3.9 $ mysql --version mysql Ver 14.14 Distrib 5.1.51, for apple-darwin10.3.0 (i386) using readline 5.1 $ gem environment RubyGems Environment: - RUBYGEMS VERSION: 1.3.7 - RUBY VERSION: 1.8.7 (2009-06-12 pa...
tweak mysql via ssh (Putty) please help me ...
See something wrong in my code? I can't get the update function to work.. weird thing is the rest works correctly, and the same code works 100% on another page. <?php include("config.php"); $id = $_GET['id']; $number = $_GET['no']; $result = mysql_query("SELECT * FROM comments WHERE commentid = '$id'") or die(mysql_error()); $row ...
Hi everyone, I am pretty new to Python programing and programing in general so bare with me. I am trying to create a program that takes a number of tab delaminated text files, and works through them one at a time entering the data they hold into a MySQL database. There are several text files, like movies.txt which looks like this: 1 ...
Hello good people of stackoverflow, I am trying to create an ecommerce product that takes orders for print jobs. I would like to create tables such as the ones here on solopress for example http://www.solopress.com/leaflet-printing/leaflets.html. I am just struggling a little with the logical steps of modelling this in a database. Firs...
I'm using mySQL InnoDB tables. The query is simple but it just takes too long to run. Its bound to run even slower once I upload it to a server (not to mention that these two tables will keep growing in size). The 'author' table size is 3,045 records. The 'book' table size is 5,278 records. SELECT author.*, count( auth_id ) AS author_c...
Possible Duplicate: Can Someone Explain MySQL's License and What it Means to Closed Source Development? I know of an application that is closed source but can connect to a MySQL database. I know that MySQL has commercial licensing and a FOSS exception, but I was curious about this case. The program is free-as-in-beer but not a...
Hi, I am writing a query on Mysql . I have to find the youngest customer and in my database , I have 2 persons with same dob. I am doing it in a way that first it checks all the conditions and then order by dob desc, limit 1. It gives me only 1 result. If I set the limit 2, I get the second person but setting limit according to database...