10,940 Topics
 | |
| | Hi All. I am currently designing a photo sharing website. I need to make a script that deletes the image from the folder it is stored in and also from the database. I have done the database bit but i cannot work out the deleting from the folder bit. Any … |
| | [CODE]<?PHP $results = mysql_query("SELECT * FROM messages, comments WHERE messages.user_on='$user2' AND comments.msg_id_fk = messages.msg_id ORDER BY messages.msg_id, comments.com_id DESC") or die(mysql_error()); ?>[/CODE]  |
| | I have data.sql file and there is 151262 insert statement in SQL file. but while i try to IMPORT it in MYSQL database this give me following error. Fatal error: Maximum execution time of 300 seconds exceeded in C:\xampp\phpmyadmin\libraries\import\sql.php on line 111 Pls give some solution for this Problem. -keval |
| | All, I've recently installed Apache version 2.2, MySql version 5.1, and PHP version 5.2.13 and am using Windows as my OS. I've gotten PHP to work on the Apache server, and MySql is working properly on its own. However, when I try to connect to a mysql database, I get … |
| | Hi everyone I am making a system where i have to refresh the database after updating it. I am using a JTable and a mysql database, but i have to close down the application so that the updates can be implemented.Is there a way of refreshing the connection session, or … |
| | Hi everyone. Could someone assist me with a problem I have. I want to display images in a folder.(image/). I have my MySQL table with my images location.(images/test.jpg) etc. I also have a legend_id where I specified id's (id_1, id_2, id_3) This is linked to cars. If I search according … |
| | basically i have a table which has different branch names recorded in the same column as other data. I cannot change how the data comes in so i have to find a way of extracting and matching data from this column. eg +---------+---------------------+------+------------+--------+ | Company | Branch | Tml | … |
| | [CODE]#include <iostream> #include <string> using namespace std; class w { public: void InsertRow(String* myConnection) { // If the connection string is null, use a default. if (myConnection->Equals(S"")) { myConnection = S"DRIVER= {SQL Server};SERVER=MyServer;Trusted_connection=yes;DATABASE=idb;"; } OdbcConnection* myConn = new OdbcConnection(myConnection); String* myInsertQuery = S"INSERT INTO test (id)"; OdbcCommand* myOdbcCommand = new … |
| | Hello, I have two tables product table and accessory table. also i have a order table. order table have either product id or an accessory id. those are two nullable fields. now i want to choose from product or from accessory table, either product name or accessory name. can i … |
| | Hi I have a html page with a div and i'm loading data into it every 10 seconds (using jQuery load().) from a php page which is querying a mysql db. This is great but what i want to do is if a value in the table i'm loading into … |
| | 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 … |
The End.