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