11,093 Topics
 | |
| | Im in need of big help... (sorry bout the size of the post :$) Im just getting started in databases and need some magic.... Im running on the server; * Apache/2.2.17 (Win32) mod_ssl/2.2.17 OpenSSL/0.9.8o PHP/5.3.4 mod_perl/2.0.4 Perl/v5.10.1 * MySQL client version: mysqlnd 5.0.7-dev - 091210 - $Revision: 304625 $ * …  |
| | hello everyone , I'm facing a problem in inserting data in TEMPORARY table. i can do it by simple query easily. but i want to do through [CODE] for Ex. i have bunch of query which i'm executing through SET @QueryText="Select ID from employees limit 5"; //it contains bunch of …  |
| | Hi... I've been doing ASP.Net for years, but I am very new at PHP. I need to redirect a user to a specific page based on the refereeing page. There's no way to calculate what the page should be so I figure I would have to use MySQL and look …  |
| | I want a database that should fetch images from a URL.How can I do that?  |
 | Hi all, am using eclipse IDE.I want to connect mysql database with jsp/servlet for that i want to add mysql j/ connector. I added properties -> Java build path-> Add External jar file but still it calls the exception Driver not found "com.mysql.jdbc.Driver". Am not filmier with Eclipse any one … |
| | hi, I need a query to get the start date and end date of a month when given the month name. For eg., When given month='august' it must display 01-08-2011 to 31-08-2011 Thanks. |
| | I'm trying to make a postback script which works with a CPALead widget, however it does not seem to work. I do not think my code is wrong (which I have attached at the bottom) so I was beginning to think this was not possible due to the fact that … |
| | Recently I have been working with Mysql and PhpMyAdmin a lot on Ubuntu, and I have stumbled across a very annoying error, or set of errors. I keep on getting a bunch of random loosely related error messages. These are the errors I get. When I try to log in … |
| | [B]Hi guys, Well I just reinstalled vBulletin 3.8.6, on top of the other. I tried to make a new THREAD, after posting it says:[/B] ___________________________________________________________________ Database error in vBulletin 3.8.6: Invalid SQL: UPDATE session SET newposts = newposts+1 WHERE NOT ISNULL(newposts); MySQL Error : Unknown column 'newposts' in 'where clause' … |
| | Must need coffee or something :/ Cant figure this out. I have a table with following info: [CODE][B] unique_id block_id column_id order_id user_id[/B] 1 block-1 column-2 0 1 32 block-2 column-3 0 7 7 block-1 column-1 0 2 8 block-2 column-2 0 2 10 block-6 column-2 1 1 11 block-7 … |
| | Im just wondering if its possible to set values automatically. For example theres data in my database that have dates of birth and some of them have all info filled in like 1953/12/25 and then some have just 1953. Is it possible that i can use some sort of code … |
| | Hello, I'm trying to write a sql statement that would update a record only if a particular row column is empty; else, insert a new record. Is this doable? Currently, I have this update statement: [CODE]//query for additional cars 1 $mysql_query=("UPDATE additional_cars SET clientID='$edit_clientID', registeredstate='$edit_registeredstate', dhtmlgoodies_category='$dhtmlgoodies_categoryupdate', dhtmlgoodies_subcategory='$dhtmlgoodies_subcategoryupdate',caryear='$edit_caryear', servicearea='$lastservice', currentmileage='$edit_currentmileage', todays_date='$date2', … |
| | i have no idea where to start but; i'm looking for a way to change all emails from [email]suppliers@test.domain.com[/email] to [email]title@test.domain.com[/email] in a MySQL DB. DB Name: simons_directory Table: listing Fields: title, email caveats - title has words with spaces, if possible to remove the spaces so "My Business Name" … |
| | Hi all, I want to sort some sql results by a certain list. I don't want it sorted alphabetically or anything. I want to specify a certain list. eg "order by `office` = 'president', 'vise President', secretery'" ect. Is there anyway to do this? I didn't type this example exactly … |
| | Hi, how do I add (using SQL) string that has the char ' ? I have many words that look like this- dsf'dfdf or dfsdf' but when I'm trying to add them the query command thinks that the ' is the end of the string and then messes up everything … |
| | Hello all, I'm trying to build a forum site. The code below works fine but I dont know how to catch it from the address bar. I'm having trouble finding tutorials to help me with this. viewtopics.php [CODE] echo "<tr bgcolor='#6698FF' ><td><a href='viewcomments.php?id=".$rows['topic']."'> ".$rows['topic']."</a></td><td>".$rows['username']."</td><td>".$rows['timestamp']."</td></tr>"; [/CODE] Address Bar [CODE] http://localhost/testsite/viewcomments.php?id=Cowboys%20Dancehall [/CODE] … |
 | Hello everybody. I've created a PHP page that adds a new record to a table. I want to know what's the ID of that created record in that table. For example: [CODE]mysql_query("insert into tableName(field_A,field_B) values('valueA','valueB')");[/CODE] |
| | |
| | I installed mysql on ubuntu 10.10 using the terminal screen but when i give in the command %mysql -u root -p .it gives me the following error( as attached in the screenshot)..Please tell me as to how can i access my mysql account and create databases etc. |
 | Hi All, In windows on easyphp we open the mysql console from the browser by typing [url]http://127.0.0.1/home/[/url] In ubuntu when I do the same thing, it does not happen. I installed LAMP server using the following command sudo apt-get install tasksel sudo tasksel and then it is interactive When I … |
| | how to create stored procedure with phpmyadmin i tried this codes,its syntex error [CODE]1 DELIMITER $$ CREATE PROCEDURE `TestProcedure`() Begin select * from testtable; End $$ DELIMITER $$ or CREATE PROCEDURE `TestProcedure`() Begin select * from testtable; End [/CODE] i having mysql 5.1.41 version in my hosting regards rajan |
| | I have 2 tables: Users and Log I want to select ALL users from Users who are not in Log having already received a msg_id matching 'x' What I have so far is this: [CODE] SELECT * FROM users AS USR WHERE USR.user_id=2 NOT IN ( SELECT * FROM msg_log … |
| | hi all, i am writing store procedure so please send me steps to follow that increase the performance |
| | Hey, I created a simple user register script which later stores the data in a mysql database. What I did initially was that a small code would count the number of rows in the database and then automatically increase the variable by 1 to set the user id. For example … |
| | Hi,I have 6 checkboxes. name,father name,city,state,dob,education What i am trying 1)if user check name,father name its shows only checked item [B]name[/B] [B]father name[/B] Mr. a Mr.abs Mr. B Mr.bcd ([B]table structure like that[/B]) 2)if user check name,father name,city its shows only checked item [B]name[/B] [B]father name[/B] [B]city[/B] Mr. a Mr.abs … |
| | I wrote this code in php, it's purposes is to update the user record in mySQL database. There's already a script view.php which displays all records in the database, in the view file there's a edit link which sends the user id information to edit.php via get method. on the … |
| | Well i somehow failed to use the search on this site. How do i connect to an online mysql database via VB.NET? I did lot's of search the past few days Could not find my answer. |
| | [B]Hi all i am writing a software for a department store, how can i package LDF and MDF of its database and .exe of its windows form application design? i want to have one .exe file and give just it to department store's manager? could you please help me asap:) … |
| | Hi.. I am frequently using XAMPP's phpmyadmin for MYSQL database. I want to install original Mysql database from their developer's site([url]http://www.mysql.com[/url]). I am very confused that I found 6 types softwares. Which one should I install? I also need to access the software using GUI.. Any body can help me? … |
| | I was following a tutorial and i copied word by word i don't know why i get the error. Error >> Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/*****/public_html/download/url/search.php on line 36 [CODE]<?php $results = $_GET['results']; $terms = explode(" ", $results); $query = "SELECT * … |
 | I am trying to figure out the best way to figure out "age" of a particular item. I currently have fields in a mySQL databases that are stored as datetime formats and I need to display (in PHP) the relative age of those dates in terms of years, months, and … |
| | I have a query which generates a soccer standings table and am trying to create a different version which will only include the 6 most recent games for each team. An example of the output of my current query can be seen [URL="http://www.margate-fc.com/content/test/standings.php?season_id=104"]HERE[/URL]. The full query is below and I … |
| | Is it necessary to install mysql workbench in order to run database based php web apps? |
| | I am new to using sql .i have two table expense statement and revenue statement such as revenue statement accountname debit A 100 B 200 expense statemnt accountname credit X 300 Y 400 is there anyway i can join these two table like this, if so can someome tell me … |
| | I want the query to retrieve topics but if the topic repeats I only want one result to show up, no duplicates. I also want it to return username and timestamp. Here is what i have now but I get an error. [mysql_fetch_array() expects parameter 1 to be resource]. Anybody … |
| | i want to be abale to update the filed 'activated' to 0 when the 'expireDate' is before today. can you show me how to do it with a trigger? (i want to do this after the user insert the row) |
| | I wrote this code called delete.php, i have another script called view.php which displays all the users in the database and displays a link to delete that particular record using the get method. In the delete.php file it retrieves the id through get method from the view.php file and deletes … |
| | I'm trying to figure out the best way to replace apostrophes in various user input which is all formatted first using [B]mysql_real_escape_string[/B]. Of course this replacement should take place after all input has been sanitized and anything funny removed. :) Any help would be awesome! |
| | Ok I am stumped. I am inserting the data fine into the table and database so i know its not the config.php nor opendb.php. I used a code like this before and it work, i've only altered the $sql, the td's, and the $rows[]. Table name is hotspots (all lower …  |
| | hey guys.. i have trying for 2 weeks now to connect 2 tables in the way that i need them to print out.. [B]to understand the table structure please see attachment 001[/B] Now... i have managed to join both table but the problem is that each time i insert a … |
| | ey guys..i have been given a project that needs things which am still a beginner in.Am asked to develop a database whereby a user will enter the website and answer some questions about their intrest in using database to store their medical records...So far i just know that i have … |
| | HI. I'm new to MySQL and downloaded easyphp a while ago and had been using the phpmyadmin GUI to create databases on MySQL. Because I am also doing web development I decided to download Wordpress. But as I was downloading Wordpress I got a message telling me that I did …  |
 | There must be a better way… Hello all, I am now designing a new data structure and I faced this problem that I am going to describe making me think that maybe I should redesign it. Maybe the solution is in front of my eyes, and please if you have … |
| | I have a query which generates a soccer standings table and although it works fine there I am trying to implement a couple of variations on it but everything I have tried has failed. I have searched and asked many times and for both problems and it seems as though … |
| | For my new code that I'm developing, I have a text box where a user will type in a date as follows: [B]MM/DD/YYYY (e.g. 05/19/2011)[/B] This date then needs to be converted and inserted into a date/time field on a mySQL database. I've been trying to play around with this … |
| | Hi Friends i have some problem in update my dynamic text box value for particular id alone, i want to update only the 2 column fields into my database, i have used the below code. i am not able update the fields into my DB. Please help me to solve … |
| | Hi All, This is the first time I'm using Java to connect to my online MySQL database that is hosted by a separate web host. Following is the code in use: (I've removed the server url, username and pass for obvious reasons. They all work when I use them in … |
| | How to upload a photo in mysql database using Browse Button.that means i want to upload the photo in databse anywhere from hard disc using Brawse button.. please help me .. |
 | Hey guys, I'm having some trouble setting up a form to delete a specific row in my database table. Here is the idea: I have one page that makes looping calls to MySQL for a query result, at the same time I print out the html as I need to … |
| | Dear All, I have an application where I got few different sql queries that I would like to have an ACID properties. I have now setAutoCommit false. Where best to put commit and rollback statement? [CODE]try { [INDENT]dbconn = DriverManager.getConnection("jdbc:mysql://192.168.1.45:3306/***?"+"user=****&password=*****"); dbconn.setAutoCommit(false); stmt = dbconn.createStatement(); String selectQuery2 = "Select * from … |
The End.