11,093 Topics
 | |
| | Hello, I am trying to insert values from a .csv file into a MySQL database from a GUI. I cannot seem to accomplish this. I keep getting a null pointer exception where I set the connection properties in my main method. I also cannot seem to figure out how to …  |
| | Hi Friends, In the website in which i am developing for every searches made an entry would be made in a table. As a result of this the size of the table grows to great extend. Now i am planning to take the backup of that table periodically and to … |
| | Hi, I have an ms-access database (.mdb) which I need to import to mysql. Is there a free software to make a .sql dump of this ms-access database? I have been trying some softwares (google searched) but none of them worked. One of them was able to replicate the table … |
| | Hi all. I have a table with a this records: [CODE] <!-- Table user_activity --> <user_activity> <id>1</id> <event>LOGIN</event> <username>user@domain.com</username> <domain>domain.com</domain> <remote_address>ip_address</remote_address> <date>2008-05-23 20:19:36</date> <comments></comments> </user_activity> [/CODE] I am trying to query the DB to get the total results of activity PER DAY. This is my query (which obviously doesn't work): … |
| | Hello i am trying to generate mysql reports. I have them working but my problem is: i want to happen is when u click an option value e.g. list customer details, i want it to generate the report automatically. Here is my code below it is all correct i just … |
| | Hello! Im new to PHP and have a need for what I have found out is called AJAX. I prefer to code in PHP for my DB access. I need to create a dropdown list using AJAX that updates it self depending on what is slected in the parent dropdown … |
| | Hello. I have a php script that is pulling records from a database. Everything up until now has been working great. Even now the first page of results show up as they should. (5 records are displayed per page) When I click on "next page" to view more results I …  |
| | ok so here is the error:[ICODE] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from, content, date) VALUES('', '', '', '')' at line 1 [/ICODE] Between the apostrophes is the information from the …  |
| | |
| | hello i have the following code [COde=php]<?php mysql_connect("localhost", "lekan", "") or die(mysql_error()); echo "connected to database"; mysql_select_db("today") or die(mysql_error()); echo "Connected to database<br>"; $tables=mysql_list_tables("today"); if ($tables ==""){ echo "this database does not have a table"; exit; }else { echo $tables; } //number of rows $row_num = mysql_num_rows('first name'); if (!$row_num){ … |
 | I am working on a project that requires a MySQL database to store important information (So a little security would be nice). I realize that some users can't find or don't have MySQL databases with their hosting accounts. I would like to provide users with the ability to get a … |
| | hello I've got two tables that I want to be connected(let's call the A and B), so I made a third table. In table A and B i got two primary keys a_id and b_id. Now I create the third table named AB. Inside that I create ab_id as primary … |
| | Hello everybody, i am trying to import an mysql table to sql server both has the same attribute and with the same datatype. and here is what i did : 1- i export the mysql table to excel sheet. 2-then i went to the sql server and import this sheet … |
| | MySQL is great, especially for storing large amounts of data such as users, event logs, and tables for forms or CMS systems. There is one big problem though that faces PHP/MySQL developers: MySQL injection. Hackers usually try something like a username and password of ' a='a'. This is a MySQLer's … |
| | Hi all, I need to save a number to 3 decimal points, however I want 10.3 to be saved like this: 10.3 not this: 10.300 varchar will not work because ORDER BY rating treats 10 as being lower than 9... So what datatype should I use? Thanks, Max. |
| | hello Everyone I was wondering if anyone can help me with a little php and mysql problem occurred to the CMS i am using. I have a function which is get data from a table after updating the table, the code is as follow: [code=php]public function getHtmlWrapper($id) { //get entire … |
| | Hi all, I am fighting with this a while allready, a moving average with mutilty items The (example) tabel : item datum volume item1 1/1/2009 10 item1 1/2/2009 11 item1 1/3/2009 12 item1 1/4/2009 11 item1 1/5/2009 10 item1 1/6/2009 10 item1 1/7/2009 10 When i do this with only … |
| | hello everyone i am currently working on a php script on my website. I wanted to make a script for registering users. So that they may log in, log out, register, and access member only functions. I found a good tutorial online but since im fairly new to php and … |
| | i am trying to retreive the contents of the table in my databse into a html form using servlets in tomcat. here isthe code: [code] import java.io.*; import java.lang.*; import java.sql.*; import javax.servlet.*; import javax.servlet.http.*; public class ServletusingData extends HttpServlet{ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{ response.setContentType("text/html"); …  |
| | Hi everybody, I want to have a login form in Java, which comparing the username and password, according to MySQL database data, so I have the following code, just don't know where to add the select statement and how verify the username and password from MySQL with the JTextfield of … |
| | Hi, Im having a wierd problem with my mysql query: I have entries in my database with a rating (out of 10) and a timestamp, and I want to pull out the highest rated entry from the past 30 days. These are the entries I have: [CODE]Primary key ----------------- Rating … |
| | I'm a noob and am struggling with what should be some fairly straightforward php and mysql coding. I have a page that I am building and am able to get the following code to work: [code=php]<?php include 'includes/config.php'; include 'includes/opendb.php'; ?> <div align="center"><h1> <?php $id=$_GET['player_id']; ?> <? $query= "SELECT p.player_id … |
| | hi, I have implemented the following query to search the db for exact phrase (ex : if the search term is "air" should match the exact word not like hair). Quote: [code=sql]select A.*, B.*,C.GGCategoryID,C.CategoryName,C.CategorySlugName,XX.EcoStatus from tbl_products A,tbl_members B,tbl_product_categories C ,tbl_eco_ratings XX WHERE A.MerchantMemberID=B.MemberID and B.MemberType='Merchant' and A.GGCategoryID=C.GGCategoryID and XX.EcoStatusValue=A.EcoStatusValue and … |
| | Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/sites/miraclehosting.co.uk/public_html/scdc.php on line 169 --------------------------------------------------------------------------------------- Can anyone help here this is doin ma ed in!! gggrrrhhhhh i get the above result when Load the script into the browser. here is the form: [code=html]<form action="scdc.php" method="post" name="chooser"> <label>Select Parish … |
| | Okay, I'm trying to output data from one table, with only certain instances pulling up data from another table. On a value of 0 in PriceID, it uses values in the first table; on a value of anything else, it should pull a set of values from the second table. … |
| | Hi all Mamp is not processing my php files, anyone know why this might be? Very general question I know, I've tried most of the usual suspects; preferences etc.... |
| | I have a database that I want query and pull an users specific details into a "$profile" variable. the url would be: "[I][url]www.website.com/profile.php?id=12345[/url][/I]" Thus, I use the $_REQUEST["id"] to put the id number into a variable and then I query the database using this id number. The code is below: … |
| | hi i had a database table and one of its column is filled with hobbies of the users. ( eg: stampcollection, fishing, photography ). How to do a search in this column. I am using php. If visitor search by any hobby then need to show users in database who … |
| | Hi All, I am trying to build an SQL statement that will pull data from a parent table and count rows in a child table. Parent table - event: [CODE] eventid, title 1 'Metallica is coming' 2 'Elvis is in town' [/CODE] Child table - eventattendance: [CODE] eventid, userid, response … |
| | So I have a sql query [code] SELECT * FROM `database` ORDER BY `database`.`Name` DESC [/code] Is there anyway to index this so it uses a lot less Handler_read_rnd_next |
| | In my mysql data is something like this Name 1.0 Name 6.0 Name 5.2 Name 4.8 Name 10.00.258 now when I short that column it shows up like Name 6.0 Name 5.2 Name 4.8 Name 1.0 Name 10.00.258 I want that 10 to be on top Is there any way … |
| | I am only beginner in this. I don't understand all of code, most of it was given to me to work on. I am trying to do checks on MySQL on workshift table. There is dayshift, eveningshift and nightshift (Other two fields are shiftid, name and date). They are drop … |
| | I am only beginner at this. I don't understand this fully, half of it was given to me and other half was my team writing it out. I can't work out how to create a form to edit a table. There is people.php file. Thats the file I want to … |
| | Hello, just recently I have experience the following error message: "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/ptremail/public_html/admin/newmail.php on line 431" If anyone could help I would greatly appreciate it. I have pasted the entire code below. Thanks! [ICODE]<script language="javascript"> function clear(){ for (i=1;i<=240;i++){ document.getElementById(i).checked=false; … |
 | |
| | Hi people... I have phpVideoSearch script, and want to add a feature, that if someone a specified page, to add to mysql a +1 value... Example this is the page: [CODE]watch.php?title=Riz+Khan&link=http://www.youtube.com/v/[B]xE0wOa5R6KY[/B][/CODE] i've set a code to create a id for this video like: [B]yt_xE0wOa5R6KY[/B] Can someone help me create a … |
 | Can someone help me with this database, code bellow [CODE]-- -- Table structure for table `bapps` -- CREATE TABLE `bapps` ( `bappID` int(11) NOT NULL auto_increment, `bappFROM` int(11) NOT NULL default '0', `bappBUSINESS` int(11) NOT NULL default '0', `bappTEXT` varchar(255) NOT NULL default '', PRIMARY KEY (`bappID`) ) ENGINE=MyISAM AUTO_INCREMENT=51 … |
| | Hi. I have this problem Group by will make the table only show a value of that group once. So lets say there was 1000 results without group by. 500 with a single group by. But now i want to do another group by to filter it down more to … |
| | Hello all, using mysql I have the folowing (example) table +------------+--------+ | date | total | +------------+--------+ | 2009-01-08 | 150000 | | 2009-01-09 | 151000 | | 2009-01-10 | 156000 | | 2009-01-11 | 154000 | | 2009-01-12 | 153000 | | 2009-01-13 | 157000 | +------------+--------+ Now i … |
| | I cannot get mysql working. This is a Fedora Core 2 installation, I tried installing mysql with yum (it installed the 3.23 version, I dont want that). I tried upgrading, that did not go so well. I tried installing from the binaries, well, that didnt go to well either. So … |
| | Hi, I am wondering is there a solution to do this type of problem. I would want to release a list of queries that only show only orders that does not match each other. For a order to match it will be companyname from different hiddenkey are the same and … |
| | hi All, I want to ask if is there any possibility to separate column data in different columns using php code.. really dont know if i have solution in php or here in mysql.. any idea would be really appreciate Thanx enim |
| | New PHP person here.. I am setting up an event registration page. The users must select from two arrival dates for hotel and flights. from my database, I am able to populate a dropdown with the two dates. [code] "SELECT DATE_FORMAT(firstarrival, '%d %M %Y') as newfirsta, DATE_FORMAT(secondarrival, '%d %M %Y') … |
| | Hello ALL, I have a table contains words extracted from documents which are belonging to a number of categories. Each category contains a number of documents. For each category, I want to find out those words which occur at least in N documents belonging to this category. [Code] Category DocID … |
| | I am writing a stored procedure in which i want to catch all the exceptions.So. i need how to catch the error code from an exception. |
| | Hi..I am fairly new to SQL and need some help writing a script. I have 2 tables table 1 is the student data and table 2 is the student schedule data. In table 2 the students have a student id number that is teh same as the student id in … |
| | Hello, I have two tables, one with the main users details in and a users movement table which has an entry to everything they do. I want to pull out a list of all users which havent done a specific task, put only pull the results once. So for example … |
| | hi I am working in a online shopping website using php, MySql. And I had a detail database with me . Let me give some details I had columns in my table. ie 1. name of the product ( eg : 1 gb pendrive) 2. Brand 3. warrenty 4. category … |
| | Hello all. I'm working on wiki development now and have some issue with MySQL. I am using InnoDB engine to store wiki data. Sometimes updating data with wiki Database class [icode]$dbw->update()[/icode] do not update my database data (I can see it via phpMyAdmin). When debbuging the code I've found that … |
| | I work in an office that has an Intranet site for office use. We have two Windows 2003 Servers. One Server has the Intranet site on it and all of the files (php html pdf txt etc) that are used in our Intranet site. The problem is we do not … |
The End.