Webmaster Forum / PHP / Database Access / November 2005

The books I've been looking at about PHP and MySql all tell you how to
install them on your own local machine. But how do you install them on your
web site? I would like to build a flash application which uses a MySQL
database. I want users to be able to update the data base by ...

I would like to pull the two most popular items from a database then
pull two random ones, and produce one resultset to work with.
My two queries are ;
SELECT * FROM product INNER JOIN stock ON product.id_product =

I'm trying to work out how to run a query
that checks if there are duplicated records
in a table and then have to run a query to
delete them (need to check if there are

Hello, I'm using PHP 4 and MySQL 4.  Is it possible to write a query
that joins two tables, but if one value cannot be matched, the row
would not be excluded, but a value could be substituted.  For example,
if there were two tables

When I have an Sql statement of the form:
SELECT LOC_ID,REPEAT('--',LEVELX)||NAMEX
  FROM is3.locations
 WHERE entity_id=2

I'm creating a site that wiill be submitting post data but I want to
verify how that the site sending the data is using SSL(https). Is
there any way of validating that in PHP?
TIA

A mate had a site done and has been left to update it himself but appears to
have screwed it up. Ooops http://www.wlhr.org/
Anyone any idea what is going on at the bottom of his pages?
TIA Ian

I'm presently working on a web server. I just installed phpmyadmin and
I would like to secure it. I already put some basics securities rules
but I would like that my phpmyadmin to be only accessible from my LAN
(192.168.0.0) .... and not from my domain name (for example :

I have a question about making a database connection (MySQL). In my php
scripts you have a lot of queries to make. Wat is best to do
- Make every time a new connection whenever you execute a query
- Keep the connection, how do you save the connection. Do you need include

Does anyone know of a way to perform a fulltext search (PHP/MYSQL) on
a string less than 4 characters in length?
e.g. if searching for 'PHP' ?
I thought about a boolean search adding * before/after the search

What kind of var should I use to store some words in a field?
For instance, I would like to save some key words for each user. How can
 I achieve it?
USER    KEY WORDS

Using MySQL 4, how do I write a SELECT statement that returns the
portion of the string after the last comma in the string?  That is, if
I have a field with a value
"a,b,c,d,e"

Could someone please give me the steps for enabling MySQL support in PHP
5.0.5?
Thanks.

I'm trying to work out how to change the following mysql statement which inserts rows from one table into another.  I want to ensure that it does *not* insert rows if an exact match of the row already exists on the table.
I've tried to use WHILE NOT EXISTS, but I can't seem to get ...

Can somebody tell my something about performances when using mysql and php!
Where i can find document about this performance?
How php and mysql behave in use of multiple connections?