10,942 Topics
 | |
| | Hey guys I am trying to create a login that checks for a password in a mysql database. I have just started picking away at this and have no clue if I am even close. If I am not even close I don't need someone to wast there time holding … |
| | hi I'm having trouble with php and mysql I'm getting this error [CODE] [Sun Jan 30 17:43:40 2011] [error] [client 127.0.0.1] PHP Warning: mysql_query(): Access denied for user 'root'@'localhost' (using password: NO) in /var/www/t/view_tg.php on line 29, referer: http://localhost/t/ [Sun Jan 30 17:43:40 2011] [error] [client 127.0.0.1] PHP Warning: mysql_query(): … |
| | I modify a php comment system. I want add it after every article witch are query from database. this is the php part [CODE]<?php ... while($result = mysql_fetch_array($resultset)) { $article_title = $result['article_title']; ... ?> <form id="postform" class="postform"> <input type="hidden" name="title" id="title" value="<?=$article_title;?>" /> <input type="text" name="content" id="content" /> <input type="button" … |
| | 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 … |
The End.