11,093 Topics
 | |
| | 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 …  |
 | I am trying to display values fetched from a MySQL database as an excel spreadsheet. Now, I have been successful to create a csv file using the code below; <?php error_reporting(0); include("includes/connect.php"); // This is the connection string to the database //Select the required records from the database $result = … |
| | |
 | This is my word "नमस्कार". (It is Indian language (Marathi language) ) mysql is showing like something in image attached How to store Unicode characters to Mysql to show properly? |
| | Hi. I'm trying to get my hover-effect to work , but the php seems to destroy the hoverfunction. My javascript works fine if I remove all php-code. What have I done wrong? <?php $host="*********"; // Host name $username="**********"; // Mysql username $password="geronimo"; // Mysql password $db_name="***********"; // Database name $tbl_name="****"; … |
 | Hey all, Looking for some quick guidance, Trying to make it so that I can have a field which presents how many customers the database has. E.g This is the DB: http://prntscr.com/o2vuf This is my php: <?PHP $id_customers = "SELECT id FROM Customers"; $Customeramount = mysql_query($id_customers) or die(mysql_error()); echo $Customeramount; … |
 | Hi everybody, I am in the process of building a small web application which will hold around 10 pieces of information for every person inserted. Due to data protection the majority of this information must be encrypted. Using the CodeIgniter framework and the CodeIgniter encryption class I can encode the … |
| | Hello, Happy New year please help me senior bro,I can't insert mulityple selected checkbox value into my databse.When i click SUBIT then it show me below error: *Error Number: 1054 Unknown column '0' in 'field list' INSERT INTO `tbl_course_offred` (`0`, `1`, `2`, `3`, `4`, `5`, `6`, `7`, `8`, `user_id`) VALUES … |
| | I have 2 tables: tblUser: +------+-----------+ | id | Name | +------+-----------+ tblItems(this table accepts multiple checkbox value depending on how many user selected): +------+-----------+---------------+ | id | items | name_id | +------+-----------+---------------+ `name_id` will get the value of `id` in `tblUser` I use this code to get the value … |
 | |
| | the MySql command is being skipped and the error being execute within th Try Catch.. Please help of possible Dim myConnString = ";" & _ "Database = inventory;" & _ "Uid = root;" & _ "Pwd = root;" & _ "Connect Timeout = 30;" Dim myupdateconnection As New MySqlConnection(myConnString) Dim …  |
| | I'm having a strange issue that I'm sure has a reasonable answer, but it's making me nuts. I am using the code below, but no matter what I do, on the host's server it displays the created_date as '0000-00-00 00:00:00'. I get the correct response locally. If I go to … |
| | Hi there. I'm trying to wrap my brain around something that is probably really simple - once you know how. I want to print the name of each park, only once, along with a list of its features. I have the following SQL query... $query = 'SELECT id, name, feat_name … |
| | Okay what I am trying to do might be hard to understand, but I will give it my best shot. I have created a script which selects data randomly from a table called albumname in a databse called characters. This array is then used again in a mysql_query to select … |
| | Wow.. I guess I must have been living with my head in the sand for a few years. I write everything using PHP/MySql, and now it seems that eveything I am reading is referencing MySqli... So I started researching that and found that it has been around for years and … |
| | Hello masters It is possible to connect two different database system like(sql server and mysql) at the same time in the same script? If yes can you give me some tips of what procedure I'm going to use. If no then thanks for reading my threads. ///////////////////////////////////////////////////////////////////////////////////// Because i have … |
| | I am finding it difficult to update the `JTable` when I enter a person's name in search button. The program compiles correctly without any errors, but in `SearchActionPerformed` event when the search button is pressed an empty table comes up. Where without search, the table is full of values from …  |
 | Hi guys! Is there anyone can help me to do import and export database from my sql? i don't have any idea how to do it. I don't want to do it manually which is using phpmyadmin. So, i want to make it easy only by click the export button. … |
| | I am trying to make an array which has a random selection of database results in it. This is what I have so far, <?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("photos", $con); $query="SELECT album FROM albumname ORDER BY RAND() LIMIT 9"; $result= … |
| | Hi , I am able to compile my program , which simply connect to mysql and prints the table result. But I am unable to compile it with Makefile. Any pointer will be appreciated. My program: [code] #include <mysql.h> #include <stdio.h> main() { MYSQL *conn; MYSQL_RES *res; MYSQL_ROW row; char … |
| | I have a site that has categories of images generated from the database, I am trying make it so when the user selects a category, the query is based off of that selection and the respective images load. Is that something that can be done? Here is my current code. … |
| | Is there a service available to have someone translate your code from mysql to PDO or Mysqli? Pay service or free. I just know I'm in over my head. Thank you. |
| | Hello guys , i am new around here.Need help with one script its for movie's web site, i need to add more than one picture in database. The code is: <?php @mysql_connect($host,$user,$password); @mysql_select_db($db); @mysql_query("SET CHARACTER SET cp1251") or die( "Не мога да избера БД"); if(isset($_POST['submit'])){ $kategoriq = htmlspecialchars($_POST['kategoriq']); $seriq = … |
| | Hi, I have something wrong at table_academicMouseClicked() method which results me with a java.lang.NullPointerException error. basically trying to compare the surname in Jtable and look it up on the database to select the corresponing record so that I can set the label to the value from database. So when a …  |
| | Hello, My weather station software produce an XML file with live info about temperature, Wind, etc. It is possible grab this info to mysql db every 5 minutes and organize for day, month and year? Thanks |
| | Hi Guys....i am facing a small issue with an SQL statement here. Will you be able to help me out? I wanted to grab the page title, page author's name which is in the users table, the no of comments, and the page publish date. "SELECT * FROM pages INNER … |
| | I'm having trouble with a query. Here's my code. ---------------------------------------------- `"SELECT *` `FROM listings` `WHERE MATCH(title)` `AGAINST('ipod' IN BOOLEAN MODE)` `ORDER` `BY relevance DESC"` ---------------------------------------------- And I get this error: > Unknown column 'relevance' in 'order clause' |
 | Hello to everyone, im having some trouble in setting a position on a table in php. I learn how to display a table in php on school and with some research through the internet, but not how to customize it. Is it possible to display a mysql table from a … |
The End.