7,368 Topics
 | |
 | Hello, I am trying to rename database MySQL: RENAME DATABASE old_db_name TO new_db_name; 1 kesalahan ditemukan dalam analisis. A rename operation was expected. (near "" at position 0) Query SQL: RENAME DATABASE wwwsoulf_revsoul TO wwwsoulf_revsoul2 MySQL menyatakan: Dokumentasi #1064 - You have an error in your SQL syntax; check the … |
 | Hi I have the following form at [http://test.genealogyresearchassistance.co.uk/newLinks.php](http://test.genealogyresearchassistance.co.uk/newLinks.php) The code is <form id="add" action="add.php" method="get"> <label for="name" id="name">Name of site</label> <input type="text" name="name" required="yes"><br/> <label for="link" id="link">Link of site</label> <input type="url" name="link" required="yes"><br/> <label for="desc" id="desc">A bit about the site</label> <textarea name="desc" required="yes"></textarea><br/> <label for="location"> Location:</label> <?php include 'database_conn.php'; $sql …  |
 | Hey, I have two columns. Ride and booking. In table booking there is the foreign key of ride. The intention is that 30-day and later bookings will be removed. If I run this query, I get the error message: mysql 1451 can not delete or update a parent row The … |
| | Hi, I'm back ^_^ Ok, I almost have this cute thing working. I know I am close but I have no idea how to get this working the right way. I am Left Joining a few tables and I want to filter the results after multiple values. ...... Ex: Options …  |
| | I want to search a combination of values from any given field that has a list of items. Example: id | nume | denumiri_job 1 | my_list | chair,apple,snake,can How can I search for 2 or more elements from the field list? For example if I input in my search … |
 | Admin USERNAME: IT-1 PASSWRD: IT-1 Nw use index.php file t lgin. If an errr ccurs that “Multiple lgins nt allwed” then run errr.php and try again. 2. Nw yu will see the Accunt Details f Admin. 3. Fllwing ptins are available in the interface: Hme: My accunt: T view the …  |
 | Am trying to create edit-form but there are some problem which I cant determine by my self. I cant echo inserted record and updating. <?php include("db_con.php"); $edit_reg_no = filter_input(INPUT_GET, 'edit_customer_detail', FILTER_VALIDATE_INT, ['options' => ['default' => NULL]]); if(isset($_POST['update'])){ $update_reg_no = $edit_reg_no; //getting the text data from the fields $d_fname = $_POST["d_fname"]; … |
| | Hello SQL Gurus, This Query below is doing the job but it is horrible slow. Is there any way to make the query faster ? Perhaps a join .. inner outer, left ? I am looooost. Thanks for any help. SQLQuery1.SQL.Clear; SQLQuery1.SQL.Text:= 'SELECT * FROM orders_batch WHERE invoice_no=:elorder_no'; SQLQuery1.params.parambyname('elorder_no').Asstring := … |
 | Am able to use this code to bind a.id = :auc_id in order to display certain result needed for menu code, but when i introduce it in the submenu i dont get any result below are the codes for menu and submenu' MENU works fine, display whats need to be … |
| | Hi not sure if this is possible so wanted some guidance.. I have a database with 3 columns.. id, data,timestamp id is auto increment and data is json array and timestamp is unix timestamp.. the field I wanted to update was data but I wanted to replace just a part …  |
 | hi guys, anyone can sauggest me which institutes are best to learn oracle in india . |
 | hello everyone , i have follwoing table structure check_id(pk) | user_id(fk) | check_in_time( timestamp ) | check_out_time( timestamp ) | is_checked_out(0 or 1) | checked_by | family_id now i want to calculate average of all checkIn and checkOut of user per day and then plot these data in graph this … |
 | I am using OS Ticket and I have another site for Members Area,I am trying to join the 3 tables that have the information that corresponds to the customer by EMAIL. the first table is:qbcd_ticket: ticket_id | number | user_id | user_email_id | status_id | dept_id | and more... 5 … |
 | Hi, Imagine there is a tbl called "users" and it has a column called "your blog url". Now, imagine you want to display that blog's url in an iframe on one of your pages. How would you code it ? I did the following but the iframe fails to load … |
 | I need to separate the questions to atleast up to unemployment and after clicking the button it will go to another page and it resume the user from answering the question.. Thanks in advance.. <?php include('connection.php'); ?> <?php session_start(); if(!isset($_SESSION['id']) || $_SESSION['privilege'] != 'user'){ if(session_destroy()) // Destroying All Sessions { … |
 | Hi, I am new to this concept. I donot know how to make certain coulmns to be readonly , but when uploading it into server , I have to access that column value, I used this comment but it is not working. Here $avst is my excel file object. $avst->getActiveSheet()->protectCells('A5:D5', … |
 | First Input is No. of Kids. How to create Age Group field for each kid. e.g. If 1 is selected create 1 age group field. If 2 is selected create 2 Age group fields. And so on. **First Input** <select name=""> <option selected>No. of Kids</option> <option value="">1</option> <option value="">2</option> <option … |
| | I am working on creating a BEFORE UPDATE trigger which should display an error message if I UPDATE a student's EnrolledDate with a future date. For example, the last inserted EnrolledDate in the Student table is '2016-10-18', so any other record after that date should flag an error message saying … |
 | Hello, Recently I am starting to code my scripts in PDO method to manage the information in a mysql database. In this case I am having an issue how to use the best practice conditions when dealing with a POST **int** value. With the posted values I am making a … |
 | HELP HELP HELP!!! I need an assistant on a project am working on using php/javascript. Its a forced matrix. HOW DOES IT WORK? A person is automatically assigned three downlines without any referral based on id. Starting with the admin, lets say 100 persons register, three will be placed under … |
 | Only one of mysql databases stopped working. Unfortunately, it was the most important database: Table was marked as crashed and should be repaired. It happened on MySQL 5.6, and I don’t know how to overcome this error. I need to restore microsoft my sql 2000.  |
 | Output PDF is overwrite, please solve this. advanced thanks <?php require('mysql_table.php'); class PDF extends PDF_MySQL_Table { function Header() { //Title $this->SetFont('Arial','',18); $this->Cell(0,6,'World populations',0,1,'C'); $this->Ln(10); //Ensure table header is output parent::Header(); } } //Connect to database mysql_connect('localhost','root',''); mysql_select_db('pro'); $pdf=new PDF(); $pdf->AddPage(); //First table: put all columns automatically $pdf->Table('select * from products'); … |
| | Ladies & Gentleman, Or should I say 'Gentle Ladies' and 'Hard Men' (tough guys)! :winky: Here is my very latest (New Code) reg.php. I have modified it by: * Removing outdated strip tags, mysqli_escape_string. * Bound input parameters on the user reg form. * Added htmlspecialcharacters code on output to … |
 | Actually the form below is a registration form, and i only have ' username, email, password and confirm password field' so i want to add another field name job, but keeps getting error. see the code below; if (!preg_match("/^[a-zA-Z ]+$/",$name)) { $error = true; $name_error = "Name must contain only … |
| | New Friends! :) The following is my member registration code as of latest. ISSUE 1: I get this error: Parse error: syntax error, unexpected '_' (T_STRING), expecting ',' or ')' in C:\xampp\htdocs\e_id\register_edited.php on line 10 What is wrong ? I copied the "'images/'_$FILES['avatar']['name']);" from a youtube tutorial on how to … |
| | Hi, i am beginer to codeignitor,i know how to write basic active queries in CI. i want to know how to write a query(having multiple conditions,double parentheses) in which supports CI. query is: $query="SELECT * FROM `apply_special_leave` WHERE ((`from_date` <= '$dt1' AND '$dt1' <= `to_date`) OR (`from_date` between '$dt1' AND … |
 | Hello everybody I'm looking for someone to help me about my problem, im trying to display user details after login with allow user to edit some fields . the user can edit these fields password repassword description address telephone email and these two fields not allow to edit only display … |
| | Guys & My Ladies, This LOGIN.php was working lastnight and so I don't know why not now. The ELSE at 53 gets triggered even though I have typed the right password! What do you think of line 16 ? ... if($numrows >1) I tried the following but no luck: if($numrows) if($numrows … |
| | I'm trying to build a script that adds multi entries into same single cell or mysql row. The script tries monitoring what you are browsing via the: <pre><input type="text" name="browse_url" size="120"></pre> and then record your viewed urls into the same row (position: 0), column: browsings like so: 1.com,2.com and so … |
| | Buds! How to code so php forces mysql to show only the final row of the column ? The followings are how I coded (2 copied youtube tuts) to show all rows to allow user to delete multiple rows: SAMPLE 1 [php] <?php session_start(); require "conn.php"; require "site_details.php"; ?> <!DOCTYPE … |
The End.