11,093 Topics
 | |
| | |
| | I am a beginner in JSP, I am just wondering will it be possible to create a pie chart in jsp without installing new classes and stuff? If yes, how can I do it? Or else will it be possible if I retreieve the data from mysql and display it … |
| | I want to add an image to my php script: [QUOTE]<?php $sql = "select * from Prod_listing"; $result = mysql_query ($sql); while ($row = mysql_fetch_array($result)) { $field1= $row["Product_Name"]; $field2= $row["Product_Id"]; $field3= $row["Product_Description"]; $field4= $row["Product_picurl"]; echo "<h1> <strong> $field1 <br> </strong> </h1>"; // Header Tag, bold.tag echo "$field2<br>"; echo "$field3<br>"; echo …  |
| | Is it possible to make a column on my database that automatically copy another column on the same table string together with another url? for example on my database "ewelby_k5" I want to create a new column called (fullthumb) on table "files" where "fullthumb" stores "http://k5live.com/thumbs/ + column "thumb" " … |
| | after some troubleshooting inside the tables of a mysql database the system still not runs stable. The next day I wanted to login via Plesk it stated: 'ERROR: PleskFatalException Unable to connect to database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 0: /usr/local/psa/admin/plib/common_func.php3:156 psaerror(string 'Unable to connect … |
| | mysql4.X is installed on my system.while i tried to install Phpbb forums in my personal computer it is giving the following error: Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Program Files\Apache Group\Apache2\htdocs\phpBB2\db\mysql4.php on line 48 Warning: mysql_error(): supplied argument is not … |
| | hi all, i just want to know whether it is useful to alter the 50% threshold scheme that mysql uses by default ,is it beneficial in any way regarding serach(either by increasing or decreasing its value)or is it good to use default value of 50% only. which is better (altering …  |
| | I am relatively new to mysql. I am updating a site for a customer, and I'm using mysql 5 w/ phpMyAdmin. I was supplied an .sql (echeck.sql) script to build the database for this site. I create a database named "echeck" in phpMyAdmin, and once created go to the import … |
| | Can not get the following code to delete Jack.... What is wrong with the code? <?php ===QueryString=== delete.php?q=169|170|171| $arr = explode('|', $q); for ($i = 0; $i < count($arr); $i++) { $query .= "DELETE FROM aCar WHERE aID = '".$arr[i]."'"; $result =mysql_query($query); } ?> Thanks in Advance!  |
| | I had my site working which require mysql database... so now im trying to host that site here at home... my site comes up but now on the top of the main site 3 errors come up... Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'milatcom_clipsha'@'localhost' (using password: YES) in /www/www.mysitesname.com/include/adodb/drivers/adodb-mysql.inc.php … |
| | Hello Everyone i need help connecting my site to a database.. Either MySQL or PHP Which Is better. |
| | I used both Myisam and InnoDB. We have something like 500k update, 500k and 500k insert/delete/replace per hour. Many full scan because of updation.Both give me some problem either dead lock occurs or too many connection rise. Also insert/delete/replace operation takes long time. If i used innodb then dead lock … |
 | I'm looking for some PHP scripts that be able to search into the Database and retrieve all the records that matches the user input string in the search form. Please advise. |
| | I want to apologize for this morning's downtime. We were having some mysql problems this morning, and I didn't realize it until I woke up, a few hours too late. Sorry everyone! Cheers, Dani |
 | I am emailing a field from a MySQL DB table. The field type is text. Basically, it is an accept email. How can I make it so the email sent is capable of emailing HTML to make the message more attractive? I have already tried to insert < html > … |
| | I want to build a web application with MySQL database. When more users will visit my site, more database queries will be initiated and the response time will increase. - Is there a limitation for the number of users who can query MySQL? - What are the ways to handle … |
| | hi i want to know how to fetch data by giving more than two condition...please tell me wat should i use eg i have a query [ICODE]SELECT * from post_resume WHERE ind_type='IT'and career='Engineering' order by tdate DESC[/ICODE] i want to check based on another condition also... [ICODE]select association from employer … |
| | hi, i need ur help. can u help me how to remotely connect some database like ms access,sql server,etc to mysql?every minute i hav to send new information from database ex ms access to mysql. I use VB6.  |
| | guys i m really havin hard time to establish connection bet jsp n mysql...give me some tips..i ve done all the procedures required for that n i couldn execute the followin code [code=html]<%@ page import="java.sql.*" %> <% String username="mahesh"; String password="mahesh"; String connectionURL = "jdbc:mysql://localhost:3306/mahesh"; Connection connection = null; //Statement …  |
| | 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 … |
| | I need to get the details of a packet like Proto type, Sourc ip,Dest ip, packet Size, Source port,dest port in a vc++. These data i will store in a mysql database. How do i get these details in the program for a windows system ? |
| | 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 … |
| | Hi I'm triying to develop an application to read barcode (from laser scanner) and manipulate the string with mysql. I've read something about serial port but i'm not sure how to do it. Could somebody give me a piece of advice? |
| | 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.. :) |
The End.