Re: [PHP-DB] Alter Table / ADD col_name

2002-01-18 Thread Keith Webb
Many thanks. regards keith Miles Thompson [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Keith, You're building it upside down! If your design relies on adding columns to store data you will quickly run out of columns. More typically when you submit data

Re: [PHP-DB] OCI8

2002-01-18 Thread Thies C. Arntzen
On Thu, Jan 17, 2002 at 01:20:47PM -0700, Randall Barber wrote: I've been using the OCI8 extension and have a question about the Persistent Connections. While debugging the site, I will run into the following error (paraphrased): BeginSession: too many processes running etc... I

[PHP-DB] 1 query or 2 queries

2002-01-18 Thread George Pitcher
I have a page that displays a book and some of its chapters (not all chapters are recorded) and I want to do a layout like this: ISN: 012345678X Book Title: A Christmas Carol Book Author: Dickens, C. Publisher:Victorian Press Year: 1934 Dickens, C

Re: [PHP-DB] 1 query or 2 queries

2002-01-18 Thread Jon Farmer
Yes, Do a join on the two tables and only pull the book data from the first record. -- Jon Farmer Systems Programmer, Entanet www.enta.net Tel 01952 428969 Mob 07763 620378 PGP Key available, send email with subject: Send PGP Key - Original Message - From: George Pitcher [EMAIL

Re: [PHP-DB] 1 query or 2 queries

2002-01-18 Thread Patrick Emond
Yes you can do that (that's what relational databases are all about). To join the two tables and fetch the data you need in a single query you would do something like this: SELECT Book.*, Chapter.* FROM Book, Chapter WHERE Book.BookTitle = Chapter.BookTitle Where BookTitle is whatever common

[PHP-DB] Resource id #2 ?

2002-01-18 Thread James Kupernik
I run this query $countreq = mysql_query(SELECT COUNT(*) FROM catalogs WHERE PROCESSED IS NULL); then try to echo $countreq but end up getting Resource id #2 instead of the count total. What would cause this? Thanks for any advise! James -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] Quotes in db fields

2002-01-18 Thread Faye Keesic
Hi there.. Just wondered why some of my db fields are getting chopped wherever an occurrence of a quote () is. I used the stripslashes() function before saving them. would this be why? Do quotes need slashes in front of them when stored/being written in the db? Maybe I should use stripslashes

[PHP-DB] Recalculation ?

2002-01-18 Thread Dave Carrera
Hi All, I have create a page to calculate qtys and show totals. This works fine, except that I change a qty the change is not registered and calculate from the old value. I am using sessions and have try a loop of if($qty == $qty){ than calc stuff here} else{ session_unset($qty);

RE: [PHP-DB] How can recommend a book for SQL and DB design

2002-01-18 Thread Chris Lott
I always recommend: MySQL by Paul Dubois for the MySQL side and Database Design for Mere Mortals for db design (it's better than the title might sound). Very good in fact. c -- Chris Lott http://www.chrislott.org/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail:

[PHP-DB] strange link problem to a database item

2002-01-18 Thread chip
In my code I have the following line: printf(td align=\center\a href=\%s\ img src=\.xvpics/%s\/a/td\n, $row[name], $row[name]); When I view this web page I get I get, in- konqueror - all thumb images are fine netscape 6 - no thumb images, just a narrow verticle bar opera 6 - a rectangle with

[PHP-DB] php/msql

2002-01-18 Thread Mike
Hi, I have the following code: while ($row = mysql_fetch_array($result)) { echo trtd.$row[0]./td\n; echo td.$row[1]./td\n; $formatted=sprintf($%s,$row[2]); echo td $formatted /td/trbr; } I get an error in the last line where I want to put $formatted into the last cell of a table if I //

Re: [PHP-DB] php/msql

2002-01-18 Thread Fabien ILLIDE
Mike wrote: Hi, I have the following code: while ($row = mysql_fetch_array($result)) { echo trtd.$row[0]./td\n; echo td.$row[1]./td\n; $formatted=sprintf($%s,$row[2]); echo td $formatted /td/trbr; } I get an error in the last line where I want to put $formatted into the last cell of a

Re: [PHP-DB] strange link problem to a database item

2002-01-18 Thread Steven Cayford
Hello again. On 2002.01.18 18:48:36 -0600 chip wrote: In my code I have the following line: printf(td align=\center\a href=\%s\ img src=\.xvpics/%s\/a/td\n, $row[name], $row[name]); Ok. So the name field in your table holds the filename of the image and you have a thumbnail image by the

Re: [PHP-DB] strange link problem to a database item

2002-01-18 Thread chip
On Friday 18 January 2002 08:09 pm, Steven Cayford banged out on the keys: Hello again. On 2002.01.18 18:48:36 -0600 chip wrote: In my code I have the following line: printf(td align=\center\a href=\%s\ img src=\.xvpics/%s\/a/td\n, $row[name], $row[name]); Ok. So the name field in

[PHP-DB] Variable search help still needed - sorry :-(

2002-01-18 Thread Chris Payne
Hi there, I know this is probably a REALLY simple problem, but I can't get this to work. I need to get it to cycle through each word and do a search, I used this as sent from Beau Lebens (Thank you) but I can't get it to work. It works on 1 word querie but if I enter more than 1 it says

RE: [PHP-DB] strange link problem to a database item

2002-01-18 Thread Chris Lott
In my code I have the following line: printf(td align=\center\a href=\%s\ img src=\.xvpics/%s\/a/td\n, $row[name], $row[name]); When I view this web page I get I get, in- konqueror - all thumb images are fine netscape 6 - no thumb images, just a narrow verticle bar Can you make this

Re: [PHP-DB] Variable search help still needed - sorry :-(

2002-01-18 Thread Jason Wong
On Saturday 19 January 2002 13:11, Chris Payne wrote: Hi there, I know this is probably a REALLY simple problem, but I can't get this to work. I need to get it to cycle through each word and do a search, I used this as sent from Beau Lebens (Thank you) but I can't get it to work. It works