[PHP-DB] displaying result across 3 cells - where did I go wrong?

2003-08-05 Thread Aaron Wolski
Hi All, I'm trying to display results across 3 cells - for example: #5 Perle Cotton 223 | 225 | 301 304 | 326 | 333 #12 Perle Cotton 211 | 223 | 224 225 | 356 | #4 Braid 95 | 100HL | 102 Right NOW it is displaying like: #5 Perle Cotton 223 | 225 301 | 304| 326 #12

Re: [PHP-DB] displaying result across 3 cells - where did I go wrong?

2003-08-05 Thread CPT John W. Holmes
From: Aaron Wolski [EMAIL PROTECTED] So.. do I need to use 2 different incrementors? $z and say $x for each part? I basically pieced this code together from several examples I found so forgive forgive the fact I don't know a whole lot about the code even though I've tried to understand it as

[PHP-DB] a bandwitch question

2003-08-05 Thread JeRRy
Hi, I have this site that uses PHP and mysql. Now I have a page that has 2 frames in it, a top frame and a bottom frame. Top frame loads a page from the server itself and the bottom frame loads an external website. (off the server) So top frame loads: http://localhost/blah.php And the

[PHP-DB] maximum memory

2003-08-05 Thread Natividad Castro
Hi to all, The maximum memory size allocated to PHP scripts defaults to 8MB. For very big documents, especially with images, this limit may be reached (the file being built into memory). My question is: does anybody know what is the maximum size you can change php.ini? Thanks, Nato -- PHP

RE: [PHP-DB] MySQL Returns Error

2003-08-05 Thread Aaron Wolski
UNIQUE gradient (gradient) This is causing your issue. You have stated that new records cannot match an already established record with the same name under gradient. HTH Aaron -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: August 5, 2003 1:44 PM To: [EMAIL PROTECTED]

[PHP-DB] MySQL Returns Error

2003-08-05 Thread Jeff
Hi... again. :P Been working on this code all weekend, and I did take everyone's advice, but I'm still getting the same error. Error retrieving records. From line $result = mysql_query($query, $link_id) OR DIE(Error retrieving records.); of my code. When I first put the insert query in, it

Re: [PHP-DB] a bandwitch question

2003-08-05 Thread mike karthauser
on 5/8/03 12:20 pm, JeRRy at [EMAIL PROTECTED] wrote: So top frame loads: http://localhost/blah.php And the bottom frame loads: http://www.getpaid2reademails.com/ (example) Now does the localhost generate the bandwitch for that visit from the bottom frame aswell or only the top

RE: [PHP-DB] MySQL Returns Error

2003-08-05 Thread Matt Schroebel
Change the gradient definition to: gradient MEDIUMINT(10) NOT NULL AUTO_INCREMENT, -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 1:44 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL Returns Error Ok, that worked, Now the error

Re: [PHP-DB] MySQL Returns Error

2003-08-05 Thread Jeff
Ok, that worked, Now the error I'm getting is Duplicate entry ' ' for key 1 Is this a SQL table error? Here's my Table as entered: CREATE TABLE gradients ( gradient MEDIUMINT(10) DEFAULT '0' NOT NULL AUTO_INCREMENT, kwo VARCHAR(10) NOT NULL, lsd VARCHAR(10) NOT NULL, date DATE DEFAULT

[PHP-DB] Re: MySQL Returns Error

2003-08-05 Thread William H. Anderson
Jeff, First, let me apologize if I'm reiterating something already said, but I'm new to the newsgroup. What does mysql say the problem was? That is, if you put echo mysql_error(); immediately after the query, what does it say? Is it possible you have one of the fields set to be unique in

Re: [PHP-DB] displaying result across 3 cells - where did I go wrong?

2003-08-05 Thread CPT John W. Holmes
From: Aaron Wolski [EMAIL PROTECTED] while($z++ %3 !==0) [snip] echo (++$z %3 == 0) ? '/tr' : ''; The first time through your code, $z is zero. Since the thread titles don't match, your going to get to your while loop above. $z is

[PHP-DB] How do I make PHP aware of Interbase/Firebird?

2003-08-05 Thread Evan Morris
Hi Please help. I have installed Apache and PHP, and they are working together. I have Firebird installed on a different server. I want to have my PHP pages to talk to the remote database, but when I try to use the Interbase functions, I get: Fatal error: Call to undefined function:

Re: [PHP-DB] Table locks

2003-08-05 Thread John W. Holmes
Tim Best wrote: Anyone know how you set a lock in a MySQL table using PHP? I tried: $select = LOCK TABLES t1 WRITE;; $select .= select * from t1;; $select .= UNLOCK tables;; When I run mysql_db_query(db,$select,$conn); it always returns nothing. Any insights would be appreciated! Run one query

RE: [PHP-DB] dual-processors and php

2003-08-05 Thread Jennifer Goodie
My php scripts that work well on single-processor machines will not work when I put them on a dual-processor server running RedHat 8.0. Is this a matter of settings in php or in the mysql database that provides the data? I can connect to the database through the php.include scripts, but then