I have a web form with about 15 checkboxes that users may check 0 or all 15 checkboxes and any quantity in between. The database that will store the form data is MySQL, but reports will be generated from the data in MS Access using a MySQL ODBC connection. I see three options for handling this. The Spreadsheet way: Have one table wit...
I get an internal server error with the following code... any suggestions: <form name="user" action="this.php" method="post"> <input type="text" name="description" id="description" value="" /> <input type="submit" name="" id="" value="Edit Page" /> </form> There is no other code on the page, and it self submits fine UNLESS I pla...
Does anyone know of a way to make Excel 2003 push changes to a MySQL database? Currently, we're using Excel 2003 for keeping track of a big bunch of interconnected equipment (actually, an entire electric power distribution system with all the hoo-ha's that hang off it.) Quite frankly, using a spreadsheet for this sucks and I'm sick of i...
Lets say I wanted to build an app that will pull url links from a database and show 50 on a page. I am just using links as an example. What if I had to store multiple values, an array into 1 mysql field for each link/record posted. If there is 5 items for every Link, I could have an array of 5 items on the page, a list of 5 items s...
In my PHP program, I am having trouble with the mail() function. I can call it in my scripts anywhere up until this line: $this->db_conn = mysqli_connect($this->db_host, $this->db_user, $this->db_pass); If I put a call to the mail function immediately before it, mail() succeeds and returns true. If I put mail() right after this line...
When making a MySQL query with no WHERE constraints, most people use WHERE 1 in the query. However, omitting WHERE 1 does not influence the query. Is there a difference between the two? Is one considered to be the best practice? ...
I have a table called trends_points, this table has the following columns: id (the unique id of the row) userId (the id of the user that has entered this in the table) term (a word) time (a unix timestamp) Now, I'm trying to run a query on this table which will get the rows in a specific time frame ordered by how many times the colum...
SURVEYS table: SurveyID UserID Question Choice1 Choice2 Choice3 RESPONSES table: UserID SurveyID Answer The first desire (achieved): Show me all surveys that User 28 has initiated: SELECT * FROM Surveys WHERE Surveys.UserID = 28 The second desire (achieved): Show me all surveys that User 28 has answered: SELECT * FROM...
I'm trying to mimic a reddit feature. When you link to a specific comment in a threaded list (example), you can add a var 'context' in the url to show the context. I can show you the comment I want you to see, plus a parent (context=1) or the parent's parent (context=2) and so on. Now, cakePHP simplifies the threaded thing with find('th...
Hello, Im using Mantis bug tracker v1.1.8. When mails sent from mantis arrive in my company inbox,the date shown on the Inbox page is "Unknown Date" for the message. On opening the message, i can see the actual date. The date of mails received from Mantis is of the format Thu, 31 Dec 2009 12:30:28 +0580, whereas the date format of othe...
NOTE - I HAVE PROVIDED MORE DETAILS AND AN EXAMPLE AND USED CODE BLOCKS (THANKS TO THE HELPFUL COMMENTS ON THIS POST) IN THE QUESTION DEFINING VIEWS IN MYSQL FROM COMPLEX QUERIES -- TRY #2 I'M NOT SURE HOW TO DEPRECATE OR TURN OFF THIS QUESTION... PLEASE SEE MY OTHER POST. THANKS, DOXGUY So the following code works (gives anticipa...
It's created this way: create table listings( id integer unsigned NOT NULL AUTO_INCREMENT, accountId integer unsigned default null, title varchar(300) not null, country integer unsigned, region integer unsigned, type integer unsigned, price integer, unit varchar(20) not null, priceUSD decimal(12,2), ...
Hai guys, I use the following connection string <add name="connectionString" connectionString="server=localhost;user id=root; password=; database=lms; pooling=false;" providerName="MySql.Data.MySqlClient"/> It gives me the error There is no 'lms'@'%' registered. My database server is localhost and the user account doesn't have a pas...
Hello, Im using Mantis bug tracker v1.1.8, and the Horde Webmail System for my company emails. When emails sent by Mantis arrive in my company inbox, i get Unknown Date in the Date field of the inbox view. When i open the message, i see the Date like Thu, 31 Dec 2009 14:32:15 +0580. The other mails, whose date i can see in the Inbox vie...
I have a strange problem. 5% of its time; i get the error "No Database selected". Only on a page where i use iframes; called from out tab script. Here is the "sometimes problem" page: http://www.thediscopalace.com/programtest.php Every tab calls for a page and loads it into the iframe. The requested page get its content from the d...
How does one format wide listings vertically like in MySQL using the sqlcmd client? Or should I be using osql instead? And must I write "GO" each time to execute my query? Is there a shorthand? ...
It's basically this - I was used to using mysql < dbfile.sql to restore a database dump created with mysqldump. Then I saw there is mysqlimport, with no reference to the other way. The arguments of both CLIs look similar. So, what's the actual difference? (And is there any) ...
I want to query a database and return specific row numbers eg 1, 10 and 25. Is this possible or will I need to do 3 queries (or 1 query and loop through the rows then only output the ones I need) using php. ...
Hi, I've been doing RPG game recently and every page load I have to use mysql_query (and this query quite big, takes a few tables with inner join) to take information about player. How can I avoid this query sometimes? Of course I can use cache and make query for example every 30 secs, but it won't renew new information instantly. So, an...
Hi, I know that a database is used to stre data in, but I have a little problem. I have a a column with prices for my online store, now I want to change all the prices with a certain a som of 1.5 example: Normal the column prices has a value for ie: 1,95, this should be changed to 2,04 (round on 2 decimals) What can I do? ...