I'm attempting to build a web app and I've run into a bit of a wall. I'm not asking for anyone to hold my hand through making this, just some advice and a push in the right direction. So, I'm trying to build an app that uses the Google Maps API to display a map of local parks near you and allow people to post pickup games (informal spor...
In MySQL I want to write a script and put multiple CREATE PROCEDURE statements into it, the usual (;) wont work for some reason. Is there another way to run multiple CREATE statements in the same script? If so, how? ...
I have a mysql query which is really bogging down my VPS. Its doing a filesort according to explain extended. I usually optimize queries on my own but this one i'm not sure I know how. SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_posts.*,MAX((1.00 * (MATCH(wp_search_post.post_content) AGAINST ('test' IN BOOLEAN MODE))) + (2.00 * (MATCH(wp_se...
I have this question on and of for a year or two, but it is so nonspecific, and my native language is not English, so I don't know how to ask to be precise and everybody will understand what is my dilemma. It is even more valid if using objects but for the sake of simplicity I'll make a simple example (theoretical) with a function and d...
Hello Everyone, I have triple drop down menu. I want to display the contents of the table based on the third menu selection. The code is in the link http://php.pastebin.com/hgazULxi I know I need to include a onchange function to but as you can see I have a already for it. I am confused how to create the function to display the table...
I am new to python, I come here from the land of PHP. I constructed a SQL query like this in python based on my PHP knowledge and I get warnings and errors cursor_.execute("update posts set comment_count = comment_count + "+str(cursor_.rowcount)+" where ID = " + str(postid)) # rowcount here is int What is the right way to form queries...
Hi Guys, I am currently developing a an application to allow users to search through a database of documents using various paramaters and returning a set of paged results. I am building it in PHP/MySQL, which is not my usual development platform, but its been grand so far. The problem I am having is that in order to return a full set ...
are there any way to duplicate the resources produced by functions such as mysql_query? it may sound dumb but i wanted to reuse such resources so that i won't retype the mysql_query() again and again just to use have a resource..like for example $rsrc = mysql_query('SELECT * FROM `table` LIMIT 0,1'); $rows = mysql_fetch_array($rsrc); ...
I have two tables, applications and applicationRevisions, structured: applications (id, time, user, views) applicationRevisions(id, application, time, user, name, description) The latter holds 'revisions' of an application page, containing title and description, so it's a one-to-many relationship. When an application page is shown, th...
if(isset($_POST['submit'])){ $eventSelect = $_POST['eventSelect']; $eventLocation = $_POST['eventLocation']; $eventDate = $_POST['eventDate']; echo "Event Name:";echo $eventName; echo "<br /><br />Event Location:";echo $eventLocation; echo "<br /><br />From :"; echo $eventDate; } When a user goes to the site ...
This query would get one row with the id and the number of ID in the Messages. SELECT id, count (id) FROM Messages and I need that could get a list of id in the second field was the number EDIT: I do paged media. To do this I need to know how many of these lines that would make the button "next" active or not active I used C# ...
in c# what is the difference between both. ...
i already install mysql 5 in my system and visual studio professional. and everybody work fine but how i can connect mysql database in server explore using installing connector when i download connector for mysql i get the rar. the rar have some code but i not know how it work are anyone tell me what i do to use mysql in my server explo...
I want to make an AUTO_INCREMENT column in a database table,here is the syntax i write: create table comments ( name varchar(20), mail varchar(30), comment varchar(100), com_no int auto_increment ); and i get the following error: ERROR 1075 (42000): Incorrect table definition; there can be only one auto column ...
Hello I need a Windows based MySQL profiler. I've read the article where says that profiling is limited on Windows, but Im convinced that there has to be a tool which allows me at least to check all queries issued to the database, hopefully providing some more data. Can anyone help? ...
I have a classifieds webbsite, and users have the option to change / remove their classifieds. I am working on a "edit.php" page where all this can be done. Basically it is setup like this when you click on "edit/remove classified": A new page appears, with a form, where user may chose from "REMOVE" and "CHANGE" through radios. The us...
I am probably overlooking something simple-- Some of the news items has 2 categories checked, and other times it has all 4 check. I know I can do OR '' OR '' OR '' OR '' -- but I think there is a better way. The question: How could I query this to output: if the story has category 10,13 or 10,13,15 or 10,13,15,16 or 10,15 or 10,13?? ...
I am using php to build a "change classifieds" page right now. I use Mysql as a db. Currently I use PHP to fetch all mysql information about the classified, and then I output it like this: $table.=" <select name='year' id='year'> <option id='2000' value='2000'>2000</option> <option id='2001' value='2001'>2001</option> ...
Here is a sample query: UPDATE `table1` SET `table1`.`field1` = (SELECT COUNT(*) FROM `table2` WHERE `table2`.`field2` = `table1`.`field2`) MySQL gives me an error message that table1.field2 does not found. Please advice ...
CREATE TABLE IF NOT EXISTS `Channels` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30) NOT NULL, `commercial` tinyint(1) NOT NULL DEFAULT '0', `usrid` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; INSERT INTO `Channels` (`id`, `name`, `commercial`, `u...