10,940 Topics
 | |
 | 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 … |
| | Hello all, I need help with part of an assignment that is due Sunday. This is my first week learning mySQL so clear and simple descriptions will be well liked. Here are the instructions. a)When adding a customer, add the customer's balance times the sales rep's commission rate to the …  |
| | Im working through sprocs with MySQL and I came across something that made me quite uncertain... I learned sprocs with MSSQL and I am used to declaring as such: create ... myProc (@var type, @var2 type(xxx)) as .... and for declares, we declare vars as declare @var3 type(xxx), @var 4 … |
 | i want to make comment box in my own site so i have to make database online but it shows some error, Please help me.!! this is the code <?php $comment = $_POST['comment']; $submit = $_POST['submit']; if($submit) { if($name&&$comment) { $con= mysql_connect("localhost", "root",""); if($con) { $query="create schema IF NOT EXISTS …  |
 | Hi,everyone.. I was wondering.. Is it possible to carry out other tasks in a php application while data is being uploaded(by that application) into a MySQL database? |
| | Posted earlier in the wrong forum...update here: Hey there...my code below had tradtionally only updated 1 of 4 fields. Now I want to update 2 of 8, but when I enter two variables it crashes. Any help would be appreciated. Code is here if( isset($_POST['Submit']) && $_POST['Submit']=='Submit' ) { foreach($_POST['CFHL_A'] … |
| | I have a code that places the time into a database in the format Year-Month-Date Time. The time isnt in Pm or Am. I want to change the code from that into Month/Day/Year and the time in am or pm. Is this possible? Or should I be using a different … |
The End.