11,093 Topics
 | |
| | My Alter Table Editor Window Not Coming Up in Mysql Workbench? PLEASE CAN SUM1 HELP ME! ^_^ My Alter Table Editor Window will Not open up.. Is there a way to make it open???? Im using Mysql Workbench Thanks! |
 | Hi, I'm making a custom user management class that inherits from DBManager class. The problem I have so far is executing queries using mysqli prepared statements. DB connects fine but then prepare statement fails. I have mysqli object as an attribute that is shared in the class. I'm new with … |
| | Hi Friends i am having one master table for category which contain 7 fields, i am having sitename as a table which contain 8 fields, if i create [B]newsite[/B] name then it has to copy all the fields from master table in addition to that it has to display the … |
| | I would like to know how to a use a text box in winform to name the table . can anybody help me please I am using the following statement to create table SQL = "CREATE TABLE tbCatalogue ([Id] COUNTER, [Stock Code] TEXT(10), [Account Number] TEXT(6))" |
| | I have these two queries which i want to run together and not one by one. How can i do that? Or can it be modified to be one query. [CODE] UPDATE runquery.table1, runquery.table2 SET runquery.table1.`Column1` = (runquery.table2.`Col1`/runquery.table2.`Col2`*100) Where runquery.table2.`itemid` = 3 and runquery.table1.`Userids` = runquery.table2.`userid`; UPDATE runquery.table1, runquery.table2 SET … |
| | I'm using mysql and phpmyadmin to create a video rental database and I've been having problems with the auto_increment feature and the numeric data type. I have auto_increment on multiple tables for their table id's. The problem is when i enter data into the tables the counter doesnt reset. So … |
| | Hi, Need some guidance here parts of my DB need to be updated by data from another system's DB, what I'm gonna get are CSV files with data that isn't exactly the same as my DB, meaning, the tables aren't the same structure, the fields don't have the same name/format..some … |
| | 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 … |
 | I have resolved a couple issues on my site thanks to you all, and hoping that you can come to my rescue one last time, because I am at wit's end trying to figure this one out. I have a shopping list on each page. Normal grocery store items; users … |
| | Hi I coded a calendar pop up with events and I wanted to be able to join the event table with a timecard table but im not sure if im doing this correctly. What it is suppose to do is when they add stuff to the calendar the person can … |
| | I need help using a mysql user defined function in php. What i want to do is use the mysql function to perform a query to get the count from the inventory table whose movie_id's are equal to the movie_id entered by the user. And then I would like to … |
| | 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 // … |
| | |
| | I need help using a mysql user defined function in php. What i want to do is use the mysql function to perform a query to get the count from the inventory table whose movie_id's are equal to the movie_id entered by the user. And then I would like to … |
| | 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), …  |
| | |
| | I am making a mysql fulltext search. my database table article1 has ~18000 articles, article2 has ~7000 articles, article3 has ~13000 articles. FIELD cat is a INDEX field Now I want to make a union search. there are 5 groups words put into 3 table, match out the results. But … |
| | I keep getting this error when I try to run and print out the results of my database query. I know that this error usually mean that my query failed but i can't figure out what is wrong with it. [CODE=PHP] $genre=readline("Enter Genre: "); $query = "SELECT movie_title FROM movie …  |
 | 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.  |
 | hi, although, database is connected and admin table of my database consist of 2 rows of data, I still get 0 value for $numRow=mysql_num_rows($result); And mysql_fetch_array doesnt fetch values properly plz can any body help me thx in advance [code]<?php //include_once 'config.php'; /* 1. Got the username and password from … |
| | 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) … |
| | In mysql, the table consist of informationtype, status and informationno , [CODE] $information = mysql_query("SELECT * FROM table WHERE informationtype='message' AND status='waiting'"); $row = mysql_fetch_assoc($information); $result=($row['informationno']); [/CODE] The query result are 4 rows. The informationno are 11001; 11002; 11007; 11009; If I intend to express the results in term of … |
| | i've been attempting to execute this code , all i got was an error. [CODE]<?php $connect = mysql_connect("localhost","root","") or die ("connection failed!"); mysql_select_db("users") or die (mysql_error()); echo "connected!" $extract = mysql_query("select * from member order by id ASC") or die mysql_error(); ?>[/CODE] and this error appeared : [ICODE]Parse error: syntax … |
| | 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 … |
| | hi guys as the title which is the best in security mysql_connect() or mysqli_connect() and which one you prefer thank you for help or suggestion . |
 | 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 checked my php.ini file and there is no ; in front of extension=php_mysql.dll or extension=php_mysqli.dll. I think the I am getting this error because my figuration File (php.ini) Path is C:\Windows. How would I change it to C:\Apache2.2\php\php.ini? Also, once I have done this do I need to recompile … |
| | 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 …  |
 | 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 | … |
The End.