11,093 Topics
 | |
| | How do i perform search from php within the search result that was just returned? In oder to perform a search on the result set again i need to have the result set stored some where. either in session/cookie or temporary table in the mysql server. i tried the mysql … |
| | Hi There. Is it possible to use the LOAD DATA LOCAL INFILE command from a crontab or what will the best way be of importing a csv on a hourly basis. Regards |
| | hi, i have been trying to work out how to list all the users on the database for my website with a particular access level and also only the user id that the client is associated to however i end up with duplicated users. here is my query so far …  |
 | I'M reading the book "Simply SQL" and I need to use the files for the book. It was suggested to be to use postgreSQL and now I've got it up and running on my Ubuntu machine. But I'M having a little bit of trouble getting started. When I first start … |
| | I am writing a GUI in GKTMM for my own learning experience and to use on a personal project I have at home. The data will be stored in a MySQL database on a server I already have running in my home and which I use for some PHP/JavaScript code … |
| | I am learning to write C++ code to access data in a MySQL database. My goal is to use a separate class to control the database access so I can use this class elsewhere. To facilitate my learning, I'm working on simple code to connect to a database (success!) and … |
| | hi, i am a teacher. i have a list of students in my MySQL table. How to retrieve their names one by one, and while doing that there will be a text box to put their marks in. |
| | Not sure if many ppl here use navicat, but I am somewhat confused by the way data entries are handled through my page and how that interacts with my local db server and my remote db server. For example, at work I am sometimes working on cfm templates on my … |
| | All, I'm having issues running a simple java program on the linux command line. When I run: java -server -cp ./mysql-connector-java-5.1.12/mysql-connector-java-5.1.12-bin.jar -jar PaymentProcessor.jar I get `"java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost/pmtdb"` When I run this command (which works on the windows command line) java -server -classpath ./classes;./mysql-connector-java-5.1.12/mysql-connector-java-5.1.12-bin.jar paymentprocessor.PaymentProcessorServer I … |
| | Hi All, I am creating a MySQL Module for usage in all my applications, one of my functions writes all data from the MySQL Database to an array, although to make this as versatile as possible I want one of the paramaters to be used to choose which array the … |
| | Hello! I have designed a dialog with a grid widget. I would like to populate it with data from a MySQL table which has 10396 rows and 5 columns, as the grid widget. How can I do it? Then, how can I select a row from the grid widget and … |
| | I am absolutely newbie to Ajax and I need to have this fixed by tomorrow as I have a project to complete so anyone who could help me, I would be really greatful! This is what I have cooked up so far index.php [code=php]<html> <body> <script language="javascript" type="text/javascript"> <!-- //Browser … |
| | Hi ... I'm trying to make a drop down list box populated from a mysql table. It all looks OK on the screen, but there is an error that I cant seem to fix. The error is: Notice: Undefined index: xxx in C:\Documents and Settings\GSW\My Documents\xxx\test.php on line 29 and … |
| | This is the part which searches and add the result to the 'pass' variable. At one stage I was getting a resource id number and found to get around that, but when I do this I get nothing on the pass variable [code] $result = mysql_query("SELECT `Pass` FROM `wiki` WHERE … |
 | I Can't upload imige as my database donot support update although i give all previliges to the user root.Whats the problem?? Please Any one help me.The same code work on local PC. The link is: [URL="http://csefriends.com/index.php?page=auth/change_image.php"]http://csefriends.com/index.php?page=auth/change_image.php[/URL] The code is given below: [CODE] <?php $id=$_SESSION['userid']; $name=$_POST['name']; $fname=time(); $type= ".jpeg"; $fname = … |
| | i have the multiple chioce.. this is the source code [CODE]/* * To change this template, choose Tools | Templates * and open the template in the editor. */ import java.io.*; import javax.microedition.io.*; import javax.microedition.midlet.*; import javax.microedition.lcdui.*; import java.util.*; /** * @author user */ public class listphp extends MIDlet implements …  |
| | I am facing a query performance problem. While connecting to MySQL database through different Users methodology. Tell me does connecting by IP address user has over head. Like connecting using user@locahost or user@host-ip-address Is there any performance-wise difference by connecting using any of this user. I am getting a massive … |
| | Hello All- I'm in the process of getting started a complete website for guidance and discussion about a new type of banking/lending. I would like to offer my fellow investors or potential investors greater access to slice and dice the data of one of the key companies involved in this … |
| | Using the following: [CODE] protected void testDriver ( ) { String drivers = "nada"; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); } catch ( java.lang.ClassNotFoundException e ) { System.out.println("MySQL JDBC Driver not found ... "); } catch (IllegalAccessException ex) { System.out.println("Illegal Access"); } catch (InstantiationException ex) { System.out.println("Instantiation problem"); } System.out.println("Midway drivers are " … |
 | [code] namespace sqlconnecttest { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { SqlConnection myConnection = new SqlConnection("user id=name" + "password=pass;server=http://www.mywebsite.co.uk;" + "Trusted_Connection=yes;" + "database=mydb; " + "connection timeout=30"); try { myConnection.Open(); } catch (Exception f) { MessageBox.Show(f.ToString()); } } … |
 | Hi, i need some help, since mysql benchmark don't work well on select i need help with a query what will be the fastest way? to use this query: [code]select * from news n, users u where n.users_id = u.users_id and u.users_id = '1' limit 0, 20[/code] using like this … |
| | How do I format the links from a mysql query to show [U]click here[/U] on my webpage. $row['reviewlink'] (eg of reviewlink = [url]http://www.abc.com[/url]) I want this result to show in the html source code: <a href="http://www.abc.com" >click here</a> So the page shows [U]click here[/U] and links to [url]http://www.abc.com[/url] I want … |
| | I've been trying for a few hours now, and to be honest I'm getting fed up of it not updating the table!!!:icon_sad: [CODE]$sql="UPDATE list SET title='$_POST[title]', console='$_POST[console]', system='$_POST[system]', tv='$_POST[tv]', sram='$_POST[sram]', chips='$_POST[chips]', size='$_POST[size]', md5='$_POST[md5]', sha1='$_POST[sha1]', work='$_POST[work]', error='$_POST[error]', retrode='$_POST[retrode]', comments='$_POST[comments]' WHERE ID='$_POST[id]'"; if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } echo "1 … |
| | This is the part which searches and add the result to the 'pass' variable. At one stage I was getting a resource id number and found to get around that, but when I do this I get nothing on the pass variable [code] $result = mysql_query("SELECT `Pass` FROM `wiki` WHERE … |
| | Hi all, I hope you are well. I have a very quick question for you please. I have a table with x rows and y columns. I need to select the top 100 rows ordered by col2 for eg. Further, I need to select only one row for a particular … |
| | Ok back again. lol I just purchased a new hosting provider and was trying to transfer my database over to my new site. I exported the tables using Navicat and "tab" as the delimiter. I have three tables and they all saved as text files and look fine when I … |
| | Hi, Please let me know whats wrong with syntax of the following query, its written in MS Access format: Select count(*) from [Demographics/Job Data Table] D1 WHERE EXISTS (Select (*) from [Demographics/Job Data Table] D2 where [D2].[Supervisor ID] = [D1].[Employee #] and [D2].[Termination]=Yes) I am getting a syntax error message … |
| | how to insert and retrieve a 20mb pdf file from mysql database? |
 | Hi all I have a table that has a datetime column. What I'm trying to do is select the time only like one does when selecting only the day or month from a date column (eg SELECT day(date)) Can anyone tell me how to get this right. Using the following …  |
 | HI All, my requirement is as below: lets product name is "aaa bbb ccc". Now in search coding i have use LIKE statement. [CODE]"... where product_name LIKE '%".$keyword."%'"[/CODE] Now when user insert 'aaa' or 'bbb' or 'ccc' or 'aaa bbb' or 'bbb ccc' search works. But if user insert 'aaa … |
| | Hi everybody, I wanna make a simple leads form in php, this form has three fields. the first field is "code", the second one is Name and third is e-mail. the issue is that i have two tables in my database and i want in one hand store all this … |
| | Hi, Im having a problem with this image uploading thing..:( I was able to upload the image to a folder in the server,but the problem is I dont know how to set the path in the database.Every time after uploading I set the path manually.And I could be able to … |
| | Dear all, I have some table on my database. i had input them via JSP and i view them on JSP too. i use simple MySql queri in it to view the values of the Table. But when i use another query like : [CODE] SELECT tabel_jawab.nis, CASE WHEN (tabel_jawab.jwb1=tabel_kunci.Kjwb1) …  |
| | I use a couple of functions to which I have to pass the name of the mysqli connection in order to fetch some data. Is it safe to use a global variable for the mysqli connection to skip passing the connection name to the functions?  |
 | I want to upload and store images in MySQL database, but have no idea. Please help me out? Thank you |
| | I have my website up and runnng succesfully with around 5000 member - [url removed] Now I want to start a Social Networking option for members using a CMS - like Wordpree-WU, Drupal, Joomla, SE ... How can I use my current users databese to these CMS database? Please help … |
| | hello all i'm using cUrl and mysql in PHP but new to c++ for connecting to remote mysql database and run query what i need? should i install mysql connector? where are mysql libraries? may i download a large file for example 400 mb in c++ using cUrl ? i … |
| | i want to use federated tables in my db and not sure how to set them up in phpmyadmin...? does anyone have a solution for me...? |
| | How exactly do I transfer data from my local server to my remote server. I had been using Navicat, but want to do it using myPhpAdmin, if possible. Thanks for any help in advance. |
| | Hey guys, I'm a total newbie with this PHP stuff but i'm stuck with my page that allows people to sign up to my mailing list. Every time you press the "Submit Query" button on the form it brings up the option to download the php file. Have been working … |
| | I have a table with 3 columns, a record_num, a date field, and a description. In the date field there can be some rows that have a distinct date and others that have the same date. I wanted to take a look at all the rows that have dates that … |
| | Hello guys, I am having a weird problem. I cant understand and i have spent almost 2 hours in finding the problem. Well,Actually I have a table of id,date,comment. id and date are composite primary key. so id always starts with 1 everyday. now i want to find the max … |
| | Hi I m using xampp latest version. I have a table created by phpmyadmin. Now I want to delete all data form the table, But dont want to drop the table. Problem is that... When I click oncheck_all it select all checkbox. but some row r yello background. When I … |
| | Hi, I need to print all the orders with the month in the Monthly Order Report.How should I do it.Can someone tel me how to do it... This is my query.Order date should equal to the relavent month... [code] $this->result = mysql_query("SELECT * FROM tbl_order,tbl_order_items WHERE tbl_order.order_id=tbl_order_items.order_id AND tbl_order.order_status='accepted' AND … |
| | Hi frnds, I need display mysql field as check box value. <?php mysql_connect("localhost","root",""); mysql_select_db("postal") or die(mysql_error()); $query = mysql_query("SELECT name FROM register"); while ($row = mysql_fetch_assoc($query)) { $tag = $row['name']; echo "<input type='checkbox' name='register[]' [U]value='$tag'[/U] />\n"; } ?> here i paste my code here. it displayed only checkboxes. not value.any … |
| | Greetings, I installed MySQL 5.1.48-2 on Fedora 13 64bit. Whenever I tried to connect using the terminal by typing : [B][user@work ~]$ mysql[/B] I get the following error: [B]ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)[/B] I also installed MySQL on Red Hat Enterprise 5 … |
| | Hi, I'm an experienced developer but not done much in c++ and wanted to get some basic database operations in my program, open, store, retrieve etc. Does anyone have any good links that could get me started? Thanks Baden  |
| | I just got postgresql & pgAdmin III up and running. I'M trying to start the book "Simply SQL" so how do I go about getting to .sql files for the book into pgAdmin? Thanks for any and all replies. |
| | how do i run a query for a variable with multiple values? i've been told a loop is not the right way to do it, which is the way i've been doing it and it has worked. I assumed putting it in a foreach loop would accomplish looping the query … |
| | hi all, i have a little issue with SUM query from this table UNIQUEID Date Production engine1 01/12/1999 1440 engine1 01/01/2000 6061 engine1 01/02/2000 5152 engine1 01/03/2000 5347 engine1 01/04/2000 4642 engine1 01/05/2000 5264 engine1 01/06/2000 5247 engine2 01/07/1995 561 engine2 01/08/1995 3066 engine2 01/09/1995 2133 engine2 01/10/1995 2282 engine2 … |
The End.