11,093 Topics
 | |
| | 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 … |
| | hi ! i m new to IT.i want to know ,how the data from a mysql database can be sent to excel sheet...............kindly help me..............thanks |
| | Hey everyone, Well, our college wants us students to make one "mini-project", a site with a database plus something in e-commerce. Now, I've chosen the topic as "comics". Can you guys help me create one ? Nothing too complex. Here's what I have on mind. The site will have 3 … |
| | Hello, I am new to Microsoft web development. I need help with plain old ASP. Not ASP.NET I would like to users to my web site to upload .PDF files into the database. I have IIS 5 on Windows 2000 server. Other modules are working flawlessly, but my employer want … |
| | heres the deal, i have created a table called tvprograms on a mySQL database and have added the fields id, program and comments and have populated the database. The first thing i need to do is list just the programs in a php form but not the comments. I then … |
| | Hi, Got a bit of a problem with form, i need to be able to update a number in a mysql database using an html form. so basically i need to increment or decrement a number using a text box and a submit button. heres the code i got: ============================================== … |
| | Hi, Got a bit of a problem with form, i need to be able to update a number in a mysql database using an html form. so basically i need to increment or decrement a number using a text box and a submit button. heres the code i got: ============================================== …  |
| | I've a table named [transaction] [B]idtransaction [/B] is my primary key ---------------- [transaction] ------------------------- idtransaction | customerID | amount | transDate [B]Amount[/B] is the credit or debit / they differ when amount < 0 it is credit and when amount > 0 it's debit Sample Data idtransaction | customerID | … |
| | Im very new to SQL in general, let alone coding it into python. I can interact with a MySQL database just fine for the most part, but im running into some problems here... This is the function in my script that keeps raising errors: [CODE=python] def NewChar(): """ NewChar() - … |
| | I am having fits trying to come up with previous/next buttons for my particular project. I want the user to be able to easily browse through shifts. I have 3 shifts per date and that is how it is stored in the db. Right now I have the users going … |
| | Hi everybody, I am Hugo . I want to know something more about SQL. please can anybody give me some idea about some basic SQl questions? First of all i want to know, 1.What is the SQL Data Manipulation Language(DML)? 2.What is the SQL Data Defenition Language(DDL)? |
| | Is it possible for someone to hack into my database/table? if so should i name my table/database: database 5465464577688960985047834? |
| | Favorite 3rd party software with MySQL Results of a poll conducted on favorite 3rd party software with MySQL: [url]http://mysql-dba-journey.blogspot.com/2007/12/favorite-3rd-party-software-with-mysql.html[/url] |
| | HI I want to submit csv file data into mysql using php. One of the fields contain data : date with format (dd-mm-yyy). I want to store the data in mysql with date format (yyy-mm-dd). pls tell me how 2 do. pls help me Thanks. bye |
| | Hi I would really appreciate some assistance on the following as I suck a bit when it comes to joins i have 3 tables consultants,points,orders all tables have the column id_number I need to run a query that will give me a list of all the consultants with a total … |
 | Hello everybody, I wrote a file using AJAX this is the code I wrote: File.js [CODE]var http = createRequestObject(); function createRequestObject(){ var request_; var browser = navigator.appName; if(browser == "Microsoft Internet Explorer"){ request_ = new ActiveXObject("Microsoft.XMLHTTP"); } else{ request_ = new XMLHttpRequest(); } return request_; } function getInfo(){ http.open('get', 'GtCht.php'); …  |
| | <form action="book_dive.php" method="post"> <input type="submit" value="Submit"> <table border="1" width="75%" cellpadding="2" cellspacing="2"> <tr> <td align="center">BOOK</td> <td align="center">DATE</td> <td align="center">TIME</td> <td align="center">LEAVING FROM</td> <td align="center">BOAT</td> <td align="center">DEPTH</td> <td align="center">DIVE SITE</td> <td align="center">MIN QUAL</td> </tr> <? include("conn.php"); $res=mysql_query("SELECT * FROM dives"); if(mysql_num_rows($res)==0) echo "No data in table"; for($i=0;$i<mysql_num_rows($res);$i++) { $row=mysql_fetch_assoc($res); //mysql_fetch_assoc STORES A … |
| | I made a query that joins 3 tables. Products, parts, and sales invoice tables. The thing is, the common key between the 3 tables is the sales invoice number, but when I try to execute the the query it displays duplicates. One example is when I make a query on … |
| | Hi Everybody! How to upload a image / pdf file in mysql table blob column with ASP pls help me HemantK |
 | Hi everyone I'm looking for advice on building up a database. Any sort of general do's and don't s. The one and only thing that I realize is that putting ALL my info into one table is not a good thing. This is the first database I'll be creating so … |
| | I need a very strong PHP, MySQL programmer for a large Web development job. The freelancer will be required to work at the client site ONLY in the western Chicago suburbs. The project will begin in 2008 with the following high level criteria: 1) The main focus of the project … |
| | Hi all, I'm not sure how to phrase this question... I have a table that requires a foreign key of anything table - this foreign key is automatically generated and the key field in the 'foreign' table. So I have the following situation (kind of): Table Observation [INDENT][B]Time_Stamp[/B] - [I]primary … |
| | |
 | I'm trying to keep all my dates and times to a standard GMT (UTC) time when I store it into the database. When I pull the data however, I want to be able to do the timezone adjustment within the query. I've tried something like this with no luck: [CODE] … |
 | Ok, I thought I had gotten all the answers I needed and marked my thread as solved. But now I am having problems trying to put the code into use. I tried to insert the data from my form into my data base and got an error message. I obviously … |
| | Please take a look at and se what is causing my computer to be slow when starting. Logfile of HijackThis v1.98.2 Scan saved at 8:08:14 AM, on 11/24/2004 Platform: Windows 2000 SP4 (WinNT 5.00.2195) MSIE: Internet Explorer v6.00 SP1 (6.00.2800.1106) Running processes: C:\WINNT\System32\smss.exe C:\WINNT\system32\winlogon.exe C:\WINNT\system32\services.exe C:\WINNT\system32\lsass.exe C:\WINNT\system32\ibmpmsvc.exe C:\WINNT\system32\Ati2evxx.exe C:\WINNT\system32\svchost.exe C:\WINNT\System32\svchost.exe …  |
| | html page <form method="get" action="sort2.php"> <table> <tr> <td>id</td><td><input type="text" name="id"></td> </tr> <tr> <td>From</td><td><input type="text" name="from"></td> <td>To</td><td><input type="text" name="to"></td> <td><input type="submit" name="submit" value="submit"></td></tr> </table> </form> sort2.php <?php $id=$_REQUEST['id']; $to=$_REQUEST['to']; $from=$_REQUEST['from']; $link=mysql_connect($hostname, $username, $password); mysql_select_db($dbid) or die("unable to connect"); $query="(select name,id from member where id=(select day,time from attend where day between '$from' … |
| | hi i have a form where the user will enter the data based on the user input i want to retrieve data ex 1st textbox one get the standard (class of the student) 2nd & 3rd textbox get the range (ex rank 1 to 10) when the user clicks submit...i … |
| | Hi, A third party development company is creating a third party application for us in PHP and uses a MYSQL database. The app is an extension of our website which is developed in .NET and uses a MSSQL 2005 database. There are some cases where the two databases require connectivity … |
The End.