7,368 Topics
 | |
| | Hi All; I have a MySql database set up called users. The only things required to register to my website are a username and password. When this is completed, the database populates with the users info as requested. How does MySql make this new users permissions to have it where …  |
| | Hi, I have this code that adjusts the position of the subjects and the pages in my site. This is working where the value of the radio button = 1 (which is = showing, in the database - And 0 = Not showing) And I am talking about pages for … |
 | Hello, What I am making is a block of code where it "balances" the load for support tickets on a website. I know that my setup may (most likely will) not be the best. I'm looking for working, not a lecture on how to do everything and have it all … |
| | hi all, l created php submission script and l wanted to how l can create another script which allows me to view all the submissions made in an orderly manner? |
| | Hi all, was wondering if I could get some help with my code. I want to be able to insert a person and details into a database, however i keep getting a syntax error, and not very experienced so was hoping some one here could help. thanks dbConfig.php [code=php]<?php // … |
| | |
| | Can anyone help me figure out why the table movie_actor cannot be created and how to fix it? I know it's the only table without a primary key, but I don't see a need for one. [CODE=MySQL] create table actor ( actor_id int not null auto_increment, first_name varchar(20), last_name varchar(20), …  |
| | |
 | Hi guys! i wonder how can i save image path in a string to MySQL, i mean...what instruction i have to use...i want to save it to MySQL and then show it into a picture box. Thank you very much for your help.  |
| | I'm trying to load a CSV file into a database table, but having some issues. [CODE] LOAD DATA LOCAL INFILE 'Report_1.csv' INTO TABLE report_1 Fields terminated by ',' ENCLOSED BY '\"' LINES terminated by '\n\r'( company,key_code,dlr_code,rep_code,dlr_name,first_name,last_name) [/CODE] This gives me the following error: [ICODE] File 'Report_1.csv' not found (Errcode: 2) … |
| | Hi, I have gone over and over the subject and still confused. I currently develop in PHP 5.2.x along with MySQL. (awaiting host to upgrade to 5.3.x, hopefully not to long although on local i develop using php 5.3.5) Currently i use the standard MySQL functions in PHP like: [B]mysql_connect()[/B],[B] … |
| | Hello, I've got a problem with simultaneous placement of an order in a webshop. I will start off with a general description of the problem, and provide details after that. **The problem** Orders are stored in the table 'orders'. Each order has a BillNumber, which is obtained via a mysql … |
| | On executing the DELETE statement I keep getting the error about foreign key constraint failing. What do I do?  |
| | I'm creating a html form that allows the user to search for people in a database. I want the form to work with drop down selects and radio buttons. Currently I'm using an if { } elseif {} else if{} format to my script. However this causes a problem because …  |
| | I have a html form where a user can narrow down his or her's search. For example they want to find a person based off of a number of characteristics, say hair color, eye color, body type. These are selected by a drop down menu and there are additional radio … |
 | we have a mysql server running from mac os x. i dont like mac but the server has been here forever. a client machine received the 'too m any connections to server' error. my colleague restarted the mysql server - and now the mysql server service will not start. does … |
| | I am trying to get information from my database that contains a foreign key that relate to another table, I am trying to enter details of an order and then have the customer ID of that order enter automatically from the customer table. [CODE] [B]Customer Table [/B] CREATE TABLE IF … |
| | Hi, I have a fully pledged membership system and want to integrate my own user referral system but want some tips, advice really on the logic of it. Basically already registered users on my site will have the option to refer people, only registered users. I will try to explain …  |
 | 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 … |
| | 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 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 … |
| | 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 … |
The End.