Webmaster Forum / PHP / Database Access / October 2006

Can anyone tell me what is invalid about this?  The table items definitely
exists and looks like it matches the spec:
http://dev.mysql.com/doc/refman/4.1/en/create-table.html  It's doing my head
in - I thought I'd finished.

The next filters out everything
I would like it to filter which has the value f2
$t = $_SESSION[f_or_temp_data][f_or_st_id];
if (price.size_key  == "$t"){

I am trying to make a change to a php program,
Could you see the error
$t = $_SESSION[f_or_temp_data][f_or_st_id];
$query = "select vinalux.fabric, size.size_height_max, price.size_key  

I have a page with a link
<a href="Contributor.php?action=&SubCat=<?php echo $row["writer"];
?>"><?php echo $row["writer"];?></a>
that does to a page with a SELECT

I have a website in my mind I would to implement once my db is more
furnished. For now, it's a small db in a form of Excel tables.
Is there a way if I create an access file to export it into my sql with
little work?

Hi My Name is Danny,
I have a problem with the Order By Clause.
My scenario is that I have Varible Data inside a Table ie: A123, B123,
1, 2 , 10, 11,13, 33

I cant seem to get my odbc_result to work with a Paradox database TIME
field. My result always comes back as a date of 1899-12-30.... this is
driving me nuts, thats not a time... thats a date! It also always
returns the exact same date even if the time is different. All the

Not a php or sql wiz but working on a form that is linked to a sql database.
I want to put a statement at the top of the form that says
" there are currently '20' places remaining in this workshop".
Each time a person submits a form I want the page to reduce the number by 1

My apologies for the length of this post but I'm hoping that some
background will help clarify my request. I'm not using MySQL for
anything other then the database for my guestbook. I had a previous
guestbook that became corrupted and my new guestbook uses MySQL. I have

I'm try to do something like:
SELECT description FROM table WHERE {regularexpression to remove all
non-word} = 'WidgetLarge02'
I have a field called description. Description contains a value like

I'm trying to go back and forth between a db and XML pages that filter
db data.
I have a multidimensional array (parsed from XML) like this
(simplified):

I am trying to get to the bin directory of mysql 5 on windows, the name of
the mysql folder whereby I can cd to the bin directory is MySQL Server 5.0
and windows has shortened it to MYSQLS~1 however I cannot get to the
directory regardless of what I type, it keeps saying invalid ...

i was wondering if its possible to do something with permissions in MySQL so
that a user can only see a restricted set of data in all the tables?
For example, if I have 10+ tables with data for several teams - how can i
make it so that a particular team can only see data relating to ...

I am having a few problems with this script, part of a package of scripts
designed to record website visitor data:  I get the following errors:
---
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result

I need Help in keep records while updating the records. My prob is that
i cant able to keep the version of records. i m working on a website
project. For that purpose we hav to keep the version of records. each
time update the record it will update it that for sure but it will also