Webmaster Forum / PHP / Database Access / August 2004

NB I'm a newcomer to php / mysql
Using phpmyadmin, I'm trying to export data to a .csv file (and
ultimately to a .xls file).
The problem is the data contains what I'm told are unwelcome delimiters,

mysql_query("DELETE FROM cart WHERE ItemId=$ItemId");
There is the code but the result in my databse is that the ID number changes
from, lets say, 77 to 78 with 78's contents being empty.  Therefore when I
look at the results - the deleted ID77 is gone but now I have ID78 with no

I have this PHPBB2 forum running on my server.
I want the user coming in from the internet to get directly into a
specific forum I created.
so the user types "http://for1.xxx.com"

I have a table with quiz questions. Each question has a unique ID, based on
an auto_increment field.
Now I've discovered that with deleting rows from the table the deleted ID's
are not reissued. Makes sense, just thought of that a bit late.

I'm a PHP and MySQL newbie.
I have a feeling a lot of you have seen this before. I'm teaching myself
PHP/MySQL trying to setup a guestbook. I'm running latest versions of
Apache, PHP and MySql on my WIN2k machine. I have them working, except, I

I was wondering if there is a way to get a MySQL database to automatically
perform procedures on a regular basis.
For example, say you developed a stock exchange program and wanted the
orders to be matched regularly after every specific time period, how would

I'm heaving a small problem updating a record containing an encrypted
password. I'm using aes_encrypt.
This is my suggestion for the query (that obviously doesn't work very well):
   $sql_update = "UPDATE $Tabell SET

Got the following statement but I need to order results by the 'Title'
column.
How to do that within the current fragment?
<?

I want to list rows from TABLE_A that have not equivalent value of column
ID in TABLE_B. How do that?
Example:
TABLE_A

I trying to install phpbb, which requires php and mysql, so I
installed them also.  It is on win2k and IIS 5.0 .  It seems that
phpbb can't access the mysql databases.  I am getting a hint from
elswhere that I need to install a module or something, but I don't

Bit of a novice at this so go easy.
Is it possible to have 2 submit buttons in the one form, each submit
button going to a different location. Have tried having an if
statement as follows in my form,

I've given up using phpmyadmin to form a query that pulls from more than one
table - whatever I do seems to result in about 6,000,000 results, even for a
table with only 1000 items! So I got my "Php and Mysql" book and tried to
get my head around hand-building a query, but no ...

I am looking for a simple PHP script to track the location of
file/folders in my office. I'd like to use an SQL database to store
the information. A simple script that includes a search function and
the ability to change field values easily and quickly through a web

Anyone help on this? PHP/MySQL
I have a repeat region displaying records from orders in a CSV format:
CalJoe33,18,08/23/2004,FED EX,PREPAID,WEBSITE,CA,Book,25.95,???
CalJoe33,18,08/23/2004,FED EX,PREPAID,WEBSITE,CA,Poster,10.00,???

I use mysql on local computer, but have installed PC Bus Ethernet Card. When
i RUN   mysqladmin I have IP address different than 127.0.0.1. when I
configure for example PHP phpMyAdmin on user =root,  host the same as in
MYsqladmin I can't connect to Mysql server - acces not allowed ...