10,946 Topics
 | |
| | 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 … |
| | Hello, My problem stems from reading an image from the local disk and displaying it. There's a middle step of storing it in a database, but I simplified the problem into this test script that replicates the error: The image "http://example.com/test.php" cannot be displayed, because it contains errors. test.php looks … |
| | |
| | inside my database, there is a table name january such as: id | code | 1 | 2 | 3 | 4 2 | 0000 | X | X | O | O when i access the data using PHP and parse it into an array e.g. $array1, It became: … |
| | Hi I have a problem with the mysql query that uses both order by and limit.Following is the sql query i'm using, select * from temp where venue <> '' and cat1 = 'sports' and id < 74528 order by id desc limit 10; in this temp table 'id' is … |
| | I'm hosting on NetworkSolutions (which has PHP 5.2.17) and every time I make a prepared statement it returns the error "Incorrect arguments to mysql_stmt_execute" D: Can you help me spot the error in my code please? D: [code] <?php $mysqli=new mysqli(host, username, password, db); $query="INSERT INTO `Variables` VALUES (?, ?)"; … |
| | hi, i have some variable defined in a php file. for example: DEFINE( '_clientass', 'Cliente' ); so when i do a echo of _clientass they return Cliente now i want call _clientass from a mysql row and return Cliente If i do this: $row['variable'] he return _clientass but i want …  |
| | Ive used date() before but I do not remember how to store it in mysql. VARCHAR, TEXT, TIMESTAMP? |
| | Hi, I need help with PHP/javascript/mysql I am fairly new to this so excuse me for my bad programming skills. I have PHP page which has to update mysql table and HTML table onclick. It updates HTML table ok but as soon as I refresh page it updates all data …  |
| | hi all, i am using temporary table to store ids,from this i am calculating the records count,it is working fine and i am getting the result.The problem is i am getting warning that temporary table does not exists |
| | Hi Guys, I am having few issues testing a software for which I have to develop a front end GUI. Basically, the previous person failed to document on how to run the system and left all the pleasure for me :D Anyhow, the system basically is a web crawler and … |
 | Hi. I'm not sure if this is possible or not, but I need to be able to SELECT * FROM all the tables in the database. Is this possible? Thanks! |
| | Hi All... I'm wondering if an extra pair of eyes can find a problem with this trigger: [CODE] DELIMITER // CREATE TRIGGER `auto_approval` BEFORE UPDATE ON `my_table` FOR EACH ROW BEGIN SELECT security INTO user_sec FROM users WHERE userid=NEW.userid; IF user_sec >= 10 THEN set NEW.admin = 1; IF NEW.admin … |
The End.