10,940 Topics
 | |
| | 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 … |
The End.