If you run an optimize or a repair on your datafile
it'll set the autoincrememtn back to next number
Howard
-Original Message-
From: Daniele Baroncelli [mailto:[EMAIL PROTECTED]]
Sent: Friday, 14 June 2002 11:27 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] auto increment
Hi guys,
The au
hello, i think u have to create the series yourself ... before u insert
every record, first calculate the next value :
"SELECT MAX(ID) AS NEXT FROM TABLE"
then u insert ...
hope it helps ...
-Mensagem original-
De: Daniele Baroncelli [mailto:[EMAIL PROTECTED]]
Enviada: sexta-feira, 14
-Mensagem original-
De: José Moreira [mailto:[EMAIL PROTECTED]]
Enviada: sexta-feira, 14 de Junho de 2002 9:53
Para: Daniele Baroncelli
Cc: Php-Db
Assunto: RE: [PHP-DB] auto increment
hello, i think u have to create the series yourself ... before u insert
every record, first calculate
I haven't been following your whole thread on this issue, but I did notice
that the syntax for your include statement is incorrect. Try this:
I've been working with includes recently and that's the standard syntax.
Furthermore, if you put the functions.php file in a different directory,
remembe
Hi,
I working with this query
SELECT * FROM entries LEFT JOIN category ON entries.cat_no REGEXP
\".\"+category.id+\"(.|$)\" LEFT JOIN entgroup ON entries.id = entgroup.eid
LEFT JOIN catgroup ON category.id = catgroup.cid LEFT JOIN mzgroup ON
mzgroup.id = entgroup.gid || catgroup.gid W
sorry, a bug of my e-mailclient quotes some charaters
now without slashes ;-)
#
Hi,
I working with this query
SELECT * FROM entries LEFT JOIN category ON entries.cat_no REGEXP
"\\."+category.id+"(\\.|$)" LEFT JOIN entgroup ON entries.id = entgroup.eid
LEFT JOIN c
Hello!!
ALTER TABLE $table1 AUTO_INCREMENT = 242
Replace the $table with your table's name and replace the end number
with what number you want.
Dan
On Thursday, June 13, 2002, at 08:27 PM, [EMAIL PROTECTED] wrote:
> Hi guys,
>
> The auto_increment field of my MySQL table gives me "258", al
On Friday 14 June 2002 20:23, Hutchins, Richard wrote:
> I haven't been following your whole thread on this issue, but I did notice
> that the syntax for your include statement is incorrect. Try this:
>
>include("functions.php");
> ?>
Doesn't really matter, it works with or without parent
On Friday, June 14, 2002, 2:51:51 PM, Jason Wong wrote:
> On Friday 14 June 2002 20:23, Hutchins, Richard wrote:
>> I've been working with includes recently and that's the standard syntax.
>> Furthermore, if you put the functions.php file in a different directory,
>> remember to use double slash
Ok I've found a solution
ON entries.cat_no REGEXP CONCAT("\\.",category.id,"(\\.|$)")
but nevertheless
thanks too all
Martin
> Hi,
>
> I working with this query
> SELECT * FROM entries LEFT JOIN category ON entries.cat_no REGEXP
> "\\."+category.id+"(\\.|$)" LEFT JOIN entgroup ON entries.id
Hi there,
Sorry for my bad english.
I want to read a table from a mySQL-database and store it in an array built
like this:
$value[column][row];
I am not sure, how this is done.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
You'll have to loop through the result using mysql_fetch_array and put that returned
array in each index of your new array. So it would look like this:
for ($i=0;$row=mysql_fetch_array($RESULT);$i++)
$newArray[$i] = $row;
Then $newArray should look like what you want. :-)
<>< Ryan
Hello,
I am getting some odd errors trying to get an encrypt/decrypt process to
work. Looking at the manual examples and some other literature, I have tried
the two approaches listed below. For each, I get a sometimes-works,
sometimes fails result. The manual entry has a string of user notes
Hi All,
Can anyone post a sample ibase_connect() call? I am interested in what
should appear in the host parameter.
Thanks.
Chris
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I have a database of the menu items used on my web site, there are more
than 100 entries.
How do I set up navigation arrows to point to the next appropriate page,
and the previous
page, from the database? I don't want to use javascript history function,
navigation is too
important to allow it
-Mensagem original-
De: Pedro Oliveira [mailto:[EMAIL PROTECTED]]
Enviada: quinta-feira, 13 de Junho de 2002 17:33
Para: [EMAIL PROTECTED]
Assunto: [Fwd: Funcao recorrente para PHP ... guardar para me dar na
TGP]
-Forwarded Message-
From: José Moreira <[EMAIL PROTECTED]>
To: [E
I'm currently using a PHP application to interact with DB2 and MSSQL (via
FreeTDS). The application name reported to DB2 is httpd, and the application
name reported to MSSQL is PHP 4.0. How can I replace these with my actual
application's name?
Thanks.
Please CC me on replies as I do not keep
Frankly, I've never quite "gotten" the whole quoting thing in PHP.
If magic_quotes_gpc is turned on in the environment:
1. I don't see slashes in any form variables outputted with echo() or
print() Does this mean that these functions effectively remove the slashes?
2. After posting the form va
I have a database layout similar to this-
id order title namepagecat
0 0 title1 blueap
1 2 blue1 page1 ap
2 3 blue2 page2 ap
3 1 blue3 page3 ap
I would like to get title1 (title col
The problem is they are parts of different rows. In a relational database rows only
know about other rows through relationships. You have either:
1. Designed your database incorrectly.
or
2. Are a genius with a unique concept that I do not grasp.
<>< Ryan
-Original Message-
From: [EM
Hello Chip,
Could you please send your program to dig more.And also
send your database schema.
Do you want to
select title,name from your_table_name where title='title1' and
name='blue2';
Is the title and name field are unique.If it so,then the above query will
helps you.
Regard
21 matches
Mail list logo