[mysql] Forum Topics

ei..guyZz... Can u help me with my project??.. I'm using front end vb6 and back end is mysql.. it is a cashless system.. do you have any idea about that??.. because i'm already a card.. how do i connect it in my project???

hello to all, would somebosy help me creating a library system that consist of book inventory, barrower form, validation of user hope someone could be able to help. iam new in php/mysql and have no idea how to start please help me i will truely appreciate all your help. thanks

Hi, How can i read the OUT parameter of a MySQL stored procedure in PHP with using mysql not the mysqli? Thanks

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 …

Hey again. just want to know how to create a query such as an insert query with MS access and C++. this is the code im using to connect to the database and im using Dev C++ [CODE=syntax]#include <windows.h> #include <stdio.h> #include <string.h> #include <odbcinst.h> #include <sql.h> #include <sqlext.h> #include …

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 …

I've created a software using vb6 and mysql as the database. The exe runs ok but whenever I try to open a report, I get the error "ActiveX component can't create object". Can anyone shed some light on this problem? I'm using crystal report 11. The reports will run on …

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 Can anyone please help me sort this problem out I create store procedure in mysql and I want to call this in php. The store procedure is executing ok in mysql but when I call this into php I get fatal error: call to a member function prepare() on …

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 want to create a table in sql database using php code. if i try to use the sql command(given below) in my php source code [code]"CREATE TABLE new_table( id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, id1 VARCHAR(55) NOT NULL id2 VARCHAR(32) NOT NULL, id3 CHAR, PRIMARY KEY(id));"[/code] i get syntax …

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 …

Hi, I have checked several examples but, i couldn't do the pagination. Please help me because i simply can't do it. I am stuck with my assignment because of this. Table is shown below. Thanks [code] CREATE TABLE `country` ( `code` varchar(255) default NULL, `rank` int(11) default NULL, `name` varchar(255) …

Hallo. I am working on a listing site ([URL="http://www.togoenvogue.com"]www.togoenvogue.com[/URL]) and need to set an auto deletion feature. What I want is this. When the user wants to add a listing (job offer for example), he will need to select from a SELECT drop down how long he wants his message …

: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 …

Pls help me to add two times which is in mysql database table....Very urgent...Thank you

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) …

hello!!im new in jsp and i want your help...i am making a site for e-betting,so i'm trying to make the code where the client is betting and site is making the multiplication with the amount that client is betting and thn write it to mySQL database...can anyone help me?im very …

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 …

Hello, i need a code to insert the values entered in the Text box to a Table in the Same JSP Page. Then the values in the Table should be stored in the database. im using MySQL. Thanks in Advance. Ananth.S

i have passed multiple identical id values, and now i want to retrieve those corresponding id values in mysql. how do i retrieve them? the table that the ids were inserted is a join table named hrm1_employees with field names hrmemp1Id, empId, and hrm1Id. the field hrm1Id came from the …

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 …

hi folks.. In my application am storing some textbox values to a datatable inside a dataset.Now I want to save the multiple rows of datatable to my sqltable..ll anybody plz help me.. with thanks and regards. jithesh.P.

Validating form field with table fields in MYSQL through PHP .... how do i do that!

Hello all, I am all set to launch a website on which i have been working from months but now am afraid how safe it might be once it gets attention of hackers . As most of the code in website is in PHP,html,mysql i am posting this in this …

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 …

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 There. I'm just hoping someone can answer a question for me, as although i have been a IT Network Administrator for a long time, I know very little about web design/database design. I'm currently in the process of setting up a website to will contain a very large amount …

Hi I am new to MYSQL DB and i am a fresher here i am having code which is perfectly run and the only thing is i have stored the data in file but now i want to stored the file in DB i mean i want to change file …

Hi i have a php script that retrieves all data from one database to be transferred to another database. The problem is that the database I am retrieving has 2,778 total rows and after i run my script the new database has 2,658 total rows. Whats going on? Here is …

I need help with creating a "booking system", i had already done some tables,and i need help with the coding part,especially concerning the relationships between the tables.Thankyou

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....

Hi all i want to add my Column names in a combo box for some purpose But how i will do that because i dont know the number of columns in the table and new column in the table can be added from the application. So the column size is …

I'm not entirely sure if this is actually possible. Haven't found anything yet. What I'd like to do is have a page that lists numerous articles. Then when you click on the "Read more..." link I want to go through to a template page that would pull all the info …

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 …

First: I'm somewhat of a newbie to php. Just a forewarning. I've been playing around with this code for about 4 hours. It's almost 2 AM now, and I'm finally deciding to throw in the towel. That, and I have to work tomorrow and I'll sit here trying to figure …

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