Re: Can't fetch result twice in a PHP script

2007-09-15 Thread Néstor
mysql_num_rows() http://www.php.net/manual/en/ref.mysql.php :-) On 9/15/07, Chris W <[EMAIL PROTECTED]> wrote: > Mahmoud Badreddine wrote: > > it is more of a PHP question , I admit. > > I tried mysql_fetch_array, mysql_data_seek, mysql_result . Same result. > > And I am sure there's more than z

Compiling a second mysql binary with a distinct configuration.

2007-09-15 Thread Lloyd Zusman
I'm running mysql-5.0.46 on a linux system on a VPS. As such, the yum package manager is being used to install a standardized mysql installation, and I due to other system dependencies, I can't change this. I need a second mysql installation on that machine that runs under a completely different

Re: Can't fetch result twice in a PHP script

2007-09-15 Thread Chris W
Mahmoud Badreddine wrote: it is more of a PHP question , I admit. I tried mysql_fetch_array, mysql_data_seek, mysql_result . Same result. And I am sure there's more than zero rows to be fetched, because it works in the first call, but not the second. That just means there is one row in the r

Re: Can't fetch result twice in a PHP script

2007-09-15 Thread Kevin Waterson
This one time, at band camp, "Mahmoud Badreddine" <[EMAIL PROTECTED]> wrote: > I have something like > while($someArr=mysql_fetch_row($result)) > { > ...some code. > } > > The first time I call mysql_fetch_row , the code inside the while loop gets > executed, but not the second time. What is the

Re: Can't fetch result twice in a PHP script

2007-09-15 Thread Mahmoud Badreddine
it is more of a PHP question , I admit. I tried mysql_fetch_array, mysql_data_seek, mysql_result . Same result. And I am sure there's more than zero rows to be fetched, because it works in the first call, but not the second. On 9/15/07, Chris Sansom <[EMAIL PROTECTED]> wrote: > > At 16:35 -0500 15

Re: Can't fetch result twice in a PHP script

2007-09-15 Thread Chris Sansom
At 16:35 -0500 15/9/07, Mahmoud Badreddine wrote: In one of my php scripts I make 2 successive calls of mysql_fetch_row using the same Mysql Result. In the first call the desired result is achieved, but in the second one it isn't. I have something like while($someArr=mysql_fetch_row($result)) {

Can't fetch result twice in a PHP script

2007-09-15 Thread Mahmoud Badreddine
I am using mysql 4.1.11 and PHP 5 In one of my php scripts I make 2 successive calls of mysql_fetch_row using the same Mysql Result. In the first call the desired result is achieved, but in the second one it isn't. I have something like while($someArr=mysql_fetch_row($result)) { ...some code. }

Re: modify default value

2007-09-15 Thread Baron Schwartz
Yes, use ALTER TABLE tbl ALTER COLUMN col SET DEFAULT 'foo'; and you won't rebuild the whole table. You know, you can also just manually specify a value for that column in the LOAD DATA INFILE statement. I think you can anyway -- I always have to check the syntax on that one. Baron Bernd J

modify default value

2007-09-15 Thread Bernd Jagla
Hi, I am mass-importing A LOT of csv tables. In order to distinguish between files I change the default value for the table before doing a "load data infile.." from a Perl script: ALTER TABLE `data` MODIFY COLUMN `sample_id` INTEGER UNSIGNED NOT NULL DEFAULT $sample_id[$idx] After importin

Linking tables

2007-09-15 Thread Kevin Waterson
Hi all, having a spot of bother with a 'keywords' table. I have a table of articles with an article_id and a table of categories with a category_id, all is well. These are linked via a article_link table so that an article can be a member of multiple categories. I then have a table of 'keywords' t