10,932 Topics
 | |
| | Hi all, in my website there are ftp-uploaded images (about 3000) in a folder called IMAGE. What I want to do is somehow get the image file names inserted in to my database so, I can see image file names in a pull down menu selection when I insert records … |
| | I wish to create an inventory database with the following: 1. When an item is checkmarked and the submit button is pressed that item is deducted from the mySQL Inventory portion. By default only 1 is deducted per item, but if they add to the Quantity they wish to order … |
| | Ok, i have a database where i'm storing information on plants and in one of the tables is a plants table: here's the first few fields in the table plants: [code] plant_id, family_id, genus_id, species_id, auth1, auth2, ... [/code] plant_id is the pk, family_id, genus_id, species_id are foreign keys. soon … |
 | Hi all, I hope everyone is well. :) Ok, I don't know how to explain this properly, so I'll just struggle along & if you need anything clarified, please ask. First, I'd like a quote from only very experienced MySQL/PHP programmers on how much this appl. will cost to build. … |
| | I want to know how to copy the mysql database on my development PC to mysql server on my production PC. Please, anyone who knows how to go about this should help me. Thanks! JNORA |
 | Hello Everyone, I was trying to figure out why this particular mysql_query() doesn't return false and how to deal with it. First of all, I have a table (call it table1) with only one row in it. The one row has a 2 in the user_id column. So when I … |
| | Hi, My php script would do a few updates/inserts to a table. after that I would like the rows that have not been affected by the script to be deleted from the database. cant figure out how to do this. any ideas ?  |
| | I've been tring unsuccessfully to find information on what each language, C and PHP, have to offer in terms of working with MySQL. Just wondering if anyone out there has preference for one or the other and why. I understand that PHP is supposed to have alot of built-in functionality … |
| | I have a huge database in SQL on my hard drive, I am trying to figure out how I can get it online with a decent looking interface to allow my sales people to run querries on it simmilar to what infousa has going on. My database knowledge is not … |
 | Hey, I've been searching around, having a hard time finding something. Are there any simple scripts out there or something that I can use to generate graphs from information in mysql database tables? |
| | Hi all, I have written a query like this. [code] $dbh= DBI->connect("dbi:mysql:dbname=$database;host=$hostname", "$username", "$password"); $statement = "SELECT patient_intime from $table_name where patient_intime=$ARGV[0])"; [/code] I want all the "patient_intime" values to be retreived, where there are other columns(fields) also. Pls suggest me how to proceed. Thanks in advance. Padmaja T N.  |
| | I am trying to set up a java server page and mysql. I have installed jdk and all of the neccessary tools and drivers. I am using Tomcat for the servlet container. I have also set up an account with a password on mysql. I think that the only issue … |
| | suggest me a way on how to upload file using JSP to mysql database |
| | I just finished a php MySQL query. Everything is great, except the date column doesn't format correctly. The date output looks like this: 1175114705 The date column prints from: echo $row['createdTime']; Ideas? Thanks. |
| | Hi all, Im trying to create a trigger but keep getting a syntax error. Basically the trigger must be created after a insert on table_1 and update another table's fields with 1 depending on what was inserted into table_1 ( apple, orange, banana, grape ) CREATE TRIGGER trigger_name AFTER INSERT …  |
| | Hi, I am Linux Fedora and having problems connecting to MySQL despite being root. Here is the error when I type mysql at the prompt/terminal. [B]ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)[/B] Can any one help? Thanks... |
| | Ok this is what my table structure looks like: username varchar(20) eadd varchar(40) for email addresses bday varchar(4) everyone is posting mmdd emailques varchar(2) they answer yes or no I want my query statement to tell me what birthdays are today and as a bonus email them on their birthday. … |
| | Hi, I've developed pocket pc application using vb.net and mysql. But the prob now, I cannot access data from mysql thru pocket pc. when I run the application in Symbol pocket pc, it will give me this error: TypeLoadException Could not load type MySql.Data.MySqlClient.MySqlConnection from assembly Mysql.Data, Version=1.0.4.20163, Culture=neutral, PublicKeyToken=C5687FC88969C44D … |
 | Hi, i am having a problem with indexing. In my database, one of my table have 3 foreign key references, All these fields are indexed by default. I need to create an index for a regular seach item. is there any problem regarding performance, if i combine the primary key … |
| | Hi, I keep on getting the following error message: Software error: DBD::mysql::st execute failed: 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 '-50,50' at line 1 at arp3-data.pl line 48. My host is …  |
| | I was able to install Apache2, PHP5 and MySQL5 on my MacBook running Tiger and using root to start the Apache server manually. However - I am not able to get it to start automatically on reboot. I even added a line in etc/hostconfig: APACHE2=-YES- Having done the above - … |
| | Hey Guys, can you suggest any Open Source Application Server for SOA deployments. Also, wondering, if our needs are somewhat lightweight, is there some lightweight open source Application Server you could Suggest. |
| | Hi All I am trying to connect mysql and VS 2003 but i am unable to do the connection, which makes me wonder if the are compatible. Can someone tell and also give me the code for connection. Thanks in advance. |
| | Any idea? I get this error: org.apache.jasper.JasperException: An exception occurred processing JSP page /test2.jsp at line 7 4: <title>DB Test</title> 5: </head><body> 6: <% DBConnect d = new DBConnect(); 7: ResultSet rs = d.getResult("SELECT name FROM items"); 8: 9: while (rs.next()) { 10: String name = rs.getString("name"); Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:524) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:435) … |
| | [code] public static Connection getConnection(){ if(connection==null){ try{ Class.forName("org.gjt.mm.mysql.Driver"); connection=DriverManager.getConnection("jdbc:mysql://localhost:8084","root","ceyesuma"); }catch(Exception exc){ connection=null;} } return connection; } [/code] Here is the bean to get connected. Should this work? [code] package db; import java.sql.*; import java.sql.DriverManager; import java.sql.Connection; /** * * @author James */ public class DBConnection { static String dbdriver; static … |
| | I made more progress ong CreditCard program I am trying to insert a row into mysql from a creditcard account number. Could I get some feed back on why it as a problem with the url it looks like it wants to insert a record. [code] package creditcard; import db.DBConnection; … |
| | I would like to return a connection to a Bean to make statements to mysql database "ccdb" I'm really not sure of [code] public static Connection getConnection(){ if(connection==null){ try{ Class.forName("org.gjt.mm.mysql.Driver"); connection=DriverManager.getConnection("jdbc:mysql://localhost:8084","root","ceyesuma"); }catch(Exception exc){ connection=null;} } return connection; } [/code] Here is the bean to get connected. Should this work? [code] … |
 | i have this code: include('DB_connection.php'); $result = mysql_query('select * from login'); $count = mysql_num_fields($result); for ($i = 0; $i < $count; $i++){ $header .= mysql_field_name($result, $i)."\t"; } while($row = mysql_fetch_row($result)){ $line = ''; foreach($row as $value){ if(!isset($value) || $value == ""){ $value = "\t"; }else{ # important to escape any … |
| | What are the performance implications of storing some data across 2 databases instead of duplicating this data in both databases? ie. is example 1 significantly slower than example 2: Example 1: SELECT Users.User.*, Transactions.Sales.date FROM Users.User, Transactions.Sales WHERE Users.User.id=Transactions.Sales.userid; Example 2: SELECT Users.User.*, Users.Sales.date FROM Users.User, Users.Sales WHERE Users.User.id=Users.Sales.userid; Note … |
 | I have one doubt about WAR file........ Like i am creating a project with mysql databse and deploying it through WAR file My question is if i want to deploy it on some other machine then i am copying war file there in webapps folder.........but do you think it war … |
The End.