11,093 Topics
 | |
| | How do i join two tables in MySQL to form a third table having certain columns from both the tables?:?:  |
| | Hello guys, I am trying to make a very simple booking system. The booking will be either for the current or the next year only. There are three fields; number of person, type of meal and date. In any particualr day and meal, the number of person can't exceed 100. … |
| | hi, looking for some advice on the deisgn of my tables i currently have setup. the app is a sales management system. the sellers sell insurance policies, be it life, buildings etc what i was wondering was to allow calculations of commission due from each product table (as they all … |
| | Hi everyone and thank you for helping me... again :icon_neutral: I am trying to perform a MATCH AGAINST sql query on one of my table called "what". [ICODE]id (int 11) PRIMARY org-id (int 11) keyword (varchar 100) FULLTEXT bid (DECIMAL 4,2)[/ICODE] I want to perform a search on the column … |
| | i have two table in my database which is the room table and roomtype table.i'm using phpmyadmin. [B]room table[/B] room_no r_roomtypeID [B]roomtype table[/B] roomtypeID roomtype how can i create a query that can select A random room_no from "room table " based on the roomtypeID in the "table roomtype" p/s … |
| | Hi, i am relatively new to mysql just learning the basics really. i have googled this but there is so many discussions on it. Could someone just give a simplified answer to what is the difference between using Union or Join and when would you use one or the other? … |
 | Okay, not sure if this is the right spot, but here's my issue. So, my mom is taking a php programming class, and she's learning how to use MySQL and the phpMyAdmin. She wanted to activate the passwords for the root and admin users, and instead of asking me for … |
 | This is my first post to DaniWeb, and I've read the Member Rules, so I think this is the correct forum. I have created a page in PHP that collects seven items of data then displays them lower on the same page. The data columns are: name, alignment, origin, archetype, …  |
| | working on a system with 2 tables both have the exact same fields - the tables are past_participant and course_participant - CP table has all current students whilst the PP has only past students. after a course concluded, that set of students is transferred from CP to the PP table. … |
| | Hello friends, i have developed my application in MySql. My database is distributed among the 3 servers, if 1 of the server gets updated, then i want to updated remaining servers. Otherwise i want to replicate the database...please help... |
| | Wanted help in connecting to a MySQL database named Airline having table Booking with 8 columns and performing update and insert operations. Please please help. Thank you.  |
| | Hi! I am new in PHP. I have a table which stores user surnames and 12 months each having a value of 1 or 0. I need via a form in PHP to check whether or not this value is 1 or 0, and be able to control this values … |
| | So here is my search query set [CODE]/all possible input combinations //name and id combinations if($q != '') { if($id != '') { $sql = "select * from course_participant where name LIKE '%$q%' and nic='$id'"; $result = mysql_query($sql); $num_rows= mysql_num_rows($result); }else{ $sql = "select * from course_participant where name LIKE … |
| | so there are 2 tables course participant and past participant - both have same fields. i want to write a query that selects both from course participant and past participant if search option "find all" is called. i out everypossible combination but it just doesnt get right - pls help |
| | from mysql command line, what's the command to import query from a text file? does mysql has this ability? it would be handy if so.... does the text file have to have mysql file type? please be a bit specific. thanks very much. |
| | Hi, I tried to use dynamic table names like: [CODE]create table outgoing_%Y%m%d ( ip_src CHAR(15) NOT NULL, ip_dst CHAR(15) NOT NULL, src_port INT(2) UNSIGNED NOT NULL, dst_port INT(2) UNSIGNED NOT NULL, stamp DATETIME, PRIMARY KEY (ip_src, ip_dst, src_port, dst_port, stamp_inserted) ); [/CODE] but every time i got message about syntax … |
| | Hello, I am stucked while making code in PHP. I actually want to make a table in database with name as username (of the respective user). (table should be formed only when no such table exisit before) I used session to get username and every thing is right except formation … |
| | hi i need to create a query that will query my 6 tables that have an amount column & date paid column. i need to total up all the amounts due, so therefore the datepaid column would be null. can anyone help how i would be able to view how … |
| | Hey Guys. I am quite new in C# and MYSQL, but u can definetly help me out! I am supposed to insert a new row to MYSQL server, i am unable to do so after too much of browsing kindly help me... the code till now is as... string connStr … |
| | Hello, i'm having 2 tables one is CLG and other is STUD. in CLG(columns CID-autoincrement and CName) and in STUD( three columns are ID-autoincrement,Name and CID) > im using this code to store the records into tables [CODE]$sql="INSERT INTO clg (Cname) VALUES ('$_POST[cname]')"; $id=mysql_insert_id(); $sl="INSERT INTO stud (name,CID) VALUES ('$_POST[name]',".$id.")";[/CODE] … |
| | Please can you help. I have been trying create a form to insert some data into a database. (I am coding with PHP and MYSQL). When I put any data into the field called enter treatments completed the database gets updated with the treatments_completed column containing a 0 and then … |
| | [CODE] $result = mysql_query("SELECT * FROM Users") or die("could not select ".mysql_error()); if (!$result) { echo 'Could not run query: ' . mysql_error(); } $rows = mysql_num_rows($result) or die("no rows" . mysql_error()); if ($rows > 0) { $row = mysql_fetch_assoc($result); while ($row = mysql_fetch_assoc($result)) { print_r($row); }[/CODE] Every time I … |
| | When a user logs in, the user is directed to a page called accountsummary.php. I have sessions enabled. I can successfully echo the inputed username, and echo the ENTIRE column of firstname and lastname for the entire table. The problem is that I do not want to echo the entire …  |
| | I’ve been fighting this for a few days now. I’ve found some wonderful tutorials that get REALLY close to what I’m doing, but I guess I’m too dumb to figure the last step out. I understand it in theory but I’m hoping someone can help me complete this project. What … |
| | I've LAN in my office . We work on local server there but.... is it possible for me to access localhost from my home situated far away from office? Plz help me????????? |
| | I am accessing the mysql DB via TOAD and I am getting the below error "MySQL Database error - select command denied to user for table 'proc'" When I click on the Procedures I dont see the list of SP's and see this error. When I execute the below script, … |
| | [CODE]//only completed successfully if($cs =='yes') { $sql = "select * from past_participant where completion LIKE '%$cs%'"; $result = mysql_query($sql); $num_rows= mysql_num_rows($result); } else if($cs =='no') { $sql = "select * from course_participant FULL JOIN past_participant ON completion LIKE '%$cs%'"; $result = mysql_query($sql); //$num_rows= mysql_num_rows($result); }else if($cs =='current') { $sql = … |
| | [B]SHA1 my password fields all at once by running a query, I need to know how to write the query[/B] What I want to do is update all password fields in my database to be SHA1 Can anyone help me to run a query to update all fields as I … |
| | ok so i have to tables and i want to have a query that selects all from "table a" and "table be" where "a certain variable"="$x".. how do i select all from 2 tables at once? |
 | Hey guys, this is probably a really simple question for you experts so I hope you can help..! Basically I have three separate html fields for the user's date of birth: "year" "month" and "date" All I'm trying to do is to take these three from the form and insert … |
 | hi all,,, i am storing word document in mysql db. i have to email those word document form mysql database how to do it? |
| | What I would like to do is search a MySQL table for anywhere from one to 12 seprate fields, depending on what is submitted from a search form(has 12 different things that a user can search -- its an "AND" search only) What I am unsure of is how to … |
| | hi, i had a post in php re display a countdown for policy, it got side tracked to inserting the date properly into mysql database. that is now resolved. what i have is a database setup like this, and if anyone could tell me if this is wrong design before … |
 | Very simple code, I even echo the variables to make sure they are comming through: [PHP]<? include 'config.php'; $recordid = $_POST['recordid']; $im=$_POST['im']; $bm=$_POST['bm']; $peachtree=$_POST['peachtree']; $canapprove=$_POST['canapprove']; $cancomment=$_POST['cancomment']; $canclose=$_POST['canclose']; $administrator=$_POST['administrator']; echo $im; echo $bm; echo $peachtree; echo $canapprove; echo $cancommnet; echo $canclose; echo $administrator; echo "<p>"; $result = mysql_query("UPDATE employees SET im='$im', … |
| | Hello all i am new to sql, iam having a requirement where i need to have a distinct value from the result lets say example, contacts table id name --- -------- 1 john 2 jason 3 mark address table id address conid -- ------ ----- 1 newlane1 1 2 newlane2 … |
 | Hello to all, I want to know the difference between SQL and MySQL. Also, please post links if anyone have links related to this question. |
| | Hi, I have a PHP application that stores sales transactions into database tables, etc - and we have decided to use this as an online service - which makes it great for the client. They aren't computer literate and their computers mysteriously die and disappear. Having off-site data and no … |
| | I was searching around but I could not find it: I'd like a tool(free or paid) that is able to manage multiple MySql servers from the same GUI. I know about a few thick-client apps that do this, but I need one that you can use it from internet(forget about … |
| | Hello, I've DOB field in my database with date datatype. Bt when I enter 1 March 1980 from front end it stores 29 Feb 1980 in database. Can anyone help me? Thanx a lot in advance. |
| | Hey Guys I'm gonna start on a eleave system for a business soon and I was wondering which language should I use to write it in ? Can someone give a few suggestions as I'll be using MySQL database and Apache but server side script is not yet decided. Personally … |
| | Hello everyone. I have a php webpage, where there are textforms, dropdown lists and stuff. There is Activity field in the database. Whatever activities that i do on the webpage, like modifying the text in the textbox, or changing a value for a dropdown list, these need to be automatically … |
| | mysql trigger if new row inserted into that tabe... php need to popup that values in php... can u please advise me... |
| | hi... actually me wish to have few differences between SQL Server 2005 & 2008, from interview point of view. As I have asked the same question most often. give me the basic difference as well as technical too. Thanks |
| | Hi I have a query which i run to give me the monthly amount of money that needs to get loaded to our consultants cards. Our system has changed and I need to get the same data but differently The query needs to join three tables consultants,voucher,gift_cards. The only difficulty … |
| | is there any to export data from mysql to excelsheet through PHP.. Thanks in advance..!! :D |
| | Hello' I'm using following code and getting mysqlerror Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs/..... Code is $query="SELECT ('$retfield') FROM ('$table') WHERE ('$givefield')=('$val')"; $res=mysql_query($query); if(mysql_num_rows($res) > 0){ } Upto my knowledge I'm using correct syntax bt I dnt where I'm going wrong. Can anyone help … |
| | Hi to all, Example: CREATE TABLE test(name varchar(20) NOT NULL DEFAULT ''); In the above query varchar is described as NOT NULL.Then why we are inserting DEFAULT value as '' (null). Thanks in advance, Prem |
| | I am trying to connect to Mysql from Jsp in Tomcat and I am getting Java.lang.NullPointer Exception. Please provide any help as soon as possible. I have set the web.xml and the server.xml properly. My web.xml contains: [code=xml]<description>MySQL Test App</description> <resource-ref> <description>DB Connection</description> <res-ref-name>jdbc/TestDB</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref>[/code] server.xml I have …  |
| | can somebody prove me the coding to update the database (mysql) with JSP  |
 | Hi people. I'd like to use MySQL in my application - would be an easy way for me to store users. But then I'd have MySQL credentials in my app, visible for everyone with a HEX editor, I'd suppose? And even though that MySQL user will have low privileges, then … |
The End.