Webmaster Forum / PHP / Database Access / March 2005

I'm looking to build a message board from scratch... something pretty
advanced... similar to the features of phpbb, but i'm looking to code it
myself for experience sake ( big job i know)  I want to know if anyone knows
of any good books out there that walk you through an object ...

I'm writing a php program and I need to connect Now to ODBC (MS access).
When I have finish I'd like to use Mysql (and no MS access).
which library can I use to connect to mysql and to ODBC by changing less
code as possible?

after I got sql*plus to work on my Linux box and I recompiled PHP 5 to
include the oracle instant client, I run into a weird problem:
I get 'ORA-01017: invalid username/password; logon denied' when using the
same combination of username/password and Oracle instance that works in

Is there a PHP/MySQL solution to keep spammers from posting to guest
books?
Maybe something along the lines of a db of banned words?
I have a small personal site dedicated to medieval clothing, and the

I have a table which stores the size of photos in varchar(100) format.
When I query this using:-
$result=mysql_query("select distinct pid, p.*, i.* from products p, photos
i where p.hidden='N' and p.deleted='N' and p.photo=i.iid order by i.size,

Hello all, i have this matching story. What i want to do, is to check the
variable $betaling if this is 0 or 1. But the id from the tabel form have to
be compared with $persid from the table reactie. thats not the problem, the
problem is i am not able to make 2 queries in one ...

The problem is like this, There are a number of $rows resulting from the
query described below. There is a variable named payment, this has for
example the vualue 2. lets say the query had 5 results, the i want to do a
compare that it shows only 2, depending on the value of ...

hey everyone
i have a problem and i don't know how to do it.
right now i'm making a web site, and it connect to a mysql database, the
database has customer information, such as name address, phone number, and

Vote for or against a new newsgroup proposal.
To summarize what you need to do, just send an empty e-mail to
postgresql-ballot@netagw.com
You will receive a ballot by e-mail.  Follow the instructions and vote.

i need to collect alist of fields from a db. now using mysql_field_name()
i think will do it. but i have hit a problem. According to the php manual
the syntax for this would be mysql_feild_name( resource result, int
field_index ) but i dont know the field_index value?

Hi guys. 2 questions here.
1) How do you check if a SQL table exists?
2) How do you check if a SQL colum or row exists?
thanks in advanced

hey all,
my problem is that the LIMIT selection doesnt work right!?
I have 3 tables
houses

Hey Everyone, hopefully someone can help me out here as I'm looking at quite
a complex query (complex to me, anyway) and I need some help on the theory
behind it
I have a database table (MySQL) full of events, some of which happen every

Connecting to a database I meet the following problem with the code $ db=
mysql_connect ("servername");
As I use the MySql-database on my own computer, I fill in for the hostname,
localhost.

I am looking for a tutorial, or some help with a slight problem that I am
having.
What I need to do is create a bit of code that will allow me to select
multiple categories for a product.  I all ready have it so I can pick form a