Webmaster Forum / PHP / Database Access / April 2007

Is there an easy way to "lift" data from HTML tables and enter that into
my database? I'm a total novice and so far my searches have yielded
little. I see Navicat has an import option, but that appears to be for
well structured data like Word, Excel or PDF...

When i use the following query:
$sql = "SELECT * FROM table WHERE 1 AND project like '%$zoek%' and publi
NOT like 'no' order by jaar DESC LIMIT 0, 100";
I get what i want: all projects named '%$zoek%' where publi is not like

Sorry for confuzing subject, but that's the thing I'm trying to achieve. For
example:
$a = "Hello";
$b = 1;

I'm a newbie to PHP and I can't get started so this may sound like a mundane
question to you professionals.
I am using Windows XP Pro and have IIS 5.1 to be the server. I installed PHP
5.2.1 straight from PHP.net and it seems to have installed correctly.

I know this can be done, just not sure how
I have 2 tables of orders, table A ("summary") has 1 line of info per order
(a summary the orders)
table B ("full_orders") has the full details of orders, this is a one to

I know this is probablly really, really simple, but I can't figure out
how to retreive the next autoindex in a table, so when I want to
obtain it, I've been inserting a new row, then finding the unique
index from some combination of other values that I know will be

I'm trying to extend a class (written by others) and was wondering if
there's a standard a way of passing a $_GET request to a class. Here's
what I have (see below). If I hardcode $where, something like
$where = " WHERE `firstname` = 'John' "

my web hosting is unix. I have the tables the ss in capital. When I export
from remote server to local server the letters from capital become very
small!
I would have to insert parameter to lower_case_table_names=0 in my.ini.

I have a large data file (9 Meg) that I want to upload to a MySQL table. It
contains the key, model year, maker, model, and engine type for about the
past 50 years. The limitation of my MyPHPAdmin transfer is 2 Meg. So, I;m
looking for a simple PHP script to take 7 fiedls of data ...

At my company we want a new configuration for our webservers. Two
loadbalanced webservers (linux and apache) and one database and (nfs)
fileserver. MySQL is only installed on db server. Apache is only
installed on webservers. (Even the websites (files) are on the dbnfs

I'm looking for a MySQL data extraction > PDF tool. Free would be great,
but cheap would also be acceptable. I'm a webmaster rather than a DB
expert, so please be easy with me - I googled and found lots of stuff,
but it was over my head!

I'm trying to list meteorological data reports, from an ever-varying
number of locations, in two columns, side-by-side - the first half of
the list alphabetically in the left column and then the second half in
the right column.  In the example below, numbering the locations for

I want to allow full text search of a row in a table (MySQL v3.23). I
understand that the WITH QUERY EXPANSION clause adds ability for results to
be returned even where the match is not exact, misspellings, and some
equivalences.

Hey gaiz !!!
just aim trying to make a collaps menu on timer Sowhen we over upon
the main the Subs appear slowlly !!! i think its nice i dea ! :)
The problem is when aim roll over the main the subs apperar  and on

I'm repeating this earlier post in case the gurus around here take the
week-end off from reading cries for help or don't look back more than
24 hours.
=========================================