10,946 Topics
 | |
| | Hi iam having a problem with combining a few union statement together. The statements run separately without any problem. The below union outputs the following results: team points leeds 3 [code] select team ,points from ( select hometeam team, sum(homepoints) points from fixtures where competitionname = 'prem' group by hometeam …  |
| | Hi I am trying to write/modify a script to read from a spreadsheet into mysql database using php. I did a search on google and found phpExcelReader. However i wasnt able to use that to do so. ALso managed to find an open script to read from excel spreadsheet onto … |
| | Hello! I'm trying to migrate a database table from a joomla installation to drupal. The problem is with the column containing image file names. The column in the joomla table only contains the filename and drupal needs the sourcepath to the image as well. So I'm wondering if there's a … |
| | How to add Lv2 and Lv3 referral to database? for example: D is new register and downline for C, C is downline for B, B is downline for A. I want the A, B and C add into the database like upline upline2 upline3 C B A below is my … |
| | |
| | i m newbie in web development plz help me to sort out the problem.. the problem is: in [B][U]edit.php[/U][/B] when control enters in if condition it never goes to else when i press the edit button. i want to get id from view.php and display category name in edit.php textbox … |
| | How do you offload the time/date handling to MySQL? |
 | [QUOTE]$tag = $_GET[tag]; $search = mysql_query("SELECT * FROM `threads` WHERE FIND_IN_SET('$tag', `tag`) = '$tag'"); [/QUOTE]why is this returning all of the rows in the table they all do not have the same tags none of them have the same tags as each other yet the column name is tag. the … |
| | I have a program which connects to a remote MySQL Server. When i try running the program on other PCs (ones with nothing more than the .NET Framework) I tried using ODBC, which would run the program, but not be able to connect to the database because of the lack … |
| | ---Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Group\Apache2\htdocs\Project\login.php on line 72---- <html> <body> <form action="login.php" method="post"> <div> <table width="100%"> <tr> <td><img src="Logofinalcopy.gif"></td> </tr> <tr> <td bgcolor="aqua"><h2>Login</h2></td> </tr></table> <table align="right" style="width:40%"> <br> <tr> <td>Username:</td> <td><input type="text" name="username"></td> </tr> <tr> <td>Password:</td> <td><input type="password" name="password"></td> </tr> … |
| | As you wud have seen i am working on a search field, how do you select one displayed result and then use it for editing? how to dynamuically point the mouse at a result and then edit it through a form which is on another page called "Edit Details" |
| | Hi all - This is kicking my butt. I have searched everywhere I can think of and have tried the various solutions to no avail. First I am connecting to two databases on the same instance of mySQL using : [code=php] $conn2 = mysql_connect ( "XXX.XX.XX.13", "User1", "PWord1",true) or die("Could … |
| | I have 2 fields in my db, the first is Title and the other StopList. If a StopList word appears in any of the Title names, I want to flag that item for deletion. Currently using a PHP array to do this but wanted to know if mysql could do … |
| | Hello folks, I'm getting the error message "Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /var/www/login.php on line 9". I've been at it for hours and my eyes are starting to bleed, I would greatly appreciate a code-weary traveller could spot my mistake. Here's the first 10 lines of my page. … |
| | I have Webpage written using PHP that displays drop down data from MySQL tables. I want my page to refresh and appeared new entry list in drop down list, after new records are entered to the database.I want auto refresh but when submit the form only. |
 | Hi and I have a mysql table that gets a few million records inserted per day and it seems to get corrupted very often. The current database structure is myisam but it keeps on getting corrupted. Are there any mysql data structures that won't corrupt even when restarting the mysql … |
| | Hey all, Im creating a voting website using PHP & SQL. Im planning on using a single table to store votes. Something like this. -- Voter_ID -- Candidate A-- Candidate B -- Candidate C -- ### --- 1 --- 2 --- 3 ### --- 1 --- 3 --- 2 ### … |
| | Hi there, i have a bit of a problem with integrating CKeditor... I have a dynamic dropdown select box filled from MySQL, i have followed an Ajax tutorial on W3 schools [url]http://www.w3schools.com/php/php_ajax_database.asp[/url] on how to get the selection pulled from MySQL to populate a textarea where it can then be … |
| | l have got a table populated with data. l need to export and append the contents of the table to an existing table. l have got an auto_increment column which l need to change so it starts at 100 not one |
| | hai i am new to php. i am getting this as error ---You have an error in your SQL syntax; check the manual that corresponds to your MySQL--- can anyone tel wher is the error. Thank u..!! <html> <body> <form action="login.php" method="post"> <div> <table width="100%"> <tr> <td><img src="Logofinalcopy.gif"></td> </tr> <tr> … |
| | Hello Guys, I need someone's help please. I just recently started to learn MYSQL and am a complete novice. I learned a few things from here and there but it's still not enough for me to complete my ("they called it a basic simple task" ) new project. The project … |
 | hello all, i have a problem. First off, i am able to upload 200mb to mysql database; so im good there. I changed the values in "my.ini" to 700mb. The problem is, when i try to download it, i get a error 404 or something like that. Its like the … |
| | I am new to php/MySQL, so I apologize in advance for any stupidity on my part. I have a MySQL database for events, and the main table ("Brochure") has multiple Trip Leader fields, e.g., "Leader," "Assistant Leader," "Leader in Training," etc. All of these leader fields get their data from … |
| | Hi I'm new here and I have a question. Basically I have a database named data with 4 columns in it. The main one being url and I want to query based on the url because i don't want to view all of them. How can I do this? Sorry …  |
| | Hello everyone I have an issue here that I couldn't find much info about, I saw a lot about it when people where selecting a lot of data but not on an insert. Heres some background. I have an application that adds items from our in house order/inventory manager to …  |
| | How would you select all the users, whose phone number is null?  |
 | Hello friends... How can I change the order of the columns ? e.g. My columns order is: id name lastname and now I want to change the order of the columns like: id lastname name Thanks. |
| | How do you get the number of rows affected by query? |
| | When would you use ORDER BY in DELETE statement? |
| | How would you change a column from VARCHAR(10) to VARCHAR(50)? |
| | Hi!. I'm trying to get a connection from a Java application to a MySQL database. When I execute the method getConnection(url, user, pass) this is what I get: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mysql.user_objects' doesn't exist I have executed the perl script called mysql_install_db with the result: C:\Archivos de programa\MySQL\MySQL Server 5.1>perl scripts/mysql_install_db.pl … |
| | Hi, I want to create a scrapbook like orkut or in facebook. I am taking a text area on which the user have to write the text. The text can be any thing like "text with special characters as well as html codes. This text will be stored into mysql … |
| | Im suppose to search by name and active users, now the problem is I can search by name, but i dont know why active is givin me a problem.. My coding is like this, what is wrong? $sqlFilter .= ' AND (username LIKE "%'.$_SESSION['filter']['filterusername'].'%" OR active LIKE "%'.$_SESSION['filter']['filteractive'].'%" )'; username … |
| | I am having trouble with a certain query. The problem is that I am using an INNER JOIN with two tables that both have a column called "id". I want the query to return ALL the column names but in addition I also want table1.id to be returned as id1 …  |
| | Hi all, if anyone can assist I have a query which just will not resolve it self no matter what I have tried. I am testing this PHPmyadmin before I apply to the website if this helps Thanks in advance DJ The query that is being run produces duplicate row … |
| | basically this is the first time iam using the iSQL *Plus, i am confused and i just want to no, when you create a table how can you view the actual table you have created, and how do you put data into the table?.. |
| | Hello all, I have a page that allows the user to update their account detail. The prblem is that when the page loads the users inforamtion doesn't appear in the text fields. I've checked the code and i cant see any errors nor does php flag any errors. Can someone …  |
| | Hello All, I have been trying to copy a database from a local system to remote system using the mysqldump command.However, I am not able to do so.I just wanted to know syntactically where am I going wrong? Here are the commands I have tried: mysqldump database-name | ssh [email]myname@mysql.cs.abc.edu[/email] … |
| | Does any one know how to use SQLite? Can anyone tell me how to convert populated MySQL tables to SQLite tables without using a DBConvert software? |
| | We are an American company, doing business world wide, we have a lot of members coming on board in Russia, Estonia, Latvia, Africa and lots of other places. They are all asking for us to translate the web pages. So I programmed in a language translator, where we can give … |
| | I am having issues with the following code of mysql when using the "not like" mysql command. My snippet looks like this [CODE]$name = something $sql = "Select * from table1 where table1.field1 not like ' $name ' ";[/CODE] What it should look like in phpmyadmin is [CODE]Select * from … |
| | can any one give the code for join the table in left join method in phpmysql ? |
| | Hi guys... I know little to nothing about this and i was told to run this command, but I got this error when I did...does any know the correct syntax for this? I appreciate your help and thank you in advance! Error SQL query: CREATE TABLE wp_wpmq( id int( 11 … |
| | I created a user login/registration system and the login works fine. But I can not seem to get the registration to insert the info into the database. It returns no errors and says the record is there but when you check from phpMyAdmin, the record is not there. Here is … |
| | Anybody know how to do the following: id (PK/autoincrement) file_id (FK/int) - same file id pops up loads of times statement (varchar) - just some text from the file status (tinyint 0/1/2) - depending on the statement = 0 or 1 or 2 into a single record for each file_id, … |
| | hi first of all i want to create a linking with two tables in database: 1 table : id,name 1 nick 2 john 3 michael 2 table (i want to use this table for dropdown list) id,job 1 engineer 2 scientist 3 coder how can i link them both? the … |
| | Specification: I wrote most of the code separately but seems am having difficulties linking it to my database: Write a simple E-commerce application, which may be a bookshop, music shop, clothes store, or anything else you wish. There should be a “user” interface to allow customers to select and purchase …  |
| | I wan to host my own content, but I can't figure out where to put my files. I'm using WAMP, [url]http://www.98.163.121.220.com/cgi-sys/defaultwebpage.cgi[/url] That's my site. How can I just host my own files? |
| | please any one help me i want display images from mysql database to my web page... i have no clear idea about that please help me.. i want script that will upload file and also display files in date vise. And also i want display my images like my attachment. …  |
| | Hi All, i want to develop a realtime stock updation chart with js,Ajax,MySQl and Eclipse. Environment with MySQL,JS and tomcat is established. Now how can i start with the use of Ajax into Eclipse and go through dis module is there any source example or code available ? Thank u … |
The End.