10,940 Topics
| |
i tried to make a new server registration suing pgAdmin3. i filled up the form with this name: test host: localhost port: 5432 Mantainance DB: postgres Username: test the rest i left it empty. but i got an error, [QUOTE]An error has occurred: Error connecting to the server: FATAL: database … | |
I have one MySQL database field which saves comment from users. Some comments have new lines but when I try to use PHP to display the contents of the database, the new lines are ignored. I know about nl2br() but I guess it will not work as my users will … | |
What is difference between SQL,MYSQL, and MS-SQL? | |
Hi all, This is my first post on this forum, I hope someone here can help because the last few forums were at a loss... Any ways, I have this MYSQL command: [CODE]SELECT DISTINCT schedule_date, schedule_time, schedule_team_1, schedule_team_2, event_name, type_name, gen_duration, COUNT(DISTINCT((SELECT id FROM link_schedules WHERE schedule_id = schedules.schedule_id UNION … | |
hello... I created a website having a database. I realised that I need to set a database username and password. I tried to include it in the connection string but I'm having the below error: Login failed for user ''. The user is not associated with a trusted SQL Server … | |
I set a password to mysql console in wamp. I followed a video tutorial. And it was successful. But now I can't access phpmyadmin or localhost. It says invalid password ...And gives no option to type the password. How can I solve this?? | |
I can't find information on this anywhere online. I am building a site using drupal. As you may know drupal installs its own database and runs on Apache. I have a backend mysql database that must be read and written from a vb.net app. I had to purchase a hosting … | |
Hi Not the first time Ive wondered about this, just the first time Im asking the internet :) I have a list of 'users', and there is a table of 'photos'... each matched to a user via a 'link' table... When I use a left join, and the 'user' doesnt … | |
I am having a little bit of trouble coding a registration form. The text fields are no problem, its when I have a selection of checkboxes asking why they chose to register with this particular website. There are 3 checkboxes and 3 fields in the mysql table for them, the … | |
Hi, I am looking for some information about using Underscores ( _ ) in usernames. I currently have a friends system where a user can become friends with another user and this is placed into a database. I then have a query to display all of the users friends, which … | |
Hi, I guess it's time for my first post here :) I've managed to create a php script that can run through a MySQL table and print out OPTIONS for a HTML SELECT tag. That was Google 101. But I want to keep my php and HTML separate so i've … | |
Hi all, I am trying to output data from a MySQL database from the column, 'category', however what I have at the moment isnt working. Any suggestions please? [CODE]$catrow = mysql_query("SELECT category FROM tuck"); $cate=array(); while($category = mysql_fetch_assoc($catrow));{ $cate[]=$category; } echo $cate[0]; echo $cate[1];[/CODE] Thanks | |
Hi, the problem is that my scrip stops if a duplicate key is found and i would like to know how to handle duplicate inserts into database and if founded ignore and don't insert the data or handle the type of error. [CODE=C#] try{ cmd.CommandText = "Insert into subscritor ..... … | |
I have an html file that is supposed to do a search and return of a database I have created in phpMyadmin but is giving me nothing but one error after another!!:'( This is the html form[CODE]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>Directory List Request</title> … | |
I am working on an Android app for a company. Their website is hosted on godaddy and all of the info I need for a "news" section are in their MySQL database. What is the best way to show the latest news in the app? I figure the easiest way … | |
I have two tables Banks(Bank_id, Bank) FX (ID, Bk_id, currency, trans, value) Banks and FX are innerjoined on Banks.Bank_id=FX.Bk_id. in the original table in database: [CODE]Code: ID Bank Transaction type Currency Value 1 X Buy EUR 1 2 X Sell EUR 2 3 X Buy USD 3 4 X Sell … | |
Hi guys! Please - tell me -how to perform the following task. There is a table- [CODE] table SUBJECT ( SUBJ_ID NUMERIC not null, SUBJ_NAME VARCHAR(100), HOUR NUMERIC, SEMESTER NUMERIC );[/CODE] I need to count the number of items. studied in each course. I had already counted number of subjects, … | |
| Hey all, my first post in this brilliant website, got a lot of ideas from here. So I'm a student and currently we are learning a bit of php and right now I'm stuck. I have a database with URL adresses, there is 3 fields, id, name and adress. I … |
I am trying to write a PHP script to connect to a database I have created in WAMP Server 2.0 but no matter what I do I keep getting the same error message: Parse error: parse error in C:\wamp\www\database.php on line 5 I have looked at this for over an … | |
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\AppServ\www\eUTM\login\logincheck.php on line 13 here is the code: <?php //login check require_once("dbconn.php"); $con=connectdb(); $idpengguna=$_POST['idpengguna']; $katalaluan=$_POST['katalaluan']; //login PELAJAR from table pelajar $pekerja_query="SELECT * FROM pengguna where idpengguna = '$idpengguna' AND katalaluan = '$katalaluan'"; $pekerja_result=mysql_query($pekerja_query,$con); $pekerja_row=mysql_fetch_array($pekerja_result); if(!$nama_id && !$katalaluan) { $err=1; … | |
I need to know how to sort my authors into their respective categories I have a mysql table with the authors details and another with the categories this is my code to get the info from the tables (i realize I spelled category wrong in my database) [CODE]$sql = 'select … | |
I am running an automated script that generates a CSV file from a query every 24 hours which works well, but I must use root login. As soon as I change it to the user login (who has the same rights to the schema as root) it gives me the … | |
Hi, Dear frnds ,i am new to this site. could any one help me i want to know the Requirements of hardware for MYSQL - thans®ards sureshbabu | |
i've successfully developed a page where i can echo a `$_SESSION['SESS_MEMBER_ID']` and display the member id of a person who is logged in. however i need to display all the data of two mysql databases that are relational. $sql = "SELECT * FROM `members`.`players` WHERE `member_id` = 3 LIMIT 0, … | |
I have created a login system with some validation which all works fine, however I want to be able to create a session when the user logs in and then store this session information in a table that I have allready created. The table has the following values id ip_address … | |
First the table [CODE]create table customer( no int NOT NULL auto_increment, cust_id varchar(15) NOT NULL, cust_name varchar(50), cust_address text(150), cust_phone int, cust_email varchar(30), PRIMARY KEY(no));[/CODE] Then the trigger [CODE]DELIMITER | CREATE TRIGGER trig BEFORE insert on customer FOR EACH ROW BEGIN set new.cust_id=concat(new.cust_name,new.no); END; DELIMITER |[/CODE] Then the insert query … | |
Please help.. i need a script for this problem. i have 2 different departments, one is accounting and the other is payment. it should be the accounting page will create a transaction and when the transaction has been done, the webpage of the payment department will automatically show that there … | |
Date: January 22, 2011 Hi, Need some help to solve this error. Nothing similar in the forum, IMHO. [B]Environment:[/B] [QUOTE]phpMyAdmin – 3.3.9 with this info: # Version MySQL client: 5.0.51a # Version MySQL: 5.0.45 # Server: Localhost via WAMPSERVER 2.1 # PHP 5.2.6 # Apache 2.050 [/QUOTE] [B]TABLE [/B] DROP … | |
Hi Guys I am new to PHP and slowly learning. I have a piece of code that I need some help with. I am trying to take user input and use it to query data from a table in MYSQL. I know all my connections are working because I can … | |
Hey Guys, Struggling a bit here trying to get my head around something. I'm not a PHP expert, but I feel I've come a long way in the 6 months or so I've been learning it. Anyway, I thought I would pluck up the courage to build my own custom … |
The End.