10,940 Topics
 | |
 | Hi there I"m building a page that displays events for example: Event heading 05 June 2007 Event Description Another Event 19 June 2008 Event Description What I'd like to know is how do I sort the events by date in the format shown above. At the moment I have a … |
| | I'm working on a project (lord knows why, I'm a below average coder) where I need to identify a phone number and its country code and national code to obtain the billing info.. I have been able to obtain the the country code without problems, but I'm having problems getting … |
| | <html><body> <%@ page import="java.sql.*" %> <% String user="root@localhost"; // root itself String password="pwdl"; String connectionURL = "jdbc:mysql://localhost/Database_name"; Connection connection = null; Statement statement = null; ResultSet rs = null; Class.forName("com.mysql.jdbc.Driver").newInstance(); connection = DriverManager.getConnection(connectionURL, user, password); statement = connection.createStatement(); rs = statement.executeQuery("SELECT * table"); while (rs.next()) { out.println(rs.getString("name")+"<br>"+rs. getString("emailid")+"<br>"+rs.getString("contents ")+"<br>"); } … |
 | Hi, I want to modify the max connection settings in myql5 on RHEL4. i was searching for my.cnf file but i could find that.. does anyone knows where should i modify the settings...? Thanks in Advance.. |
| | which way is the best to design multi-language web sites ? PHP/XML or PHP-MySQL ?? |
| | This post is copied from another member :[B]mohanavv[/B] ; with his prior permission. Hi! We have a network of about 55-60 computers (netware & NT) running XP and Win2000 workstations. We have about 5 network printers and copiers to which a computer can print. What I'd like to do is … |
 | hello friends, I am working with stored procedure in my sql.I m traying to call SP in php but i fail to do that. I have already configer mysqli.dll file in php. but still i m gating error :[B]Fatal error[/B]: Call to undefined function mysqli_connect() in [B]C:\Employees\Ajay\SP\test.php[/B] on line [B]4 … |
| | i want to load bulk data files dynamically inot mysql database by using visual basic as front end. i want to get the filepaths dynamically i.e i just enter the file name into textbox and it will automatically load the data into the database. i have written this code myCommand.CommandText … |
| | 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. |
The End.