10,940 Topics
 | |
| | I have a table that a new line gets added to when the machine stops with reason for stopping, when the machine gets going again I want to add the time lost. So when the machine stops the table will look like this: [CODE]ID | reason | time_lost 1 | …  |
| | I have written the title as “Script to Group Values” for lack of a better title. I want to have a MySQL database that receives value from a form on a webpage. For example, I have people signing up for an event. I want to create something (probably in PHP … |
 | here is the database [url]http://img214.imageshack.us/img214/3852/23405199.jpg[/url] here is the form [url]http://img254.imageshack.us/img254/3518/60904005.jpg[/url] if the search click i want the selected month in the combobox search from the database table under departure field month and it will fetch on the table.. for example: <--departure--> 09/10/2010 10/10/2010 10/11/2010 [code]<select name=\"month\"> <option value=\"01\">January</option> <option value=\"02\">February</option> … |
| | i have one table.i.e Employee.my empoyee table having 22columns. i used below code.but i got error [CODE] DELIMITER $$ CREATE PROCEDURE sp_search ( ) begin declare str varchar(255); set str="select * from Employee"; EXEC(str); end $$ DELIMITER ; [/CODE] |
 | I'm in the middle of a project development, and I'm frustrated with this problem. Im running XAMPP under Ubuntu 10.04 (Lucid Lynx) mySQL version : Ver 14.14 Distribution 5.1.41 The problem is that, mySQL is accepting null values even if the field is declared with the NOT NULL constraint. Example: … |
| | I have a database hosted at a remote location. I want to access that database. But I keep getting the error [CODE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'username'@'%' to database 'db' [/CODE] This is the code that i have written [CODE] Connection con = null; Class.forName("com.mysql.jdbc.Driver"); String username = "username"; … |
 | Hey Friends! I have some tables by which i have to select the data to display in search result. Table Details user_type Table [CODE] int id string user_type [/CODE] ticket Table [CODE] int id 11 not_null primary_key auto_increment int user_id 11 not_null multiple_key int type_id 11 not_null multiple_key string ticket_type … |
| | So, not so much of a coding question but more of a development question. [B]Some background:[/B] I have finished writing a scheduling program (in part thanks to the folks at Daniweb) in PHP (using MySQL) for a small business that sells musical instruments, music lessons, and the like. The program … |
| | Hi, I used mysql_real_escape_string to insert a data with apostrophe, in the database, using php. This works. But when I want to select this data and display it in a form's field, it does not work. What happens is that the data before the apostrophe is displayed in the field, …  |
| | <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type"> <title>Edit</title> </head> <body> <?php $con = mysql_connect("************"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("**************", $con); $1 = ($_POST['1']); $2 = ($_POST['2']); $3 = ($_POST['3']); $4 = ($_POST['4']); $5 = ($_POST['5']); $6 = ($_POST['6']); … |
| | Can anyone see what is wrong here? This is my first serious attempt at this.[CODE]<?php $query1 = mysql_query(" SELECT topics.url_big, topics.url_small, topics.title, topics.".$egroup.", quiz.passState FROM topics INNER JOIN quiz ON (topics.managerId = quiz.".$managerId.") WHERE topics.".$egroup." = 1 ORDER BY title ASC"); ?>[/CODE] |
| | I have a complex query I've been wrestling with for 2 days and can'seem to get it to run. I've tried LEFT JOINs and sub-querys and GROUP_CONCATs and still can't seem to get this to work right! What am I doing doing wrong? Lets say I have 2 tables in … |
| | Hi, I can't manage to set a root password no matter what I try. I've tried to uninstall and reinstall. I've tried to get the new version and replace the old one with it. I've totally deleted all mysql files off my machine and reinstalled mysql but I STILL get … |
| | Hi there everybody, I'm working with a company and they are looking to set up 2 server a UK and a US server. This is good and I know how to check what country the viewers are coming from and redirect them accordingly, I also know how to share the … |
| | Hi everyone I know there already is a thread on that one, but not enough for me to make it work. So I know I can do : $command = "mysqldump -u [username] -p [password] [databasename] > [backupfile.sql]"; then system($command); the thing is, I'm on a web server (hosting company) …  |
| | I have the following code:[CODE] if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) { $insertSQL = sprintf("INSERT INTO inventory_software_request (Software, Name, NISD, Room) VALUES (%s, %s, %s, %s)", GetSQLValueString $_POST['software[]'], "text"), GetSQLValueString($_POST['name'], "text"), GetSQLValueString($_POST['nisd'], "text"), GetSQLValueString($_POST['room'], "text")); [/CODE] to send data to a MySQL database. the form includes a list of software … |
| | Hi, How do I go about creating a XML document from information requested from multiple tables ? Do I need to split the queries up or can I just run it as one complete query ? Then how do I set it up so that information is output into an …  |
| | I'm a novice when it comes to MySQL so I'm not too sure about how to go about this. I have two tables, and both tables have two fields I need to deal with. Table investors has fields Dealer and Rep. Table advisors has fields dealer and rep. investors.Dealer = … |
| | hye guys.. i've got a problem on inserting the data from mysql database into the textbox in php.. i dont get any error reply..but im still cant retrieve the data from the mysql database into text box in php.. below are the print screen and my sourcecode: this is the … |
| | I need to make a Registration show hide based on whether you are > 48 hours or =< 48 hours out... I wrote this before based on a start and end time... [CODE]<?php $startdate = $row_product['startdate']; $enddate = $row_product['enddate']; $todays_date = date("Y-m-d"); if ($enddate <= $todays_date) { header('Location: expired.php'); } … |
| | how to nsert and retrieve image into mysql database?  |
| | hi everyone i am having a problem in my mysql class to retrieve the stored data in database. i want to retrieve data in view class calling controller class and then model class for select query. plz help me the code is bellow. call from view to controller in line … |
| | Hi, I want to make the table for (hold on book),So my fields are book_name Dt_placed_on no_of_books Dt_expires_on So is there any more fields i need to add?Please mail me. |
| | Error Database connect failed Warning: mysql_error() expects parameter 1 to be resource, null given in /home/globilla/public_html/inc/classes/BxDolDb.php on line 447 Fatal error: Call to a member function getParam() on a non-object in /home/xyz/public_html/include/db.inc.php on line 83 please help me to sort out this problem. |
| | hello, phpmyadmin have a feature that order the tables by the added in db order DESC how can i order the table to ASC EDIT: I forget to say, i don't have a row that sets added time so i can't order by rows |
| | |
| | I have a table with ~10,000 records. There is a "viewed" column which contains either 0 or 1. At some point in my code I want all rows = 1 for the "viewed" column. Does it matter if I set all rows to 1 or set all rows to 1 … |
| | I need a PHP expression to validate a field value against a list predefined in mysql database So that anything different from that in the database will not be submitted to the database. Looking forward to your assistance. |
| | I have a DB with two tables schoolresults; uniresults; Extracts are as follows: [B]schoolresults[/B] stuID Name Surname Gender Schoolname etc. (irrelevant to q) 1001 John Dawson M PretoriaHS 1002 Peter Zondi M Hillcrest (only one entry here for each stuID) [B]uniresults:[/B] stuID course mark symbol seniorCourse 1001 ECO1 54 3 …  |
 | I'm having some difficulty trying to figure out how to write a certain query. The very basics are that I have two relevant tables: `containers` and `items`. `containers` have the fields: ContainerID, ContainerName, and ContentType. `items` have the fields: ItemID, ItemName, and ContainerID. The easy part of the query is … |
The End.