Hi all,
I have seen queries of this nature before, but they never seem to get a
thorough answer - and that maybe because the issue isnt explained properly..
okay, so here is the scenario.
I have a database which features the following tables:
hst_category
hst_product
hst_categ
I am about to build a database of products that will store features fore ach
product in a separate table.
I need to be able to store both text and numeric values in this table, but
be able to perform mathmatical functions on the numeric variables.
is it possible to have PHP covert numbers that a
alculation) then display the result, otherwise, just display the
text.
-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]]
Sent: Friday, 21 June 2002 2:53 PM
To: Matthew Nock; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Converting values from text to numerical
"is it possible to
[mailto:[EMAIL PROTECTED]]
Sent: Friday, 21 June 2002 3:04 PM
To: Matthew Nock; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Converting values from text to numerical
Matthew:
um how about using the is_int() function to decide if the value from
your DB is a number or not?
http://www.php.net/manual
date as text in the db you want be able to
filter out entries which are between x and y.
Good luck,
Andy
--
http://www.globosapiens.net
Global Travellers Network!
"Matthew Nock" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
Is it more efficient to run a SELECT query on a MySQL database that
retrieves maybe 100 records from approximately 6 tables (based on one
result - such as a product ID) and then process these results using PHP
or is it more efficient to run say 6 SELECT statements that get the exact
details w
I have a query which returns a number of product details.
there may be one or more rows for each product category for example:
prod_ID feature_ID feature_cat_ID feature_value .
1 2 1 10
1 1 2
I want to create a form that will input a number of records, into a number
of different tables.
The first part of the detail will need to create a new "product" record.
this will create Product ID. the Product ID is required to insert the
"features" for this product ID into another table.
Is th
Hi all,
I am currently building a site for a cinema to display session times, film synopsis'
etc...
I have built the database as follows:
TABLE: film_detail
FilmID
FilmName
FilmRunTime
FilmRating
FilmSynopsis
etc...
TABLE session_data
session_ID
session_filmID
session_StartTime
session_Date
Hi All,
I am currently building a website for a cinema - and a cinema week runs from Thursday,
to Wednesday.
I need some help with how to get PHP to work with one week periods, but having the
week starting on a Thursday, instead of Sunday, or Monday.
The "week" will be used to generate dynami
10 matches
Mail list logo