10,942 Topics
 | |
| | Can anyone tell me if the following query can be done? [CODE]mysql_query("SELECT a, b, (a+b) AS c FROM table WHERE c=1");[/CODE] When I try this I get an unknown column error for c. In order to get the query to work I have had to do this [CODE]mysql_query("SELECT a, b, …  |
| | I have changed a column in my database from the primary Key to Index, as i need to allow the same reference in the column for multiple entries with different dates against them, but now i need to adjust my queries. how do i do this? |
| | Firstly, Sorry for the long post :) Im currently creating a training database for use within the business (not done many getting used to coding) I used MySQLMaestro to construct the datagrid and have modified it to suit most my needs. however i have one issue that i cant resolve. … |
| | Hello there Daniweb community, today i encountered a problem while developing a Desktop Application in C# With Mysql (MySql.Data.MySqlClient). Im not using ODBC. The situation is the following: When NOT executing two queries, the data gets processed and everything works fine. However, once there are two queries, problems appear. Its … |
 | I want the post_delete column to generate unique id's so that when I want to delete a comment for e.g. I can refer to the post_delete's value. [B]Here is my users TABLE[/B] [CODE]CREATE TABLE users ( user_id INT(8) NOT NULL AUTO_INCREMENT, user_name VARCHAR(30) NOT NULL, user_pass VARCHAR(255) NOT NULL, user_email … |
| | Hey guys.. this isn't a coding qs... my php cant read any of my mysql functions... eg. mysql_connect, etc.. everything else in my php works... but even if i echo after mysql_connect it wn't print, but if i echo before it will... its not a coding problem because it works … |
| | Hi, I am having an issue with updating my database with info from an excel spreadsheet. I am using php-excelreader from: [url]http://sourceforge.net/projects/phpexcelreader/[/url] Here is what I have thus far: [code=php] <?php require_once 'reader.php'; $Host = "..."; $User = "..."; $Password = "..."; $DBname = "..."; $Link = mysql_connect ($Host, $User, … |
 | hi all , new to database, how to design these table in mysql. Permissions for CRM 1. Broker /Team a. Add agents b. Assign agents c. Add/Edit everything any agent has 2. Agent a. Can NOT add agents b. Can NOT assign agents c. Only add/edit their own leads any … |
| | Hi I'm just starting with php programming and need some help. This is just a test script I'm writing to see how it works. I'm trying to search for phone of a certain make and price using a different search box for Make and price. I want the results to …  |
| | I had created a registration page for users to sign up an account and a database to store all information such as username and password. I had also created a login page for users to login after registering an account. How do I link the database so that I will … |
| | Please help me out her, I am building a website using wordpress I have created a post with four different categories in the post page, categories named : Action. Terror, Documentary, and News, and these four named Categories are automatically inserted into one of the eleven tables automatically created by … |
 | Hi guys! I got a problem with my logging in system. I can connect to my database with the code: [CODE]session_start(); include('header.html'); $page_title = 'Home Page'; $mail = $_POST['email']; $password = $_POST['password']; $msg =''; if(isset($mail,$password)){ $con = mysql_connect('127.0.0.1','root',''); if(!$con) { die('Could not connect: '.mysql_error()); } else{ echo "Connected!"; } } … |
| | Dear All, I have been using the MBRWithin function for quite a lot of times. Suddenly I notice on google map this 'POINT(101.11857 4.34475)') is out of the geo fence which I specify but it still give a value of 1 in mysql any reason or tweaking need to be … |
| | i have received an error on adding an information on VB6.0 database is SQL i just use the covert ACCESS to MYSQL code :[ please do help me O_O i received an error "mySQL server has gone away" ...other adding of information seems ok except from this one please do … |
| | I have a large array. Is there an alternate method to check if $value in the array is present in the MySql table vote and if not then insert $value into vote. This is what i am doing currently. Is there a better method? [CODE]foreach($rowids as $value) { $select = … |
| | is there a significant difference between phpmyadmin and mysqlbuddy? i mean does they differ in codes? coz i have to make a website that checks whether the username and password exists in the databse. here is my code for looking up in the databse. [CODE] <?php if(isset($_POST['submit'])) { include 'connection.php'; … |
| | Hi, Can anyone explain to me what does this piece of code mean? [CODE] <roleManager enabled="true" defaultProvider="MySQLRoleProvider"> <providers> <clear/> <add name="MySQLRoleProvider" type="MySql.Web.Security.MySQLRoleProvider, MySql.Web, Version=6.3.6.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="LocalMySqlServer" applicationName="/name" autogenerateschema="true" /> </providers> </roleManager>[/CODE] Whenever i run the program, there is this error message that prompted in my web browser Parser Error … |
| | we have our system running but our system needs to be modified because we did something wrong...we are doing an "Internet monitoring System" in our school library where the user can only access the internet 1hr a day, and he/she cannot use the internet within that day if he couldn't …  |
 | Hello first code I need to know the code to get data from mysql table that have a letter a i mean i have a table called "Games" there's a games start with a b c d e f g h I need to retrieve games That begin with (( … |
| | Hi all, just wondering what the best way is to structure time in sql database. For example, at present i use this format ; 19/08/2011 (which is day/month/year). when i call this in a sql statement, it shows all results, but not in a chronological order. Can any body solve … |
 | Hi I just set up my IP Board. Now i want to retrieve some of the data via mysql, so far I have no problem getting a table into a datagridview, but what do i do to get a value from a table right now i got SELECT * FROM … |
| | Hello, I think I made a mistake while connecting my tables with foreign keys :S here's the DB- table 1: [U]Id[/U],[U] year[/U],..... (2 Primary keys) table 2: [U]tbl2Id[/U], ... now the table that connects tbl1 and 2 with m..m relation- table 3: [U]Id[/U],[U] year[/U],[U]tbl2Id[/U] I set the foregn keys for … |
| | I am facing problem on sum of dynamic array value. For example : [B]tablename : totalamt[/B] ref_no | Amount 1 | 58 2 | 12 3 | 11 i am using check box to select the ref_no. now i am selecting 3 check box now and submit it. Now it … |
 | Okay so me and a friend of mine are discussing the following: If you have 1. a table with 10 fields, each a varchar(255) or 2. a table with 10 fields, each a varchar(1billion) [B]Which would be better, performance wise?[/B] I say it won't matter, because MySQL reads the field … |
| | I'm trying to creat a search procedure that will search table game and return all rows where columns title, description, platform, and gameid are LIKE parameter searchtext. This parameter is coming from many different pages as a Session("searchtext"), and I'm using a UserControl to send the Session, all pages in … |
| | Good day. I'm new here and I'm nt sure this post should belong in here or not. I had done my programming on the virtual machine while having mysql database set up in my PC. I was unable to get the data from my PC unless I installed another database … |
| | I keep on getting this error "Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in" from both of my while loop conditions. Can anyone review my code and let me know what I'm doing wrong? [code] <html> <head> <title>Task # 4 - Test Page</title> </head> <body> <?php $link … |
| | I have a page full of user-submitted updates and stuff. Basically the basic stuff. I am taking it out of a database. I have this so far: [CODE]$getnews = mysql_query("SELECT * FROM news ORDER BY $order LIMIT 50"); [/CODE] and $order is determined by a drop down menu on the … |
| | Hi, Basically I'm creating and implementing a dynamic website as part of my uni final year project but i am a beginner in php so need some help. First, I'm not entirely sure about how i should go about creating the database, tables and inserting data. I don't mean in … |
| | [code=php] <?php $conn = mysql_connect("localhost", "root", "dotherz"); //connecting to database if($conn) //testing if the connection was stablished { mysql_select_db("orders", $conn); //selecting database from your localhost $qry = "SELECT * FROM customer WHERE customerId = 1"; //the query to get the first user $result = mysql_query($qry); //executing the qry and passing … |
The End.