11,093 Topics
 | |
 | Validating form field with table fields in MYSQL through PHP .... how do i do that! |
 | Hey all i'm fairly new to php and need some help with this code. I'm not recieving any errors but it wont work. what i'm trying to do is up load a picture from a form. i want to copy the picture into a folder named "images" then keep all … |
| | I wasn't sure if this should be in the MySQL or PHP forum. I have a database to enter student info for a school (it's a detention list - I'm the VP) I have a form to update records in a database as each student is assigned detention. It only … |
| | Hello there, I am having trouble with a form/database. I have 3 age groups that needs to be sorted into 3 separate tables. Users fill in a form (dropdown list with the separate age groups) and when they click submit, the data gets sorted in tables on another page. With … |
| | hi for all....im sabeel... here's my prob.... i have a column named date select date from blabla returns all the date i need to select duplicating dates from blabla.... what is the function to find the duplicating data..? thanks in Advance....:-)  |
| | hi, im new to this platform.i want to know, how can i insert the url link into a mysql database? and also php query also.some help me.... |
| | I want to create crystal report in c# with mysql.please help me by providing the procedure. |
| | Hi All, I've been using the query below to get data that starts with a ',' then any number of spaces in between, then a word that starts with 'w'... SELECT * FROM xtable WHERE xvalue REGEXP '(,([[:space:]])*w)' Using the query above, I was able to get correct results like … |
 | I am using phpMyAdmin and as I delete a row, it stuffs up the auto increment once I insert a new row. Example: Delete - 21 Insert - 22 (should be 21) Thanks, Regards X |
| | Hi, presently i am working on mirroring in between two servers of mysql.can you please provide me a code to do mirroring |
| | Hi, i don't know how to do the following or even if it's possible. These are 3 tables from my database sport: [team]-|-----<-[team_match]->-----|-[match] [LIST] [*]Team: [LIST] [*]id (int) [*]name (text) [/LIST] [*]Team_match: [LIST] [*]match_id (bigint) [*]team_id (int) [*]score (text) {this is not an integer because it can contain "f" for … |
| | here is the code.. but it is not working.. why? [code=java] import java.sql.*; public class Connect{ public static void main (String[] args){ Connection conn = null; try{ String userName ="testuser"; String password ="testpass"; String url = "jdbc:mysql:/localhost:3306/test"; Class.forName("com.mysql.jdbc.Driver").newInstance(); conn = DriverManager.getConnection (url,userName,password); System.out.println ("Database connection established"); } catch(Exception e){ System.err.println("Cannot …  |
| | Thanks in advance for anyone who can help me with this query. I want to select all from table one and the matching image from table two. Using the following inner join query works great: [code] $result=mysql_query("SELECT * FROM members inner join avatars on members.user_id=avatars.user_id where members.user_id ='{$user_id}'");[/code] but if … |
| | :S Hi, I am terribly stuck with this code. It is suposed to upload my images to the mysql database with the foreign key(property_id). At first it worked, then later started giving serious errors where the web page could not load. I am lost. Can any one help me, solve … |
 | Hello there! I greet you all, I have a question on Database. First of all I'm completely new In Database realm and know a little . Just definition and little about it. Can anyone tell me how to do database programming (Specifically MySQL) in both server and embeded sever mode, … |
| | Hi all... Let's say that I have a database with two tables: departments (dep_id, dep_name) & employees (emp_id, emp_name, dep_id). I need to select the departments that have the employees with ids 10 AND 20. How do I do that with SQL? Note: The following is NOT what I want: … |
 | Hi EveryOne, I am working on 5.1.18 mysql community edition. It has a large number of records. I wanted to create an event to handle some particular tasks regularly. So I googled and found that i would have to set a global variable event_schedular=ON. So I have run following command: … |
| | Hello there! I greet you all, I have a question on Database. First of all I'm completely new In Database realm and know a little . Just definition and little about it. Can anyone tell me how to do database programming (Specifically MySQL) in both server and embeded sever mode, … |
| | Hello there! I greet you all, I have a question on Database. First of all I'm completely new In Database realm and know a little . Just definition and little about it. Can anyone tell me how to do database programming (Specifically MySQL) in both server and embeded sever mode, … |
 | k... so, here's the thing... I'm creating a User's Interface to insert some data into a database, and there are some fields that have foreign keys to other tables, which i have listed in a [ICODE]<SELECT>[/ICODE] form, so the user would just select the vlue from a list instead of … |
| | Can any one help me. I trying to develop an e-mail system for an intranet but i dont know where to start from. Am using WAMP SERVER. Thanks |
| | I am using phpbb forum and tried to link the forum from index page of website by including php files that contain following code: [code=php] <?php include("config.php"); $result = mysql_query("select * from phpbb_topics WHERE forum_id = 5 ORDER BY topic_id DESC LIMIT 0,10"); while($r=mysql_fetch_array($result)) { $topic=$r["topic_title"]; $link=$r["topic_id"]; echo "»"; echo … |
| | Hello members i am developing an application where user registers and uploads music files to server and if je wishes listens to music present in the portal............problem is this is my first to this type of application.........please any one help me ............. please guide me how to upload audio files …  |
| | I have to copy a file into MySQL database as a Blob. I tried it using 2 methods. [B]1. Using MySQLdb module 2. Using mxODBC & pyodbc modules (through ODBC) [/B] The first one executed properly and I was able to retrieve the data from database. When I tried it … |
| | Hi all, I need to import a database (currently in excel) to Mysql. I searched a little and found out that CSV files can be imported. However, there is a problem that I am facing. The delimiter for fields in a CSV is a ',' obviously. But many of the … |
 | Hey I host a website for a sports team, theres a nominations page where each member, when logged in, can cast a vote to whoever in the team they want to be captain for a tournament. The Problem is when someone votes i store the id, name and there vote … |
| | hi, i ve hospitaldb created in MYSQl, i have connectivity problem like[CODE] String connectionURL = "jdbc:mysql://eall:3306/hospitaldb"; // declare a connection by using Connection interface Connection connection = null; // declare object of Statement interface that uses for executing sql statements. PreparedStatement pstatement = null; // Load JBBC driver "com.mysql.jdbc.Driver" Class.forName("com.mysql.jdbc.hospitaldb").newInstance();[/CODE] … |
| | Hi, I just want to retrieve name of the employees who have two or more than two email_id in employee table. pls help me out.. |
| | hello friends plz help me, iam uploading excel sheets into the database. it is succefully entering . the problem is when again uploading excel sheet i want to check the database and if excel sheet which i send is there already i have to restrict by inserting into the table(resource_table) … |
| | Im a newbie, I have compiled apache and mysql in the same server;i need to host a site that has perl scripts and the database linking .How to integrate the mysql server to apache for smooth functioning of this site??  |
| | I'm creating a project right now which is entitle Agenda Management System. I want to log in to server with a flexible connection. I was able to code my server connection but my other forms which contain the saving, updating and deleting command was only working to the computer which … |
| | Hi, Well to start od i decided to learn how to create jsp pages and finally finish my project. So i used the netbeans tutorial for making jsp pages. The sample worked fine, but when i wanted ti retrieve information from my own database it do not work like it … |
| | Hi, Thanks for checking this out. My goal is simple. Create a list of all the years that have had articles published in them (so basically every year). I have three unique dates in the date column, 2008-08-20, 2007-08-20, and 2006-08-20. The code below only returns this as the print_r … |
| | Hello everyone :) Sorry for bothering you, but I have a problem with solving one query, in general query is much more compllicated, but I will try to simplilfy it Lets asume that we have table named info and it looks like this: id , name,price, from_date, to_date, 1 , … |
| | i am working on a project and i have faced trouble in connecting php with mysql. anyone out there who can give me a clue can contact me. thanks mekdes |
| | Hey there everyone! I'm just about to start a database assignment for uni but don't know whether to use MS Access or MySQL. I am an adequate use of both but does anyone know the advantages and disadvantages of them??? Thanks ;) |
| | Hey Guys Can anyone help me. On my website i receive this message Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/mangofitness.net/httpdocs/developments/includes/mysql.inc.php on line 26 The coding for this file is below, can anyone help me get no errors. <? require_once("config.php"); function db_connect() { mysql_connect(DATABASE_SERVER,DATABASE_USER,DATABASE_PASSWORD) or … |
| | Hi Code below generates this error "Table 'sis_audit.pay' doesn't exist". [code]UPDATE pay SET Ref='111', date='2008-11-11' WHERE id=29[/code] When i create same table in different database, no error at all. Why? Thanks |
| | I'm fairly new to the C++ world (did some C work in the past years ago) so I'm a little rusty on some things :) I've got a small table in a database and I'm trying to grab some date information out of a UNIX EPOCH time stamp (all seconds). …  |
| | Is there any easy way of mirroring a mysql database, without having access to the config files?? Reason I ask is that I have 3 servers all running of the same mysql databases. 95% of the access to the DB is read data. So what I'm thinking is for both … |
| | Uhmm,, im new round here, And i just wondered something,, I have recently made a private server for World of Warcraft.. And i need to make a website to advertise obviously. But the only thing is that i have no idea how to make a registration page so people can … |
| | i am assigned to convert data from microsoft excel to mysql... pls tell me how. pls help. thanks ! :( |
| | Hi, How do we save person's pictures in database?Do we just create column "pictutePath" and enter this value "../pictures/user1.jpg" for each person or is there any other way? Thanks  |
| | Hi This might be a basic question for all of u, but i need help from you guys. here is my query select (sum(datediff(dd,DateAdmitted, DateDischarged))/count(*)) AS Avrvg from table1 where DateDischarged is not null this gives me the result as 4 in the column Avrvg. but the actual result should …  |
| | First off I am new to PHP, I am trying to display categories from a mysql db in a drop down menu. for some reason it is not displaying the category options. Need help with the code. Can anyone help me out. "the db has two fields "id" & "category_name" … |
| | I'm having a problem in displaying data from the table.I've a candidate table in the db. i 've got the problem when i try to select the place of the candidate in the main html code. the html has the place selector, frist name, middle name and partystatus of it. … |
| | Hello everyone. This is my first post to this site. I've used it before as a reference and now I'm here with a question of my own. I'm currently storing some data in a row like this: "apples, oranges, pears, bananas, peaches" Basically the row contains just a few terms … |
| | Hello, I manage Sun servers for a living that are ONLY used for DNS. With that said, I've been hired by another company to manage their dedicated server. P4 1gig with CentOS is what they have. They are running mysql, php, and apache 1(httpd). What concerns me, after this transfer …  |
| | I have a php webpage file that contain all the file and the code i want to edit that database content from all the file extrcted from the www folder of the wamp serve rthat will be use to connect to the database pls where will i get the database … |
| | Hi All: I have an extensive website in which I would like to echo the name of the company various pages after the user logs in. I think I should be using the $_SESSION global, but I'm having difficulty implementing it, placing it in my code, and knowing what php …  |
The End.