7,368 Topics
| |
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: … | |
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 … | |
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 … | |
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 = … | |
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'); } … | |
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 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 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, … | |
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 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 … |
The End.