Designing Categories

Greets Folks, I cant tell if this is a dumb question or not, so please bear with me if it is... But here goes... You know how when you visit a website and they have "Categories", like in an online store or maybe an auction sites... or maybe categories would be used in a bulletin board system fo

Re: Some Basic Questions I can't Find Answers to

Hello Linda, You said ---> The MySQL database I want to run will be on my web host. Since I don't have the server physically in my possession, is the working method to install MySQL to my machine, develop the routines there, then upload them to my server? You may not need to do this. Check yo

Re: Cant Explain Error Message

Thanks... syslexia ducks... Wil --- Hello. I am trying to create a table in one of my databases using textbook code, but it is giving me an error message. Here is how it reads: mysql> create TABLE messages -> ( -> id INT UNSIGNED NOT NULL AUTO_INCREMENT PR

Cant Explain Error Message

Hello. I am trying to create a table in one of my databases using textbook code, but it is giving me an error message. Here is how it reads: mysql> create TABLE messages -> ( -> id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, -> forum int not null, -> author char(255) not null,

Sorta OT: Perl/MySQL Mail List Module?

Greetings, This may be a bit OT, but does anyone know of a good perl/cgi module that works with DBI (MySQL) to write a mailing list? PLMK, Thanks, Will _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.ms

newbie stuff: good mysql books?

Greets Folks, I have been wanting to get into data driven sites for the longest time, and I can do some immediate level work in them using perl, but my understanding is still not comprehensive enough for whatever it is I want to do (subconsciously). I sense there is some need to pursue databas

Index Columns: Night of the Living Newbie

Hello, Without giving me the RTFM, and in 25 words or less... Can someone tell me what an index column is and does for a query? Thanks, Will _ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com

NULL ?

hello, Please dont tell me to RTFM on this one (cause I am already doing that), but for clarity's sake... can someone tell me what it means when you use NULL and NOT NULL in a query (specifically CREATE TABLE)? Also, when should I use them? W

Learning Data Types

Hi, I am learning about MySQL and how to use the CREATE TABLE command, and I was wondering where I could learn more about MySQL datatypes (cause they seem to be a big part of this command). Will _ Send and receive Hotmail on you

3 Questions

Greets Folks, These questions may sound kinda basic, but here goes... 1.) What if I want to print (on paper) the contents of my MySQL database, then how do I do it? Everything I have done is for the web so far, so that's why I ask. I was thinking I should just use the reports off the web pa

Design: General DB Question

Greets Folks, Are there any good online tutorials for DB design in MySQL? I'm not necessarily interested just in the programming per se, but in DB design theory in general. Thanks! =) Will _ Get your FREE download of MSN Expl

Connection Problem

Greets Folks, I am trying to get an online database set up and running, but I keep getting error messages at login. Here are two sample scripts I have been running (both are from Paul DuBois' book MySQL and Perl for the Web). ## SCRIPT 1 ## #! /usr/bin/perl -w # intro4.pl - generate

Seeking Freelancer

Greets Folks, I need help with some too-involved-for-me CGI stuff, and I'd like to work with a freelance programmer/consultant. The consulting will be for a mature themed site, and I am running on a limited budget, so open minds only please. The project is for a paid membership site using Per

Scanning Directory/Inserting Image Links to DB

Greets Folks, Can someone recommend a Perl script/technique that will scan a Unix directory of image/text files, and then insert the links into a MySQL database? I used to have a good one, but it got misplaced... Doh! Thanks, Will

Select most recent files

Greets Folks, Quick question here... Is there a command I can use to select the most recent files inserted into a MySQL table? Thanks, =) Will _ Chat with friends online, try MSN Messenger: http://messenger.msn.com ---

SSI's and Databases?

Greets Folks, Does anyone know if it is possible to get an SSI to work in conjunction with a database, like MySQL? I'd like to have a script that will insert a new text file each day along with a timestamp, and I was wondering if it would be possible to use an SSI to draw the info out of that

Uploading to MySQL?

Greets Folks, Suppose I wanted to upload a lot of files (1000 or so) to MySQL... sort of like FTP-ing files to another server's directory... Is there a way to get them all into MySQL like that? Uploading to a database seems much different than uploading to a server... Next, suppose I just F

Data Validation

Greets Folks, Semi-newbie question here. Is there a way to perform data validation (in the SQL language for MySQL) for input I would have coming in off the web (i.e. via HTML/CGI)? I need some tuts, or even just the raw SQL code with some simple install directions. Thanks, =) Will

Seeking Database/Scripts

SQL database. Please let me know if you have any scripts, tutorials or off-the-shelf software you could recommend. Thanks! =) Will K. P.S. Is the Paul DuBois on this list the same Paul DuBois who wrote "MySQL and Perl