10,938 Topics
 | |
| | 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 … |
| | Hi, Can any one suggest how to organize data while using Solr. |
 | hi pls tell me this command is correct or not..... if wrong give me the correct command....... [code] "insert into guesthouse(status) values ('C' where (date_of_arr <= getdate() and date_of_dept<=getdate()) or 'O' where(date_of_arr <= getdate() and date_of_dept >= getdate() or 'S' where (date_of_arr >= getdate() and date_of_dept >= getdate())[/code] here iam … |
| | hey guys... can anyone help me in connecting xammp to vc#.net?? xammp is a package and mySQL is one of its softwares... i cant connect to my database... can anyone give me a code/s....tanx guys.... |
| | How can we connect two databases to PHP at same time. Like .. retrieve data from Mysql and compare it with MSSQL data. :-/ |
 | Hello everyone! I'm Amie, and I'm a little new to PHP and MySQL. That being said, I am attempting to create a Login form with a username and password field. I pretty much have it down with the structure I think. I set up the MySQL database with GoDaddy. I … |
 | Hi All, Help if you can, The following script wont insert a row into my table. There is an auto increment field at the start of the table called "ID". [code] <?php // this is processed when the form is submitted // back on to this page (POST METHOD) if … |
| | I am trying to find the sum of a column( cal) between two dates and then assign or display the result (sum) in a textbox or label in C#. Please help me. [CODE] MySqlConnection mycon = new MySqlConnection("datasource=localhost;username=root;database=church"); mycon.Open(); MySqlCommand get = new MySqlCommand("SELECT sum(cal) from tithes where transdate between … |
| | Hi, I'm new on this forum, hope you can help to solve my problem :) I would like to modelize a binary tree like that [CODE] A / \ B C / \ D E[/CODE] They will be more nodes be a node can only have a maximum of two … |
The End.