10,946 Topics
 | |
| | I new to mysql and I need a free mysql developer software ?  |
| | I am getting this error message [code]Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'dorcas'@'localhost' (using password: YES) in C:\myweb\dbmysql.php on line 2 Error connecting to database [/code] when i run this code[code] $con = mysql_connect("localhost", "dorcas", "dorc123") or die("Error connecting to database"); $query = "CREATE DATABASE chene"; $result = mysql_query($query); …  |
| | i am getting the aboe error in the code given below <html><head> <title>MySQL Server Information</title> </head><body> <h1>MySQL Database Server Information</h1> <?php $DBConnect = mysqli_connect('localhost', 'root', 'mrityunjay'); echo "<p>MySQL client version: " . mysqli_get_client_info() . "</p>"; echo "<p>MySQL connection: " . mysqli_get_host_info($DBConnect) . "</p>"; echo "<p>MySQL protocol version: " . mysqli_get_proto_info($DBConnect) …  |
 | Hello everyone! Im just a newbie here, and i really need help from you guys. We have a project in our school right now... i want learn how to implement a simple "Post Messages and Announcements" using PHP and MySql in my site. Kind of like a miniforum where the … |
| | Hi, I want to create a table in Mysql but i receive an error. [COLOR="Red"]Warning: mysqli_query() expects parameter 1 to be mysqli, null given in C:\wamp\www\CreateTable\create.php on line 11 Table veriler_2 couldn't been created! : [/COLOR] i give you the whole lines to check it for me. I can not …  |
 | Pliz help me for an efficient tagging system such as for images, articles, products etc, so that it could be easy for tag-could and relevancy searching for my web site. (php/mysql) |
| | Hello, I would first like to thank everyone for their help so far, i really appreciate it. Well, i have been learning perl for my job now for about three weeks. Things have gone pretty well so far. I have written a few scripts here and there. However, i have … |
| | i have acode that upload file from client to web server but i need to insert the file name into DB (mysql) to get it in download list............HOW? this is jsp code <%@ page contentType="text/html;charset=windows-1252"%> <% response.setContentType("text/html"); response.setHeader("Cache-control","no-cache"); String err = ""; String lastFileName = ""; String contentType = request.getContentType(); … |
| | Dear all I have a few questions. I would be grateful if you could take the time to answer. I have installed on windows xp home apache2, php 5 and mysqlserver 5. The [URL="http://localhost"]http://localhost[/URL] page of apache works fine. The <?php echo phpinfo(); ?> page works fine. However when i … |
| | I've got a Perl script that lets a client of mine dump and restore his inventory database. It has worked fine for years, only I recently noticed strange file results. Instead of dumping the data to the file, I found this (I've munged the db name): -- MySQL dump 10.10 … |
| | Using PHP on my registration page to register users on my site. Everything seems to be working properly from a PHP perspective. It even tells the user that they've been added. But when I view the table it only has one record which is the one that I created when …  |
| | hi, im trying to view my php page on the browser on iis and i got this error : [COLOR="Red"]call to undefined function mysql_connect().[/COLOR] im not sure why this happened, tried googling but found only solution on apache. any help would be appreciated.thanx |
| | I am a Newbie To PHP!! I used maestro php myqsl to crate the code below.. I am trying to change the query to include a where statment: "where Product_Category = Acoustic treatment" everytime i edit it i get a syntax Error!! please can you help? Thanks in advance [CODE]<?php … |
 | Hey everyone, I'm using php to delete a row from a table in a database in mysql, but it's not working. I'm not even trying to do anything fancy, just delete one row. Here's the code: [PHP]<? include 'config.php'; $recordid = $_POST['recordid']; echo $recordid; mysql_query("DELETE FROM employees WHERE recordid='$recordid'") or … |
| | hi folks, I have installed PHP 5.2X on apache and mySQL 5.0. PHP on apache is working fine. can anyone tell what exactly are the steps to configure PHP to mySQL ? thanks in advance, nikhil |
| | I'd been trying to do date range comparisons all day, and found that using sql was the only way to find out if a date (inside a table) was between a range (assigned by me) I have 4 of the statements below, one for each season. [code] $strSQL = 'SELECT … |
| | |
| | I am trying to add users to my MySQ table "users" and for some reason I can only get one record added into the table. It tells me that the user is added but when I check the table I still only have the initial record in there. Please Help... … |
| | how can i generate a data report using vb 6 and mysql...? |
 | So I'm not happy right now ... just woke up to an IM on my screen that Sun is buying MySQL. Look what Sun did to Java. Good or bad move for the developers out there? Cheers  |
| | I am working on a product reviews site using php and mysql, and have a table set up for product data, as well as review data. I am trying to get a list of top rated products within the last 24 hours to show up on the front page. This … |
| | Hello I am really new at this and are having trouble with MySQL updating .php files in the database program I am using. This used to work until I changed some of the .php file. I only changed the front end of these files and cannot see why what used … |
| | Hi all, I want to add a string and a character to two columns of a sql database table. To do that I use a Command object rather to use the same connection on different functions. At the same time used a stored procedure to add data. Hear are some … |
 | I have a standard SELECT query as follows: [code=MySQL]SELECT eid, title, content, thumb_image FROM diary ORDER BY eid DESC LIMIT 3[/code] ...and a SELECT SUBTRING query as follows: [code=MySQL]SELECT SUBSTRING(content, 1, 200) FROM diary[/code] I'd like to combine the two so that it selects the latest 3 entries in the … |
 | Hello all, i have recently finished work on a clients database. they now wish for one field in the database to have 10% taken off for each record. can this be performed soley through an SQL statement on the MYSQL database. |
| | Hi guys and gals Just curious to know if it's possible to select the 3 latest entries in a table. Would be an added bonus to my project. ;) |
| | Hi there What I'd like to do is store a paragraph in a column and pull roughly the first 200 characters of the paragraph and display them on a page as a snippet. Is this possible? If so could someone give me a link or code snippet on how to … |
| | Greetings, I am triying to diplay morethan one column from mysql database by limiting the display into three rows. I want all the row data to be shown as column data. I want the data in the fourth, fith and sixth row to be diplayed in the next columns, and …  |
| | I have a web based program that I am trying to create, in which I will have a user create a profile, which optionally includes a homepage URL and/or blog URL. Since not every user will have a blog or a homepage to enter, I have moved that information to … |
| | Im trying to figure out a way to access a row I 'just created' via the primary key. As it being a primary key it is auto incremented. I am using php/mysql to create the row then I require to access that same row (via the primary key) to be … |
| | Im trying to figure out a way to access a row I 'just created' via the primary key. As it being a primary key it is auto incremented. I am using php/mysql to create the row then I require to access that same row (via the primary key) to be … |
| | I've created my own forum and would like to display username - from users table title - form topics table and a count of comments - from replies table I 've got the first bit sorted ok SELECT username, title FROM users, topics WHERE users.userid = topics.userid ORDER BY RAND() … |
| | Hello, I have a problem with sorting record in my access 2000. I have created a query (name - BOP Month wise) which has a date field where records are grouped month wise. When i first create the query, it shows correct figure i.e. records are grouped and properly sorted … |
| | Hi all... I've been reading this site for a while and now I have a question for you experts. I have a php page named edit.php. Code here: [code] <? // Connect database. include("connectdb.php"); // ***** This part will process when you Click on "Submit" button ***** // Check, if … |
| | Hi I wanted to know how can I make sure that table exist in my database. [code] class Record: def __init__(self): self.conn = MySQLdb.connect( host = 'localhost', user = 'root', passwd = 'abcd', db = 'justfun') self.cursor = self.conn.cursor() self.cursor.execute("DROP TABLE IF EXISTS book") self.cursor.execute( """CREATE TABLE book (name char(40), … |
| | How would I make it so when I select something from a mysql database, that information isn't stored in the array twice? Here is my code [code]<?php include "header.html"; include "db.php"; if($_GET[by]==genre) { $sort = mysql_query("SELECT genre FROM bands ORDER BY genre"); while($sort2 = mysql_fetch_array($sort)) { $sql=mysql_query("SELECT * FROM bands …  |
| | Ok, ran into some problems in one of the newsgroups so thought here would be an excellent place to turn. Actually have only posted once or twice here and was real surprised at the pleasantness of the answers. So. You have [B]bOrders [/B]and [B]bUser [/B]listed respectivly below. In the simplest … |
| | i have three table 1st viewleave 2nd applyleave 3rd personal based on the leaveid in viewleavetable i wnt to fetch the spid in the second table,based on the spid i want to select spid email address........please tell how to do tat.. CREATE TABLE `viewleave` ( `leaveid` varchar(25) NOT NULL, `message` … |
| | [B]Hello Guys Can anybody here answer my this question. How we can show Latest Categories from this Sql table. Here is the Table [code] -- -- Table structure for table `jos_afm_cats` -- CREATE TABLE `jos_afm_cats` ( `cat_id` int(11) NOT NULL auto_increment, `parent_id` text NOT NULL, `file_id` int(11) NOT NULL default … |
| | Hello, I'm a newbie to this, but I am determined. I wanted to test perl-based functionality on my PC (XPpro) "server." I have installed apache, php, mysql, cgi. All components and connections work [U]except perl to mysql[/U]. It is amazing after reading hundreds of posts on many sites, that apparently … |
| | Can someone point me in the right direction, what I am trying to do is use the result set that I have from a php query to a mysql table. I would like to be able to individually select a record from a query result that returns multiple records. I … |
| | Hey everyone, I'm attempting to delete records within my database but I'm having problems writing the query. What I need to do is delete records from my database that, within a field in this record, have a substring that I will pass to the mysql command. So for example, A … |
| | hi i am new in PHP ,i am doing my job in a company and there are some existing project they tell to me plz check and remove errors ,i m trying more and more to remove this error but i m failure....plz help me. <?php require("header.inc.php"); session_start(); if(($useradmin)=='') { … |
| | Hi, I'm having a having a hard time trying to insert some data into a mysql DB, so I'd like to know if there is some kind of error log that could help me. I've already looked into the binary log but it didn't help me. I also started mysql … |
| | when i run this query ...... update item set description=(select description from item where itemid=5384); i get this error message... Msg 279, Level 16, State 3, Line 1 The text, ntext, and image data types are invalid in this subquery or aggregate expression. there is a lot of text in … |
| | Hi. I'm starting to use clientdatasets after years with Zeos DBO and I'm facing some difficulties. I created a TSQLConnection, a TSqlDataset as a ctTable, a TDatasetProvider and a TClientdataset. I populated the clientdataset and tried an ApplyUpdates(0) to insert the records. But I'm getting a "cannot modify a read-only … |
| | I am unclear how to write a query where I want all the entries in a specific month and date format from a MySQL table. I am not using DATE_FORMAT() with a NOW() correctly. I need to write a query that has a time field in the yyyy-mm-dd format to … |
| | I'm trying to make a script to run via cron to backup my moodle database in mysql. However, I'm unable to get it to accept the password on the command line. (?) I'm trying to run the following command: #!/bin/sh date=`date '+%y-%m-%d'` mysqldump -u root -pmy_pwd -p -C -Q -e … |
| | Hi all, I am new to shell script and really help. I need to connect to MySQL and do some proccessing. How can i do that? Thanks |
| | Hi. I am fairly new to mysql, so help is appreciated. I have two tables and I wish to count some results from two tables and combine them onto one row, and then join an ID to another table. The problem is as follows: Table A: This lists information of … |
The End.