Webmaster Forum / PHP / Database Access / June 2006

I've been working on a PHP/SQL page for the past few days, and for some
reason I'm having trouble updating/inserting new records in this
application.
I'm getting the following error message while trying to update or

Hi, I want to drop a foreign key constraint in MySQL 4, but i keep
getting this error:
mysql> ALTER TABLE ORDER_FORM_CARTRIDGES DROP FOREIGN KEY
FK2_ORDER_FORM_CARTRIDGES;

I have a question. I have installed php and mysql on an apache-server on
windows and I can't connect to the server.
I tried to create a database (since I am trying to learn howto). My manual
said I should write this at the shell:

i have a simple table which outputs the results of a select query. how can i
make the headers sortable so that if you click on them, the values are
sorted ASC if its already DESC and vice versa.
appreciate all suggestions

i have a simple php page with a select query on mysql db.
i was wondering how to format currency with the "?" in the front. i tried
changing the international locale to netherlands as suggested on php.net
website; but the sign doesnt appear. any ideas ?

i want to only do a REGEXP against 4 columns in a table
Job_Title | Job_Description | Job_Salary | Job_Location
i tried $sql = "SELECT * FROM Jobs WHERE (Job_Title, Job_Description,
Job_Salary, Job_Location) REGEXP '$search'"

Why does creating the following table give me the error: ERROR 1005
(HY000): Can't create table (errno: 150)
CREATE TABLE orderProducts (
orderID integer(10),

One of field of my database is amount.
How can I update (set mark="X") as many rows as sum of the amount give
me <=20? (in Id order DESC)

keep in mind in am new to PHP.
here is a snippet of some of the checkbox options...
<tr>
<td><input type=checkbox name=skill04/>Ad Design</td>

Hello. I am trying to write a code to filter entries (porn and
medical, etc) in my guest book. The words will come in the $comments
field.
This is the file that handles the data coming from the guestbook.php

I have 2 tables ("records" and "metadata") that I can join together -
no problem. But I want a select that brings out the columns in table
"records" with the data in the second table also as columns. Like
this:

I am new to php but realy loving it . I would like my code to tell the
browser to load a new page at a given URL. In java you could create a
variable of type URL.
It should work something like this.

This problem has been vexing me for some time and I thought I should
consult the group....
Often times when writing a php script to handle some mysql DB
transactions, I must write code that performs, say, an insert into a

Hello, I hope I can get some help on this. I really really really need
to get this working!
Here is an overview of what I am trying to do. I have a database of
movie reviews, and I am trying to sort them alphabetically. (So I can

Sorry if this is the wrong place to ask this question.
I am trying to build a mysql database using phpmyadmin for my wife.
the database is going to hold information on real estate with pictures.
I would like people to come to the web site and beable to do searches via