10,944 Topics
 | |
| | Hi,I can't display Multiple checkbox save value in my veiw page. Here is insert/save value details: Model --------- public function saveInstituteOfferdCourse($data = array()) { if ($this->db->insert('tbl_course_offred', $data)) { return $this->db->insert_id(); // tbl_course_offred = "Table name" } return FALSE; } ---------- Controller ---------- public function saveCourses() { $data = array(); $this->load->library('form_validation'); …  |
| | Hello, I was wondering if there anyway to Select rows where the date column falls into a certain range? For example, heres a table [code] The date field is generated automatically by MySQL with the DATE function Heres the table: [user] . [wins]. [date] bobby.......4..... 2006-08-21 boby1.......3..... 2006-08-22 boby2.......6..... 2006-08-24 … |
 | I have been searching all morning and I cant seem to find a reliable source for a decent slideshow script, I am working on creating one myself now, if anyone has any helpfull hints or tips, or even if you have some code snipets that would be usefull for my … |
 | Hello, Let's say I have 2 tables: * projects * users and I need to relate them so that a user can work on one or more projects and a project can be worked by one or more users. How to implement this without having a third table ?? It …  |
 | Hi all, This is a follow on from my last post. Here is my current query: SELECT * FROM ( SELECT * FROM ( SELECT TeamID, PlayerID, COUNT(*) AS Total FROM Scored WHERE MONTH(GoalDate)=12 AND YEAR(GoalDate)=2012 GROUP BY PlayerID ) T GROUP BY TeamID, Total DESC ) T GROUP BY … |
| | Hi everybody, i have problem in my php code (it just showing nothing....means no error no results).......can anybody tell me what is wrong with this code.....i'm new to PHP........here is my code <?php try { $config=array( 'DB_USERNAME'=>'root', 'DB_PASSWORD'=>'' ); $conn=new PDO('mysql:host=localhost;dbname=scc',$config['DB_USERNAME'],$config['DB_PASSWORD']); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); echo rand_id(); } catch(Exception $e) { echo … |
| | Hi all, Regarding a football (soccer) league: I am trying to find the top goalscorer for each team in the league in December 2012. Each time a player scores a new row is created in the table "Scored" with their name in it and their corresponding team and the date … |
| | Hi everyone, I would like to ask a question about MySQL. Say, I have a database like this: database 1: articles |- id |- title |- description database 2: tags |- id |- articleID |- tag I needed to search from articles.description and tags.tag and while doing so, the searched … |
| | I have a couple of messages which are stored in the databases. I have an app which depending on the answer that the user gives should get the right message from db and include the user answer to the record. Example: record-> **Hello ____ Thank you for your answer**. The … |
 | ***Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/crysta21/public_html/hospital.phpon line 53*** <?php /* MCCodes FREE hospital.php Rev 1.1.0c Copyright (C) 2005-2012 Dabomstew This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the … |
| | hello, i have a basic code, and i want to fetch a data from mysql using PHP, and display in my html page; i just want to have a basic idea so i can add more details later on, like data of birth, nationality, profession etc. im planning to make …  |
| | hello guys, how can i display the data from php mysql with text decoration for example underline or a dotted line css/html? thanks. |
| | hi i have some data in mysql db and i need to create a page where i have a dropdown down box with different categories. when a user select a category from a the drop down it will show data form the mysql table from that category. so how can … |
 | Please show me what is the correct code to compare the DateAdded (2012-12-26 00:00:00 - its format inside MySQL) and DTPicker (01-01-2000 default format from user input) Sub FilteredQuery() cnDDR.Open "Driver={Mysql ODBC 3.51 Driver}; server=x; port=3307; database=x; user=x; password=x; OPTION= 1 + 2 + 8 + 32 + 2048 + …  |
| | Good Morning, This may seem like a very basic and simple question from someone that has been doing programming as long as I have, but it is something that has always eluded me, and I've never taken the time to ask, so here it is... When I am doing queries, … |
| | My Python environment: Python 3.3.0 (v3.3.0:bd8afb90ebf2, Sep 29 2012, 10:57:17) [MSC v.1600 64 bit (AMD64)] on win32 I have a script that has been running for months. It's a cron job and suddenly it started throwing this error: *pymysql.err.Error: (<class 'TypeError'>, TypeError("'int' does not support the buffer interface",))* I don't … |
| | Hello Floks, I have been working on a database design for my company which is in the filed of calibration. I have came up with thae attached design and i need you to give me feedback. |
| | Good Morning... I seem to be having a problem getting the data that I want from a single query... I have a table that contains various information on record processing it has an auto increment field called period_id also a field called max_pl_trans What I need to be able to … |
 | Man that was a mouthful! Basically I have a page which when I click on a button, a jQuery (iframe) window comes up. Here there is a combobox that should be filled with values I read from a database. Ive been reading two pages: http://openenergymonitor.org/emon/node/107 http://stackoverflow.com/questions/8019489/simple-ajax-jquery-script-how-can-i-get-information-for-each-of-the-rows-in-the But Im having problems … |
 | Hey guys how do you filter a datagridview with a the contents of a combo box? For example i have a combobox filled with categories. btw im using a MYSQL as database |
| | I am having a devil of a time trying to get my arrays to print right, but I am missing something. I am hoping another set of eyes can help me figure it out. I have this current function: function getArrayUsers($id) { $sql = DB::inst()->query( "SELECT * FROM " . … |
 |  I'm trying to figure out how to add a new connection to MySQL running on a different computer on my network. When I click Project --> New Data Source a list of drivers appears, but none of them are MySQL (see thumbnail) which I have previously installed. I'm … |
| | This is probably simple enough to do, but I cant get it! I have a mysql table 'links' with these fields; id int 10 primary ai link varchar 200 description varchar 200 I have a links page to populate with this info. I want the desciption as the visible text. … |
| | I am using 'MYSQL' datasource in ODBC' for my project. My deployment is failing with the error "Error 1 An attempt has been made to use a data extension 'ODBC' that is either not registered for this report server or is not supported in this edition of Reporting Services. 0 … |
| | Good Morning, Hopefully someone can help me with a quick answer. I have a transaction table with a 'description' column that contains a combination of the members name and some static information i.e. "'username' PURCHASE" or "'username' PAYMENT" and a 'type' column that contains various types of transactions i.e. 'FEE' … |
| | Hi, ok I have about 1600 records in a mySQL db. Many of them have a forward slash "/" in the itemName column. In my site, I am passing the itemName as a URL variable on many search forms, so obviously the forward slash is not a good naming convention … |
| | This code is suppose to take the images array and use its value for the name of the table. When I echo the images varaible I get kids, which is what $images[3] is set to equal, but when I put it in the query the $result2 is echoed as resource … |
| | I have got MySQL Workbench 5.244 installed. I have a server instance created (MySQL55). Everything works perfect inside the workbench. The problem is when I try to connect to the server on my PHP (version 4.2.1) file. (Pleasew find header.php and default.php below) I get the message below: Warning: Unknown … |
 | i' saved the key names as column names in database.so i want to insert i all the values in database.with out mentioning the column names in the database. <html> <body> <form action="#" method="post"> Firstname: <input type="text" name="name"> Lastname: <input type="text" name="lname"> Age: <input type="text" name="age"> <input type="submit"> </form> </body> </html> … |
| | Dear All, I'm facing a problem when using DISTINCT in mysql. Please refer my database design below. id lang album singer title family writer song hits In my db i want distinct title and the id from the db. I'm trying the following code. But it only fetching the results …  |
The End.