10,938 Topics
 | |
| | 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 …  |
The End.