10,946 Topics
 | |
| | I want to make a query in C++ using the MySQL++ API. Here is my problem, in PHP for example I make something like this: $query = "SELECT * FROM table1 WHERE id = " . $value; In C++ I can't do that. I need a way to make $value …  |
| | Well, whenever I try to run a user verify script, that asks SQL if a username is not taken, I always get this response... [quote][B]Warning[/B]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [B]dir/userver.inc[/B] on line [B]11[/B] count unavailable[/quote] this is the code in general: [php]<?php //User …  |
| | Hi, This is a simplified problem for a mock book store I am trying to build. I have been stuck on this all morning. Any help would be appreciated. Thanks. [U] SET 1[/U] | 1 | a | | 2 | b | | 3 | c | | 1 … |
| | Having a diificult time with date range in a pawn database: Any suggestions  |
| | Hi all Can someone tell me how to connect to msql database using c# 2003. can you please show me the steps to take. i have tried many times without success. Are they compatile? Thanks sibotho  |
| | Hi there, I am relatively new to MYSQL and i have to design a database for stock for a dvd firm, this database has to link up to a website, the website is a DVD firm so the only things that needs to recorded in the database is how much … |
| | is there any way through which we can generate reports in mysql. not using any s/w but coding. if yes plz tell me Thanks |
| | Hello I´m trying to make a function that give-me data from a data base mysql at time there is no problem but i would like to now how i can make that funcion to be called from x hover x seconds, the ideia is just to se if there is …  |
| | hello, i need help!!!!! i would like to know how i can make a backup and restore of my db mysql from one form??? |
| | hi all i m making a project using jsp as my front end and mysql as my back end. i had to change backend from oracle to mysql bcoz of clients request. now there is 1 problem i m facing. there a password change option. person enters its old password …  |
| | hi, it is giving me headache to write data from a php file to mysql( i can read from the table but cant write) here is my connect.php which connects to mysql: [CODE]<?php $mysql_host = "localhost"; $mysql_user = "sam"; $mysql_pass = "123456"; $mysql_data = "website"; $mysql_table = "shoutbox"; mysql_connect($mysql_host,$mysql_user,$mysql_pass) or … |
| | Does anyone know the name of the MySQL library package? I'm working with a server that recently had an upgrade from PHP 4 to PHP 5, and apparently PHP no longer provides built-in library files for MySQL. The system in question should have the libraries from PHP4 on it somewhere, … |
| | I hav calculated a value(years).Now i want 2 merge it with an attribute of a table.So i want 2 merge ml_y and 2.then i want to find the value of ml_y2 frm a table....plzzzzzzzz help me .can i do somthing like this in MY SQL??? |
| | [B]When i try to access this page: it shows this: Warning: mysql_query(): 2 is not a valid MySQL-Link resource in /user/langlab/wwwhome/signup/signup_adm.html on line 28 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /user/langlab/wwwhome/signup/signup_adm.html on line 29 Warning: mysql_query(): 2 is not a valid MySQL-Link resource in … |
| | i m exporting my table from one system to another. when i do shell# mysql databasename<file.txt i get the error given above. the table i create is -> CREATE TABLE entrytab ( uname varchar(10) default NULL, enterDate date default NULL, status varchar(10) default NULL, productName varchar(15) default NULL, featureName varchar(20) … |
| | hi every1 i m using jbuilder9 to develop my website and mysql as its back end when i use mysql with simple java program it runs as i store the jconnector in jdk1.3/lib/ext. but when i stor the jconnector in jbuilder/jdk1.3/lib/ext it does not work. can any 1 plz tell … |
| | hi every1 i hv created my database in mysql now i have to run the s/w on my clients system. can any 1 plz tell me the steps to export the mysql database and then to import it on my clients computer. thanks in adv |
| | Is there a free Host in the Net ... which host ASP and MySQL do anyone of u know..please post if u know..... |
| | Can someone start a tutorial about MySQL++ combined with Win32? I would like to learn about that |
| | Hi I am very new to MySql. I want to use Navicat along with MySql server to develop and maintain very simle database in future. Up to this point it is OK. I want to develop and maintain a small customer database. My question is do I need a GUI … |
| | Hi, Can someone please give me examples or teach me how to design and implement in MySQL a normalised database for any case study they have in mind.. Please help me out as it would really help understand a lot better or if you can give me a link to … |
| | Hi, I am trying to get my head around the whole database theme by learning MySQL on my own with the help of a couple of easy to use books and some online forums including this one. Is this is the right choice in terms of learning the database related … |
| | Hi, I am trying to understand MySQL as i am new to this and i have a few queries I am having problems with and I was wondering if anyone can help me with it.. How would you solve this problem using the Select, from, where etc commands. For example … |
| | [COLOR=midnightblue]The INSERT statement conflicted with the FOREIGN KEY constraint "FK_yaf_Forum_yaf_Category". The conflict occurred in database "yafnet", table "dbo.yaf_Category", column 'CategoryID'. The statement has been terminated. How to solve this error...........[/COLOR] |
| | I have a db full of articles that have a category field. Is there anyway to select and display just the different categories? |
 | how can i retrive data from database (mysql)and make it a drop down menu on a html form using php .and also if an iteam is selected from a fist dropdown before the next well become active. |
| | How can a band create a mialing list to send out show responses thanks rob |
| | SELECT * FROM `studentcourse` WHERE `systemcode` = 'ilscorp' AND `status` = 'complete' AND `techcode` IN (SELECT `techcode` FROM `usersubscription` WHERE `subscription_id` = '296') After I run this the server has an intense lag and needs to be restarted or timeoutes occur. |
 | Hello, I am going to study MySQL on my web server. I would like to ask if there is a useful GUI tool for MySQL to create/delete tables and browse entries on my database.  |
| | Hello, I heard SELECT COUNT(*) can take a lot of resources if your counting a table with lots and lots of rows (hundred thousands, millions). What if you add A WHERE clause to it? So something like: SELECT COUNT(*) FROM table WHERE pid = ? (pid is a index too … |
| | Hi, I am using Fedora Core 5 32+bit as my os but not using a particular development tool as of now and just sticking to the normal text editor called the KWrite. I am learning C++ and MySQL on my own and want to know if the connection between the … |
| | I have a school problem, I'm not going to try and hide it. This is for Oracle9i: SQL class. The question we have to write a code for is: Create a list of customers that will display the characters 'NOT REFERRED' if the customer was not referred by another customer. …  |
| | Hey, so I get a Driver error when I try to connect to my local mysql db. My code is in a servlet as follows [code] Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection con=null; Statement smt=null; con=DriverManager.getConnection("jdbc:mysql://localhost:3306/sql?user=webusr&password=pass"); [/code] Thanks M |
| | Can some one help me to set up a database in mysql. I need more of a logical help. |
| | I am currently responsible for a set of server units. Recently, the group of users working with one of these units informed me that they were having problems with a php-based report generating program. I did not write the program; my predecessor did. I did manage to track down the … |
| | Hello, I tried searching but didn't see anything. How involved is it to copy a database to another server? Currently the database is on a cpanel server and I need to copy it to my new server. I copied the rest of the site and everything seems to be working … |
| | Hi. I have tables like these: [B]table1 [/B]([U]table1_id[/U], table1_attribute1, table1_attribute2) [B]table2 [/B]([U]table2_id[/U], table1_id*, table2_attribute1, table2_attribute2) The primary key of the first table is table1_id. It is auto incrementing and it is also a foreign key for the other table - [B]table2[/B]. Let's say I want to add a new record … |
| | HI, I'm still rookie guy with mysql database, I have a mysql script file called "MYBox" in notepad and I want to export to the one of folder directory but I don't know to do that from Does. I need someone help me what command do I need to type … |
| | I was wondering what is the Database Storage Capacity for the following databases: MySQL 5 Microsoft Sql Server 2005 MS Access 2003 Thanx |
| | Hi, I'm running MySQL 4.0.13, connecting from PowerBuilder 9 using ODCB Connector 3.51. I'm facing a problem where whenever I issue a SELECT COUNT(*) statement from PowerBuilder |
| | in my each jsp page i have to write this code to connect with Mysql database Class.forName("com.mysql.jdbc.Driver").newInstance(); String url ="jdbc:mysql://35.212.176.25/tri"; Connection con = DriverManager.getConnection(url,"root", ""); now i want to make this code in a separate jsp page and then only include this page in my current jsp page where ever …  |
 | Hey, just need a little help on this one. I have a script allows a user to choose from a list of files in a directory for a form. When they submit the form, it adds the files name and url to a couple fields in the database for that … |
| | Hi, I have a table named 'team' which has fields such as name,contactno and dob. My entries are: For eg: name : Arun Kumar K contactno : 9445123880 dob : 27 Mar I want to display the name of corresponding members(here Arun Kumar K) on the previous day of his … |
| | Can somebody please help me to little customize the view of the phpMyAdmin? Curently this is what I [URL="http://www.peterbudo.f2s.com/extra/myAdminC.jpg"]see [/URL] but I would like to have as [URL="http://www.peterbudo.f2s.com/extra/myAdminW.jpg"]this[/URL]. Simple, I don't like options to be displayed as list of links but as tabs. What shall I change in config? |
| | Hi, Im new to JSP and I am trying to add data from a simple registration page using JSP to a table in mysql, My code seems to be working OK howerver when I check the table in MySQL Control Centre...no new records have been added, I am able to … |
| | Hi, I just installed MySQL on my computer and went though a decent MySQL tutorial. Now I need you guys help me out so I can get my java programs to connect to MySQL. I am using the following code from a book to connect. [code] import java.sql.*; public class … |
| | Hi, I am new linux and using Fedora Core 5 32+ bit at the moment. In order to install mysql and related stuff I prefer to use the terminal and apply the following commands yum install mysql-administrator yum install php-mysql etc. But these are the only two I am aware … |
| | Hi all, I am a newbie in PHP_MYSQL.Please provide me script for reminding bdays of the concerned persons on those days on the index page we view first.I stored b'days in my table as (eg:27th Mar,03rd June etc).My table has also info such as name ,contactno and email id of … |
| | Hi, I'm in colledge and I have to finish this thing by tomorow mornig... So I'm asking if anybody cal give me some help on how to call and execute mysql procedures in PHP... I already tryed this but it dosen't work... :eek: [URL="http://www.daniweb.com/techtalkforums/showthread.php?t=41143&highlight=procedure+php+mysql"]link[/URL], Sorry for my english and thanks … |
| | do these tables look like they will work? i want theerror.errorcode to be a forgin key in the hostname.error but i don't know how to do the insert or if it's even posiable the way i have it set up. thank you, shark [INLINECODE] // Table: error Create Table: CREATE …  |
The End.