10,940 Topics
 | |
| | Hi, My mysql_error is No Database Selected. errno 1046 I am connected to the database and it has worked fine before so I was wondering what I am doing wrong. The code is from a tutorial I am using. [CODE]<?php require_once('Connections/connAdmin.php'); ?> <?php //file properties $file = $_FILES['content']['tmp_name']; if (!isset($file)) … |
| | Hi, I have created a MYSQL database and connected to it using Dreamweaver CS3. There is a Master and Detail page and the initial creation works correctly. (not bad for my first attempt!!):cool: The site is for a dog rescue charity and it would be best to be able to … |
| | here's the process: 1. i display the mysql data in rows with checkboxes on each row 2. i want to add the checked values into another table under the specific field employee here's the problem: i can't seem to insert the checked value to the specified project table. what if …  |
 | when I try to access my phpMyAdmin. It occurs this error message. [QUOTE]MySQL said: #1045 - Access denied for user 'root'@'localhost' (using password: NO) phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and … |
| | Hi.. i need to learn how to send the username and password to the database and when the user logs in it should retrieve the password from the database and authenticate if the username and password is correct. Am using this jsp code and getting error in (Resultset line) [U]here …  |
| | hey everyone i have sugested to create a new club in my school called programmers , so they told me that i have to bring a list of the club aims and they xheck if the aims are good or bad then they accept the club or no , so … |
| | Hi There, I do have an sql query to update and insert row into database which I use it within a form. Problem is ; This sql query works good in one form but in other one it does not at all(same query different form), looks like it is blocked …  |
| | Hi There I do have a form and a little sql query to update the row before do something else. Problem is in the code below works when I enter the date like that= 01-02-2001 but I need to do it dynamic I know getdate() but it does not work.. … |
| | Hi: I have a process allowing the admin to view users information and download files that the user uploaded to MySQL. When the admin clicks on the file link in the admin page, I expect the file will display using the default program (i.e. pdf or txt), or download (i.e. … |
| | Hi All: I have been working very hard and long at understanding this situation. I have tried many different sample scripts, to check my work and find find my solution. I have created a job board for a client, the user applies for a job in application form.php which then … |
| | i'm having trouble getting this to work. i want mysql to delete a row where the word 'example' is within a paragraph of a column. e.g. in the column reply.. it has a paragraph with the word 'example' in it. [code]$deletebadreply1= mysql_query("DELETE FROM `Reply` WHERE `reply` LIKE '%example%'") or die … |
| | I am trying to make an Inventory GUI application using MySQL and NetBeans. So far, i was able to do add,delete,search, and save using Java Desktop Application. I now have to add a SEARCH button, a notification for the quantity if it is less than 10 and a USERNAME and …  |
| | Yesterday, I had started a thread with a problem, am trying to execute the script below, but each time it is failing and returning "Unable to record form details". Note: "Unable to record form details" is the response returned when isset($_POST) is not working, refer the code for more details. … |
| | <?php $allsql="SELECT SUM(Salesprofit)+SUM(Serviceprofit)+SUM(softwareprofit)+SUM(Airtelprofit) FROM billing,service,software,airtel"; $profitall=mysql_query($allsql) or die(mysql_error()); while($row=@mysql_fetch_array($profitall)) { echo $row['SUM(Salesprofit)+SUM(Serviceprofit)+SUM(softwareprofit)+SUM(Airtelprofit)']; } mysql_close($con); ?> Hi everybody.... i have problem in mysql query.. i got the sum for the field called profit from each table... i am getting the TOTAL value as wrong calculation value... how do i get the …  |
| | Hi, I am trying to execute the following script, but each time it is failing and returning "Unable". Note: "Unable" is the response returned when isset($_POST) is not working, refer the code for more details. [COLOR="red"][B]PHP CODE[/B][/COLOR] [CODE]<?php $test = "Hi!"; if ((isset($_POST['usrName'])) && (isset($_POST['pWord']))) { $user = $_POST["usrName"]; $pass … |
 | [CODE]+--------------+------+------------------------------------+-------+ | ProductCode | Qty | Title | Price | +--------------+------+------------------------------------+-------+ | relationaldb | NULL | The Relational Database Dictionary | 14.99 | | artofsql | 50 | The Art of SQL | 44.99 | | databaseid | 0 | Database in Depth | 29.95 | | mysqlspp | 5 … |
| | Hi, Currently I am working on a site that lets users upload photos for their personal page. This page is just a prototype so some of the code is very sloppy so I really should not post all of it. Anyway, here is some: [CODE]$id =$_GET['id']; if(!isset($id) || empty($id)){ die("Please … |
| | Using the above technologies, I want to create a PDF, store it in my db, and email it. All with the click of one button. I also want to call it up and have it be able to display with a hyperlink. I am very new to FPDF. Therefore, I … |
| | At the moment, I have the following to do MySQL queries: [code] MySqlCommand Command = new MySqlCommand(Query, SQLConnection); IAsyncResult Result = Command.BeginExecuteReader(); return Command.EndExecuteReader(Result); [/code] This is a static command in a server in the database class, which includes a static connect/disconnect function (used once when the server starts and … |
| | Hello! Finally I joined daniweb. Great stuff in here guys. Anyways lets get to the problem: I have a page where a number of topics are displayed ( they are added by admin). And to get this list I`m using this script [CODE=php] // Query the database $gettopic = mysql_query("SELECT … |
| | My database has a list of events, and I'd like to return it sorted by date. However, I'd like to have the past events be forced below more recent events, so I try to do this: ( SELECT name, date FROM events WHERE date >= curdate() ORDER BY date ) … |
| | So i had to do the following assignment in GWT: 1.Implement a selection/de-selection component as described below: The selected item in the first list goes into the second list and is removed from the first list when the >> button is pressed. The selected item in the second list goes … |
| | I have made some tables and created relationship from phpmyadmin. Relationship is as below [IMG]http://img295.imageshack.us/img295/2411/relationship.jpg[/IMG] Problem is that requisition table allow [B]material id[/B] which is not in [B]material table[/B]. what is the problem. How can I solve this. Simply Foreign key can not be such value which is not in … |
| | Hi There, I've got a membership script and a login using PHP and MySQL databases however when it logs in it simply displays a PHP page - the same one for all users. I want to be able to customise the members page so it says things like: Hello, <username>. … |
| | Hi, I have a problem with importing special slovenian characters (č, ć, š, đ, ž etc) from excel to mysql database. I changed database coding to utf-8 in phpmyadmin and in php editor (Eclipse). Adding articles (to table) from html form works fine (with special characters: č, đ etc), but … |
| | hi, I have a table called shoutbox, i created it this way: [CODE]CREATE TABLE `shoutbox` ( `id` INT NOT NULL AUTO_INCREMENT , `ip` varchar(20) NOT NULL , `name` varchar(30) NOT NULL , `url` varchar(30) NOT NULL , `message` varchar(50) NOT NULL , `date` date NOT NULL , PRIMARY KEY ( … |
| | Hi everyone, I have a database with X items, and each of them can have one or more of 20+ properties. How I currently make this work is I have a huge table with each of the properties having it's own column, and a boolean to determine does the property … |
| | Hi All, I am using MySql and wrote all my create table scripts directly on the command line client. Now I have no tracks of them. I need all the table scripts present in my database region for future reference. I used the below command to view the script of … |
 | Ok...this is my "HELP ME! HELP ME!" thread.:D I finally got my code to work...almost. The form posts to my database but only the first query data inserts and the last value of the third query. All the form fields are correct and the problem appears to be with my … |
| | I've used the code below previously with success, but I'm having problems this time around, and hoped someone could point me in the right direction. I complete the form, click submit, and receive the message confirming data has been added. However, when I look at the database, there's nothing there. … |
The End.