10,946 Topics
 | |
 | 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 … |
| | As you can see from this page: [url]http://www.cornwallfantasyhockey.com/cfhl/schedule3/[/url] I have created an output table of 11 players. I would now like to total the GP and PTS column. Here is what I have so far: any thoughts? [code] <?php $result = mysql_query("SELECT * FROM stats1011 where 1A = 'BULL' OR … |
| | i'm working on an e-voting system for my thesis... but i'm having problem on how to output the data in all the rows in the database in a check box. so it means that the number of checkbox is equals to the row of the table. i manage to output … |
| | heyy... i need to knw how to update some table value to default value automatically after some period of time. assume that user update table value to "false" today. then it will be update to its default value "true" to tommorow by automatically. some one told me this can be … |
| | hi! i have little problem with left join below script working but i want to add restriction field_id = 16 (any value) and user_id = 65 (any value) pls help me how to do this [CODE]id user_id field_id value[/CODE] [CODE]<?php $dbHost = "localhost"; $dbUser = "root"; $dbPass = "123"; $dbName … |
| | Hi I have a database which has a table named [B]main[/B] and a field named [B]description[/B] typ of [B]description[/B] is [B]longtext[/B] I can insert more than 100 word through phpmyadmin. but can't insert through form submit by post method. but Here i can insert 10 word through same form submit. … |
 | i am making a webstore and it has a table that has all the items in it. like each item has its own row in the table called like "items" or something right and each column is specific to all items. but im lost what to do with orders. i … |
| | hey all I have these lines [CODE] create table Singers(SingerName varchar(30),picture text,id int primary key auto_increment); create table Songs(id int primary key auto_increment,sid int,foreign key(sid) references Singers(id) ON DELETE CASCADE); [/CODE] In situation I want to delete a Singer for example who has the id->1 from Singer's table automaticaly to … |
| | Hello! I have a table with the structure you can check at [URL="http://spreadsheets.google.com/ccc?key=0Ahb705_66NMOdG5RM0stQU5wVC1JUmRBbWhLeDRyM2c&hl=ca"]http://spreadsheets.google.com/ccc?key=0Ahb705_66NMOdG5RM0stQU5wVC1JUmRBbWhLeDRyM2c&hl=ca[/URL]. The table has many more rows but no more columns. Is there a way to select the rows like select all the fields from Table from row where Family is Tinamidae to the next non empty row … |
| | hello, for my application I have created a database containing a table where my clients data is stored before they are allowed to use the website. When they are allowed, the info on this table has to be transferred to 3 different tables, using the insert...select-statement. Doing this I don't … |
| | We have 3 shifts running at our plant, day 0720 - 1520 swing 1520 - 1120 night 2320 - 0720 I have a table storing the bags packed on each shift, and now need to display the team (tech, packer_l, packer_r etc) with the greatest number of packed bags depending … |
| | Hello All, I seem to be having an issue with a many to many relationship database or how I like to call it a many to many to many...... j/k. I am wondering if I can get some input for this very long problem. I work for a direct mail … |
| | Hello! As a part of a database project, I need to find a way to send a MySQL table to wxpython and then select some of its records (using a Select/Remove button) to store them in another class of the database. Is there any kind of widget to do this? … |
| | Hello! I am trying to update a MySQL table using a Python code but I am having some problems. I define the connection and the cursor in the Ornithobase (wx.Frame)class in the OnLof function as [CODE]self.db= MySQLdb.connect(host='localhost', user=self.Username , passwd=self.pwd, db='Ornithobase') self.cursor = self.db.cursor()[/CODE] Then, in the same class but …  |
| | I have designed a survey with PHP that submits the responses into a MySQL database. The people that will be taking the survey are existing clients which have user IDs and information stored in a database that I do not have direct access to. What I would like to do … |
The End.