10,940 Topics
 | |
 | 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 … |
| | 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: ============================================== …  |
The End.