10,938 Topics
 | |
| | 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 … |
The End.