11,093 Topics
 | |
| | 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 … |
| | Does anyone know of any PHP and MySQL code that will help me out? I'm looking to translate my website but without the use of Google, Yahoo, Bing and so on, but would like to try drive the website through a database. The idea was to have friends from around …  |
| | Hi all, i don't know how to solve this problem...i want store all the data into database. help pls~ thanks~ <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <link href="/style.css" rel="stylesheet" type="text/css" /> <title>Insert New Institution</title> <script type="text/javascript"> function addRowToTable() { var tbl = document.getElementById('tblAddress'); … |
 | Hello I'm having trouble solving the following error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '( )' at line 1 I have a php script which I've written in PHP6 which creates … |
| | Hi everyone, I wrote an INSERT for an insert form but for some reason it wont save the data tot he database. In phpMyadmin the rows are taken up with blank nothings. It seems to work but nothing is being stored. code as follows... [CODE]session_start(); $db_hostname = "localhost"; $db_password = … |
| | Hi I am trying to write a query that will return the gold, silver, and bronze medalists for each individual-based event. The relational schemas are: EVENT(Event_id, Event_title, Event_team, Event_gender, Sport_id) GAME(Game_id, Gtype_id, Game_year, game_website, game_cancel, Country_id) GAMETYPE(Gtype_id, Gtype_title) SPORT(Sport_id, Sport_title, Gtype, id) CONTESTANT(Cont_id, Rep_id, Comp_id, Team_id) MEDAL(Medal_id, Medal_color, Cont_id) REPRESENTATIVE(Rep_id, … |
| | Hello all, I am new to php and thus far i'm love the potential this language has as I learn more about it. I have been trying to write a script to no avail. What I am trying to accomplish is to setup a sms site from web to mobile. … |
| | I am having a hard time understanding subqueries. I am pretty sure that is what I need to accomplish my task, but not sure how to put it together. I have a unique ID field that auto-increments, so that a new entry always gets a higher number assigned to that … |
| | [QUOTE=nav33n;813365]Where are you inserting the value to client table ?[/QUOTE] I have two tables; school and courses and need to insert records into the courses table that have the same school id as the corresponding record in the school table  |
| | Hi, I have the following extract from a table called results. StudentID Course Percent 1005 MAM1 63 1006 PHY2 55 1006 MAM1 71 I need to produce a list of student ID's WHO take MAM1 AND PHY2. I first selected all rows where course is MAM1 OR PHY2, but then … |
 | Hello Guys....i am very happy to interact with u all. Im new to database. i want to display database names into a dropdown list box and at the same time if i select a particular DB it will display all the tablenames into another dropdown list box... Can any one … |
| | i am developing a social networking site as my project in college. i have a doubt on php and mysql.. """ I TWITTER OR FACEBOOK OR IN GMAIL WHEN THERE IS NO ACTION FROM USER(BROWSER) THAT IS, THE USER LOGS IN AND STAY STILL(NOT RELOADING THE PAGE). HOW CAN WE … |
| | hi all, i had 4 text boxes. 1.Emp_id 2.Emp_Name 3.Mobile No 4.Blood group and a search Button. so when i fill any textbox or all the textboxes then it should display the required data. For example: If i want some person details. i know only his name.Then if i enter … |
| | I save prices data for different days. If a day doesn't have any changes, it is not in the database. table prices date | price ---------------------- 2010-10-01 | 200 2010-10-02 | 200 2010-10-03 | 220 2010-10-06 | 260 2010-10-09 | 190 ... Now I need to prices for statistic purposes … |
| | Hi I'm a newbie to PHP and mySQL I have the following problem. I have a database with mp3's which I query by artist name, I then print the results in a table with a maximum of 15 rows. I can then have a next, prev, last and first button … |
| | i have a prob to insert the data that i've select from the mysql database into the textbox in php..[CODE]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>New Doctor Record</title> </head> <body bgcolor="#FFFFFF" text="#000000"> <p> </p> <?php $host = "localhost"; $uname = "root"; … |
 | I have read through the FAQ sticky regarding this topic (and have also searched/read here further on this topic) but I am still receiving the following error: [B][I]Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/a4542527/public_html/index.php on line 8[/I][/B] The scripting for this is basic at …  |
| | Hi, I have created a program in Python which creates a database called inb104 and loads the data from text files into the mySQL server. The code works perfectly fine. The data is inserted into the table without any issues. The problem is that I would like to place the …  |
| | hi all, i am trying a query but i am not getting the result properly.. Is there any error in my query.. [CODE]$query ="select Emp_Id,First_Name,Last_Name,Gender,Mobile_No,Email_Id,Blood_Group from Employee where"; if($empid!='') { $query1=$query . " Emp_Id like '".$empid."%' and"; // echo $query1; } if($empname!='') { $query1=$query . " First_Name like '%".$empname."%' and"; … |
| | Hi, I am using Tiny MCE as a Textbox to get user generated input which can be bold, italic, underlined, lists and different alignments. When the user submits the form data the information is then saved to a variable like below: [CODE] $jobDesc = mysqli_real_escape_string ($dbc, $trimmed['txtJobProfile']); [/CODE] The I … |
| | Hello I want to do that after submitting form it will insert in a table. the table has auto increment field. name of the field is ID. Now how can I get the ID number of that inserted data's ID number. for example I have a table which field are … |
| | Hi. I want to have a query as below. [CODE] $sql = "SELECT amount FROM payment WHERE id = '$a'"; $result = mysql_query($sql); $row = mysql_fetch_array($result); $amount = $row['amount']; [/CODE] The value for $a variable is getting from the selection on drop down list. For example, the user select id=11, … |
The End.