7,368 Topics
| |
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 … | |
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, … | |
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 … | |
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 " . … | |
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 … | |
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="****"; … | |
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 … | |
We already have a MySQL database full of important data. We would like to change our uniquely developed website to a WordPress CMS with migrating the data. What is the most effective solution? Tibor | |
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 … | |
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 … | |
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= … | |
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. … | |
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 … | |
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' |
The End.