I'm developing an application in which users upload pictures to server and then send email to people they choose with a link that shows these pictures. My question is about organizing the people in a database (I'm using MySQL). I would like each user to have people tree like this: Family Mom Daddy Jonathan Close Friends David Ron...
Hi, I am looking for solution where using jquery I want to display 5 records per page and need Next/Prev functionality. So when user click on next button or image it will fetch data from PHP, Mysql and displays it. SO kind of pagination but using Next/Prev Thanks & Regards, web programmer ...
Hi, Does anyone know any free tools that will generate insert statements given a result set? I know TOAD for Oracle does it, i would need this for a mysql database. For example, if I execute this query select colA, colB from mytable where colC = 'numbers'; //returns many rows |colA | colB | |1 | 'one' | |2 | 'two' | |3 | '...
Hello, can someone tell me what's the best way to store many different settings in a database? Should I use one table with id,key,value? Here is an example what i have to store: PageNavigation.Font = "fontRegular"; PageNavigation.FontSize = 14; PageNavigation.FontColor = 0x000000; PageNavigation.SubFont = "fontRegular"; PageNavigation...
I am working on a site that has tests users can take. I have a test area set up with 100 questions on each subject. If a user is taking a test, I want them to be able to save the work they have already done and when they return I want them to be able to continue the work from where they left. The questions being answer are multiple choic...
+--------------+--------------+------+-----+-------------------+---------------- + | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+-------------------+---------------- + | mag_id | int(11) | NO | PRI | NULL | auto_increment | | cat_id ...
I have a 71GB file having contents of one table of mysql database. Loading that takes me couple of days. Is there a easier way to load the data. I am not sure if removing indexes or splitting files actually helps. How stackoverflower's solve this problem. ...
I am creating an application to help our team manage a twitter competition. So far I've managed to interact with the API fine, and return a set of tweets that I need. I'm struggling to decide on the best way to handle the storage of the tweets in the database, how often to check for them and how to ensure there are no overlaps or gaps. ...
SELECT * FROM `objects` WHERE (user_id IN ('7,8,12,9') AND visibility IN ('0,1')); but it only returns the stuff corresponds to the second array's first element. So it returns the same as like this: SELECT * FROM `objects` WHERE (user_id IN ('7,8,12,9') AND visibility IN ('0')); (I swapped the two values (of the visibility arg) an...
I'm working on a project, and we've been creating tables that store references as a combination of two columns. An example: we have an 'alerts' table, that is used to deliver information to the user. An alert can refer to a number of different things, you can be alerted about a new message, or if another user has mentioned you. Thes...
I have a python script that connects to a local MySQL db. I know it is connecting correctly because I can do this and get the proper results: cursor.execute("SELECT * FROM reel") But when I try to do any insert statements it just does nothing. No error messages, no exceptions. Nothing shows up in the database when I check it from sqlyo...
Okay I'm using strip_tags to get rid of html from when a user tags a post but when a user enters something like in the upcoming example. I get five empty values entered into the database, which I don't want everything else is fine. How can i stop this? ,,,,,,,, ,, ,,,,a,d, <html> , ruby-on-rails , ad, <html> I get the following ente...
I have a row in a MySQL column named tags. In tags I have a series of keywords separated by commas. For this example lets use ice cream as the theme.. mmmmmmm.... Ice Cream :). So in my tags row I have: Vanilla, Strawberry, Coconut, Chocolate, Rocky Road, etc. I also have a column in the same table named Ice Cream Shop. Each with j...
Hi Guys. I'm creating an application for a friend to handle Deadlines. I have a page set up where each user can see their own 'jobs to do' with a deadline next to it. My question is... How do I compare a deadline date that comes back from the mysql query as 2010.08.08 with today's date? For Example... <?php while($row = mysql_fet...
I am using SQLite3. I load a table with say 30 rows using integer as Primary ID and it auto-increments. Now I delete all the rows from the table and then, reload some new information onto the table. Problem is: the row count (my PrimaryID) now starts with 31. Is there any way that I can start loading new rows from the number 1 onwards?...
This drives me craze, whatever i do in SqlQueryBrowser i have the same 1064 error: CREATE Function surname (uid int(11)) Returns TEXT 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 '' at line 1 What is the problem ? Thanks ...
I could not find a similar question on stackoverflow, so i apologize if its a duplicate. If its already been answered, kindly point me to that. I am moving my app from engineyard to heroku and i am trying to push the db using their db:push command. It works great until it reaches one table where it complains of violating a unique constr...
Mysql errors are among the most common ones you see during development, and I am searching for a pleasant and informative way to output them. phpMyAdmin apparently has a decent pretty-printer for mySQL queries: However, it prints errors as simple text: Whereas in the latter example, the text after for the right syntax to use near ...
Hi, I'm currently working on a SaaS type application, and for multi-tenancy I've settled on one database per user, with each database containing all tables required by the functionality the user is entitled to (have payed for). The application is designed to capture data (i.e. like web analytics) and present it for the user. The design ...
We're running MySQL 5.1 on CentOS 5 and I need to securely wipe data. Simply issuing a DELETE query isn't an option, we need to comply with DoD file deletion standards. This will be done on a live production server without taking MySQL down. Short of taking the server down and using a secure deletion utility on the DB files is there a wa...