11,093 Topics
 | |
| | I had my wordpress site up and running just fine but when I visited it recently I got the following error: > *Your PHP installation appears to be missing the MySQL extension which is required by WordPress.* I contacted the person who set up my database and was told > … |
| | am total newbie to programming, apart from knowing SQL, the thing is i have been given a MYSQL database containing various information about kids diseases and a web interface written in php to create reports from the database that can be accessed via the interface. there are almost 25 different … |
| | Hi, wondering can I get some help here please as this is incredibly frustrating. I have a database that contains files and I want to be able to search those files by putting in a ID number. In my databse my doc_id is the primary key, and I want the … |
| | Hi All, I'm having a problem with a query - which is based on conditional user inputs. In all circumstances, the outputted query ALWAYS works in phpmyadmin returning rows where applicable, but not always in php. No errors are displayed, with error reporting set at E_ALL, and mysql_error hasn't been …  |
| | Hey guys, So, I have a connections php file which contains info such as the host, username, password and database to be accessed. I'm wondering if there is anyway to make the database value to be changed later on in the website. When first logging into the website they choose … |
| | Good Morning, I have an ever growing member database that is currently at around 6000 (developed over the past 2 weeks), and expect it to be in the hundreds of thousands within a few more weeks... My problem is that alot of members are using a single email address for … |
| | I have an application written in VB.Net with a MySQL database that is working fine in my development environment. I would like to create an installation package to test on other computers. The install package should include: 1. Check for .Net 4 - if it doesn't exist then install it …  |
| | Hi, When a user registers on my site there status is 0 (not active) ... meaning they not activated there account via email. When they register i also store the DATETIME they registered, i store it in MySQL using MySQL DATETIME and using `NOW()` in my INSERT query on registration. … |
| | Hello peeps! I've got an issue which I am trying to sort out. I am trying to build a website where ppl can search for car's sell and buy. I got stack where I had to make the search option on the website, so I started looking on google where … |
 | Hello, i am saving a listbox into a mysql database. it saves correctly expect if there is space in between the data, it saves only the first part. any reason why so? |
| | I keep on getting this warning message Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\test\checkPosts.php on line 12 <html> <p><a href = "postArt.php"> Post Article </a></p> <p><a href = "editArticle.php"> Edit Article </a></p> <p><a href = "viewAllPosts.php"> View All Article </a></p> <p><a href = "Logout.php"> Logout … |
| | So guys, I really need a script that I can select from drop down menu, depends on choose, and updates mySQL row every click gives +1 point. Thanks you! |
| | What I need to do is search brand names, find all the brands that start with the letters A-E and put those under a header on my webpage. Then search F-O and then P-Z and do the same thing. How would I go about querying the database to get the …  |
| | Hi, I have been trying to solve this for ages and just can’t seem to get it right. I want to do 2 things here, i am getting an array out of a mysql database (i am getting the user’s id) and then converting that array into a string and … |
| | Hello all, I am having problems setting up a connection with a mysql database that i'm going to need to use for one of my projects. My code to establish the connection is as follows: import java.sql.*; import java.sql.Connection; import java.sql.SQLException; import java.sql.ResultSet; import javax.sql.ConnectionEvent; import java.sql.DriverManager; public class SQL … |
| | Hello, Can someoneone tell me when you `prepare()` a statement (in my case an update statement) and then `execute()` it, i then check using `rowCount()` after the update query (see code below) if `rowCount() > 0` if it is then a match was found and update took place, but i … |
| | hi, I am having trouble finding the problem here. i also can't really find anything great on the net to help me. I keep getting an error saying: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax … |
| | This is my query SELECT DISTINCT brand, category FROM product WHERE subcategory = '$subcategory' My problem is that i want the distinct to work on both brand and category, but it is only working on brand. How could i fix this? |
| | Hello! I need to ask for a little help to build SQL query to delete some records! Table structure: `charId` int(10) DEFAULT NULL, `schameid` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(250) DEFAULT '', `skills` varchar(500) DEFAULT '', PRIMARY KEY (`schameid`) ) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8; Some times record `skills` is empty … |
 | Hi gentles! jest i am creating one stand aloe application by using JDK-1.6 Netbeans.7 Mysql i can run in net beans well and the database also working well with this, if i "clean and build" the project as jar file it working well in it's specific location (eg:D:\Raj\Gui\WorkersData\dist) But! if … |
 | Hey everyone, Does anyone know if there is a possible way of using an online Database without uploading the website files onto the server? Cheers, |
| | so i've been working on a database in oracle for a booking system and I am trying to create dyanmic query results... was just wondering if there is a way to create a query to add up all the seats in a arena with booking numbers (not necessarily the same …  |
 | I have the following queries (as examples): ~~~ sql SELECT articles.* FROM articles WHERE articles.forumid IN (2,8,118,9,61,58,34,114,112,113,125,124,4,134,42,14,71,181) ORDER BY lastpost DESC LIMIT 0, 30 ~~~ ~~~ sql SELECT articles.* FROM articles WHERE articles.forumid IN (2,8,118,9,61,58,34,114,112,113,125,124,4,134,42,14,71,181) AND NOT deleted ORDER BY lastpost DESC LIMIT 0, 30 ~~~ ~~~ sql SELECT articles.*, … |
| | Ok I need help. I have a couple hundred databases, which are different cities, that I am trying to connect with one query. each city has the same Sports table in it. I want to put the 100 most recent results on one page . The code below gets the …  |
| | I am trying to setup a navigtion link section on my home page. what i have is a table called section in mysql and this is the way it is setup up. [CODE]+----+-----------+----------+ | ID | name | parentid | +----+-----------+----------+ | 2 | News | 0 | | 3 … |
| | Hello All I am having an odd issue with mysqldb connection from python to a database. The issue is, when I run the query directly or via a sql client like navicat or toad, I get the required value, but this does not happen via python/mysqldb combo. This is the …  |
| | I am trying to change the data type of a primary key in table A from INT(11) to CHAR(11). However, this primary key is a foreign key in tables B and C. SQL is giving me an error whenever I try to change the value type of the primary key. … |
| | Hello: I was wondering if I can get some guidance on how to pull data from mysql and inserted in js array in the following manner var option_array = new Array(num_of_cats); option_array[0] = new Array(\"You need to select a category\"); // This is the first (blank) category. Don't mess with … |
| | Hi all. I am not sure if this should be in PHP or MySql, but it is more relevant to MySl. I am designing a helpdesk for my department. Currently I am entering data into a form, which submits that data to a MySql table. That table is then displayed … |
 | I have this: [code] DELIMITER $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `linkacorte`(vid_pedido int(11), vid_producto int(11),vtiempo varchar(50),vid_pastelero int(11),vcorte varchar(200),vnum int(2)) begin declare campo varchar(20); DECLARE EXIT HANDLER FOR SQLSTATE '42000' SELECT 'Ha introducido un campo incorrecto. Solo se permite 1,2 o 3'; if vnum=1 then set campo='programa_corte_1'; elseif vnum=2 then set campo='programa_corte_2'; elseif … |
| | what's wrong in my codes? this is my insert.php: `<?php $host="localhost"; // Host name $username="root"; // Mysql username $password="rommelbarrio"; // Mysql password $db_name="system"; // Database name $tbl_name="grades"; // Table name // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); // Get values from … |
| | Hi all, I'm making a website that enables easy sharing of Public PGP keys using PHP and MySQL server side and JS client side making it all nice and dynamic. The site works fine on localhost, but I have just uploaded it to my host, TuxFamily, and it doesn't work. … |
| | I need a script that selects all from mysql, orders them DESC with highest money and prints out only where username=$_SESSION['username'], so it will show Your position is X/10 |
| | HI, Could you please explian this code so it will work, { "display **all** from **tablename** **colloum_id** in a **random order** " } I am trying to get all the data echoed into a random string ie. echo = "3,4,5,6,7,3,2,6,3,22,43,132,ect. not in a table. thanks. |
| | Hi, I have created a form and since it is very long some of my users need a SAVE feature so that they can enter some details-> save it, and then fill the blank fields in the future. Most of my form fields are 'textarea' as the data entred by … |
| | Hey Im trying to start from scratch a MySQL installation in Linux but for some reason through apt-get and the software center, when I remove it, my users (and privileges) still exist. How can I remove everything releated to MySQL and start from 0? Thank you |
 | Hi All, I am trying to create a page were users can edit their post. -Select subbmitted data from the database using post id, and display this information so that users can Edit. -And finally i want to update the data and continue to the preview page, where users can … |
| | pls suggest me some online tutorials for databases.finding it difficult to learn from textbooks  |
| | Hi I am running the following SQL (extract shown below) INSERT INTO users (user_id, username, username_clean) SELECT member_id, username, lower(REPLACE(username, '.', '_')) FROM members The problem arises when lower(REPLACE(username, '.', '_')) produces a duplicate that already exists in username_clean as the users table does not permit duplicates. Is there a … |
| | Hi, I'm developing a blog that will have categories. I want to be able to store blog posts in more than one category. My problem is i am not sure how to go about it. I have a table called posts: CREATE TABLE `posts` ( `post_id` int(10) unsigned NOT NULL … |
| | Hi guys, I'm doing an application that works with an online mysql database. Here is a sample of my code: ~~~ Dim adapter As New MySqlDataAdapter("select * from my_table order by code", "server=my_server;User Id=me;password=password;Persist Security Info=True;database=database") Dim my_table = New DataTable adapter.fillj(my_table) ~~~ On the last line, the application freezes …  |
| | Hi everyone, Now a days Justhost & Bluehost are putting restrictions on mysql joins. Even If there are 11 or 12 Joins the query is not running. When you will run the same query in phpmyadmin then, its giving you error message as "#1104 - The SELECT would examine more …  |
 | Hi all , I need to insert a value in to a table if that value does not exist more then twice , If once that value exist then it should insert only once .. could any one guide me.. thanks in advance |
| | Each childrow has a parentid and position. For childrows with the same position there is one row where start='1'. What i'm trying to do is return the pending rows with their start row. The results that should be shown are; start(owen) pending(dave,paul). This is because they have the same position. …  |
| | I need help making this mysql trigger. I'm creating this student enrollment project and the trigger I need needs to check that there is no course schedule conflicts when a student enrolls in course. Everytime a student enrolls in a class a row is added to the courses database. I … |
 | I have a page that I wrote to upload a text file to a mysql database. The text file has thousands of lines and each line is a separate database row. An identifier at the beginning of each line tells me which table to insert the line into in the … |
| | Hi. I am trying to perform a "process of elimination" type of search using MySql. I have a table with a lot of values that people could search for- and currently if they search for 1 value it works great. But if they search for lets say "value1 value2" it … |
| | Hello, Is there any way of restricting the values returned in MySql? For Example: There's a field in my table called points whihc I want to restrict from 0 to 17 only. This means the values more than 17 are unacceptable for field. Is there any way of implementing that? … |
 | I HAVE MS ACCESS DATABASE OF 'STUDENTS' containing Their roll no's, names, min marks and max marks. As like schools publish results on their webistes, there is a text box in which roll no. is entered and the command button for searching the whole record of roll no. entered in … |
| | Hi, Please help me... I am new to php and my sql. I need a code for uploading uploading the data from xls or xlsx file into my sql. Please give the code and help or send the code to futures.magesh@gmail.com..... Please help me..... |
The End.