nks again
Tarique
--
=
B2B Application Providers
http://www.sanisoft.com
Vortal for Nagpur http://nagpurcity.net
=
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTE
Nagpur http://nagpurcity.net
=
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set for
yourself"
- Original Message -
From: Christopher Allen <[EMAIL PROTECTED]>
To: Jacky@lilst <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, January 25, 2001 12:39 AM
Su
that aprticular line of
course ).
What is wrong here?
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set for yourself"
that now I have database on mysql server call
"FreeSale" and I need to add user in it, how do I do that properly?
cheers
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set for
yourself"
- Original Message -
From: Maxim Maletsky <[EMAIL
value returned by mysql_insert_id() will be
incorrect. Instead, use the internal MySQL SQL function LAST_INSERT_ID().
cheers
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set for
yourself"
- Original Message
$sql3 = "insert into Thirdtable (SecondTableID,FirsttableID,Thirdfirstname,
Thirdlastname) values('$secondLast','$FirstLast','Steve','Chan')";
$resultsql3 = mysql_query($sql3);
$sqlLastIDthird = "select LAST_INSERT_ID() from Thirdtable&
://www.sanisoft.com
Vortal for Nagpur http://nagpurcity.net
=
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL
,'$FirstLast','Steve','Chan')";
$resultsql3 = mysql_query($sql3);
$sqlLastIDthird = "select LAST_INSERT_ID() from Thirdtable";
$resultlast3 = mysql_query($sqlLastIDthird);
$ThirdLast = mysql_result($resultlast3,0,0);
**
what have I done wrong? Please enlighten me here
Thanks
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set for yourself"
Don't you have to do something like this?
$something = mysql_query("into mytable.");
$result = mysql_query($something);
$rs = mysql_query("select LAST_INSERT_ID() from mytable");
$theLastInsertedID = mysql_result($rs,0,0);
corerct?
Jack
> [EMAIL PROTECT
RT_ID like you said
previously.
By the way, what even drive me crazy more is that with using
mysql_insert_id();, it returns me value 0 (zero) which I suspected it comes
from the fact that data type of that field is BIGINT, correct me if I'm
wrong.
any thought?
Jack
[EMAIL PROTECTED]
"T
y before both values will
be inserted into the third query.
Can we do that? If not, I will have to come back to mysql_insert_id(); but
it won't work with a field with data type BIGINT, will it? So I guess I
would have to change the data type too, right?
please enlighten me about this
Thank
Jack
So can I do either way as I show below here?
first could be :
$sql = "insert into user (name,email) values('Jack','[EMAIL PROTECTED]')";
$result = mysql_query($sql);
$sql1 = "insert into userFriend (userId,friendName,)
values(LAST_INSERT_ID(),'John'
the native MySQL C API function
mysql_insert_id() to a type of long. If your AUTO_INCREMENT column has a column type
of BIGINT, the value returned by mysql_insert_id() will be incorrect. Instead, use the
internal MySQL SQL function LAST_INSERT_ID().
****
J
://www.sanisoft.com
Vortal for Nagpur http://nagpurcity.net
=
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL
ould be the same too, right?
So is there anything I miss here?
error mesage:
Warning: MySQL Connection Failed: Access denied for user:
'[EMAIL PROTECTED]' (Using password: NO) in
/home/sites/site1/web/FreeSale/submitagree.php3 on line 2
**
Hi all,
I got the error below when I tried to establish db coonection.
Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]'
(Using password: YES) in /home/sites/site1/web/FreeSale/submitagree.php3 on line 2
The sniplet is :
$connection = mys
nection.
cheers
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set for
yourself"
- Original Message -----
From: Samantha Savvakis <[EMAIL PROTECTED]>
To: Jacky@lilst <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, January 24,
or die
("Could not connect");
mysql_select_db("FreeSale", $connection);
***
Please enlighten me what I have done wrong because I nearly went crazy now
:-)
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set f
I did use "./mysqladmin reload" and I got this back on the interface ( using
telnet)
**
mysql> ./mysqladmin reload
->
*
and it does not do anything, is that mean the db serevr has already been
reloaded?
cheers
Jack
[EMAIL PROTECTED]
&
x27;y');
and freesale is of course username and I left password field as blank and given all
previliges as yes.
Then add that username into Db table together with the database name using this query :
>insert into db values
>('216.122.146.147','FreeSale','free
The variable $HotelID is the hotelId of the record that I just inserted into
database and I want to retrive the Id of that record to insert into another
table.
what is the correct syntax of using mysql_insert_id in this case?
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than rea
otelContactLastName',
'$HotelRoomProvided', '$HotelEmail')";
$resultHotel = mysql_query($insertHotel);
// retrive latest HotelID
$latestHotelID = mysql_insert_id($HotelID);
**
cheers
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set for yourself"
.
**
I have a table as shown below and when I tried to run the query ( direct at Mysql db,
not from a php page) :
INSERT INTO Hoteldetail VALUES ('test', 'thai', 'thai', '12', '11', '124', '',
'firstna
the html bit below)
I wonder specificly about the check if it is null part if it is corerct. Any thoughts?
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set for yourself"
ww.sanisoft.com
Vortal for Nagpur http://nagpurcity.net
=
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
I am wrting a php page that will write out an email message to the email address
retrieved from Db. If i want to have CC function togethere with mailTo, how could I do
that?
cheers
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set for yourself"
Hi people,
I have one ASP site that need to be converted to be PHP3 ( on Linux OS). Is there any
proper way to do this? The database detail is that the ASP site is using SQL7.0. And
the database server that is avaliable on my Linux server is MySql.
Any thoughts?
Jack
[EMAIL PROTECTED]
"
Wasn't a private mirror. =)
- Original Message -
From: <[EMAIL PROTECTED]>
To: Rasmus Lerdorf <[EMAIL PROTECTED]>; [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, January 19, 2001 3:44 PM
Subject: Re: [PHP] php.net's docs ar
I tried the plain html, and the PHP manual online. The Annotated manual
was working okay.
They're all working now for me. *shrug*
-Szii
- Original Message -
From: Rasmus Lerdorf <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Fatal error: Failed opening required 'shared.inc'
(include_path='.:./include:../include') in
/local/Web/sites/phpweb/manual/html/index.php on line 2
Peace, love, code.
-Szii
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For ad
Sorry, I think it should be like this:
$queryInsert = "insert into user values ('firstname','lastname','email')";
$resultinsert = mysql_query($queryInsert);
$UserIdLatest = mysql_insert_id(userId);
Is that correct?
Jack
[EMAIL PROTECTED]
"There is
So what i should really do is like this:
$anotherQuery = "select mysql_insert_id(UserID) from user";
$resultUserID = mysql_query($anotherQuery);
is that corerct?
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set for
yourself"
- Origina
thanks for Jason:-) Lucky the ID is sequential. That was command I was
looking for.
cheers
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set for
yourself"
- Original Message -
From: Jason Murray <[EMAIL PROTECTED]>
To: 'Jacky@lil
e Id of the record I just
inserted?
$resultID = mysql_query($getID);
$anotherQuery = "insert into userrequest values('userID','userRequestDetail')";
$resutlrequest = mysql_query($anotherQuery);
Will it work if i did that? If not, what should I do to achieve this?
che
Hi people,
Can PHP3 work with flash movie? I mean, something like using Php3 to run flash content
from db? If so, is there anywhere I can find out more information?
cheers
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set for yourself"
AIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Hi people,
How do I do the log out function out of the site?(the site is on secure server) Is
that okay to just use the redirect function?
cheers
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set for yourself"
=
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
w source.
What did I do wrong?
cheers
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set for yourself"
pear on the page, although the source can be seen using view source.
What did I do wrong?
cheers
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set for yourself"
the SMSC the email address is usually
[EMAIL PROTECTED]
> mesaging system..can anybody tell me what are the
> requirements for this...
For developement purposes visit http://www.gnokii.org
Cheers
Tarique
--
=
B2B Application Providers
from a "date" data type field from a table.
Can I use this "-mm-dd" to compare with value from another date variabile in the
"mmdd" format? If not possible, How do I make both of them to be in the same
format?
cheers
Jack
[EMAIL PROTECTED]
"There is
= 20010120 ( which of course we can easily tell that $date1 come
before $date2). Can I use the sniplet below:
if ($date1 < $date2) {
..
}else{
.
}
Or do I need mktime() command to convert $date1 and $date2 like
if (mktime($date1) < mktime9$date2)) {
.
}else{
}
cheers
Jack
ime() for this purpose?
cheers
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set for
yourself"
- Original Message -
From: Jason Murray <[EMAIL PROTECTED]>
To: 'Jacky@lilst' <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
t;));
$thisBirthdate = "$year"."$month"."$day";
if ($thisBirthdate < $myBirthdate) {
do something
} else {
do some other thing
}
Is it the correct way to do that?
cheers
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set f
three value like
below?
$Birthdate = $year&$month&&day;
And I will insert value in $Birthdate into table.
cheers
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set for
yourself"
--
PHP General Mailing List (http://www.php.net/)
To
all?
Tarique
--
=
B2B Application Providers
http://www.sanisoft.com
Vortal for Nagpur http://nagpurcity.net
=
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
T
501 - 548 of 548 matches
Mail list logo