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
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
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
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
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
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
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
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);
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:
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
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 //
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
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
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
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
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
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
17 matches
Mail list logo