Webmaster Forum / PHP / Database Access / August 2005

I need to store player numbers in a DB with a range from 0-99, ie. 00,
07, 99, etc.. These will be entered by way of form. Whats the best way
to do this?
I've messed with char(2) and validating but,

I added a field to my company table (PBV_rstCompany.Fields("Installer")) the
default value of the field is Null. I place this If statement and it doesn't
work
   If PBV_rstCompany.Fields("Installer") <> "Y" Then

I recently installed SuSE 9.3 on x86, and it seems to contain scripts
"apache2" and "mysql" in the /etc/init.d folder. However, these two (Apache
or MySQL) are not running when I fresh reboot the machine. I am having to
execute a "./apache2 start" and "./mysql start" every time I ...

This is on a linux FC3 system
To create the first database here is what I did:
Under linux I created a user "mysql"
As a root user I executed from a command line:

I want to select employees and products which they bought. I did it in
two ways:
SELECT Employees.Name, Orders.Product
FROM Employees, Orders

i have 3 drop down lists on my page, all of them have forms contained and
separate buttons to submit. only one will ever be submitted at a time
though. the page receiving the values then does fancy stuff with them, but
this page needs to be able to just look at the one variable ...

http://dev.mysql.com/doc/mysql/en/encryption-functions.html
INSERT INTO t
VALUES ( 1, AES_ENCRYPT( 'text', 'password' ) )
help me :-\

I am trying to run the MySQL DB on a Linux machine that is part of a home
LAN (IP=192.168.0.3), while trying to access it from another WinXP machine
(IP=192.168.0.5). I keep getting the following error:
MySQL Error Number 1130

Hello, I have a table with a single column "WEIGHT" which is an
unsigned integer meant to represent weight in ounces.  Right now, I
have 4 values in this table (4, 8, 16, 32).  When I select values from
this table, I would like to be able to display like this:

I am working on a website to show creative writing which is similar, in
many ways, to a blog.
Some of the pieces of writing a quite long and need to be displayed
over several pages, rather than a single page.

I have 2 questions :
1 - How to launch a sheet S2 from a sheet S1 ?
------------------------------------------------
We have to is the header() function or do there is something else ? Like

As the subject says: How do you debug this stuff? Is there some way to set
breakpoints, view variables, step through code? Or do I have to resort to
something like getch and printf as in 'C' a hundred years ago?
Any help appreciated.

I've just started playing with Flash. I have a MySQL database with text,
images (JPEGs) and audio (mp3) how would I access them to incorporate them
into a Flash movie? (It's a game with images and sound for 10 questions so I
need to get the next question from the database when the ...

I have some data in a data base in Paragraphs format I I setup the column
type as LONGTEXT. How do set up my php to display this in Pargraph right now
It does not seem to it is word warp in  one big line or I put<nowap> but
does not seem to  be backing the lines. I took a look with ...

For those of you who braved looking at this thread, i commend thee.
out of all the PHP and MySQL work I've done, REGEXP is purely chinese
to me.  Thus I seek all of you out there with knowledge about REGEXP
that is far greater than mine.