11,093 Topics
 | |
| | hi,im really new to MySQL,can some one help me in joining table pls...i hv 2 tables,customer table and record table customer table with CustomerID,Customer Name,CustomerAddress, record table with RecordID,CustomerID,Date, how to make the CustomerID in record as foreign key? how to join that two tables so that record will be … |
| | hi, i'm really new to programming in general, and i think i've figured out how to insert and select data from mysql databases, however, i can't seem to get values from a table and work on it here, i'm trying to 1) grab a number from my table 2) generate … |
| | I have a database with some tables from a restaurant and users can see if they are [I]free[/I] of [I]reserved[/I]. If [I]free[/I] they cand book that table. Now, my question is this: What can i do so that after (let's say 1 day (or any amount of time) after the … |
| | Hi all, I'm going crazy... I need make this simple function: I need to have 2 inputs checkboxes Bank wire and visa. How can i update them? Here is my VISA table (the bank_wire is almost equel to visa table) [CODE]CREATE TABLE IF NOT EXISTS `visa` ( `id` smallint(6) NOT … |
| | Hi, i was wondering how if it is possible to enter a large amount of information into mysql database easily. I have about 15,000 rows that i have to enter and i would like to know if there is a way anyone knows to enter it fast rather than entering … |
| | Hello, So here is the story: I'm trying to select from two diferend tables ( bank_wire and visa) [CODE]CREATE TABLE IF NOT EXISTS `bank_wire` ( `id` smallint(6) NOT NULL AUTO_INCREMENT, `method_name` char(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Bank wire', `checked` smallint(1) unsigned NOT NULL DEFAULT '1', `commision` char(255) COLLATE utf8_unicode_ci … |
| | Hey guys, Please tell me how to load data from an excel file to a mysql database using jsp. |
| | guys can i call this a database and how to use it this is the file mysql.php [CODE]<?php if(!defined("SQL_LAYER")) { define("SQL_LAYER","mysql"); class sql_db { var $db_connect_id; var $query_result; var $row = array(); var $rowset = array(); var $num_queries = 0; // // Constructor // function sql_db($sqlserver, $sqluser, $sqlpassword, $database, $persistency … |
| | Hi Everyone. I have MySQL db with images in(MEDIUMBLOB); I would to display the images in a gallery fashion with a MySQL select command. Any help would be appreciated. Regards  |
| | It sais Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given on line74 and I tried a lot of things. here is code [$query="SELECT * FROM specificati,ofertant,suprafete,preturi,manopera WHERE ofertant.id_ofertant=preturi.id_ofertant AND preturi.id_manopera='Montaj parchet' AND preturi.id_manopera=manopera.id_manopera AND specificati.id_camera=suprafete.id_camera "; if (isset($query) && !empty($query)) { echo"<!--" . $query . "-->"; $result=mysql_query($query) or … |
| | Hello everybody, I have a problem with my mysql-server, at least, I think... This is the problem : I use aptana as my editor, in which I have installed QuantumDB as plugin. This allows me to quickly update or delete or insert data in my MySQL-database without having to leave …  |
| | Is it possible to edit the contents of fields after a select statemen? For example, I have a table Person (Id int, Username varchar(50)). Most of the rows in Username has the format of, say for example, aaa_01, bbb_02. I want to select this usernames with the underscores and the … |
| | Hi There Everyone. Could anyone assist me in the correct method of displaying images from my mysql db. I want to display multiple images on my page. This is the code I have. I got this from a post from DaniWeb. Hope I did the code tags correctly. [code=php] <?php … |
| | Hello, I am new to php code (month or so) and mysql, I am pretty much teaching myself, I am good with HTML, CSS, JS, etc... I am trying to create a DB for a client that is fairly simple; Add members (got that done); Verify member and post data … |
| | I am trying to join two tables and havent been very successful, can anyone please help! The two tables are joke and author; I need to get the authors name and email address in the joke table! The database is ijdb; mysql> USE ijdb; Database changed mysql> SELECT LEFT(joketext, 20), … |
| | I would be thankful if some one explain me where to start in order to access a database in Java on Eclipse Thank you in advance |
| | how do i insert a image into a directory through MySQL, rename it, generate a link and upload the generated link in MySQL......??? anyhelp will be really apprietiated.... and if its a tutorial its the best way out, i'm not good at PHP..... plz its urgent for me.. thx alot.. |
| | Hi again! I have a db table named "users" . Within that table, a column named "havechildren". When a client registers on my site, they will choose whether they have children or not by a simple yes or no drop down. That information is stored in my table in the … |
| | There are 2 questions that I have. After banging my head with mysql server for more than 4 hours, I've given up. The mysql server will start mysql service on windows 7, but will not start another service. (Is this somehow related to admin rights of 7. I am an … |
| | Hi all, I have a cities table in MySQL with 3 rows in it. Table 'cities' row 1 'city' row 2 'statename' row 3 'stateabbreviation' With 52,593 cities in the DB. I would like to create an auto search form so that while typing a city in it will show … |
| | Hi all, I m designing a hospital management project, and I need to provide unique id to every patient. The requirement from our client is that the format of this unique id is: ddmmyyxxx. For example, 080710001, 080710002 etc Here is what I did: concat dd mm and yy strings. …  |
| | I'm writing an application to catalog a very large number of files (2 million+ files)on a share drive. For each file in the directory tree, I'm adding a record to a mysql database. The share drive is active, in that files will be regularly added; thus the app will need … |
| | Hi, yesterday i downloaded a script. Now, im installing it on my website, but when i load index.php page and all the page where config.php is included, it say that: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mhd-01/www.newsict.com/htdocs/config.php on line 13 this is config.php : … |
| | Forgive my ignorance with such matters, but I have what is probably a simple issue that I can't seem to resolve on my own. I'm getting this error when sending a request to the SOAP server [CODE]org.xml.sax.SAXParseException: Content is not allowed in trailing section.[/CODE] I've checked the end of all … |
| | Hi I need to know, is there any option to use For loop instead of While and ForEach to retrieve the result. While Loop ----------- [CODE] $query = "SELECT name, subject, message FROM contact"; $result = mysql_query($query); while($row = mysql_fetch_array($result, MYSQL_ASSOC)) { echo "Name :{$row['name']} <br>" . }[/CODE] instead to … |
| | I have a site that uses apache(php) & mysql I recently moved the mysql to another dedicated server in order to increase performace. This is the problem now : MYSQL Server is showing ~150GBs daily outgoing transfer to Web Server ! And at the same time the Web server is … |
| | Hi guys, Need your help/advice/opinion for below sql. I try to select all count record that exist in tables between to date insert by user.Currently, just put dummy date to test. The result is ok, but it only view for match data. How to include the record that not match … |
| | Hi, I am trying to get some info form my database. I want to see if there is an entry with a certain product_id that also has another column marked as 1. I want to display the number of rows that contain that combination. I have tried a few different … |
| | Hello ppl, I have a mysql db and i want to know how is better to use queryes on my website in the table favorite i have many rows with id (some numbers..) and fav ( img1 img2 img3 img4 img5 etc..) and a table named img where the first … |
| | Hi There, I have had a look on the internet but not really been able to find the correct thing i'm looking for very easily, or at least not very well/easily explained. I am trying to create a Search Form for my website which has 2 fields. 1) A Postcode … |
| | Hello to all Web Developers! I need a simple help here: [CODE]<table class="maxWidth" cellspacing="0"> <form action="update_conditions.php" method="post" > <tr> <td ><input type="radio" name="sex" value="citizenship" checked="checked" /> Accept all citizenships <br /> <div class="paddT5 borderT"></div> <input type="radio" name="sex" value="citizenship" /> We do not accept citizenships from: <textarea name="ud_not_citizenship" class="textarea" rows="5" > … |
| | Hello! This is my very first post, anywhere, asking for advice. I have a mysql table named "children". It has 5 columns. "username" "child1" "child2" "child3" "child4" Based on my register form, A user creates a username and list the names of children he/she has (up to 4) on submit, … |
| | Hello, I'm new in PHP and MYSQL.. I need a small help... Here is what i got: [B] CONDITIONS[/B] [CODE]<form action="update_conditions.php" method="post" > <table class="maxWidth" cellspacing="0"> <tr><td >Method</td><td>Commisions</td><td>Proccess Time</td><td>Min Deposit</td><td>Max deposit</td></tr> <tr> <td> <input type="checkbox" name="ud_bank_wire" value="<? echo "$bank_wire"?>" /> Bank Wire</td> <td><input name="ud_b_w_com" class="update_by" type="text" value="<? echo "$b_w_com"?>"></td> <td><input … |
 | I have this long winded query [code=sql]select i.id,i.name, i.item_type_id, (select it.name from items it, relations rel, relation_types relType where it.id=rel.to_id and rel.from_id=i.id and rel.relation_type_id=relType.id and relType.name='CityCtountry') as cityCountry from items i where i.item_type_id=2;[/code] Cut the long story short, we inherited database from customer that hasn't been happy with other company, … |
| | I want to insert records into multiple tables at one go, I am doing this in the following way, is this the correct way of doing? If not, what is the better way? [CODE] mysql_query("insert into table1 values('abc')"); mysql_query("insert into table2 values('ttt')"); mysql_query("insert into table3 values('5t6')"); mysql_query("insert into table4 values('ghy')"); … |
| | When I use the following PHP code I get this error Error performing query: Unknown column 'nh12134' in 'where clause' Yet when I use 'nh12345', which is the Value that the variable $username contains (i've checked that it does by printing it out elsewhere) instead of the $username in the … |
| | I've got what I think must be a pretty simple question, but it's my first time doing something like this. Here's my situation. I have a simple database. It's a dictionary of words. I want to have a form that I can enter a word into. Once I do that, …  |
| | I run a non-profit association bulletin board using vBulletin software. I have been unable to find a vBulletin coder to help me with a MYSQL query. Seems straight forward to me. I have a csv email file of paid up association members. I also have vBulletin members/users who might or … |
| | Hello, I wrote a query to find the products names by the name entered and to count now many records are outputted. $query="SELECT COUNT(product_id) AS tot,product_id,product_name FROM tblproduct WHERE product_name LIKE '%$pname%'"; $query="SELECT COUNT(*) AS tot,product_id,product_name FROM tblproduct WHERE product_name LIKE '%$pname%'"; I tried both way. but always it returns … |
| | Hey! I am making a program that keeps track of users so the program has to update the number in the database how do I actually do it? I know how to select things and such, but have no idea how the update works.. I didn't really find anything for … |
| | i am not able to use connection string anyone help me |
| | I have linked my vb.net application with mysql database but i am having a problem inserting data from the vb forms into the relevant fields in the database... Any assistance will be highly appreciated! thanks:-) |
| | Hey there, I hope this is the right place to put this in? Anyway, Im currently using PHPMyAdmin application on the yahoo small business web hosting. Basically when I click the privelages button I recieve this errer: [QUOTE]Warning: Your privilege table structure seems to be older than this MySQL version! … |
| | [CODE]<?php $host='localhost'; //Change the user,password and database variables as desired $user='root'; $pass=''; $dbname='imagedb'; $link=mysql_connect($host,$user,$pass) or die(mysql_error()); $db=mysql_select_db($dbname) or die(mysql_error()); ?> <html> <head> <title>Uploading image to MySQL database and displaying it</title> <script src="mootools1_2.js" type="text/javascript" language="javascript"></script> <script src="ajax.js" type="text/javascript" language="javascript"></script> <link href="style.css" rel="stylesheet" type="text/css"> </head> <body> <fieldset> <legend>Upload Form</legend> <form enctype='multipart/form-data' name='frmupload' … |
| | Hi everybody I am very new to PHP and MYSQL How can I implement : [CODE] $q=$_GET["q"]; $CMY=$get["CMY"]; ... $query=("INSERT INTO the_array($CMY, model) VALUES('$q','dddd')");[/CODE] $q and $CMY are results I get from AJAX, and I think the only way to save the results is using the DB. |
| | Hi. i have a Stored Procedure like this DELIMITER $$ DROP PROCEDURE IF EXISTS `foundation`.`TEMP_TBL` $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `TEMP_TBL`() BEGIN -- DROP TABLE IF EXISTS TEMP_TBL; DECLARE done int(10); DECLARE a,b,c,cname CHAR(26); -- DECLARE cur1 CURSOR FOR SELECT id,ccode,accname FROM account_master; DECLARE cursor1 CURSOR FOR SELECT id,ccode,accname FROM account_master; … |
| | I have a database in a text file. I want to add the database from it to my MySQL database. I am new to php so i want the code of it and please explain if you can because it will help to increase my php knowledge. And after adding …  |
| | I have two databases on two different servers. I want to connect two tables based on an id but I'm not sure how to do it. I've seen stuff like this suggested [CODE]<server name1>.<DB name1>.<schema/owner name1>.<table name1> JOIN <server name2>.<DB name2>.<schema/owner name2>.<table name2> ON <...>[/CODE] but I can't get it … |
| | Hi All, I am trying to Create the trigger which will invoke the php after record is field in record is updated. Can anyone please help me with some sample code Regards Hemant  |
| | Hi everyone, first of all, sorry for my english... I'm in this situation: I have a table in my database named products with the fields [B]id[/B] and [B]model[/B] in it. Now, I need to get 'all' the products but with different model names and each result represent a valid product. … |
The End.