Many thanks for your response , I will work on the design decision first and
maybe store this code for later!
Keith
"Rick Emery" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Other than what sounds like a bad design decision, you can:
>
> $query = "ALTER TA
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 subm
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 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 Ch
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 PRO
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/)
T
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
You have to fetch the row that contains the count in it. Try this:
$resource = mysql_query("SELECT COUNT(*) cnt FROM catalogs WHERE PROCESSED
IS NULL");
$countreq = mysql_fetch_array($resource);
echo $countreq[cnt];
(note as well that if no row is returned by the query then $countreq will be
se
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);
session_registe
Yes another question ... I thank all that have taken to help me learn these
new things.
I want to display 10 records per page and allow the user to move on to the
next page of new records. The code below allows me to move to the second
page of records but not any further. I can't seem to think wh
On Tuesday, January 15, 2002, at 05:33 PM, DL Neil wrote:
> Andy (and Natalie),
>
> In fact the O'Reilly book on PHP is the exception that might well prove
> the rule - normally I think them v.good
> The reference work on MySQL is by Paul DuBois (who often stops by
> here - "hi Paul") and pub
Hello James,
You're passing you 'i' parameter to the URL incorrectly. PHP splits
the paramer list into separate elements by looking for & characters,
examining each element for the equal sign. Note this line, towards
the end of the code:
echo "Next
You're separating the 'nextpg' and '
Thank you (as I slam my head against the desk several times)!
James
"James Chin" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hello James,
>
> You're passing you 'i' parameter to the URL incorrectly. PHP splits
> the paramer list into separate elements by
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: [EMAI
In my code I have the following line:
printf("
\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 the word image in it
I tried from work on an nt ma
Hi,
I have the following code:
while ($row = mysql_fetch_array($result)) {
echo "".$row[0]."\n";
echo "".$row[1]."\n";
$formatted=sprintf("$%s",$row[2]);
echo "" $formatted " ";
}
I get an error in the last line where I want to put $formatted into the last
cell of a table
if I // echo $form
Mike wrote:
>Hi,
>I have the following code:
>
>while ($row = mysql_fetch_array($result)) {
> echo "".$row[0]."\n";
> echo "".$row[1]."\n";
> $formatted=sprintf("$%s",$row[2]);
> echo "" $formatted " ";
>}
>
>I get an error in the last line where I want to put $formatted into the last
>cell of a
Mike wrote:
>Hi,
>
Hi Mike
>I have the following code:
>
>while ($row = mysql_fetch_array($result)) {
> echo "".$row[0]."\n";
> echo "".$row[1]."\n";
> $formatted=sprintf("$%s",$row[2]);
> echo "" $formatted " ";
>}
>
>I get an error in the last line where I want to put $formatted into the last
Addslashes on insert, stripslashes on output.
Miles
At 11:26 AM 1/18/2002 -0600, Faye Keesic wrote:
>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?
>
Hello again.
On 2002.01.18 18:48:36 -0600 chip wrote:
> In my code I have the following line:
>
> printf("
> \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 same name in the .xvpics folder? What
does
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("
> > \n", $row["name"], $row["name"]);
>
> Ok. So the "name" field in your table holds the filename of th
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 can'
> In my code I have the following line:
>
> printf("
> \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 available somewhere to look at?
c
--
Ch
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
>
25 matches
Mail list logo