10,946 Topics
 | |
| | Hi all... Im having some trouble inserting values to my mySQL database. I have the following installed on my local system. [B]MySQL[/B] Server: localhost via TCP/IP Server version: 5.1.43-community Protocol version: 10 User: root@localhost MySQL charset: UTF-8 Unicode (utf8) [B]Web server[/B] Apache/2.2.14 (Win32) PHP/5.2.12 MySQL client version: 5.0.51a PHP extension: … |
 | Hi all, I have a 4 column table. Say the count of records in each column is 5, 50, 100, 200. the column with 5 entries, has those entries not appearing at the top of its data area. eg cars houses flights a b c d a e b a … |
| | Hello and thank you for taking the time to read my question. I am currently moving a static html site into a faux CMS and have a question about which direction is best recommended. I have series of 'News Articles' that I would like to make available through a db. … |
| | hello every body i want help for the ERD , if any missing in that pleas tell me and advise me how can i modify this ERD . this ERD for Online Library management system . the diagram attached |
| | Hi, I have the following: [CODE] $_host = $DHOY_CONFIG['db'][$connection_name]['host']; $_name = $DHOY_CONFIG['db'][$connection_name]['name']; $_port = $DHOY_CONFIG['db'][$connection_name]['port']; $_user = $DHOY_CONFIG['db'][$connection_name]['user']; $_pass = $DHOY_CONFIG['db'][$connection_name]['pass']; $dsn = "mysql://$_user:$_pass@$_host:$_port/$_name?new_link=true"; print "dsn is $dsn"; if ($dsn != 'mysql://:@:/?new_link=true') { $db_connection[$connection_name] = DB::connect($dsn); if (!DB::isError($db_connection[$connection_name])) { return $db_connection[$connection_name]; } else { trigger_error("General system error ID: 00002 - … |
| | Hi, How do I change maximum connection to mysql database and maximim user connection to mysql? Thanks |
 | Hi all I'm having trouble displaying special characters. I have a database that has a number of characters from different languages and I've managed to display almost all of them. But I still have some characters showing up as a question mark inside a diamond. The code I'm using in … |
| | i want to insert non empt values (as $im1, $im2.....) in mysql database, code is as follow, im_id is auto_increment key [CODE] $im1 =image1['image']; $im2 =image2['image']; $im3 =image3['image']; $im4 =image4['image']; $sql = "INSERT INTO `class-ads`.`images` (im_id, image) VALUES (NULL, '$im1'), (NULL, '$im2'), (NULL, '$im3'), (NULL, '$im4') mysql_query($sql) or die('Error, Posting … |
| | Hi This isn't specifically a php issue, but i would be using php for the project... i am creating a site where people can upload articles, photos, docs etc - thing is, I want to keep everything as its own entity and use tables to link articles to images etc... … |
| | Hi all, I'm still a newbie in programming world.. And I just realized that PHP has a function "mysql_insert_id()" to get the most recent id that generated by AUTO INCREMENT. But, before I use it, I want to know Is it safe to use it when many users insert data … |
| | Hi, i'm sql newbies, hope someone can help. I'm trying to do a tariff lookup table for my voip service. When a user makes a call, i capture the destination phone number which has the country code prefix (the prefix may have or not have the plus sign). I'm trying … |
| | Hey, so I have a form and i want to break down the form into 2 sections when inserting into my database. I have made 2 tables to hold my values. this is my SQL statements. [CODE] $sql_insert1 = "INSERT INTO `agent_users` (`user_name`, `password`, `primary_email`, `secondary_email`, `join_date`, `last_accessed`, `activation_code`, `first_name`, … |
| | Hi there, I have successfully setup a page using a tutorial (shown [url]http://www.phpeasystep.com/mysql/10.html[/url]) It's all working fine as it stands. I have now added another column to the database that can either be 1 or 0 and I would like to be able to change it on the update page … |
| | I have 3 tables, all linked. Table 1, Table 2 and Table 3. 1 to many. Table 1 will always have records in Table 2. However, Table 2 does not have to have any records in Table 3. I want to get the id's and names of the records in …  |
| | hi. i am senthilmurugan. i am learning to php language. one error occur. i try to connect to database. [B]Can't connect to MySQL server on 'localhost' (10061)[/B]. how to correct the error . please reply the answer... |
| | I am currently working on a client management system for my Computing Coursework and I've come to the "Client Details" section, which allows staff and admin to view personal information about each client. I've successfully coded the query and everything else around it, I'm just a but stuck on how … |
| | Hai, In one of my project I need to add some data into my data base and redirect the page to a different page. In this case I need to check whether the data has uploaded successfully and then redirect. For a rough sample mysql_query("INSERT INTO") [ICODE] if(data added ){ … |
| | Hey folks, I am loading the database from the text file using load infile command, what i wish to do is to delete last inserted data not just the last row i.e all the data i have loaded from text tile.I am working on MySQL. Thanks in advance Prankyrules |
| | Hi guys, I am having difficulties to purchase a HONEST and DECENT Linux hosting for my PHP + MySQL website. I am asking you to suggest me one or two based on your experiences because most of hosting companies offer very exciting stuff but most of them are hustlers (I … |
 | Knows the code importing file in mysql using php? that would save all the data saved in excel to mysql database..tnx GOdbless |
| | i am writing a java problem connecting to mysql database. i don't know why data type decimal or numeric woudn't store any decimal numbers. my java program would output: [code] Type was: DECIMAL [/code] when trying to insert number like 23.50. what data type should i be using? probably not … |
| | userfood table auto_id | userId | date | foodname | perserving | satfat | monofat | polyfat | protein | carb 1 ------ 1234567S --2010/02/01 -- chicken rice- --- 382g ----- 8.7 ----- 9.1 ---- 3.7 ------ 25 ----- 75 2 ------ 1234567S --2010/02/02 -- mee siam----- --- 683g ----- … |
| | I am not familiar with Linux/ Unix and I encountered a corruption. How do I repair this? Warning: mysql_num_rows():supplied argument is not a valid MySQL result resource in usr/local/apache2/htdocs/vicidial/AST_timeonVDADall.php |
| | Hi guys, I'm pretty much self taught, and I'm working on a site that stores mysql data using php. In the site I previously did, I used separate pages with a query relating to what I wanted to show, eg. a page called Manchester.php that displayed all records with an …  |
| | |
| | Hey Brother, I have need to create new table into new database from exist table of old database. So how I can copy that much table into other database. I have tried below code. but it give error at "IN". [CODE] SELECT * INTO dbo.pqrnew IN "NewDatabase" FROM dbo.pqr [/CODE] … |
| | If in big problem, I want a to add the ResultSet of MySQL in JTable.Table should in Panel. and There should be autosizing of the result. |
| | Hi all, Im failing to see why this record wont update...... [code] $sql = "UPDATE tbl_sellers SET propertytype = '$propertytype', propertyaddress = '$propertyaddress', propadd2 = '$propadd2', proptown = '$proptown', propstatecounty = '$propstatecounty', proppostzip = '$proppostzip', propcountry = '$propcountry', propbedrooms = '$propbedrooms', propgarage = '$propgarage', eighteenplus = '$eighteenplus' WHERE ID = … |
| | Hi I'm trying to input a number like 2,5 from a form into mysql but it only register 2. 2.5 works great but is there something I can do to make it accept the "comma" number? |
| | hi, I want to display the mysql records in to row and column....like [CODE]user1 user2 user3 10 20 30[/CODE] where this users are dynamic and the rows also. here is the code [CODE]$sql=mysql_query("select * from report,admin_table where report.admin_id=admin_table.admin_id and which_day='".date('Y-m-d')."' ") or die(mysql_error()); while($row=mysql_fetch_array($sql)) { $admin_name=$row['admin_name']; $activity=$row1['activity']; }[/CODE] Now it … |
| | Like if you have to run a query for one million people, how would you display the percentage of the query finished? |
| | sorry but i am new to my sql, I have just a basic question.. and that is how can i create a database or table on the server! I have learned that we can create database or table by using my sql command line... but the main problem is our … |
| | good day! Please help me here, I need to count the record according to my condition but with my code it only counts the last record in the table in MySql. Here is my code.. Thanks! [CODE]<?php //establishing connection mysql_connect("localhost", "abc", "bbb") or die(mysql_error()); $submit = $_POST['submit']; $cancel = $_POST['cancel']; … |
| | Hello, I've got a problem with my project... in short I've got a mysql db bond through a DataSet and BindingSource - if I'm editing like a user the gridview then all changes are commited to the db no problem... But I need the user to responsibly change foreign keys … |
| | OK, now that I have your attention, I've got a basic mysql SELECT question that I can't figure out. I want to return the team names for the code equivalences in the games table. I'm trying to do a lookup of the team name for both the home and away … |
| | Hi, I have got visual basic program connected with access database, well I am planning convert it into mysql in a short time. On the other hands, I have quickbook set up as the accounting package. I want to pass the information that I have in access/mysql database into quickbook … |
| | Hi all. Bit of a problem - hope somebody can help. I am trying to return lists sorted alphabetically in my native language - Welsh. The alphabet: a,b,c,ch,d,dd,e,f,ff,g,ng,h,i,j,l,ll,m,n,o,p,ph,r,rh,s,t,th,u,w,y (29 letters) Note that there are 'double characters' - these are considered as single discrete letters. Roman letters (k,q,v,x,z) can be added … |
| | <?php class UserSession { public $php_session_id; public $native_session_id; public $dbhandle; public $logged_in; public $user_id; public $session_timeout = 3600; # 1 hour inactivity period public function __construct() { # Connect to database // $conn = mysql_connect($_ENV["DATABASE_SERVER"], 'db54496', 'HQe9rpTS'); $conn = mysql_connect('localhost', 'root', ''); if (!$conn) { die('Could not connect: ' . … |
| | hi all i am using phpmyadmin and i have 10 tables in my database. my problem is that i have two tables(tbl1&2) and their respective primary keys i want to reference to the same primary key of another table (tbl3). however the primary key of tbl4 is also referenced to …  |
| | Hi. I am complete beginner in databases, so please bear with me stupid questions. I am just doing for fun a simple exercise. A faculty have students and each student have different subjects. My question is, how to store the different subjects in the db? I could make up some … |
 | i have 2 tables: category, location. i create the tables: [CODE]create database tourist; grant all on tourist.* to dbuser; use tourist; create table category(id integer NOT NULL AUTO_INCREMENT,season varchar(20),num_summer integer,num_winter integer,PRIMARY KEY(id)); create table location(code integer NOT NULL AUTO_INCREMENT,town varchar(20),hotel varchar(20),price integer,star integer,media varchar(70),PRIMARY KEY(code)); [/CODE] i want now to … |
 | |
 | Hello... i have problem with UTF-8 encoding... My database and table collation are utf8_general_ci, and when I add new insert query in the database is ok, but when I'm trying to print i got -> ???? The results are: In the database -> Дамјан Крстевски In the browsers -> ?????? … |
| | Hi all, I am working as a dba in a small bank and I got an assignment to develop an in-house tool for detecting fraud scenarios. I know the technical part of manipulating multiple data sources and mining data, but do you happen to know what tests/scenarios the banks use …  |
| | Good day! How can i display the data from Mysql with the least value of primary key and when a user clicks the next button the next to the least data will appear and then the next and so on? Please help me here, thanks!  |
| | can someone help me? sometimes when my page (connecting with MySQL database) can't open normally, page will like this : Microsoft OLE DB Provider for ODBC Drivers error '80004005' [TCX][MyODBC]Can't connect to MySQL server on 'server.doreminow.com' (10061) even this only for a while (5 - 10 minutes) but this bother …  |
| | Hi, I have a bit of a strange problem where I am unable to "echo" results from a database - I will show you the code then explaine what im trying to do [code] <?php include_once "connect_to_mysql.php"; $sql = mysql_query("SELECT * FROM table ORDER BY RAND(), LIMIT 1"); while($row = …  |
| | Hi all, I am trying to rotate adds that are from tradedoubler !! I have created a mysql db as follows id,add,link,title and i can succesfully connect via a php include and rotate my query to show a different add each time the page loads [code] $sql = mysql_query("SELECT * … |
| | Hi there, does anyone know any good tuts for displaying images using php. The thing is, I have a site that i search for a part number and it displays the info, that i can do but for some reason im lost when it comes to the images. Do i … |
 | As I said, I would like to make a PHP login /Register system that would be free for anyone. Here I have started. Since Iam not expert, then I will be adding small pieces until something emerges. I hope DW guys will help until it grows to mature. I want … |
The End.