10,942 Topics
 | |
 | Hey Guys, I need some help with Deleting data from a MySQL . Currently I have, Two PHP files. the First is the main page. [CODE]<?php $host=""; $username=""; $password=""; $db_name=""; $tbl_name=""; mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); $sql="SELECT * FROM $tbl_name"; $result=mysql_query($sql); ?> <p>This Page Refreshes Every … |
 | Hello I have been using SQL for a number of years, but I am struggling with an intermediate query. I want a record to be displayed as below [ICODE] 1 Ademola Adebayo 4 Women @ West Street Member 2 Christine Adebayo 4 Women @ West Street Leader [/ICODE] when I …  |
| | I want to make a query that would return data about students who failed in a specific course, the report is looking like this- studId, studName, last grade, year last course was taken, num of fails in this course. so I'm having problems writing the correct SQL query to get … |
 | How do you implement in java to select only data from a Column i a database using java |
| | Hi, i am try to display and insert info on a person into my database but i keep getting this error whenever i enter the info You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use …  |
 | I have textarea comming from mysql. In the backend the user tyes a letter type format in a textarea They ise Enter to make new rows etc __________________________________________________ Dear john Welocome to our website hope you find it usefull Thank you The Team ___________________________________________________ When I pull the data from … |
| | Greetings everyone, I'm a noob here. I could use some help designing part of a MySQL database I'm working on. This is an event database, so think of say a conference. I have sessions and every session has a session_type. A session_type might be a Keynote speech or a Workshop. …  |
| | Hi, I have been left in the lurch with a few php scripts on my site and I'm the first to admit coding is not my strong point! I have managed to fix most of the issues, but I am stuck on the following. Basically, I want to query the … |
| | here is my code i and got this error while running it [CODE] Notice: Undefined index: Reg_no in D:\wamp\www\mohammed\geo.php on line 12 Notice: Undefined index: Reg_no in D:\wamp\www\mohammed\geo.php on line 12[/CODE] [CODE]mysql_connect("localhost","root",""); mysql_select_db("new"); $query= "SELECT SUM(Reg_no)+SUM(class) FROM fee_info GROUP BY Reg_no"; $result = mysql_query($query) or die(mysql_error()); // Print out result … |
| | hey! i need to create a customised table "Employee" in which i have to insert employeeid,employeename and salary...on inserting the salary,the table should automatically calculate Hra(10% of basic salary),DA(9% of basic salary) and hence calculate net salary...so...plz guide me...how to do this? |
 | Hi I've been using mysqli and recently moved a website to a new server hosting company. They have recently informed me that the version of PHP they use does not support mysqli. I'm not really sure about the why/why not's etc but could I just change all instances of mysqli … |
| | Hello, I have a problem with this script when i will check it in the browser, the output is : "Warning: mysql_query() expects parameter 1 to be string, resource given in C:\xampp\htdocs\doto\php\new_case.php on line 8 FOUT SELECT * FROM disp_type ORDER BY t_naam ASC Resource id #3" [CODE]<?php $host="localhost"; $username="TEST"; … |
| | Hi there, I have a very basic CMS system that I wish to update within itself and on the same page to cut down the amount of pages it gives me. At present I have a content box and an edit button, this box is validated by JS and if … |
| | Hi, i am still stuck in SQL query about how to retrieve data from two tables. I have two database tables- Forecast [CODE=text]------------------------------------------------------------------- TimeStamp | Temperature | Rainfall | Wind | City_Code ---------------------|-------------|---------|-------|------------- 2011-03-13 10:00:00 |22.2 (degC) | 0 | 7 | 1 2011-03-13 11:00:00 |23.1 (degC) | 0 | …  |
| | Is this a correctly made JOIN: [CODE] // Build SUBJECT navigation and gather SUBJECT data here-------------------------------- $sqlCommand = "SELECT id, linklabel, pos FROM subjects INNER JOIN pages on id = pages.subjectid ORDER BY pos ASC"; $query = mysqli_query($myConnection, $sqlCommand) or die (mysqli_error()); [/CODE] ? Klemme |
| | I am creating a cms, where I have a Global horizontal navigation(SUBJECTS) in the top, and a local navigation(PAGES) on the left, all database driven. First I decide if either a subject or a page has been set, to display the correct information: [CODE] if (isset($_GET['sid'])) { $subjectid = ($_GET['sid']); … |
| | Hi all, I'm new and I currently am developing a website on fishing fred's fishing. The site is an experiment for a portfolio ect. There is a feature, the guestbook. The Guestbook is managed by a MySQL database and the PHP is responsible for creating and echoing the data. I … |
| | I have fields UserID, Status and etc. The status of the user will be either active or inactive. I want to count how many UserID of Active users only. I have a code here but it's not working..It says "Invalid or Unqualified reference". Can you please help me check this … |
| | Hey guys, I need some help with selecting 2 Tables from a MySQL database. Can anyone help. Currently I am using this, and I want it to be able to select from another table called Admin and Display the Admins under admins in my table. [CODE]<?php $host=""; // Host name …  |
| | Hi guys, I am working on a web application project where I use MySQL database. Now I need to export my database/table as a CSV file and I'm using SSH client to access my MySQL. I have no clue how to export it. I would really appreciate if someone could … |
| | Hi I am having a problem with code i have created to delete a customer from my database, would be grateful if someone could tel me where i have gone wrong [CODE]<?php include ('db.php'); $cid=$_POST["cid"]; $cname=$_POST["cname"]; $cusadd1=$_POST["caddress"]; $cusadd2=$_POST["caddress1"]; $cusadd3=$_POST["caddress2"]; $ccounty=$_POST["county"]; $custpc=$_POST["cpostcode"]; $custele=$_POST["ctelephone"]; $cusemail=$_POST["cemail"]; print $cid; $str="delete from customer CustomerName='$cname',CustomerAddress='$cusadd1',CustomerAddress1='$cusadd2',CustomerAddress2='$cusadd3',County='$ccounty',CustomerPostCode='$custpc',CustomerTelNo='$custele',CustomerEmail='$cusemail' where … |
| | Hello everybody i am new to PHP and trying to learn more and more. now i am trying to make a reservation system i solved my date time problem but now i am stick on comparing two date from my form with two dates on my database here is my … |
| | [CODE]SELECT * FROM question LEFT JOIN answer ON question.Que_ID=answer.Que_ID AND question.Que_Answer1=answer.Ans_Answer1 AND question.Que_Answer2=answer.Ans_Answer2 AND question.Que_Answer3=answer.Ans_Answer3 AND question.Que_Answer4=answer.Ans_Answer4 AND question.Tes_ID=7 AND answer.Use_ID=1[/CODE] This should only show record that are use_ID=1 and Tes_ID =7. But in MySQL, there are data for test ID=8 and etc. isnt it only suppose to be 7. |
| | Hi I am having a problem with code i have created to delete a customer from my database, would be grateful if someone could tel me where i have gone wrong [CODE] <?php include ('db.php'); $cid=$_POST["cid"]; $cname=$_POST["cname"]; $cusadd1=$_POST["caddress"]; $cusadd2=$_POST["caddress1"]; $cusadd3=$_POST["caddress2"]; $ccounty=$_POST["county"]; $custpc=$_POST["cpostcode"]; $custele=$_POST["ctelephone"]; $cusemail=$_POST["cemail"]; print $cid; $str="delete from customer CustomerName='$cname',CustomerAddress='$cusadd1',CustomerAddress1='$cusadd2',CustomerAddress2='$cusadd3',County='$ccounty',CustomerPostCode='$custpc',CustomerTelNo='$custele',CustomerEmail='$cusemail' … |
| | Hi, I my admin area, where the administrator can create a new page, it is also possible to decide the position of the link. It is a menu in the left side of the screen, one link on top of the other, very simple nav. I have a dropdown list … |
| | Hi all, I have a java database application which mainly deals with database operations. Im concerned about the performance, as I have many update statements. As there are many records, each row has to be updated with a calculated value. So can anybody help me out to suggest for efficient … |
| | Hey All, I have tried to work on a way to update all the date in a row called: "position", from a table called: "pages". The admin have a choise on where to place his new page, in the cms. The pages/links, are being pulled from the database by position … |
 | Hi I am experienced in ASP w/ C# but a beginner in PHP: How do I get the value of a unique index of a column of mySQL in PHP: [CODE=C#] try{ //do connect //insert data } catch(Exception ex){ if (ex.Message.IndexOf("Column_Name") >= 0) //<-- how do I do this in …  |
| | Hi, I'm using PhpMyAdmin 3.3.9 , on the tab Designer, I see the tables but I don't see the lines between them that mark the relations (like in sqlServer or Access) I defined the relations between the tables using the Relation View, so they exist..I even tried to creat relation … |
| | Hello, i am develop website in jsp as per our final year project rule of college.my project is public transportation.i am creating site for it. now my problem is to create database for bus train and flight ticket reservation.. how can i create database for it and also journey table … |
The End.