10,945 Topics
 | |
 | Hi, I use a query which is identical throughtout my application, only thing that differs is the select part of the query, so for example: mysql_select_db("mydatabase", $con); $result4 = mysql_query("SELECT * FROM nap where Exchange LIKE '$majorvalue%'"); while($row = mysql_fetch_array($result4)) { $psba = $row['Site']; $status = $row['Status']; $spectrum = $row['InSpectrum']; …  |
| | Hello. I've created 2 pages that i'm currently working on. One is called; Test.php -- which just includes a basic form in HTML. <Form name ="form1" Method ="POST" Action ="result.php"> Building Name: <INPUT TYPE = "TEXT" Name ="buildingName"> Room Number: <INPUT TYPE = "TEXT" Name ="roomId"> <INPUT TYPE = "Submit" … |
| | Say I have 2 tables: Table 1 Name - Toys - broken - recurrence Jack 6 4 0 John 8 3 1 Mark 8 2 2 Jack 4 2 1 John 3 3 1 Mark 6 0 2 Table 2: Name - Toys - recurrence COlumn Name: name Column Toys: … |
 | **Hashing Method** // If the two SHA1 hashes are the same, returns true. // Otherwise returns false. private static bool MatchSHA1(byte[] p1, byte[] p2) { bool result = true; if (p1 != null && p2 != null) if (p1.Length == p2.Length) for (int i = 0; i < p1.Length; i++) … |
| | Hi I need an help on showing related post in an website. i want to display my related posts with help of keywords column. Below is my database structure id int(12) title varchar(250) content varchar(250) image_path varchar(250) type varchar(250) keywords varchar(250) can any one please help me. Thanks |
| | Hi, I am currently creating 'Routines' to speed up the analysis of the quiz data my database stores. One of the queries I have been using which I would like to turn into a Routine looks like this. SELECT Candidate, QuizName, PercentageScore, PassFail FROM Results WHERE Candidate ='Joe Bloggs' This …  |
 | When I insert data into the database, for instance, a new client, and after that query the clients in the database, the new client is not immediately shown in the list. For it to be listed, I have to clear the cookies and log in, again, into the site. Why …  |
| | Hello, I have Error Like this when i open the table in phpmyadmin.. why this is happening with table ? please any solution for that... #145 - Table is marked as crashed and should be repaired Thanks |
| | If I have a table like this: Table1 ID - sequence - value 1 1 6 1 2 4 2 1 3 2 2 2 3 2 6 4 1 5 5... Table2: ID - Firstname 1 Jack 2 John 3 Mark 4 Mary Querry Result I hope for: ID … |
| | I'm trying to build google+ sign in feature. I'm able to get all the user data from google+, how can i insert this data into database? I know js is client-side language and it is needed to be done on server side....... my code: <span id="signinButton"> <span class="g-signin" data-callback="signinCallback" data-clientid="My-client-id" …  |
| | i have two tables (they are fixed, not going to update any more) in my databae "phoneadd" phone_nos----name(primary id),home,office,college,friend. Examble: john 87954 45698 78965 12365 martin 45698 78962 45789 45789 trull 47896 14587 85632 14563 addresses----name(primary id),address Examble home first street,new town office second street,old town college thrid street,maxi world … |
 | want to update my database via email, for exm i have 3 fields in db, 1-Id, 2-Name, 3-Marks i wants to update this records by sending a email, how can i update it,  |
| | Say I have 2 tables: Table 1 Name - Toys - broken Jack 6 4 John 8 3 Mary 8 2 Nina 6 0 Table 2: Name - ID Mary 1 John 3 Jack 2 Nina 4 I need to merge Table 1 into table 2 and get the ID …  |
| | the following function "ranks" the applicants and writes them to the rank_results table in the database: function rank() { $rank = 0; $sql1 = "SELECT * FROM applicant_details"; $results = $this->db->query($sql1)->result(); $sql3 = "SELECT * FROM job_advert"; $job_advert = $this->db->query($sql3)->result(); foreach ($results as $applicant) { $applicant_age = $applicant->age; $applicant_id_number = … |
| | I'm working on an ORM experiment, and I'm looking for ideas to help choose which path to take in it's development. I currently have an index showing how to use it, two interfaces, a database class, a table base class and two auto-generated classes (representing a database table). The first … |
 | I already have a php file that catches data from an uploaded CSV file to MySQL but the problem is, every time I upload the csv file, it duplicates the data into the MySQL What i really want is, if I uploaded the first csv file, and edit some data …  |
 | PFA...!! **Please look at the table data carefully.** I need to delete the rows. I need urgent help..!! Table: CREATE TABLE IF NOT EXISTS `version` ( `nidt` varchar(11) NOT NULL, `noeud` tinyint(3) NOT NULL, `VERSION` float NOT NULL, `ETAT_FONCT` varchar(20) default NULL, `idnap` varchar(25) NOT NULL, `nidtint` bigint(20) NOT NULL … |
| | I Need some help.i just have some tables in data base, that is school ---Name(primary key),phonenumber,street,town,state,country college---Name(primary key),phonenumber,street,town,state,country Railwaystation---Name(primary key),phonenumber,street,town,state,country Hotel---Name(primary key),phonenumber,street,town,state,country In the front end, i will put two combobox and a submit button. All i need is first combo box will have to select the table.Second combobox shows … |
| | Please help, I want to connect two tables in mysql |
| | I have a problem to get result from mysql. I want this average result when i have for example two reviews: food: 5.0 prices: 5.0 lodging: 6.2 but i got this results separatly instead: food: 8.0 prices: 6.0 lodging: 3.0 food: 2.0 prices: 4.0 lodging: 10.0 and i cant figure … |
| | |
| | Does anyone know if there is a way in which I can install my own Encryption Algorithm into a MySQL database? |
| | I have a query that selects data and places it into an array. This array can contain 'null' as a results. I want to remove all the varaibles that say 'null'. I have a code that is suppse to remove all the null variables but instead it replaces them with … |
 | I am completely new to Triggers but I hear they can help me with a specific problem. I have a table: picid picture recordListingID 1 danny.jpg 0 2 jane.jpg 0 3 ralph.jpg 0 In the recordListingID column (int) i would like to generate numbers sequentially upon an INSERT. Is it … |
| | Hi All, I am pulling out info from my db and need to tjeck if a column is 0, if it is then i need to SUM 3 other columns and pull out that total. I want to use the CASE keyword and tjeck for this, but am doing something … |
| | |
 | Hi guys....ammm...I created a table in one function and then used it in another function. The temporary table is created this way: $tmpTable = "tmpTable"; myCreateTable($intHandle,$tmpTable,$schoolYr,$semester); CREATE TEMPORARY TABLE $tmpTable type = heap SELECT Payment.No FROM (Payment INNER JOIN Othr ON Payment.Autokey = Othr.key) I am passing the table name … |
| | want to restrict users to access particular webpages in my applicatipn. In my application I have 4 webpages like Mumbai, Delhi, Bangalore, Kolkata and I have havie 4 users say User1, User2, User3 and User4. All users are Admin. My requirement is that all 4 user can't access Mumbai page, …  |
| | I have a mysql database that includes the fields first_name, last_name, email. I have an input form to enter in the above information. If the e-mail address already exists, then I have a message page that lets the user know this and display the first and last name that already … |
| | my goal is to list each job_title or job_id and under each job_title or job_id I want to list the candidates that qualify for that job I have this sql query: SELECT * FROM rank_results AS result WHERE result.job_id='{$job_id}' GROUP BY job_id ORDER BY rank ASC I know this is … |
The End.