10,946 Topics
 | |
| | I use redhat enterprise 5 and I want to install mysql++, which used to connect to mysql from c++. I get the following error message when install checking for MySQL include directory... configure: error: Didn't find the MySQL include dir in '/usr/local/mysql/include /usr/local/mysql/include/include /usr/local/mysql/include/include/mysql' |
 | [code=mysql] $query = "INSERT INTO users (first_name, last_name, email, password, registration_date) VALUES ('$fn', '$ln', '$e', SHA('$p'), NOW() )"; [/code] What is the NOW() used for. Is it compulsory? |
| | Hi everyone, I was trying to setup MySql with Cygwin so that i can create and work on databases using my Windows OS. After gruesome hours of googling, I am still confused as to how to do that. I first downloaded the installer for MySql on windows. I also downloaded … |
| | Say you have 3 tables A (Key, a) B (Key, b) C (Key, c) How would you select say 10 from A ordered by a, from 50 from B ordered by b, from 100 from C ordered by c? All the keys represents the same thing. Thanks! |
| | Hi, I have a long list of options( 60 option) where user can selecte none or all of them. the code is like that [CODE] <selecte name="list"> <option value="1">option</option> ... </selecte> [/CODE] and I have to display it again as a list ( <li></li> ), my question is what the …  |
| | I have a need for a program better than Query Analyzer, I use Enterprise Manager on a daily basis for work purposes and have given the Query Analyzer program to our head person in charge of the front-end of the software, but they are now having a growing need to … |
| | I am trying to insert a row into a table into a MySQL DB 5.0 table. One of the VALUES that I am inserting just so happens to be HTML code. When I execute the INSERT in MySQL Query Browser it tells me "You have an error in your SQL … |
| | Well n not a mysql expert so i need help with this sql file here r d contents of it. Quote:[code] CREATE TABLE `admin` ( `id` int(11) NOT NULL auto_increment, `username` varchar(255), `password` varchar(255), `webmaster_email` varchar(255), `lastlogin` int(11), PRIMARY KEY (`id`) )"; "insert into admin set username='$admin_login',password='$admin_pass',web master_email='$admin_email'"; CREATE TABLE … |
| | Hi, I am using Cerberus ticketing system Recently I have started getting lots of junk email with the subject line containing non0latin characters. The Subject & Content looks like this: [CODE] <br> antivirus Äú=ºÃ£º<br /> <br /> ÖйúÉÌÒµÊý¾Ý¿ª·¢×é֯ΪÄúÌṩ±ãÀû¶øÇ¿¾¢µÄ£¬<br /> ¡ï£µ£°£°£°£°£°£°ÖÁ¡ï£µ£°£°£°£°£°£°£°ÉÌÎñµç×ÓÐÅ<br /> º¯±¬·¢Í¶·Å·þÎñ£¬È·±£ÄúµÄ²úÆ·(ºÍ·þÎñ)µÃµ½¼«´óÊý<br /> Á¿Ïû·ÑÕߵĹØ×¢ÓëÇàíù£¬²»³îÄúµÄÉúÒâûÓÐת»ú£¬´ø<br /> À´È«ÐÂÈ«·½Î»´ó¸²¸ÇÂʵÄÉÌ»ú£¬Ç§Íò¼¶µÄÊг¡ÄúÒ²ÄÜ<br /> Ó®µÃ£¬Ê÷Æ·ÅÆ´òÊг¡µÚһѡÔñ£¡<br /> <br … |
| | [B]Hi! I make nws CMS for self. I added search function too. But I have problem. I save data with html at DB Sample: [ICODE]<font color=red>Some text</font>[/ICODE] When I search for string "some" I get this row. But when I search for string "font" , I also get this row …  |
| | [code=sql] CREATE TABLE users ( user_id int(10) unsigned NOT NULL auto_increment, username varchar(20) NOT NULL default '', password varchar(20) NOT NULL default '', PRIMARY KEY (user_id) ) TYPE=MyISAM; [/code] [COLOR="Red"][U]Questions:[/U][/COLOR] 1. What is the purpose of MyISAM? 2. What happen if I created the above table without MyISAM. |
| | Hi everybody! I have a trouble with my work. I have a file data CVS, and i want to cover to a table in mysql. But in my file CVS have some special character : /t, ", Please help me! Thank a lot! mysql>load data local infile 'price.csv' into table … |
 | Im quite new to php and mysql but ive figured out how to upload and display content from my database, but im still facing quite a lot of problems. - First how do you display an image uploaded in the database? - Second how do you make the content only … |
 | Hi friends, I am using Netbeans 6.0.1 and I've installed MySql on Fedora 8...I 've been able to configure the jdbc-MySql connector that's bundled with Netbeans and I can create tables and query MySql using the Netbeans GUI.So I guess my connection was correct...My connection properties are as follows: Database …  |
| | hi dear all give me some details for which one of best suitable server for PHP+ mysql ? Thanks |
| | I am new to PHP or just not good at it lol, I have been trying to insert checkbox elements into a mysql database. I have a table called Team with two collumns. Id int not null auto increment PK team varchar 30 not null <? <body><form action="insert.php" method="post"> select … |
| | Hello Friends, I am having trouble figuring out how to get me Radio Buttons to search my database. Everything is up on the page and when I select enter it just shows all the items as if nothing was entered. There was already a set search button in the script … |
| | I Started Installing it and i am getting this error Step 2) Connect to the database Attempting to attach to database Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/www/tropical4.freefronthost.com/Vb/Vb/includes/db_mysql.php on line 140 The database has failed to connect because you do not have permission to connect …  |
| | i face problem when i binid data from mysql dat base from vb.net 2005 using dotnet cinnector all data was show perfect except the auto increament field in the tables and i dont know why it didnt work please help mahmoud |
| | Hi to all, I am new to Daniweb and I'm already impressed with the wealth of information available. With that in mind I did a search through the forum but did not see a solution to my problem. I have a couple of machines on the same network. ONe of … |
| | I have a problem with a query and an insert. I have a database that maybe isn't the best design - it includes a field "Former Names" which is varchar 255. It contains a list of names separated by commas. e.g.: "Svea Jarl, Apollo III " I would like to … |
| | I am using a new script Tukanas Freelance Script, everything else works fine on the user panel but when it comes to admin panel cannot log in, tried to manually create a username and password in sql but try and login says user not verifed how can i verify it … |
| | Hi there I'm setting up twp table that are linked with a foreign key. members customer_id (primary) fobnumber ZERO FILLED firstname lastname emailaddress access_id (foreign) userAccess access_id (primary) username password (engine: InnoDB) I have created recreated these tables, when both tables seem to linked. Data will go in to one … |
 | Hi guys, I am a bit stuck and after some help. I studying through a book called practical web 2.0 applications. Through this book you build a full application as you are learning. Now I have got to a section and can't go further. When I go to insert data … |
| | I have successfully uploaded image to mysql database using a form: This is the code: <?php $errmsg = ""; if (! @mysql_connect("localhost","root","")) { $errmsg = "Cannot connect to database"; } @mysql_select_db("adim"); if(isset($_REQUEST)) { $imgtype=$_FILES; $name=$_REQUEST; $address=$_REQUEST; $dateofbirth=$_REQUEST; if($imgtype=="image/jpeg" || $imgtype=="image/jpg" || $imgtype=="image/pjpeg" || $imgtype=="image/gif" || $imgtype=="image/x-png" || $imgtype=="image/bmp") { $image=$_FILES; …  |
| | Hi All, I'm using ADO (VB 6.0) to try and insert and update an image to a mysql database. However i'm having problems doing this coz sometimes it updates only once and with every subsequent effort to update this column i get the following error : Run-time error '-[COLOR="Red"]2147467259(80004005)'; Data … |
| | hi all, i have two tables, table1(id, name, address) and table2(id, phone, email, status). now i want to fetch data from both tables and display in a table. what i want is data must be fetched from table1 and table2 when the status in table2 is 1. if status in … |
| | How to import excel file data to mysql database here is my uploading file coding how to use my uploaded excel file to get it data and store it at database Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim filepath As String = Server.MapPath("Files/") Dim … |
| | hai everyone..i'm still beginner in this ASP.. jus wanna know is it ok if i used MySQL as database? can anyone teach.. really needs ur helps and guides..thanx alot guys.. :) |
| | I bought this website script from someone, it is a website that has free graphics for a popular social networking website. Since I do not know PHP/MYSQL I do not know how to upload my own layouts, graphics, etc, to my website. So I want someone to help me create … |
| | i have been getting this problem n this is getting into my nerves.. it works fine on the web.. but i need to present it on the intranet tomorrow "sunday" it gives this damn error. of mysql_fetch_array.. can u plz help me CODE: <div id="right_nav"> <div id="cga_events"> <div id="navtop" align="center"> … |
 | Hi! I have a problem with this line: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, LOCK TABLE ON test.* TO user1@localhost IDENTIFIED BY "abcdef"; Here is what I do: [CODE=SQL] >mysql -h localhost -u root -p Enter password: ******* Welcome to the MySQL monitor. Commands end with ; or \g. Your … |
| | I'm using MySQLdb. Alright, I'm doing [code=python]import MySQLdb as mysql db = mysql.connect("localhost", "root", "password", "database") cu = db.cursor() rows = cu.execute("INSERT INTO users (user, pass) VALUES ('test', 'test')") print "rows affected:", rows cu.close();db.close()[/code] Well, what happens is, it gets executed and prints "rows affected: 1" BUT when I check … |
 | Hello experts could someone tell me how can i combine multiple records into one value. Sample in MS Access: (Lastname & "" & "," & " " & Firstname) AS Name How can i do this in MySQL?..tnx in advance |
| | 1. $q="Select SQL_CALC_FOUND_ROWS * from post_resume where ind_type='$industype' and career='$careerlevel' limit $cps, $rpp"; 2.$q="Select SQL_CALC_FOUND_ROWS * from post_resume limit $cps, $rpp"; hi i am doing paging in php.the first query is not working.the second one is not working........please do tell me the error. [CODE=php] <html> <head> <title>Record Set Paging with … |
| | Ok, I've had enough of looking at the same piece of code now. Someone please enlighten me as to what simple bloody thing it is I'm missing: [code=php] $pp2 = $_REQUEST["pp"]; $io2 = $_REQUEST["io"]; $sn2 = $_REQUEST["sn"]; $re2 = $_REQUEST["re"]; $sd2 = $_REQUEST["sd"]; $ed2 = $_REQUEST["ed"]; $dp2 = $_REQUEST["dp"]; $rn2 … |
 | Iam facing a wierd issue with ASP.NET and MySQL. My ASP.NET site hangs pediodically. After it hangs none of the pages open. But other sites on the same Server still works. The only way to bring the site back is by restarting the WWW service or by restarting the server. … |
 | Hi everyone I have a csv file with data such as first name, surname, tel etc and I'd like to populate a table inside my MySQL database automatically. So far I have this but I keep getting an access denied error and I don't know why: [code=php]<?php $server = 'localhost'; … |
| | I have successfully uploaded images into mysql database, but now I want to display the images alongside other row data in html page. Thanks for your previous help. Austin. |
| | Anyone know where I can get a free MySQL database so I can start the learning process for myself? I saw a post listed here for dbfree.net.. that post is old.. that takes you to IX Webhosting. I signed up for db4free.net but when I goto login it says "Loading" … |
| | Hi there I posted this problem in the php forum thinking the issue was something I had done wrong with my PHP but is now looking like a MySQL or possibly a technical computer error altogether: [url]http://www.daniweb.com/forums/thread108602.html[/url] Could someone please help me out. |
| | Hi guys, I am trying to find a solid optimization technique for my problem. I have two tables that grow quote large: [code] CREATE TABLE `mydb`.`xm_artist` ( `artist_id` int(10) unsigned NOT NULL auto_increment, `artist_name` varchar(255) NOT NULL, PRIMARY KEY (`artist_id`), UNIQUE KEY `index_artist_name` USING BTREE (`artist_name`), FULLTEXT KEY `fulltext_artist_name` (`artist_name`) … |
| | hi i am learning to work with mysql and c. i want to select a particular row from database which must be equal to a variable and the variable should be given by user.the program is in c where i use c api to connect sql database. how to join …  |
| | I've got two tables - members and sponsor, their simplified structure below. members: id_num program_id sponsor_program_id sponsor: id_num sponsor Some of the members in members table are sponsors. I need to update the field sponsor_program_id in all records in members table with their sponsors program_id field. Sponsor table tells me … |
| | I was sticked in showing images from mysql, and another thing, if the user gives a single image , can we give a thumbnail on its own plz reply soon  |
| | [code=php] <?php // connection to MySQL server mysql_connect('localhost','root','root'); mysql_select_db('administration'); // *** Validate request to login to this site. //session_start(); $loginFormAction = $_SERVER['PHP_SELF']; if (isset($accesscheck)) { $GLOBALS['PrevUrl'] = $accesscheck; session_register('PrevUrl'); } if (isset($_POST['username'])) { $loginUsername=$_POST['username']; $password=$_POST['password']; //$MM_fldUserAuthorization = "level_usr"; $MM_redirectLoginSuccess = "validated.php"; $MM_redirectLoginFailed = "index.html"; $MM_redirecttoReferrer = true; //mysql_select_db($database_connBlog, $connBlog); mysql_select_db($database, … |
| | Hi. I have a little problem. i tries to connect to a datasource defined in Tomcat context. But when i run the jsp page i got an error telling that the driver i not found. I'm using the mysql jar 5.0.x whitch i have placed under Catalina common lib folder … |
| | Hello- I have these two tables: [code] CREATE TABLE ampref ( ampref_id serial NOT NULL, amp_id integer NOT NULL, code character varying(255) NOT NULL, description text ); CREATE TABLE amp ( amp_id serial NOT NULL, name character varying(255) NOT NULL, description character varying(255), url character varying(255) ); [/code] ...and I'm …  |
| | I installed script .It was working fine since one month but today this error is coming.Please be advice. Thanks [URL="http://www.marketdayafrica.com"]Link[/URL] [ICODE]SELECT a.*, UNIX_TIMESTAMP(a.createdon) AS timestamp, ct.cityname, COUNT(*) AS piccount, p.picfile, scat.subcatname, cat.catid, cat.catname FROM clf_ads a INNER JOIN clf_cities ct ON a.cityid = ct.cityid INNER JOIN clf_subcats scat ON a.subcatid … |
| | Hi Guys, This is probably the most silliest of questions, i am still learning php and mysql :-| . I have this code below which brings up data from the database and displays it, what i want to do is to give the table headers a bgcolor how do i …  |
The End.