10,946 Topics
 | |
| | Hello all! I have been told for many reasons that when a user wants to end their account on a website, that you shouldn't delete the user out of the database for awhile. So if I need their information to be off the Internet, but still remain in the database, … |
| | Hi i was making this code so I could connect to my server and run a database: [code=php]<?php mysql_connect("localhost","root", "samiscool"); mysql_select_db("test_db"); $sql = mysql_query("SELECT * FROM test_table"); while ($rows = mysql_fetch_assoc($sq1)) ( var_dump ($rows) ) ?>[/code] and this eror message came up "supplied argument is not a valid MySQL result … |
| | i changed my password in mysql using the mysql server instance config wizard from the start menu. once i changed it, the access is denied to view all the database in phpMyAdmin.. #1045 - Access denied for user 'root'@'localhost' (using password: NO) - this error appeared in the screen. i … |
| | hai i am sridar in my project there is a database it is created by msaccess and at present i am using mysql database by vb.net coding by clicking the button i want to download a datas from msaccess database to my sql please any one help me my mail … |
| | Hello, I was wondering if anyone can help me sort this problem! I basically have a member profile feature on my site that has an update page! Members can update information such as their date of birth, location etc! I currently have a text box in which members have to … |
| | hi please help me, i want to know how to enable smtp in php mysql, i have the code right so no worries there. please help |
| | hello guys, just want to ask some newbie questions. i have a table named "students" in my database, the field names are "Lastname", "Firstname" and "Highschool". i want to sort my query by highschool field. i want to show that query results in table form. how can i sort by …  |
| | i'm using Macromedia Dreamweaver MX, and i fail to connect with mySQL database . any tips ?? pls help .. :confused:  |
| | I am trying to display image files stored in my mysql. It displays alright as a direct php echo, but when i put it in an <img.../> src attribute... I get a cross. The following is the code snippet; [CODE] ... $query = mysql_query("SELECT pid, imgdata FROM pix WHERE pid='2'"); … |
| | How do I upload an Excel or CSV file into a MySQL database. I 'Googled' it and tried a couple things but nothing worked. Appreciate any help |
 | Hello friends, i copied a table from other database and using in other database, when iam using the same table in other database the primary key in the table is just auto increamenting from the past table only. i want it to start from 0 Rakesh |
| | A print-ready MySQL quick reference is available <URL SNIPPED>. Registration (free) is required for access to a more legible version. An extended version of this card that covers the MySQL SQL dialect in detail is in the works. Enjoy!  |
| | I will explain... I downloaded `mysql-5.0.45-win-src.tar.gz` from Mysql download area.I tried to built Mysql.sln inside that,but i am getting errors(about 58) like Error 149 fatal error LNK1181: cannot open input file '..\zlib\release\zlib.lib' mysql_upgrade Error 319 error PRJ0019: A tool returned an error code from "Performing Custom Build Step" mysqld Error …  |
| | Hi. I have been trying really hard to make a CRUD app with a wx.grid.PyGridTableBase-based wx.grid.Grid that takes its data from a resultproxy of the SQL Expression Language of SQLAlchemy from a MySQL database table, but the problem I have is that I have to convert the resultProxy to a …  |
| | Hi All, I am very new to Perl and trying to practice a bit. I am rebuilding my website and decided to take on a project - convert an Simple Machine Forum database into vBulletin database. At the present stage my script successfully converts users and topics, but I am … |
| | Hi well wishes to all i have written the code for to create to-do list in java swings with mysql i hereby attached my code to you for reference Req: Taskno(set as primary key), Task Name, Task GroupName, TaskPriority(high, low and medium which is mentioned in combo box), task status( …  |
| | Hi all, I am trying to extract some records from a SQL Server 2005 database and insert into a MySQL database. The extract from SQL Server must also be captured as an XML file. I want to call this from a button. Unfortunately, I have not been able to do … |
| | Hello Friends, i return a database connectivity like this. [code=php] function db_conn() { $mysqli = new mysqli("localhost", "root", "", "test"); if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } return $mysqli; } [/code] with this upto now i used to insert records successfully. but now i have an problem with … |
| | Hi i want need to fetch sec highest marks from given tables. my database design is like: My database design: Table 1: Student table (PK)Stud_id, Stud_name Table 2: Subject table (pk)Sub_id, Sub_name, Marks. Table 3: Stud_Sub table Stud_id, Sub_id And i come up with the query: Select Student.stud_id, Student.stud_name Max( … |
| | Hello, I have a problem that someone can hopefully help me with. I have a page where Make, Year and Model menus are dynamically created via mysql. Upon selection, the user presses submit and those values are fed to the database where the production numbers for say, a 1958 Plymouth … |
| | Hi, Stored proc code below works fine in MySQL command prompt. It returns John because it is in table. However, i can't return or read the Out parametter in PHP. I mean i cant retrieve John. I did ask this in PHP forum but no answer. [code] CREATE PROCEDURE `findname`(IN … |
| | Hi there, I desperately need help with this. I need to develop a code to upload an image to mysql database. The upload have to be done with a foreign key attached to the upload. eg.(image_id, image(blob), fileType, date_entered and your_id(foreign key). please can any one help me with this, …  |
 | Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home2/fellowes/public_html/createaccount.php on line 108 [CODE]include("conf.inc.php"); $tbl_name="tbl_courses"; $sql=mysql_query("SELECT * FROM $tbl_name WHERE crs_semister=1 AND crs_period='A'") or die(mysql_error()); $result=mysql_num_rows($sql);[/CODE] [CODE] <?php while($rows=mysql_fetch_array($result)) { ?> <option><?php echo $rows['crs_code']; ?>//Line 108</option> <?php } ?>[/CODE]  |
| | I need to display a dropdown list of hospitals several times (10) in one form and I'm not sure of the best way to go about this. I can get the first list to display, but the subsequent lists just show "Select". This is my code: [code]<td width=\"200\"><select name=\"hospital1\"> <option … |
 | I have one question! How can i check form fields against the database and then display an error! Please help me for example go to mycsmi.org There is a form on the index.php page .... a user submits the info to the database but what if there is a duplicate … |
| | I have a little knowledge of SQL, however very very little of php, I am wanting to display information from a database in a small area of a php page, I have already created the area on the page etc and "hard coded" the info in there for now, however …  |
| | :S Hi I need help urgently.. I want to insert data into two mysql tables using just one form. Tried to do it through the following code below, but keep on getting horible errors when i submit. The essence is that the client has to fill all data without moving …  |
| | Hi I am new to java and j2ee Can anyone send me the code for to-do list creation in java swings and mysql DB i want to create a to-do list in jsp . and i feel that if i modify the code from java swings to jsp then i …  |
| | This is the error what i get when i try to run my project: [CODE]Local Exception Stack: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0.1 (Build b04-fcs (04/11/2008))): oracle.toplink.essentials.exceptions.DatabaseException Internal Exception: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/varad1 Error Code: 0 at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:305) at oracle.toplink.essentials.sessions.DefaultConnector.connect(DefaultConnector.java:102) at oracle.toplink.essentials.sessions.DatasourceLogin.connectToDatasource (DatasourceLogin.java:184) at oracle.toplink.essentials.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource (DatabaseSessionImpl.java:582) … |
| | How do I add a database for my game, it has a bank and members add money but after certain amount (2 bil) it stops or freezes and you can't add anymore as in it says money deposited, it subtracts the amount, but after that bank wont show no more … |
| | Hi, everyone! I want to make the user authentication for mysql database. I write the code and test it, but can't run. Let's I talk about my project idea first. I have a server, a client and a mysql database. Before entering the server, the user must login first, After …  |
| | 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, … |
The End.