Webmaster Forum / PHP / Database Access / November 2006

very new to PHP and mysql
I'm running windows xp sp2 and IIS
trying to install subdreamer
keep getting PHP MySql libraries are not installed on this server

Sorry, this is probably something very obvious.
I created a View in MySQL some time ago, and now need to see the SELECT
statement that defines it. Is it possible to extract and see this query
in any way?

Is it possible to connect with Access on a localhost for local use?

Is there a way to accomplish something like the "WHERE" syntax from SQL
in php?  For example an equivalent to the following, which I know is
not proper php syntax.
foreach ($var as $key => $value WHERE $key != '3') {

I am trying to use GROUP BY cluse, what is the utility of this cluse in
MySQL
plz. any body tell me

Hi evry one
I need some help with my code
What's wrong in this code
<?php

Hi to all !
How to insert one value of the radio button int db. ?
<input type="radio" name="option" value="male">
<input type="radio" name="option" value="female">

Can you tell me if its possible to ORDER BY 'searchtype' where the html
for passes a value such as 'table.column ACS' and the php calls it from
the $_GET['searchtype']
If not is there another way of doing this.

Hi, I'm new to PHP so this might be a simple question to answer but I
just need a little help.
So basically I'm querying the database with this simple search SQL
statement:

For a unique id we don't want to use an auto_increment, but want to
construct a unique id incorporating a sequence (combination of letters
and a number) to make it more meaningful and to distinguish between
different projects and servers (alternative would be to create primary

Can you suggest one?

Im trying to write the following query to do the following but im not
sure about the right way to do it
I want to get back all the results minus any results that are within
the 3 minutes of each other containing the same ip address, and same

Hi, Using MySQL 5.0 and PHP 4.4.4, what is the easiest way (using PHP
code) to check if a database by a particular name exists?
Thanks, - Dave

I have an issue with several LEFT JOIN ... ON like the one postes below.
The query below executes correctly on MySQL 4.1.16-standard but fails on
the same tables on a 5.0.19-standard server.
erro: #1054 - Unknown column 'c.id' in 'on clause'

I am quite new to sql and php and jumping in at the deep end. Your help
is much apreciated.
I have two tables products and dealers.
products contains all the products product id and their spec