11,093 Topics
 | |
| | I have a table that looks like this: [code] Database: Testdb Table: Testtable ID | Value -------------- 1 | 105 2 | 105 3 | 105 4 | 105 1 | 255 2 | 255 2 | 311 3 | 311 4 | 311 1 | 500 3 | 500 … |
| | Hi, I have stored 800 images in root/Images and store link in DB for reference along with another information. There is a search box through which I get all the info. For viewing images I used [ICODE]<a href=".$row['image']." target=_blank>".$row['ch']."</a>[/ICODE] Ch value is click here to view. Now I want that …  |
| | Just wondering if it normal and acceptable use both on one string before entering it into a database or displaying it? For example: [CODE]$project_name = mysqli_real_escape_string($dbcon,htmlspecialchars($_POST['project_name']));[/CODE] |
| | Hi, I am new to mysql.I have two questions. 1)why AUTO_INCREMENT Have primary keys.? 2)Why should we declare default in below example? (ex)create table test (name varchar(15) not null default ''); Regards, prem  |
| | Hi, my table has id,startdate,enddate,starttime,endtime,salelocation,imagename both dates are in date type and starttime and endtime are in time type. I want to check if my data consisting of startdate,starttime,enddate,endtime cannot be present in table and must be a valid date and time duration. How to check this valid date and … |
 | Hi all, Im pretty ok with PHP and have recently been breaking down a project using foreign keys to identify various bits of information. This is my problem. I have an items table, which is made up of ID, country and area. It previously has the actual word of the …  |
| | I have this table publication_en Field Type related varchar(200) public_area int(11) title text detail text file varchar(200) and i am trying to do this INSERT INTO publication_en (related, public_area , title , detail , file) VALUES ('none','1','"helped"','la' "kajakjajk"','J3.pdf') but it doesn't work any idea why it doesn't work ? Thank … |
| | Hi, I want to learn sql injection.I searched in google but the information is not sufficient to me.Will u provide some links to learn sql injection. thank u  |
| | hi i am getting field names in $productname through post method that i have to insert into while loop.... while($res=mysql_fetch_array($result)) { $resproductname=$res $productname;']; } is there any way to do that ...plz help...thanks in advance... |
| | i have some problems with mysql database query and its as below : Tables : i) departments id department description ii) farmers id name sex address age category remarks iii) scientists id departmentid name remarks iv) scientistvisits id scientistid farmerid datevisited purpose remarks Here, i want the query of number … |
 | Hello DaniWeb Community! I am trying to create a web page that utilizes Ajax and PHP to connect to my mySql database and look up a username and password. You have all most likely seen the web page that has the template code on it: [url]http://www.phpeasystep.com/workshopview.php?id=6[/url] This code is nice … |
| | Hi friends, I have a form to create a company details.. which will insert the details into a table. For this table, I need to have a auto increment field as character.. when we have autoincreament as Integer... whenever the new company is created..the number will increase from 0, 1, … |
| | Hi, I have developed a database web application, in that, a database has 2 tables with same structure. I am using MySQL querybrowser to add, update and delete the records. So, now my question is how can I move the tables records from one table to another, without writing a … |
 | I Use visual Basic 8.0 and Mysql 5.0 I have one Table1: [COLOR="Red"]Table1[/COLOR]: RecordID , Integer = primary key auto_increment NOT NULL Articlenr , Integer Articlename, Char(20) Table1: has two records: RecordID, Articlenr ,Articlename 1 , 1000, Hamer 2 , 2000, saw I want to use Datagridview to update Mysql … |
| | I'm making a photo album with my own CMS, part of it is adding photoalbums to it, but i'm having some trouble linking the "click on album name" to the loading of the correct photo album. my 2 tables are gallery_categories, primary key: id and gallery_assests, primary key: cat_id What … |
| | Hi All, Can anybody see why this code wouldnt update the database? Cheers Paul [code] $me = $_SESSION['user_id']; $user_title = $_POST['user_title']; $user_fname = $_POST['user_fname']; $user_lname = $_POST['user_lname']; $user_add1 = $_POST['user_add1']; $user_add2 = $_POST['user_add2']; $user_city_state = $_POST['user_city_state']; $user_post_zip = $_POST['user_post_zip']; $user_email = $_POST['user_email']; $user_password = $_POST['user_password']; // Connect to server and … |
| | 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 … |
The End.