On Tue, 22 Jul 2003 17:08:50 -0400, you wrote:
I am trying to count in mySQL the number of entries in the field day where day=2 or
3.
Then I want to check just to see if that returned a value greater than 0 or not.
I am using the code below, but having a problem, I keep getting 0 as the total
Off the top of my head, try using OR in your query rather than AND
day=\2\ or day=\3\
day probably won't equal both 2 and 3, which is why you are getting 0.
Also, if you group by item name, you are going to get the total for each
itemname, is that what you want, or just the overall total?
Hello,
This is a reply to an e-mail that you wrote on Sat, 19 Jul 2003 at
19:16, lines prefixed by '' were originally written by you.
Given a date in MySQL datetime format, how do I extract the
elements?
That is get the month, day, year, hour, ...
Thanks,
Yasir
Bit off topic for this list,
What list do I go to? I just want store the elements into some variables
in PHP.
Yasir
On Sat, 19 Jul 2003, David Nicholson wrote:
Date: Sat, 19 Jul 2003 19:22:25 +0100
From: David Nicholson [EMAIL PROTECTED]
To: Yasir Malik [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] MySQL
Yasir Malik wrote:
Given a date in MySQL datetime format, how do I extract the elements?
That is get the month, day, year, hour, ...
You could do it in the query using DATE_FORMAT(), MONTH(), YEAR(), etc.
You can do it in PHP by sending the MySQL timestamp through strtotime()
and then using
PROTECTED]
Subject: Re: [PHP] MySQL datetime extraction
Yasir Malik wrote:
Given a date in MySQL datetime format, how do I extract the elements?
That is get the month, day, year, hour, ...
You could do it in the query using DATE_FORMAT(), MONTH(), YEAR(), etc.
You can do it in PHP
Change $email_error to $mysqlerror and hopefully some error message will
appear.
Beauford.2005 wrote:
if ($mysqlerror) {
$error = $d_base_error$email_error;
include(trades-input.php);
exit;
}
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
[mailto:[EMAIL PROTECTED]
Sent: July 16, 2003 1:18 PM
To: Beauford.2005
Cc: PHP
Subject: Re: [PHP] MySQL query problems
Change $email_error to $mysqlerror and hopefully some error message will
appear.
Beauford.2005 wrote:
if ($mysqlerror) {
$error
bruce wrote:
I have a question. I need to be able to try to perform a database update,
but if it doesn't succeed, I need to be able to rollback the changes, and to
inform the user that the changes didn't succeed.
I've looked at the MySql site, and can see somewhat how the Commit/RollBack
functions
I use the PEAR db http://pear.php.net/manual/en/package.database.php
This returns arrays - examples here
http://pear.php.net/manual/en/package.database.db.intro-fetch.php
look at the Quick data retreaval down the page
pete
Larry Brown wrote:
Is there any php function to pull a query into an
It shouldn't take a lot of code to put results into an array:
$query = select * from table;
$r = mysql_result($query);
while ($row = mysql_fetch_object($r))
$hold[] = $row;
(OR, to index by some id field in the database:)
$hold[$row-id] = $row;
mysql_free_result($r);
Total of 5 lines.
--
Brenton,
The short answer: loops, counters and test
Across - td your content /td td and so forth /td
When to stop - a cell counter tested with mod operator
Alternating colour - a row counter tested with mod operator
That should get you pointed in the right direction. (If this is for a
school
On Thu, 10 Jul 2003, Brenton Dobell wrote:
I know im probibly getting irritating to most of you :P but i thought i may
ask another thing that is on my mind!
I have a sql query bringing back 200 rows for arguments sake, From this i
would like an answer to 2 issues i have.
1) I know how to
[EMAIL PROTECTED] wrote:
helo all ,
what command in linux , to see default direcktory instalation mysql
database dan mysql library
RPMs?
$ rpm -ql package-name
- E -
__
Do You Yahoo!?
Yahoo! BB is Broadband by Yahoo!
locate mysql.lib?
Can you be a bit more specific?
Marco
On Wed, 2003-07-02 at 03:05, [EMAIL PROTECTED] wrote:
helo all ,
what command in linux , to see default direcktory instalation mysql
database dan mysql library
##
With best regards !
[snip]
$sql1 = SELECT * from `admin` where `admin`.user =
'$_POST['validuser']' AND `admin`.pwd = '$_POST['password']';
$sql1 = SELECT * from `admin` where user = $_POST['validuser'] AND
pwd = $_POST['pass'];
[/snip]
subtle differences
$sql1 = SELECT * from `admin` where `admin`.user =
-Original Message-
From: Pushpinder Singh Garcha [mailto:[EMAIL PROTECTED]
Sent: 30 June 2003 19:10
Can someone tell me what is wrong with the following querys ? I am
pretty sure its got something to do with the quotes around $_POST[]
variables.
$sql1 = SELECT * from `admin`
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi
Am Montag, 30. Juni 2003 20:10 schrieb Pushpinder Singh Garcha:
Hello ,
Can someone tell me what is wrong with the following querys ? I am
pretty sure its got something to do with the quotes around $_POST[]
variables.
$sql1 = SELECT * from
Thanks to all you great ppl out there !!!
have a great weekend ;-) for those in north america
FYI : mine has just started !
cheers
--Pushpinder
On Monday, June 30, 2003, at 02:36 PM, Thorsten Körner wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi
Am Montag, 30. Juni 2003 20:10
Yes you seem to have it figured out, just do the lock in
a normal mysql_query, following the MySQL manual for syntax,
and you can release a lock whenever you want, but the
rule is the sooner the better, since if more then one page
or query tries to do a write, while you have it locked it
has to
use explode()
-Original Message-
From: Andrew McCombe [mailto:[EMAIL PROTECTED]
Sent: Friday, June 27, 2003 11:06 AM
To: [EMAIL PROTECTED]
Subject: [PHP] mysql split?
Hi
I have a field in mysql that has paths to files such as:
project/entertainment/andrew/job/1.jpg
Does mysql have an explode function? I suppose this is the wrong place to
ask...
Andrew
- Original Message -
From: Jay Blanchard [EMAIL PROTECTED]
To: Andrew McCombe [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, June 27, 2003 5:08 PM
Subject: RE: [PHP] mysql split?
use explode
-
From: Andrew McCombe [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 27, 2003 9:16 AM
Subject: Re: [PHP] mysql split?
Does mysql have an explode function? I suppose this is the wrong place to
ask...
Andrew
- Original Message -
From: Jay Blanchard [EMAIL PROTECTED
There is a mysql function called substring_index() that returns a substring based on
an index character like space ' '. You have to specify the string, the index
character, and how many time it has to find it from the left or right (left being
positive and right being negative, I think) before
Hi All,
I found out how to do it already. Thanks for the help.
mysql_error() was the key..
Cheers,
Mun Heng, Ow
H/M Engineering
Western Digital M'sia
DID : 03-7870 5168
-Original Message-
From: Ow Mun Heng
Sent: Wednesday, June 25, 2003 10:03 AM
To: [EMAIL PROTECTED]
http://www.hotscripts.com/PHP/Scripts_and_Programs/index.html
hmmm can you check to see if your field is exactly named desc in the
table... also whether or not it can accept string ie char or varchar.
- Original Message -
From: Steven Efurd [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 2:03 PM
Subject: [PHP] mysql update not
To: [EMAIL PROTECTED]
Subject: [PHP] Re: PHP Mysql Hit Counter
http://www.hotscripts.com/PHP/Scripts_and_Programs/index.html
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
A search on mysql.com reveals.
http://www.mysql.com/search/index.php?q=DELETEfrom=%2Fdocumentation%2Findex
.html
--
Aaron Gould
Web Developer
Parts Canada
-Original Message-
From: zavaboy [mailto:[EMAIL PROTECTED]
Sent: June 18, 2003 1:03 PM
To: [EMAIL PROTECTED]
Subject: [PHP]
http://www.mysql.com/doc/en/ALTER_TABLE.html
I know this is more of a mySQL question but, how do I delete and add rows
and columns?
--
- Zavaboy
[EMAIL PROTECTED]
www.zavaboy.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
On Wed, 2003-06-18 at 10:03, zavaboy wrote:
I know this is more of a mySQL question but, how do I delete and add rows
and columns?
--
- Zavaboy
[EMAIL PROTECTED]
www.zavaboy.com
Using the mysql_*() function and the SQL language. The mysql_*()
functions are documented here:
how about :
Start Using MySQL
http://articles.weberdev.com/ViewArticle.php3?ArticleID=247
Beginners guide to PHP/MySQL - Creating a simple guest book
http://articles.weberdev.com/ViewArticle.php3?ArticleID=26
Sincerely
berber
Visit http://www.weberdev.com/ Today!!!
To see where PHP might take
On Wed, 18 Jun 2003, zavaboy wrote:
I know this is more of a mySQL question but, how do I delete and add rows
and columns?
Before you touch MySQL or attempt to access it through
PHP, you really should learn basic SQL:
http://www.sqlcourse.com/
http://www.w3schools.com/sql/
Hello,
Thanks it works now
Regards
Moses
Hello, This seems not to be working, I am using win2000 and a newbie. please
simplify this process.
ERROR 1045: Access denied for user: '@127.0.0.1' (Using password: NO)
mysql GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED]
- IDENTIFIED BY
On Tue, 2003-06-17 at 17:13, [EMAIL PROTECTED] wrote:
Hello,
Would be grateful if someone couldkindly point me in the right direction.
Check the MySQL documentation. You also might want to ask on the MySQL
mailing list.
http://www.mysql.com/doc/en/Default_privileges.html
denied for user: '@127.0.0.1' (Using password: NO)
mysql
Regards
from:Lars Torben Wilson [EMAIL PROTECTED]
date:Wed, 18 Jun 2003 01:17:15
to: [EMAIL PROTECTED]
cc: [EMAIL PROTECTED]
subject: Re: [PHP] MySQL Connection
On Tue, 2003-06-17 at 17:13, [EMAIL PROTECTED
PROTECTED]
subject: Re: [PHP] MySQL Connection
On Tue, 2003-06-17 at 17:13, [EMAIL PROTECTED] wrote:
Hello,
Would be grateful if someone couldkindly point me in the right
direction.
Check the MySQL documentation. You also might want to ask on the MySQL
mailing list.
http
On Tue, 2003-06-17 at 18:19, [EMAIL PROTECTED] wrote:
Hello, This seems not to be working, I am using win2000 and a newbie. please
simplify this process.
ERROR 1045: Access denied for user: '@127.0.0.1' (Using password: NO)
mysql GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED]
-
On Tue, 2003-06-10 at 17:18, Harry.de wrote:
Hi,
if i insert into a mysql table a row e.g.
mysql_query(INSERT into TEST (testfield) VALUES ('This is a test'));
and the first field is an auto increment (e.g. NR),
how can i get the value of the auto increment NR i've actually inserted?
This is what I use http://members.lycos.co.uk/wipe_out/automysqlbackup/
-Original Message-
From: John Kaspar [mailto:[EMAIL PROTECTED]
Sent: Friday, April 25, 2003 3:48 PM
To: [EMAIL PROTECTED]
Subject: [PHP] mysql backup solution
I've got a large mysql database (~400 megs) on a host
Felipe,
I'm replying in spanish so you can understand better.
El problema que tienes es que la variable $nueva_base esta vacia. Si
deseas especificar el nombre con esa variable debes asignarle algun
valor antes de llamarla, si lo que quieres es crear una base de datos
que se llame nueva_base,
Monfort--
There lies my problem.
How do I get mysql to translate:
... where table.username =
'table2.domain/table2.username' into
See:
http://lists.mysql.com/mysql?sub=1
--Frappy
On Friday 30 May 2003 08:35 pm, [-^-!-%- wrote:
Hello all !
Need a little help here. Is there a way
If anyone can help I seem to be stuck on a problem getting a mysql
field
inserted correctly. For instance the first page would have a field
such
as...
input type=text name=field size=12
info that is placed into the field is St. Petersburg, FL (without
the
quotes)
the php code for the
. Brown
Dimension Networks, Inc.
(727) 723-8388
-Original Message-
From: John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 29, 2003 9:44 PM
To: 'Larry Brown'; 'PHP List'
Subject: RE: [PHP] mysql field getting cut off
If anyone can help I seem to be stuck on a problem getting
use mysql_insert_id(), it keeps its value per connection so you don't
need to worry about anything
[EMAIL PROTECTED] wrote:
Ok, here's what I have. I want to insert some values into a table with
an auto_increment field, but I want to get the Serial of the record I
just inserted so I can name
Wonderful! Thanks!
-Original Message-
From: Marek Kilimajer [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 8:18 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] MySQL Insert with Auto-Increment
use mysql_insert_id(), it keeps its value per connection so you
]
Newsgroups: php.general
To: [EMAIL PROTECTED]
Sent: Saturday, March 29, 2003 2:20 AM
Subject: Re: [PHP] mysql ending at start up
Please use the appropriate list. If you want a fast
response take out a mysql support contract.
Thanks Jason. You're such a supportive individual
-lol.
J
= does not take the wildcard (%).
-Original Message-
From: Harry.de [mailto:[EMAIL PROTECTED]
Sent: Friday, March 28, 2003 2:38 PM
To: [EMAIL PROTECTED]
Subject: [PHP] mySQL query - command LIKE OR =
Hi,
i want to make a mySQL query where the result should be
in $result1
any sting
On 29-Mar-2003 Joseph Bannon wrote:
The mysql support list is slow, so I though I would
post here since I know this list is more active.
MySQL shuts down when I start it up...
# Starting mysqld daemon with databases
from /home/mysqldb
030328 09:29:32 mysqld ended
Joe you got a reply
Joe you got a reply within 20 minutes on the MySQL
list asking you this:
Yeah, I did, but I'm use to the fast response of thsi
list.
What does your hostname.err log have to say about
it?
I don't have one.
Let's find your database error log, as root type:
find / -name *.err -print |
On Saturday 29 March 2003 14:14, Joseph Bannon wrote:
Joe you got a reply within 20 minutes on the MySQL
list asking you this:
Yeah, I did, but I'm use to the fast response of thsi
list.
Please use the appropriate list. If you want a fast response take out a mysql
support contract.
--
Please use the appropriate list. If you want a fast
response take out a mysql support contract.
Thanks Jason. You're such a supportive individual
-lol.
J.
__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your
I am by no means an expert (even remotely) but I do recall instructions
on exactly how to do this in the documentation for MySQL - I think
under the how to upgrade section.
- Charles
On Monday, March 3, 2003, at 06:53 PM, Stephen Craton wrote:
Hello,
Yesturday I made a big mistake. I had to
I don't know about the tool, but maximum file upload is set in php.ini -
upload_max_filesize, post_max_size must be higher. Restart apache afterwards
Marc Bakker wrote:
Hello,
I want have a Apache/PHP/MySQL configuration running on Win2000 (SP3). In my
website I have a file-upload page where
WinMySQLAdmin has been discontinued, it is replaces by MyCC, also available
from the mysql web site.
Mike Hillyer
-Original Message-
From: Marc Bakker [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 19, 2003 4:13 AM
To: [EMAIL PROTECTED]
Subject: [PHP] MySQL qusetion
Hello,
I want
Shaun,
It should be: date(Y-m-d). MySQL stores the dates as -mm-dd, and that function
returns the current date on the format you need.
Check the date() function on the php manual.
--
Un gran saludo/Big regards...
Arturo Barajas, IT/Systems PPG MX (SJDR)
(427) 271-9918, x448
I have a date stored in a table in my MySQL Database using a DATE type
for
the column.
How can i compare the date in the table to today
... WHERE your_date = CURDATE() ...
e.g.
$today = mysql_result($result, $i, Booking_Date);
if($today = *HELP*){
or...
if($today == date('Y-m-d'))
$string = ' . implode(',',$group) . ';
$query = SELECT * FROM table WHERE groupname IN ($string);
---John Holmes...
- Original Message -
From: Van Andel, Robbert [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 18, 2003 3:51 PM
Subject: [PHP] Mysql Query Question
I am
Thanks, I knew it was something simple but I couldn't find it on the 'Net.
Robbert van Andel
-Original Message-
From: CPT John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 18, 2003 1:14 PM
To: Van Andel, Robbert; [EMAIL PROTECTED]
Subject: Re: [PHP] Mysql Query Question
great tutorial to do what you want:
http://www.freewebmasterhelp.com/tutorials/phpmysql/4
regards,
David.
On Tue, 11 Mar 2003, Joseph Bannon wrote:
How can I have php give me all the data in a table as
I would using the prompt in mysql?
Joseph
Should not it be:
$SQL = SELECT * FROM table ORDER BY id asc LIMIT .($autoindex -5). ,5;;
John Taylor-Johnston wrote:
I don't know whether this is a MySQL or PHP quesiton.
$SQL = SELECT * FROM table ORDER BY id asc LIMIT $autoindex -5 ,5;;
I would like to get the autoindex value of my table and
On Monday 10 March 2003 22:30, {R}ichard Ashton wrote:
Is there a generally recommended way of storing an array created by PHP
in a MySQL database field ?
serialize() and unserialize().
What type of field should it be, and how do you get the whole array
back in one go without reconstructing
Serializing it would be the best way: seralize($myArray)
then you can get the array back using unseralize($serializedarray)
-Original Message-
From: {R}ichard Ashton [mailto:[EMAIL PROTECTED]
Sent: 10 March 2003 14:31
To: [EMAIL PROTECTED]
Subject: [PHP] MySQL and PHP arrays
Is there
On Mon, 10 Mar 2003 22:34:44 +0800, Jason Wong wrote:
On Monday 10 March 2003 22:30, {R}ichard Ashton wrote:
Is there a generally recommended way of storing an array created by PHP
in a MySQL database field ?
serialize() and unserialize().
What type of field should it be, and how do you get
You get at the data through $array = mysql_result($result,0,0);
Mike
{R}Ichard Ashton [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Mon, 10 Mar 2003 22:34:44 +0800, Jason Wong wrote:
On Monday 10 March 2003 22:30, {R}ichard Ashton wrote:
Is there a generally recommended way
:[EMAIL PROTECTED]
Sent: Monday, March 10, 2003 8:45 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] MySQL and PHP arrays
You get at the data through $array = mysql_result($result,0,0);
Mike
{R}Ichard Ashton [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Mon, 10 Mar 2003 22:34:44
Hi all,
I have this query:
SELECT a.area_name, b.area_name FROM tbl_1 x, tbl_2 a, tbl_2 b
WHERE x.area_1 = a.id
AND x.area_2 = b.id
I am using PEAR DB to get my results as an ASSOC ARRAY. How do I echo
the values for a.id and b.id?
Thnks
Charles
I presume you mean area_name...
Try
Thanks for the help. Almost there. Here is what I have:
SELECT x.id, x.headline, x.description, a.area area_a, b.area area_b
FROM tbl_funding x, tbl_dra a, tbl_dra b
GROUP BY x.id LIMIT 0 , 30
The problem is that $array[area_a] and $array[area_b] display the same
info.
On Friday, March 7,
Then the information in the DB is the same.
Jim
- Original Message -
From: Charles Kline [EMAIL PROTECTED]
To: Rich Gray [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, March 07, 2003 10:03 AM
Subject: Re: [PHP] MySQL Alias and PHP
Thanks for the help. Almost there. Here is what
- Original Message -
From: Charles Kline [EMAIL PROTECTED]
To: Rich Gray [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, March 07, 2003 10:03 AM
Subject: Re: [PHP] MySQL Alias and PHP
Thanks for the help. Almost there. Here is what I have:
SELECT x.id, x.headline, x.description, a.area area_a
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] MySQL Alias and PHP
Thanks for all the suggestions, I have tried all and more and still
can't get this quite right. If there is a better forum for these
question, please point me to it and I will take this somewhat
off topic
thread elsewhere
saludo/Big regards...
Arturo Barajas, IT/Systems PPG MX (SJDR)
(427) 271-9918, x448
-Original Message-
From: Charles Kline [mailto:[EMAIL PROTECTED]
Sent: Viernes, 07 de Marzo de 2003 04:09 p.m.
To: Jim Lucas
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] MySQL Alias and PHP
Thanks for all
-
From: Charles Kline [mailto:[EMAIL PROTECTED]
Sent: Viernes, 07 de Marzo de 2003 05:48 p.m.
To: Barajas, Arturo
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] MySQL Alias and PHP
Wow. That is ALMOST it. The only thing is it does not return
the record
with a 0 in tbl_1.area_2 - can you
How can I get this to use the next auto_increment of
id (Next Autoindex = 52)?
What if you just remove id from your field list?
insert into ccl.ccl_maintest (id,RNum,YR,AU,ST
^^^
Here :)
(Just an idea...)
J
--
PHP General Mailing
(Just an idea...)
An idea that worked ... BUT :)
I had to leave out id in the insert and the select
INSERT INTO ccl.ccl_maintest
( RNum, YR, AU, ST, SD, SC, BT, BD, BC, AT, AD, AC, SR, PL, PR, JR, VNum, INum, DT,
PG, LG, SF, OL, KW, AUS, GEO, AN, RB, CO, RR )
SELECT
id, RNum, YR, AU, ST, SD,
Is there a way of updating a table so that I can add some sort of
identifier
to each field, something as simple as x=1 will do. I want to be able
to
modify the table so I can set a variable for each column so I can tell
whether I can let a user modify that field. If I modify the fieldname
On 03-Mar-2003 Dan Sabo wrote:
Thanks Larry,
What are some of the more active MySQL lists? Do you have a URL or two?
Thanks,
Dan
post to [EMAIL PROTECTED]
or browse http://www.mysql.com/documentation/lists.html
Regards,
--
Don Read [EMAIL
This is OT, I'm considering buying the MySQL, Second Edition Paul
DuBois
book. I'm using MySQL 3.23. Should I be buying the first edition
DuBois
book instead or does BuBois cover both 3 and 4 in the second edition?
Is
there a huge difference between 3 and 4?
Here's a URL for the second
Thanks Larry,
What are some of the more active MySQL lists? Do you have a URL or two?
Thanks,
Dan
-Original Message-
From: Larry E. Ullman [mailto:[EMAIL PROTECTED]
Sent: Monday, March 03, 2003 9:52 AM
To: Dan Sabo
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] MySQL
This is OT, I'm
What are some of the more active MySQL lists? Do you have a URL or
two?
http://www.mysql.com/documentation/lists.html
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Found this for anyone interested.
http://www.mysql.com/doc/en/INSERT_SELECT.html
John Taylor-Johnston wrote:
I was wondering about this, but decided to ask first first:
INSERT INTO ccl.ccl_main VALUES (select * from greid.ccl where id=28);
delete * from greid.ccl where id=28;
Both tables
]
Subject: RE: [PHP] mysql replication + mysql_pconnect
hi there i am setting up a test replication slave server as a mysql db
master backup if it fails , i would like to know how to
dynamically connect
to the slave if the master fails , something really strange i have set the
host like localhost
, March 02, 2003 12:34 PM
To: electroteque; [EMAIL PROTECTED]
Subject: RE: [PHP] mysql replication + mysql_pconnect
hi there i am setting up a test replication slave server as a mysql db
master backup if it fails , i would like to know how to
dynamically connect
to the slave if the master fails
hi there i am setting up a test replication slave server as a mysql db
master backup if it fails , i would like to know how to
dynamically connect
to the slave if the master fails , something really strange i have set the
host like localhost:3307 for the slave but is still connecting to
the
Shouldn't that be:
while($data=mysql_fetch_array($result))
{
//SSLT
}
NOTE: Added ) and changes $query to $result
-Original Message-
From: Van Andel, Robbert [mailto:[EMAIL PROTECTED]
Sent: Friday, February 28, 2003 3:21 PM
To: [EMAIL PROTECTED]
Subject: [PHP] MySQL Query Result
To: Van Andel, Robbert; [EMAIL PROTECTED]
Subject: RE: [PHP] MySQL Query Result Question
Shouldn't that be:
while($data=mysql_fetch_array($result))
{
//SSLT
}
NOTE: Added ) and changes $query to $result
-Original Message-
From: Van Andel, Robbert [mailto:[EMAIL PROTECTED]
Sent
At 00:20 01.03.2003, Van Andel, Robbert said:
[snip]
I have the following query:
$query = SELECT d.utilization, d.capacity_date, d.day, i.id, i.interface,
cd.date, cd.id ;
$query .= FROM (capacity_data as d LEFT JOIN interfaces as i ON
d.interface =
and verified that I got nothing back. I don't
know at this point. I'm at a loss.
Robbert van Andel
-Original Message-
From: Ernest E Vogelsinger [mailto:[EMAIL PROTECTED]
Sent: Friday, February 28, 2003 3:51 PM
To: Van Andel, Robbert
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] MySQL Query
Vogelsinger
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP] MySQL Query Result Question
I had the same thought and it didn't work. I have verified that $cmts[$i] is a
different value then the previous iteration, but the second time through the same data
as the first time through is processed. I've even run
I was wondering about this, but decided to ask first first:
INSERT INTO ccl.ccl_main VALUES (select * from greid.ccl where id=28);
delete * from greid.ccl where id=28;
Both tables would have to have the same structure ?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
how is that ??
- Original Message -
From: John W. Holmes [EMAIL PROTECTED]
To: 'Luis A' [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Tuesday, February 25, 2003 8:07 PM
Subject: RE: [PHP] mysql trouble
take a look at this
?php
// process form
$link = mysql_connect(localhost
:21 PM
Subject: RE: [PHP] mysql trouble
### ?php
### // process form
### $link = mysql_connect(localhost, root);
you need to have the password as the third argument
$link = mysql_connect(localhost, root, password);
Also, why is it in a variable?
Just make it:
mysql_connect
Re: [PHP] mysql trouble
you mean i do not need to put the pus on the end of the function
(+) i dont need to put there that?
- Original Message -
From: John W. Holmes [EMAIL PROTECTED]
To: 'Richard Whitney' [EMAIL PROTECTED]; 'Luis A'
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent
i know
the sql server in default does not have password
- Original Message -
From: paulm [EMAIL PROTECTED]
To: Luis A [EMAIL PROTECTED]
Sent: Tuesday, February 25, 2003 8:06 PM
Subject: Re: [PHP] to paulm Re: [PHP] mysql trouble
k but you still need to do insted of password, and see
]
Sent: Tuesday, February 25, 2003 8:25 PM
Subject: RE: [PHP] mysql trouble
Create a user with appropriate privledges for the database. DO NOT use
root.
?php
$DB_HOST = localhost;
$DB_USER = root; // Do not do this. Make a different user.
$DB_PASS = ;
$DB_DB = mydb;
// connect
[EMAIL PROTECTED]
To: 'Luis A' [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Tuesday, February 25, 2003 8:25 PM
Subject: RE: [PHP] mysql trouble
Create a user with appropriate privledges for the database. DO NOT use
root.
?php
$DB_HOST = localhost;
$DB_USER = root; // Do not do this. Make
On Thursday 27 February 2003 01:00, Luis A wrote:
?php
$link = mysql_connect(localhost, nobody);
mysql_select_db(mydb, $link);
$result = mysql_query(SELECT * FROM opina, $link);
echo Nombre: .mysql_result($result, 0, nombre).br;
[snip]
You need to use the mysql_fetch_*() functions as well.
OK IF no trouble for ud to send it to me the manual ??
in spanish
- Original Message -
From: Jason Wong [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 12:17 PM
Subject: Re: [PHP] to Bryan Lipscy Re: [PHP] mysql trouble
On Thursday 27 February 2003 01:00
On Thursday 27 February 2003 01:32, Luis A wrote:
OK IF no trouble for ud to send it to me the manual ??
in spanish
b) Single HTML or Multiple HTML or Windows HTML (CHM format)
Which format?
Also please do not change the subject (ie putting people's name into the
subject).
--
Jason Wong
HTML
b)single
- Original Message -
From: Jason Wong [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 12:38 PM
Subject: Re: [PHP] to Jason Wong Re: [PHP] mysql trouble
On Thursday 27 February 2003 01:32, Luis A wrote:
OK IF no trouble for ud to send it to me
901 - 1000 of 1710 matches
Mail list logo