11,093 Topics
 | |
| | create download area with login Does anyone have any examples of how to create download area using jstl or jsp with mysql? hugs .. |
| | |
| | I have read other threads on this topic, but I haven't found anything that works for me. I have a table that stores comments for orders. There are many notes for each order and I want to select the newest comment for each order so I can have a list … |
| | No matter what I try, I keep getting Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in ___ I tried array also, but here's the code for the login page. About 23 lines down. Also, I'm new to PHP, as in, today new. [ICODE] /* Start session … |
| | Guys, I can run an update query from command line and it updates records but if I'm running same query from a procedure it returns empty set. Any idea why? The update query is below. 1. Create function Age 2. Update table set column1 = Age(column2) 3. CREATE DEFINER = … |
| | Hi, I've set up a secure connection between unixODBC driver manager / MySql ODBC driver on solaris (where we run informatica) and mySql on Windows. It works, but the problem is, that whereas getting informatica to pull data (select) from MySql is reasonably fast, uploading data (inserts) are painfully slow. … |
| | i am a new to php, am trying to get the code below to work - i am getting it is returning resource id#14 Please bail me out file 1 [code] <table> <tr> <td width="245" class="style8"><?php echo "<b>".$database->getLastPoems()."</b>"; // Echoes: string echo $result; ?></td> </tr> </table> [/code] file 2 [code] …  |
| | |
| | Hi gusy, Can any one suggest , how to install DBD::mysql on windows mechine. (Its eating my head). I tried all the possible ways , but its not installing. 1) I tried to install directly from cpan , failed 2) manually downloaded, and tried to install, still failing : showing … |
| | i have a regular expression that's supposed to match any string containing certain words in no particular order. the pattern is in PHP: [CODE]var $pattern = /^(?=.*\bword1\b)(?=.*\bword2\b)(?=.*\bword3\b).*$/gmi[/CODE] this pattern works well both in javascript and php but in SQL, it does not work. I searched and found out that some … |
| | Hi I'm writing a piece of code to update a users password when they have forgotten it, but, for some reason I cannot seem to get it to work. It is always echoing out that the secret answer is wrong. It's probably something stupid that I have looked over, if … |
| | hi, please help this problem , iwill used query after while condition this will not run the program. |
| | How do I integrate a database developed using HTML and javascript and a database developed using MySQL? |
 | Hey guys, I know that the query is not good, but i CANT see the problem. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\XAMPP\xampp\htdocs\betania\modify.php on line 8 Could you please help me out? [CODE] <?php include "connection.php"; if(!isset($_POST[submit])) { $q = mysql_query("SELECT * FROM inscrieri WHERE … |
| | Trying to get results from 5 tables where the userId is the same. I am getting like 8k rows for where there should be about 20-30 or so. Here is my statement: [CODE]mysql_query("SELECT * FROM userrating, postratings, blogCommentRatings, commentratings, gamecommentratings WHERE userrating.userId = '$this->userId' AND postratings.userId = '$this->userId' AND blogCommentRatings.userId … |
| | 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 … |
The End.