10,940 Topics

Member Avatar for
Member Avatar for lonelyday

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 …

0
49
Member Avatar for Nahiyan

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 …

Member Avatar for Nahiyan
0
203
Member Avatar for lisaroy1
Member Avatar for SEOCoder

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 …

Member Avatar for SEOCoder
0
229
Member Avatar for angele18

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 …

Member Avatar for smantscheff
0
67
Member Avatar for jrosh

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??

Member Avatar for dakaptain
0
144
Member Avatar for Elehas

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 …

Member Avatar for Elehas
0
202
Member Avatar for lifeworks

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 …

Member Avatar for smantscheff
0
80
Member Avatar for lit108

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 …

Member Avatar for lit108
0
152
Member Avatar for AdriftUniform

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 …

Member Avatar for AdriftUniform
0
168
Member Avatar for DJWK

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 …

Member Avatar for DJWK
0
123
Member Avatar for ben.marks

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

Member Avatar for ben.marks
0
172
Member Avatar for braveheart_sb

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 ..... …

Member Avatar for Ketsuekiame
0
99
Member Avatar for zlloyd1

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> …

Member Avatar for zlloyd1
0
145
Member Avatar for sfrider0

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 …

0
62
Member Avatar for radujit

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 …

Member Avatar for smantscheff
0
112
Member Avatar for vedro-compota

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, …

Member Avatar for smantscheff
0
61
Member Avatar for Eneswar

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 …

Member Avatar for Eneswar
0
161
Member Avatar for zlloyd1

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 …

Member Avatar for HG&C
0
152
Member Avatar for wafieali

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; …

Member Avatar for wafieali
0
437
Member Avatar for tape enterprise

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 …

Member Avatar for jrivera
0
117
Member Avatar for muppet

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 …

Member Avatar for griswolf
0
119
Member Avatar for sureshbabuganji

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&regards sureshbabu

Member Avatar for Chronister
0
58
Member Avatar for waveydaveywaves

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, …

Member Avatar for waveydaveywaves
0
152
Member Avatar for lit108

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 …

Member Avatar for ice_k99
0
199
Member Avatar for axes2t2

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 …

Member Avatar for smantscheff
2
116
Member Avatar for nyler01

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 …

Member Avatar for rje7
0
115
Member Avatar for EPierre

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 …

Member Avatar for smantscheff
0
131
Member Avatar for ON_Jtharpe

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 …

Member Avatar for lyrico
0
233
Member Avatar for brown23

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 …

Member Avatar for lordspace
0
142

The End.