[PHP-DB] PHP/MySQL to generate colums with results

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

[PHP-DB] Converting values from text to numerical

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

RE: [PHP-DB] Converting values from text to numerical

) 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 have PHP covert

RE: [PHP-DB] Converting values from text to numerical

[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

RE: [PHP-DB] Re: Converting values from text to numerical

the 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 [EMAIL PROTECTED]"

[PHP-DB] Whats more efficient....?

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

[PHP-DB] Traversing an array usng for loops?

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

[PHP-DB] Inserting records across multiple mySQL forms - tracking ID's?

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 there

[PHP-DB] Design suggestions - performance improvement

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

[PHP-DB] making my own week? :)

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 dynamic