11,093 Topics
 | |
| | Help I am very new to MySql. I have inherited a website. The previous webmaster used a MySql database for news items. I took a back up of the whole site using FTP, then restored simply by FTP the files back up, but the database now seems corrupt I have … |
| | Hi there, I have been scratching my head for a few days now! with this problem: I am trying to echo out some data from a mysql table. I have a column name Country which has the following Countries: India, Malaysia Austaralia etc. I also have a column name Town … |
 | Hello, have a page where I am going to be doing multiple queries on different databases. However I thought my below code would work but it does not seem to resurn any error message nore any result set. Here is my common database connection file <?php //database username and pass … |
| | how do i fix this? the error says that the column count does not match value count. thanks in advance!:) -- -- Definition of table `assets` -- DROP TABLE IF EXISTS `assets`; CREATE TABLE `assets` ( `_id` int(10) NOT NULL auto_increment, `_controlNum` varchar(255) NOT NULL, `_category` varchar(255) NOT NULL, `_subcategory` … |
| | i get an error here Can't create table '.\itams\assets.frm' (errno: 150) [icode] -- -- Definition of table `branch` -- DROP TABLE IF EXISTS `branch`; CREATE TABLE `branch` ( `_id` int(10) NOT NULL auto_increment, `_branchName` varchar(255) default NULL, `_branchAddress` varchar(255) default NULL, PRIMARY KEY (`_id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; -- … |
| | I need a help with selecting the rows in a table depending on the [I]status[/I] in previous table. [B][COLOR="DarkGreen"]Table1[/COLOR][/B] [CODE]Column1 Column2 Status Smith Alex 1 Smith Mark 0 John Smith 1[/CODE] I have second table with 2 columns. I want to select only those rows which have ANY of the …  |
| | I am trying to connect to MySQL database at on host (DBhost) from another host (PROGRAMhost). While I try to connect to the database at DBhost from DBhost itself the next is working fine for me: mysql_connect("localhost","qdbname","dbpassword") Now I am trying to find out what to use instead of localhost? …  |
| | Hi all, I have a pagination script that works great apart from one last thing I require some pointers on please. The help i need is with the SELECT query - currently the select query works, but i am bringing back all records, I am trying to bring only certain … |
| | I have some data in a table in mysql. I have written a program which can connect to the database and access all tables and data of mysql. I have a variable in the C program. I want a particular data in one of the tables in the database to … |
| | I import data into MySQL over and over again. Always from .sql scripts. I have tried over and over to come up with a script that will [LIST=1] [*]Ask for a database name [*]Sign into MySQL [*]Drop the Database named in step 1 [*]Create a new database as named in … |
| | Hi Guys I Have a table with 2 fields & several roows like this : Cd val -- --- a 1 b 2 c 1 d 3 f 4 g 2 h 3 k 5 l 6 m 8 n 7 o 1 p 2 I want get the result … |
| | I have a database and will search with that database.. I want to show only first 5 results in the page and generate the "next" button for the next 5 results and on the 6-10 results page generate "next" button for the next results and the "previews" button for the … |
| | Hi! I'm trying to create my own little community for learning purposes and I'm having some trouble with getting the data I want from the table. I'm not that high on SQL but I know the basics but when you get into the more complex mysql-lines I get lost. The … |
 | Hello, I am brushing-up on SQL (using MySQL). It has been many years since I have worked with this and I'm having some trouble getting started. I have looked at a tutorial and entered the code below: [CODE]CREATE TABLE employees ( employeeNumber into(11) NOT NULL, lastName varchar(50) NOT NULL, firstName … |
| | Hi, this is my query [CODE]$result = mysql_query("SELECT SUM(`qty`) FROM sims_ac WHERE region ='North'");[/CODE] How I can show this [CODE]$result[0][/CODE] without using While loop or any other loop.  |
 | Please help me..i m getting this error in vista... java.sql.SQLException:General error at sun.jdbc.odbc.createSQLException(JdbcOdbc.java:6986) at sun.jdbc.odbc.StandardError(JdbcOdbc.java:7114) at sun.jdbc.odbc.SqlExecDirect(JdbcOdbc.java:3110) at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbc.java:3110) at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(JdbcOdbcStatement.java:288) ....etc there are 2 code pages..one is employee registration page and the details entered in this page is sent to EmpAddServlet.... [icode] import java.io.*; import java.sql.*; import javax.servlet.*; import … |
| | Hello everybody, I want to write php script with classes, but I haven't enought knowledges. I want to delete multiple rows from mysql with chekbox, but I am wrong. I will be very happy if somebody responds me. This is my code function showNews(&$sHtml) { $sHtml.='<input type="submit" name="btnDel" value="delete"/>'; $aNews … |
| | I'm currently linking two different tables in two different databases. One contains all the info from a product, while the othe contains information about the installation of the product. The SQL I use only returns those products that HAVE an entry in my install table, but many don't ie they …  |
 | Hi All, the following is a script to search using LIKE. i know data exists, but its simply not playing. any help on syntax corrections would be appreciated. regards paul [code] <?php if (isset($_POST['search'])){ echo $column = $_POST['column']; echo "<br>"; echo $param1 = $_POST['param1']; $srch = "%".$param1."%"; echo $SQL = … |
| | This is a MySQL PHP question... how to count no of fields in a perticular database and in a perticular table?? I have three columns in a table :id , name , info I have to print the unique persons.. how could I?? How to code it in php?? Can … |
| | How to print more than one results in a page?? I want to print 10 results per page and show next button if it have more than 10 results.. In the next button it will show another 10 results.. How to code it..?? And please explain the code if you … |
| | function gethotproperty($hot){ $gethot = "select p.reference_id, p.area, p.area_unit, p.transaction_type,p.property_type,p.property_name,p.address1,p.address2,p.city,p.locality,p.pincode,p.area_in_sqft,p.total_price,p.negotiable,". "p.rate_per_sqft,p.num_bedrooms,p.floor_number,p.intro_image_loc,p.amenities_detail, p.specification_detail, p.location_detail from " . DBConf::getDatabaseSchema() . "property p where p.hot = ".$hot; $result = mysql_query($gethot, $this->connection); $property = new Property(); while($row = mysql_fetch_array($result)){ $property->referenceId = $row['reference_id']; $property->transactionType = $row['transaction_type']; $property->propertyType = $row['property_type']; $property->propertyName = $row['property_name']; $property->address1 = $row['address1']; $property->address2 … |
| | Hi everybody I need a help. codes below are written by someone else. I have a mysql database, html form to login to this database: [CODE] <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <html> <head> <title>1</title> </head> <body> <h4>Please provide correct username and password:</h4> <form enctype="multipart/form-data" action="login.php" method="post"> Login: <input … |
| | Hi, I want to run some queries in mysql. Also, I want to automate this process. So can someone help me with shell scripting?? I want to open mysql in terminal, type in the password and give some queries.. Can I write a script for d whole thing?? |
| | How can i create a php file that export my selected mysql database to a execel or csv form i have my own database named as "users" that have 10 tables i want to php file that export my "users" databse to ms excel and which when run on the … |
| | Hi Guys... I'm making a form with the ability to delete users. But don't know how to do it... My form structure.. users.php ---- Lists a user with options like edit user / delete user. (His details are displayed from database on my html page in a table.) For delete … |
| | Hi Guys! I want to know how to limit the no of records to be shown in dropdown list from mysql.Below is my code. I just want to list 4 records from colum name 'department_name'. The colum has 11 records in total. [CODE]<select class="ac" name="area" > <?php $qry = mysql_query("SELECT … |
| | Hi everyone, can you check for me if my codes below are correct? i am having problem to retrieve my image file from mysql database. The errors start at "header" parts. I have no problem to store image file (mediumblob) in mysql database. The file shown are in HEX forms. … |
| | Hi, I'm actually drafting a MySQL query to be fed into Jasper Reports, and since I can no longer manipulate the resulting data in PHP as it will automatically be translated into a chart by jasper, I need my mysql statement to be able to generate what I need on … |
| | Pls help: [B]Warning:[/B] require(connect_to_mysql.php) [function.require]: failed to open stream: No such file or directory in C:\wamp\www\chibenda\root_directory\index.php on line 3 [CODE]<?php $db_host = "localhost"; // Place the username for the MySQL database here $db_username = "root"; // Place the password for the MySQL database here $db_pass = ""; // Place the … |
| | I need to write a method to return the number of rows I have in my table. This code I've written so far; [code] <pre><?php class Database { private $connected=false; private $user,$pass,$host; private $db; private $result=array(); public function initialize($user, $pass, $host) { $this->user=$user; $this->pass=$pass; $this->host=$host; return $this; } function connect($dbname) … |
| | hi i am trying to insert into mysql databse using jsp.but i am getting the error as [CODE]An error occured between lines: 38 and 47 in the jsp file: /jsp/havyaka/register.jsp Generated servlet error: C:\tomcat\work\localhost\examples\jsp\havyaka\register$jsp.java:102: Incompatible type for declaration. Can't convert int to java.sql.ResultSet. ResultSet rs = statement.executeUpdate("insert into havyak(usercode,password,email,name,phone,add1,add2,add3,add4,country) values('" … |
| | Hi, got some help from tesu on another thread but i am struggling to get this working. my individual query returns 2 results which is correct from the database. however when i try it with a view joining the multiple table with same query it returns 2 results but only … |
| | Is it possible insert datas of excel file [.xls] to the mysql? Not CSV file, please post me a coding...  |
| | Hi All, Ive just imported two CSV files into phpmyadmin, but i need to add an auto increment field into it, and then populate it. Any advice on how to do this would be appreciated |
| | I'm developing a very simple VB app in Visual Basic 2008, where i have a textbox being dynamically updated with a value every second, i need this value to be inserted into a mySQL DB, i have made the connection ok but not too sure how to structure the VB …  |
| | Hi, I am setting up a notes table, and wondered what the best type would be? Currently i have set it to Varchar with length 500 Would that take up more space than say a Lontext type in the database? Thanks |
| | Hi, I got some great help on the forum to create my total due query. However it produces it with just total due, how could i have it by month? each table has a DueDate column which i would like to show on the query along with the users FullName … |
| | Hi guys, Need some help here. I have created an individual query for each product which works absolutely fine. However i want to be able to join it so i can display on my page who is due for a review. [CODE]SELECT clients.*, protection.* FROM (clients JOIN protection ON protection.clients_ClientID=clients.ClientID) … |
| | Hi I am using tomcat 5.5 and I am unable to connect to mysql server(Wamp2.0i). Here is my code: [CODE] <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <%@ page import="java.sql.*"%> <%@ page import="java.io.*"%> <html> <head> <title>Connection with mysql database</title> </head> <body> <h1>Connection status</h1> <% String connectionURL = "jdbc:mysql://localhost:3306/names"; Connection … |
| | Hi Can anyone please tel me why my code is not updating my MySQL database? The code does not return any errors. It does how ever tell me that the update is successful, but there is no update. Pelase let me know should you require to view the code running … |
| | Hi, I am somewhat new to PHP and MySQL and I am having a little trouble with what I want to do, which is assign a cell for each option selected and a price or insert the price into MySQL table depending on the option selected. Whichever is easier or … |
| | I'm developing a very simple VB app in Visual Basic 2008, where i have a textbox being dynamically updated with a value every second, i need this value to be inserted into a mySQL DB, i have made the connection ok but not too sure how to structure the VB … |
| | Hey there, I have a code to remove the duplicates in one of my table but I cant seem to be able to ORDER the way mysql select the values. Here is my initial table: [url]http://img196.imageshack.us/img196/2421/tablesw.jpg[/url] [CODE]mysql_query("CREATE TABLE new_table as SELECT * FROM test GROUP BY url") mysql_query("DROP TABLE test") … |
| | I am developing a website related to network marketing which has a binary incentive scheme. i want a code which shows the downline of a member. a member can have 2 downlines and those downlines can have downlines as well. so i want a code which shows all the downlines. … |
| | I am working on an page that will print scheduled classes and appointments after querying a databse for them. Right now I'm trying to store the names of people with appointments in an array so I can print it after adding the classes as well. I've gotten stuck on this … |
| | Hi, need help with inputing images to mysql. I read lots of previous thread about it but couldn't find the proper answer. this is code for my basic form: [CODE]<form id="form1" name="form1" method="POST" action="<?php echo $editFormAction; ?>" enctype="multipart/form-data"> <table width="100%" border="1" cellspacing="1" cellpadding="1"> <tr> <td>tytul</td> <td><label> <input type="text" name="tytul" id="tytul" … |
| | hi guys having a problem getting a single value from a mysql query getting all sorts of problems - heres my latest version below [code=php]mysql_connect($host,$user,$password) or die( "Unable to select database"); mysql_select_db("mydatabase"); // select database to use. $user = 84; $sql1="SELECT `order_id` FROM `table1` WHERE `user_id`= '$user'"; $array = mysql_fetch_array('$sql1'); … |
| | While attempting to use my forum posting system, I received a mysql error that said to look for the correct syntax to use around '' on line 1. I attempted to reproduce the error but was unable to do so. Any ideas on what cause this and how to prevent … |
| | I have 3 tables. Here is the relevant information needed for each. items ------ prod_id order_id item_qty orders -------- order_id order_date order_status acct_id accounts ------- acct_id is_wholesale items is linked to order by the order_id and orders is linked to accounts via acct_id I need to sum item_qty for all … |
The End.