php-windows Digest 26 May 2004 23:46:49 -0000 Issue 2263
Topics (messages 23837 through 23850):
Re: MS SQL Query question
23837 by: Svensson, B.A.T. (HKG)
23838 by: Jordi Canals
databse migration... URGENT
23839 by: Sudeep Zamudra
database migration... URGENT
23840 by: Sudeep Zamudra
23841 by: Sudeep Zamudra
23842 by: Xavier Serna
mysql rollback
23843 by: Sudeep Zamudra
23844 by: Svensson, B.A.T. (HKG)
23845 by: Sudeep Zamudra
Output Control
23846 by: William CANDILLON
23847 by: Luis Moreira
23848 by: William CANDILLON
23849 by: William CANDILLON
Hello and first question
23850 by: Chris Patrick Carias Stas
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
http://nl3.php.net/manual/en/function.mssql-data-seek.php
On Tue, 2004-05-25 at 12:52, Dr. Robert Probst wrote:
> IN MY (not MS) SQL I would try
>
> mysql_data_seek ($result, 0);
>
> to move the internal pointer to the first data row
> I dont know at the moment if there is a similar function in the msxxxx area.
>
> maybe it helps
>
> robert
>
>
> > -----UrsprÃngliche Nachricht-----
> > Von: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]
> > Gesendet: Dienstag, 25. Mai 2004 20:30
> > An: [EMAIL PROTECTED]
> > Betreff: [PHP-WIN] MS SQL Query question
> >
> >
> >
> > When I run a query the syntax looks like this:
> >
> > $result = mssql_query($query);
> > $numRows = mssql_num_rows($result);
> >
> > for($i=0; $i<$numRows; $i++)
> > {
> > $row = mssql_fetch_array($result);
> > }
> >
> > but if I go to try and loop through the resultset again it
> > wont work unless I run this line again "$result =
> > mssql_query($query);"
> >
> > I'm sure this is wasting resources but I can't seem to get
> > around it. Any suggestions?
> >
> > Thanks,
> > Ron
> >
> >
> >
> >
> >
> >
--- End Message ---
--- Begin Message ---
Dr. Robert Probst wrote:
IN MY (not MS) SQL I would try
mysql_data_seek ($result, 0);
to move the internal pointer to the first data row
I dont know at the moment if there is a similar function in the msxxxx area.
maybe it helps
For MS-SQL, you mean mssql_data_seek($result, 0) ;)
http://es2.php.net/manual/en/function.mssql-data-seek.php
Regards,
Jordi.
--- End Message ---
--- Begin Message ---
Hi evryone,
I need help...I have mysql database dump files that need to be dumped into a
new database server. There... i dont find any application such as phpmyadmin OR
mysqlAdmin and that makes my job difficult. So please tell me how to migrate my
current database to the new one. Any scripts for that????
Thanks,
SuDeEp
---------------------------------
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger
--- End Message ---
--- Begin Message ---
Hi evryone,
I need help...I have mysql database dump files that need to be dumped into a
new database server. There... i dont find any application such as phpmyadmin OR
mysqlAdmin and that makes my job difficult. So please tell me how to migrate my
current database to the new one. Any scripts for that????
Thanks,
SuDeEp
---------------------------------
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger
--- End Message ---
--- Begin Message ---
Hi evryone,
I need help...I have mysql database dump files that need to be dumped into a
new database server. There... i dont find any application such as phpmyadmin OR
mysqlAdmin and that makes my job difficult. So please tell me how to migrate my
current database to the new one. Any scripts for that????
Thanks,
SuDeEp
---------------------------------
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger
--- End Message ---
--- Begin Message ---
I believe that you can do this with DBManager Professional Freeware Edition,
from DBtools software. (Win appz)
hope this helps,
Xavier
----- Original Message -----
From: "Sudeep Zamudra" <[EMAIL PROTECTED]>
To: "php mailinglist" <[EMAIL PROTECTED]>
Sent: Wednesday, May 26, 2004 12:34
Subject: [PHP-WIN] database migration... URGENT
> Hi evryone,
>
> I need help...I have mysql database dump files that need to be
dumped into a new database server. There... i dont find any application such
as phpmyadmin OR mysqlAdmin and that makes my job difficult. So please tell
me how to migrate my current database to the new one. Any scripts for
that????
>
> Thanks,
>
> SuDeEp
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Friends. Fun. Try the all-new Yahoo! Messenger
--- End Message ---
--- Begin Message ---
Help please,
i lost all of my database tables all of a sudden. It was in for example a database
called "abc". Can i retrieve the entile table and it's comtents by any means. Thru any
Rollback statement. Help please
---------------------------------
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger
--- End Message ---
--- Begin Message ---
How did you lose them?
I don't know about mySQL, but in general DELETE, INSERT
and UPDATE are logged while DROP and TRUNCATE are not.
If you do /not/ use auto commit /and/ did /not/ do commit,
then you can use rollback to undo a delete/insert/update.
Else you need to restore the database from the last backup.
On Wed, 2004-05-26 at 16:34, Sudeep Zamudra wrote:
> Help please,
>
> i lost all of my database tables all of a sudden. It was in for example
> a database called "abc". Can i retrieve the entile table and it's
> comtents by any means. Thru any Rollback statement. Help please
>
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Friends. Fun. Try the all-new Yahoo! Messenger
--- End Message ---
--- Begin Message ---
Could u just give me what should be the statement to rollback a database for eg "abc"
[EMAIL PROTECTED] wrote:what verion of mysql do you have? Early version of MySQL
didn't include the rollback functionality. Do you not have any mysql_dumps of the
databases and/or tables? (Its vital that you back-up you database frequently)
Tryst
---------------------------------
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger
--- End Message ---
--- Begin Message ---
I want to execute my script in a browser as with the shell mode.
Example:
<?
static $i = 0;
while ($i < 10) {
++$i;
echo "$i\n\n";
sleep(1);
}
?>
I've tried this but it's doesn't work :
<?
static $i = 0;
while ($i < 10) {
++$i;
echo "$i\n\n";
flush();
sleep(1);
}
?>
--- End Message ---
--- Begin Message ---
William CANDILLON wrote:
I want to execute my script in a browser as with the shell mode.
Example:
<?
static $i = 0;
while ($i < 10) {
++$i;
echo "$i\n\n";
sleep(1);
}
?>
I've tried this but it's doesn't work :
<?
static $i = 0;
while ($i < 10) {
++$i;
echo "$i\n\n";
flush();
sleep(1);
}
?>
What exactly is your problem ?
I tried this and it simply echoes the numbers 1 to 10 in a single line.
If you want to echo them in separate lines, then you need
echo "$i<br>";
Luis
--- End Message ---
--- Begin Message ---
I just want to see the numbers before 10 seconds
-----Message d'origine-----
De�: Luis Moreira [mailto:[EMAIL PROTECTED]
Envoy�: mercredi 26 mai 2004 17:21
��: William CANDILLON; [EMAIL PROTECTED]
Objet�: Re: [PHP-WIN] Output Control
William CANDILLON wrote:
>I want to execute my script in a browser as with the shell mode.
>
>Example:
>
><?
>
>static $i = 0;
>while ($i < 10) {
>++$i;
>echo "$i\n\n";
>sleep(1);
>}
>
>?>
>
>I've tried this but it's doesn't work :
>
><?
>
>static $i = 0;
>while ($i < 10) {
>++$i;
>echo "$i\n\n";
>flush();
>sleep(1);
>}
>
>?>
>
>
>
What exactly is your problem ?
I tried this and it simply echoes the numbers 1 to 10 in a single line.
If you want to echo them in separate lines, then you need
echo "$i<br>";
Luis
--- End Message ---
--- Begin Message ---
I just want to see the numbers before 10 seconds in my browser like in shell
mod.
-----Message d'origine-----
De�: Luis Moreira [mailto:[EMAIL PROTECTED]
Envoy�: mercredi 26 mai 2004 17:21
��: William CANDILLON; [EMAIL PROTECTED]
Objet�: Re: [PHP-WIN] Output Control
William CANDILLON wrote:
>I want to execute my script in a browser as with the shell mode.
>
>Example:
>
><?
>
>static $i = 0;
>while ($i < 10) {
>++$i;
>echo "$i\n\n";
>sleep(1);
>}
>
>?>
>
>I've tried this but it's doesn't work :
>
><?
>
>static $i = 0;
>while ($i < 10) {
>++$i;
>echo "$i\n\n";
>flush();
>sleep(1);
>}
>
>?>
>
>
>
What exactly is your problem ?
I tried this and it simply echoes the numbers 1 to 10 in a single line.
If you want to echo them in separate lines, then you need
echo "$i<br>";
Luis
--- End Message ---
--- Begin Message ---
I have problems running php scripts under w2k. for example, a form to send a mail. I
has 3 fields, name, email and msg. The actions goes through POST to a file send.php.
In send.php i try to use the variables $name, $email and $msg, but it says they are
not declared. The same script works fine under linux. I tried installing apache with
php instead of IIS but the same thing happens. I installed the cgi and de module
version of php, but the same error occurs. Any sugestions?
Chris
--- End Message ---
