10,946 Topics
 | |
| | Hello, my name is Matias (Mathew for english people) and I am 16 years old. And I am from Argentina !!! I joined this Community because I know a lot of things that I can share here of simply respond... I am a student from an idustrial school call Huergo … |
| | Hi, how to write the MYSQL Query select count(*) from (SELECT user_id FROM `reports` group by report_id) as tb where tb.user_id=5 in Cakephp inside the Loop [CODE]$users=$this->User->find('all'); foreach($users as & $user): //for each $user['User']['user_id']; which gives the User ids as 1 2 3 4 5 ... endforeach; $this->set('users', $users);[/CODE] |
| | [HTML] i am having four combo boxes.the item in the combo box is taken from the database.we select the data whatever we want and clicking the submit button report want to be displayed. While selection in the combo boxes, they may select all the fields sometimes they may select one … |
| | Why am i getting this error: Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /Users/Joli/Sites/TestSite/index.php on line 47 [code] $conn = mysqli_connect("localhost","sql","password","db") or die("Query died: Connect"); $checkSql="select count(id) as eCount from address"; $result = mysqli_query($conn,$checkSql); $row = mysqli_fetch_assoc($result); if($row['eCount'] == 6){ $disable = 1; } [/code]  |
| | hi my code is not working when to running .. it create to mysql files but ..not create to my table and it created to table 0 byte ... why ?[code]this is backup code :: <?php $backup=$_POST['text']; $host = 'localhost'; $user = 'root'; $pass = ''; $backupDir = 'c:\'; $backupFileName … |
| | hello everyone i'm new to this site and i'd like help in any form with a project i'm about to undertake. i would like to store .doc files in a database and retrieve them with the aid of a search string to be input by varying users (basically a search … |
| | Hi all, I used [B]Timestamp[/B] data type in mysql and Date object in jsp. Now my question is how can I store system`s current Date n Time in Timestamp field using jsp? |
| | Can someone tell me why I am unable to update a table in mysql using php with session data. First of all, I have done some reading around daniweb and Im not sure if i should be using UPDATE or INSERT to update the table. I have session_start(); at the … |
| | Hey everybody, My company decided to improve the management of some data contained in csv files by loading their content in a mysql database. I heard that this is part of the process called ETL. Is that right? If that's so, which tool can I use in order to do … |
| | I was wondering if there was a contains word to use with a mysql query, my current query is : //$query="SELECT * FROM $table WHERE date = '$selecteddate' AND Style = '$selectedstyle' AND Platform = '$selectedplatform'"; but the $selectedplatform isn't always the only thing in the Platform column, I just … |
| | i use vb with Access. I have 2 tables table1 & table2 i create a data report showing the data from table1. [B]My aim is to display the data from table2 on the same report in its next page(s). [/B]any kind of help, suggestions will be highly appreciated. with regards … |
| | [B]-- Table structure for table `attractions`[/B] [CODE]CREATE TABLE IF NOT EXISTS `attractions` ( `attID` int(11) NOT NULL AUTO_INCREMENT, `attName` varchar(255) NOT NULL, `adultPrice` double(5,2) NOT NULL, `childPrice` double(5,2) NOT NULL, `referenceID` varchar(255) NOT NULL, PRIMARY KEY (`attID`) ) ENGINE=InnoDB;[/CODE] [B]-- Table structure for table `packages`[/B] [CODE]CREATE TABLE IF NOT EXISTS … |
| | Hello! I'd like to ask a question, and I guess the simplest way to explain what I want is to simply show you the [URL="http://lace.forthesky.org/wardrobe/angelicpretty/op"]page[/URL]. See the sort by list? I simply want to sort the entries by year, which I did succeed with, in a way. The problem is … |
| | I am creating a page of articles for a site i'm working on. The current page i'm creating needs a list of articles by date. I want to have it list the year the article was posted as a header then list only the entries for that year underneath. I … |
| | [CODE] SELECT Customer_Info.CustName,Customer_Info.Address,Customer_Bank_Info.CustChequeNo,Customer_Bank_Info.CustAccountNo from Customer_Info,Customer_Bank_Info WHERE Customer_Info.AgentID=Customer_Bank_Info.AgentID [/CODE] THERE ARE TWO RECRODS ARE AVAILABLE IN Customer_Info TABLE AND TWO RECORDS ARE AVAILABLE IN Customer_Bank_Info BUT WHEN ABOVE QUERY IS EXECUTED IT SHOWS 4 RECORDS IT REPEATS THE QUERY THAT'S WHY SAME RECORDS FROM THESE TABLE ARE RETRIVED FOR TWO TIMES. … |
| | Greetings, coders from a Canadian near Toronto. I have been working on an online botanical tree of as many woods that I can identify as I can. To be sure, the following link is absolutely not any sales or promotional gimmick. I just want to make it easier for anyone … |
 | Hi ok this is what I'm trying to achieve. I have a page that loads a youtube.com video and below that video is a comments section. The video section is it's own DIV section and so is the comments. The submit new comment sits outside the DIVs. Initially the video … |
| | Hello, I am trying to structure query to execute MySQL fulltext search. I have creates simple table as follows: CREATE TABLE IF NOT EXISTS `entries` ( `id` int(3) NOT NULL auto_increment, `doc` text collate utf8_unicode_ci, PRIMARY KEY (`id`), FULLTEXT KEY `doc` (`doc`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ; And … |
| | Hey, I've got a page on a web server, that when you click a button, I want it to connect to some files and edit them. Sorry If I'm not being specific enough. The user would vote for us on a toplist, and there character files (In my game) would … |
| | I am trying to create an update query for a website, and I keep getting an syntax error message. I narrowed it down to the table column that is the only field that is set to be of type text. [code]UPDATE company SET references = "blah blah blah" WHERE company_id …  |
| | The code: [CODE = php] $selecteddate = $_POST['Releasedate']; $selectedplatform =$_POST['Platform']; $selectedstyle = $_POST['style']; $query="SELECT * FROM $table WHERE date = '$selecteddate'AND Style = '$selectedstyle'AND Platform = '$selectedplatform'"; [/CODE] Ok, the code works if someone picks something for all 3 of the items, so all of the code works, but if … |
| | please help i don't know how to delete multiple rows in mysql using checkboxes, because it seems the delete doesn't seem to work. here's the code: [code=php] <?php $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name="test"; // Database name $tbl_name="test_mysql"; // Table name // Connect … |
| | G'day, I've just been going over MySQL joins and just have a few small questions. 1. Are [B]LEFT[/B] and [B]RIGHT[/B] joins forms of [B]OUTER[/B] only or are the both Inner and Outer? 2. Can you only perform a [B]NATURAL[/B] join on Inner join classifications? Cheerz, TC |
| | File file = new File("filename"); FileInputStream fis = new FileInputStream(file); len = (int)file.length(); //prepared stmt st.setBinaryStream(1, fis, len); I have uploaded the file into mysql database from servlet program. But how to read that file or tell me how to upload a doc into the database. |
| | hello, can any one help me ,i am not getting mysql datbase values from server, to my system through applet it display all values null....but locally the program getting the values is there any browser settings..or any thing need i have to do pls help me................ |
| | Hello. I'm currently developing an IVR system under Asterisk through the Asterisk Gateway Interface (AGI), connecting to a Mysql server using the Mysql C API. The server returns a ticket number that I have to say to the client, so I developed a TTS (Text To Speech) algorithm to say … |
| | This is a rookie question and don't really know how to word it so that google finds me an answer, but can someone give me an example of a query using multiple WHERE restrictions so I can see how to format my query? |
 | Hi, I have never used table locking before. Would something like this be sufficient? Basically I want to only allow exclusive write access to the bid table: [CODE] <?php $query = "LOCK TABLES bid WRITE"; $placebid = mysql_query("INSERT INTO bid (auction_id, seller_id, bidder_id, b_timestamp, b_currentprice) VALUES ('$id', '$uid', '$ruid', NOW(), … |
| | Hello, I have a database with about 25 tables and almost every table having a foreign key on some other table. They system needs to deal with a large number of reads and writes. I'm concerned if having too many foreign keys and relationships between tables will lock the tables … |
| | Hi, well what i need to do is, through a certain interface there are assignment upload calls given by the admin, this is that interface [CODE]<html> <head> <script type="text/javascript"> function remlink(num){ var rownum=num; var rowid = "subname_"+rownum; var sn=document.getElementById(rowid).innerHTML; var cnfrm = confirm ("Are you sure you want to remove … |
| | I hope you can help. I have a program using 2 pages (main.php and resize_image.php) fragments shown below. Each script works fine independenly of each other. My problem comes when I want to pass a value held on my database held in $story[picture] to resize_image.php..... It simply will not transfer … |
 | Hello ... I have a very annoying problem just now, MySQL server in my office is not stable. This morning it has stopped for more than 10 times. :'( FYI, the version of MySQL is 3.23.54 running on redhad 9. When I tried to restart it, it showed like this: … |
 | Hi, I have a script which is meant to use all of my servers cpu but mysql will only use one core. I have 8 cores but only 1 core is being used. Does anybody know how to allow mysql to use multiple cores? -------- Second question How do I …  |
| | I am using AJAX scripts in jsp to access mysql database which has been made using InnoDB and MyISAM. while the database is in InnoDB format, the ajax script works fine but for MyISAM format, it doesn go well. Pls. let me know how this structure architecture plays role in … |
 | Hi I am using C# to connect to mysql database that install in my local machine.After I complete the project I want to publish it in another server.So I change the mysql connection string.Here I mention the connection string that I used in local machine String MyConString = "SERVER=localhost;"+"DATABASE=IPG;"+"UID=root;"+"PASSWORD=Test;"; Before … |
 | I use: Visual studio 8.0 MySql database One table: table :Groups, two fields : groupnb,groupdef One Datagridview with is link to [COLOR="Red"]Mydataset1[/COLOR] [COLOR="Red"]Some times [/COLOR]a get this MySQL error: [COLOR="red"]"Connection must be valid and open"[/COLOR] I use first this command : [COLOR="Green"]MyDataset1.Tables("groups").Rows.InsertAt(row, 0)[/COLOR] Then I change the content of some … |
| | Ok, I have been searching everywhere for solutions for charset problems I have. I have php website and backend Mysql database. In some fields I need to put in letters from the Greek alphabet. If I use a form to send info to the database and type in Greek letters, … |
| | Just wondering, why is it that PHP seems to be the preferred option over JSP when dealing with MySQL databases? I've long gone off PHP and have moved onto JSP in more recent times and find that it handles the over-all performance much better. I'd like to hear from all … |
| | Hi everyone, I am using Ubuntu 7.10, and I have Java and MySQL installed with the command line as follow: 1. sudo apt-get install sun-java6-jdk 2. sudo apt-get install mysql-server and my JAVA and MySQL are working well, but now I want create connection between JAVA application and MySQL using …  |
| | Hi my first insert statment works ok, My problem is that I wish to insert all the selected options passed from the form. into my user_req_opt table. Some items only have 1 option others may have 10 options. [CODE] $sql = "insert into user_requests(rq_id, user_id, code_ref, code_id, cat_id, opt_yn, rq_qty, … |
| | Can someone help me?? How to retrive image from MySQL(not MS_SQL) and show into my <asp:Image> control using c# Lets said my table on have a field as following: "SELECT pic FROM image" Thanks in advance !!  |
| | Hey, so i'm trying to make a double login page, 2 users put there user and password there and login at the same time, the problem is that it always says that the passwords are wrong... I think my problem is connecting with the MySQL database, because i can't create … |
| | i tried to solve a problem using php, mysql and javascript. i should cliuck a button and ythen the script alters some values in the mysqldatabase. it doesn't work. someone said i had to use ajax but i have never used ajax, please give me some help the internet dazzles … |
| | I want to calculate somebody date using his/her Date of Birth which is located on the database column name(DOB)..which sql function do i use and how do i use it on the Sqlquery..please help |
| | This is the error I keep getting, This script works fine with the local SQL server running on my windows test box but when I try it with the SQL server running on my shared web hosting account with go daddy it gives this error, I think obviously their databases … |
 | Which is better? I know that autoincrement fields allows you to get the last inserted id which is helpful when dealing with multiple tables, but other than that I'm not sure which I should use to make the database more secure/robust. |
| | Hi guys, I am creating a university database, where student can take sections and courses have prerequisites. I have to make sure that when user takes a section, he has met all the prerequisites for that course he is signing up for. And, when a course is deleted from the … |
| | Hello everyone I want to run a .jar file, but the only way to run in my computer is with the "java -jar file.jar ", but the problem is that the application conects to a mysqldatabase, when I want to add something in the program appear a message that say … |
| | I am trying to access a Mysql Server through Lan using VB6 using ADODB connection db.Open "DRIVER={MySQL ODBC 5.1 Driver};DATABASE=xxxx;SERVER=192.168.1.6;USER=root;PASSWORD=xxxx;OPTION=3;" it is giving error [Mysql][ODBC 5.1 Driver]host couldn't connect to the Mysql Server My Server IP is :192.168.1.6 user is: root Firewalls are turned off.... Might be i need to …  |
 | hello... i am doing login verification. there is tabs in index page thats why i am choosen this. actually after entering the values of email and password how to check that values are in database or not using javascript. and i will show message in alert box. this is my … |
The End.