Hi.
I have a table called images with 4 columns - `image_id`, `item_name`,
`image_url`, `image_views`
(Where image_id is UNIQUE and AUTO-INCREMENT).
Sometimes, there might be many items with the same name (but not with the
same url).
I want to make sure that each item name has at most 3 images
On 11-02-16 11:37 AM, דניאל דנון wrote:
Hi.
I have a table called images with 4 columns - `image_id`, `item_name`,
`image_url`, `image_views`
(Where image_id is UNIQUE and AUTO-INCREMENT).
Sometimes, there might be many items with the same name (but not with the
same url).
I want to make
On 11-02-16 11:55 AM, Robert Cummings wrote:
On 11-02-16 11:37 AM, דניאל דנון wrote:
Hi.
I have a table called images with 4 columns - `image_id`, `item_name`,
`image_url`, `image_views`
(Where image_id is UNIQUE and AUTO-INCREMENT).
Sometimes, there might be many items with the same name
hai all,
I have two tables a and b as follows to implement a simple block list where
users can block other users.
Table A
++--+--+
| Name | phone |userid|
++--+--+
| Mr Sasi | 01225 708225 | 1 |
| Miss Brown | 01225 899360 | 2 |
|
On 21 October 2010 14:13, Midhun Girish midhungir...@gmail.com wrote:
| Name | phone |userid|
++--+--+
| Mr Sasi | 01225 708225 | 1 |
| Miss Brown | 01225 899360 | 2 |
| Mr Black | 01380 724040 | 3 |
++--+--+
Table B
Hi guys,
Please can anyone tell me what I'm doing wrong with the code below? It keep
returning unsuccessful.
$result=mysql_query(CREATE TABLE table2(table2_id INT NOT NULL PRIMARY KEY
AUTO_INCREMENT,
table1_id INT NOT NULL,
name VARCHAR(100) NOT NULL,
This isn't PHP but mysql question.
You didn't mention that the table itslef is created or not. If not, then it
is probably a mysql error,
maybe your installation of mysql doesn't support INNODB.
SanTa
- Original Message -
From: abdulazeez alugo defati...@hotmail.com
To: php-general
abdulazeez alugo wrote:
Hi guys,
Please can anyone tell me what I'm doing wrong with the code below? It
keep returning unsuccessful.
Why don't you print out mysql_error() ? It'll tell you right away.
/Per
--
Per Jessen, Zürich (20.1°C)
--
PHP General Mailing List
From: p...@computer.org
Date: Tue, 7 Apr 2009 15:18:35 +0200
To: php-general@lists.php.net
Subject: Re: [PHP] PHP-MYSQL Question
abdulazeez alugo wrote:
Hi guys,
Please can anyone tell me what I'm doing wrong with the code below? It
keep returning unsuccessful.
Why
On Mon, 2008-12-08 at 23:50 -0800, Yeti wrote:
?php
define('HUMAN_STUPIDITY', true);
function bigbang() {
while (HUMAN_STUPIDITY || !isset($debate_is_over)) { }
return true;
}
if (!isset($universe)) bigbang();
?
Who says the big bang is past?
I can't hear it.
Cheers,
Rob.
German Geek wrote:
On Tue, Dec 9, 2008 at 2:46 PM, Micah Gersten [EMAIL PROTECTED] wrote:
Robert Cummings wrote:
On Tue, 2008-12-09 at 00:16 +, Nathan Rixham wrote:
Ashley Sheridan wrote:
On Mon, 2008-12-08 at 23:23 +, [EMAIL PROTECTED] wrote:
Presumable, the EXISTS sub-query
As a matter of fact, in space you can't even scream.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Tue, Dec 9, 2008 at 10:49 PM, Yeti [EMAIL PROTECTED] wrote:
As a matter of fact, in space you can't even scream.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I don't know if there is a better or best solution to this, but an
At 12:44 AM +1300 12/10/08, German Geek wrote:
Anybody agree or am i alone in this universe?
Of course you are alone.
As for the existence and history of the Universe, the Earth, you, or
God -- it's all a matter of perception; and what you believe to be
true; and on what the foundations
Perhaps you couldn't hear the big bang in this universe, but what about in the
universe that spawned it?
:-)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Tue, Dec 9, 2008 at 11:40 AM, [EMAIL PROTECTED] wrote:
Perhaps you couldn't hear the big bang in this universe, but what about in
the universe that spawned it?
:-)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
The omniverse or
On Tue, 2008-12-09 at 16:40 +, [EMAIL PROTECTED] wrote:
Perhaps you couldn't hear the big bang in this universe, but what about in
the universe that spawned it?
:-)
The black hole wouldn't allow it to travel in that direction ;)
Cheers,
Rob.
--
http://www.interjinn.com
Application and
On Tue, 2008-12-09 at 01:49 -0800, Yeti wrote:
As a matter of fact, in space you can't even scream.
Sure you can... I'm screaming right now... and I'm in space. A container
within a container within a container within a container (ad infinitum)
is still within the outermost container.
Cheers,
Sure you can... I'm screaming right now... and I'm in space. A container
within a container within a container within a container (ad infinitum)
is still within the outermost container.
I didn't hear you scream.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
On Sun, Dec 7, 2008 at 12:38 PM, Robert Cummings [EMAIL PROTECTED] wrote:
On Sun, 2008-12-07 at 11:01 -0500, Eric Butera wrote:
Sounds like someone thinks they're pretty clever. I'll never
understand why interviewers want to ask really odd edge case questions
instead of ones that really show
On Mon, 2008-12-08 at 10:19 -0500, Andrew Ballard wrote:
On Sun, Dec 7, 2008 at 12:38 PM, Robert Cummings [EMAIL PROTECTED] wrote:
On Sun, 2008-12-07 at 11:01 -0500, Eric Butera wrote:
Sounds like someone thinks they're pretty clever. I'll never
understand why interviewers want to ask
Presumable, the EXISTS sub-query can be optimized sometimes to just stop
processing the sub-query and kick things back out to the outer query.
IN has to process them all and find them all.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
On Mon, 2008-12-08 at 23:23 +, [EMAIL PROTECTED] wrote:
Presumable, the EXISTS sub-query can be optimized sometimes to just stop
processing the sub-query and kick things back out to the outer query.
IN has to process them all and find them all.
Don't forget the special case use
Ashley Sheridan wrote:
On Mon, 2008-12-08 at 23:23 +, [EMAIL PROTECTED] wrote:
Presumable, the EXISTS sub-query can be optimized sometimes to just stop
processing the sub-query and kick things back out to the outer query.
IN has to process them all and find them all.
Don't forget
On Tue, 2008-12-09 at 00:16 +, Nathan Rixham wrote:
Ashley Sheridan wrote:
On Mon, 2008-12-08 at 23:23 +, [EMAIL PROTECTED] wrote:
Presumable, the EXISTS sub-query can be optimized sometimes to just stop
processing the sub-query and kick things back out to the outer query.
Robert Cummings wrote:
On Tue, 2008-12-09 at 00:16 +, Nathan Rixham wrote:
Ashley Sheridan wrote:
On Mon, 2008-12-08 at 23:23 +, [EMAIL PROTECTED] wrote:
Presumable, the EXISTS sub-query can be optimized sometimes to just stop
processing the sub-query and kick
On Tue, Dec 9, 2008 at 2:46 PM, Micah Gersten [EMAIL PROTECTED] wrote:
Robert Cummings wrote:
On Tue, 2008-12-09 at 00:16 +, Nathan Rixham wrote:
Ashley Sheridan wrote:
On Mon, 2008-12-08 at 23:23 +, [EMAIL PROTECTED] wrote:
Presumable, the EXISTS sub-query can be optimized
On Mon, 2008-12-08 at 19:46 -0600, Micah Gersten wrote:
Robert Cummings wrote:
On Tue, 2008-12-09 at 00:16 +, Nathan Rixham wrote:
Ashley Sheridan wrote:
On Mon, 2008-12-08 at 23:23 +, [EMAIL PROTECTED] wrote:
Presumable, the EXISTS sub-query can be optimized
Robert Cummings wrote:
On Mon, 2008-12-08 at 19:46 -0600, Micah Gersten wrote:
Robert Cummings wrote:
On Tue, 2008-12-09 at 00:16 +, Nathan Rixham wrote:
Ashley Sheridan wrote:
On Mon, 2008-12-08 at 23:23 +, [EMAIL PROTECTED] wrote:
German Geek wrote:
On Tue, Dec 9, 2008 at 2:46 PM, Micah Gersten [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
Robert Cummings wrote:
On Tue, 2008-12-09 at 00:16 +, Nathan Rixham wrote:
Ashley Sheridan wrote:
On Mon, 2008-12-08 at 23:23 +, [EMAIL
Micah Gersten wrote:
Robert Cummings wrote:
On Mon, 2008-12-08 at 19:46 -0600, Micah Gersten wrote:
Robert Cummings wrote:
On Tue, 2008-12-09 at 00:16 +, Nathan Rixham wrote:
Ashley Sheridan wrote:
On Mon, 2008-12-08 at 23:23 +, [EMAIL PROTECTED]
On Tue, Dec 9, 2008 at 3:51 PM, Micah Gersten [EMAIL PROTECTED] wrote:
German Geek wrote:
On Tue, Dec 9, 2008 at 2:46 PM, Micah Gersten [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
Robert Cummings wrote:
On Tue, 2008-12-09 at 00:16 +, Nathan Rixham wrote:
On Tue, 2008-12-09 at 17:40 +1300, German Geek wrote:
On Tue, Dec 9, 2008 at 3:51 PM, Micah Gersten [EMAIL PROTECTED] wrote:
German Geek wrote:
On Tue, Dec 9, 2008 at 2:46 PM, Micah Gersten [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
Robert Cummings wrote:
On
?php
define('HUMAN_STUPIDITY', true);
function bigbang() {
while (HUMAN_STUPIDITY || !isset($debate_is_over)) { }
return true;
}
if (!isset($universe)) bigbang();
?
Who says the big bang is past?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
Hi gang:
I just interviewed for a job teaching at the local college (imagine
me taking minds of mush and molding them to the world according to
tedd -- frightening huh?)
In any event, the interviewer asked me how long I've been using MySQL
and I replied several years. After which she asked
: Sun, 7 Dec 2008 10:03:26 -0500
Subject: [PHP] A MySQL Question
Hi gang:
I just interviewed for a job teaching at the local college (imagine
me taking minds of mush and molding them to the world according to
tedd -- frightening huh?)
In any event, the interviewer asked me how long I've
On Sun, Dec 7, 2008 at 10:03 AM, tedd [EMAIL PROTECTED] wrote:
Hi gang:
I just interviewed for a job teaching at the local college (imagine me
taking minds of mush and molding them to the world according to tedd --
frightening huh?)
In any event, the interviewer asked me how long I've been
On Sun, 2008-12-07 at 10:03 -0500, tedd wrote:
Hi gang:
I just interviewed for a job teaching at the local college (imagine
me taking minds of mush and molding them to the world according to
tedd -- frightening huh?)
In any event, the interviewer asked me how long I've been using MySQL
On Sun, 2008-12-07 at 11:01 -0500, Eric Butera wrote:
Sounds like someone thinks they're pretty clever. I'll never
understand why interviewers want to ask really odd edge case questions
instead of ones that really show practical knowledge. I know that I
don't know the syntax to everything.
On Sun, Dec 07, 2008 at 10:03:26AM -0500, tedd wrote:
Hi gang:
I just interviewed for a job teaching at the local college (imagine me
taking minds of mush and molding them to the world according to tedd
-- frightening huh?)
In any event, the interviewer asked me how long I've been using
On Sun, 2008-12-07 at 10:03 -0500, tedd wrote:
Hi gang:
I just interviewed for a job teaching at the local college (imagine
me taking minds of mush and molding them to the world according to
tedd -- frightening huh?)
In any event, the interviewer asked me how long I've been using MySQL
On Sun, 2008-12-07 at 12:38 -0500, Robert Cummings wrote:
On Sun, 2008-12-07 at 11:01 -0500, Eric Butera wrote:
Sounds like someone thinks they're pretty clever. I'll never
understand why interviewers want to ask really odd edge case questions
instead of ones that really show practical
This one time, at band camp, tedd [EMAIL PROTECTED] wrote:
In any event, the interviewer asked me how long I've been using MySQL
and I replied several years. After which she asked a single question,
which was What does EXIST mean?
I only ever use it in rollbacks to check if a table exists.
Kevin Waterson wrote:
Only a barbarian would call it Sequel or anything other than
My S. Q. L MY ESS KEW ELL
I have never heard that product SQL Server referred to as anything
other than seequel server.
Guess that proves your point :)
Stephen
--
PHP General Mailing List
tedd wrote:
Hi gang:
I just interviewed for a job teaching at the local college (imagine me
taking minds of mush and molding them to the world according to tedd --
frightening huh?)
In any event, the interviewer asked me how long I've been using MySQL
and I replied several years. After
EXIST? Yeah I certainly have seen it before in the result of a mysqldump,
but from the top of my head, I probably wouldn't have known in exactly what
context it is used. I've used MySQL for 5 years now and i think if you ask
such a question, you don't know what you should be asking because the
On Mon, 2008-12-08 at 12:33 +1300, German Geek wrote:
EXIST? Yeah I certainly have seen it before in the result of a mysqldump,
but from the top of my head, I probably wouldn't have known in exactly what
context it is used. I've used MySQL for 5 years now and i think if you ask
such a
German Geek wrote:
EXIST? Yeah I certainly have seen it before in the result of a mysqldump,
but from the top of my head, I probably wouldn't have known in exactly what
context it is used. I've used MySQL for 5 years now and i think if you ask
such a question, you don't know what you should be
On Mon, Dec 8, 2008 at 2:59 PM, Chris [EMAIL PROTECTED] wrote:
German Geek wrote:
EXIST? Yeah I certainly have seen it before in the result of a mysqldump,
but from the top of my head, I probably wouldn't have known in exactly
what
context it is used. I've used MySQL for 5 years now and i
And 'exists' is not for mysqldump.
DROP TABLE IF EXISTS `mytable`;
if exists can be used in lots of places other than drop table, like
triggers, functions and i'm sure other things.
I said, I've seen EXIST in a result of a mysqldump before, which is not
wrong is it? Unless I'm
On Mon, Dec 8, 2008 at 3:24 PM, Chris [EMAIL PROTECTED] wrote:
And 'exists' is not for mysqldump.
DROP TABLE IF EXISTS `mytable`;
if exists can be used in lots of places other than drop table, like
triggers, functions and i'm sure other things.
I said, I've seen EXIST in a result
German Geek wrote:
On Mon, Dec 8, 2008 at 3:24 PM, Chris [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
And 'exists' is not for mysqldump.
DROP TABLE IF EXISTS `mytable`;
if exists can be used in lots of places other than drop table,
like triggers,
On Mon, Dec 8, 2008 at 5:06 PM, Chris [EMAIL PROTECTED] wrote:
German Geek wrote:
On Mon, Dec 8, 2008 at 3:24 PM, Chris [EMAIL PROTECTED] mailto:
[EMAIL PROTECTED] wrote:
And 'exists' is not for mysqldump.
DROP TABLE IF EXISTS `mytable`;
if exists can be used in
Sorry, I couldnt find EXIST there, only EXISTS.
If you're going to be that pedantic, exist isn't in mysqldump
either :P
I know it's pedantic, but unfortunately computers are strictly pedantic
and I wasn't sure why you said
if exists can be used in lots of places other than
On Mon, Dec 8, 2008 at 5:50 PM, Chris [EMAIL PROTECTED] wrote:
Sorry, I couldnt find EXIST there, only EXISTS.
If you're going to be that pedantic, exist isn't in mysqldump
either :P
I know it's pedantic, but unfortunately computers are strictly pedantic
and I wasn't sure
Right
So, how are these different:
SELECT * FROM t1 WHERE id EXISTS (SELECT id FROM t2)
If there are *any* results for the subselect, the exists returns true.
It's the equivalent of:
select * from t1 where id is true;
ie
select * from t1;
If there are no results for the subselect,
On Mon, Dec 8, 2008 at 7:06 PM, Chris [EMAIL PROTECTED] wrote:
Right
So, how are these different:
SELECT * FROM t1 WHERE id EXISTS (SELECT id FROM t2)
If there are *any* results for the subselect, the exists returns true.
It's the equivalent of:
select * from t1 where id is
Question about mySQL and PHP, when using the mySQL ORDER BY method...
Basically I've got data coming from the database where a wine
producer-name is a word like:
Château Bahans Haut-Brion
or
La Chapelle de La Mission Haut-Brion
or
Le Clarence de
On Fri, 2008-10-24 at 00:18 -0400, Rob Gould wrote:
Question about mySQL and PHP, when using the mySQL ORDER BY method...
Basically I've got data coming from the database where a wine
producer-name is a word like:
Château Bahans Haut-Brion
or
La Chapelle
nihilism machine wrote:
Ok, I read the php.net info. so with this function though:
public function select_one($sql) {
$this-last_query = $sql;
$r = mysql_query($sql);
if (!$r) {
$this-last_error = mysql_error();
return false;
}
list
Subject: Re: [PHP] PHP/mySQL question about groups
On Feb 7, 2008 1:20 AM, Warren Vail [EMAIL PROTECTED] wrote:
I did some looking into performance issues many years ago at company
that
developed and marketed another database server, comparing the query plan
to
the actual code
On Feb 7, 2008 1:20 AM, Warren Vail [EMAIL PROTECTED] wrote:
I did some looking into performance issues many years ago at company that
developed and marketed another database server, comparing the query plan to
the actual code, and a query plan usually shows the processes that consume
the
Let's say I have a PHP-based wine application, and it's taking a set of mySQL
data that looks like this:
wineidname size
123 Silver Oak 750ML
123
On Feb 6, 2008 8:46 PM, Rob Gould [EMAIL PROTECTED] wrote:
Let's say I have a PHP-based wine application, and it's taking a set of
mySQL data that looks like this:
wineidname
size
123 Silver Oak
750ML
123
Select * from wine where name = 'Silver Oak' GROUP BY wineid,size
bastien Date: Wed, 6 Feb 2008 17:46:52 -0800 From: [EMAIL PROTECTED] To:
php-general@lists.php.net Subject: [PHP] PHP/mySQL question about groups
Let's say I have a PHP-based wine application, and it's taking a set of mySQL
On Feb 6, 2008 8:46 PM, Rob Gould [EMAIL PROTECTED] wrote:
Let's say I have a PHP-based wine application, and it's taking a set of mySQL
data that looks like this:
wineidname
size
123 Silver Oak
On Feb 6, 2008 10:59 PM, Andrew Ballard [EMAIL PROTECTED] wrote:
Of course, in this case you could just avoid all the confusion with
this statement as well:
SELECT DISTINCT name, size
FROMwine
im not sure why, but i think distinct is typically way slower than group by.
-nathan
On Feb 6, 2008 11:20 PM, Nathan Nobbe [EMAIL PROTECTED] wrote:
On Feb 6, 2008 10:59 PM, Andrew Ballard [EMAIL PROTECTED] wrote:
Of course, in this case you could just avoid all the confusion with
this statement as well:
SELECT DISTINCT name, size
FROMwine
im not sure why, but i
-Original Message-
From: Andrew Ballard [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 06, 2008 8:41 PM
To: PHP General list
Subject: Re: [PHP] PHP/mySQL question about groups
On Feb 6, 2008 11:20 PM, Nathan Nobbe [EMAIL PROTECTED] wrote:
On Feb 6, 2008 10:59 PM, Andrew Ballard [EMAIL
Man-wai Chang wrote:
I tried to post to mysql.general, but the message never appeared. So I
am trying my luck here.
How could I build an index for a table created using the CREATE
TEMPORARY TABLE ... SELECT ... FROM ... syntax, using an account
without the privilege to use ALTER TABLE?
You didn't send much info along, so I assume you're using some version
of MySQL 5.0.
Thanks. I figured it out (doesn't need 5.0):
CREATE TEMPORARY haha ( KEY (field1), KEY (field2) )
AS
SELECT po_no, po_date, item_no FROM . WHERE
Then I don't need the privilege for ALTER TABLE.
--
CREATE TEMPORARY haha ( KEY (field1), KEY (field2) )
AS
SELECT po_no, po_date, item_no FROM . WHERE
Then I don't need the privilege for ALTER TABLE.
I meant I could build index on a temp table without
the privilege to use ALTER TABLE by making the index
definitions as part of the
Dave Goodchild wrote:
Hi all. I am writing a web app with a mysql back end and there is every
chance one of the tables may have to handle 56+ million records. I am no
mysql expert but has anyone else here ever handled that volume of data, and
if so, any suggestions or caveats? The tables will of
Hi all. I am writing a web app with a mysql back end and there is every
chance one of the tables may have to handle 56+ million records. I am no
mysql expert but has anyone else here ever handled that volume of data, and
if so, any suggestions or caveats? The tables will of course be correctly
I have a php form that pulls data from the database (hence the problems)
I need to do an OR search on three columns, and AND the rest, anyone
have a good way to do this? So far my searching on the MySQL lists have
been fruitless more then anything, and I figured we've probably come
across this
[snip]
I need to do an OR search on three columns, and AND the rest, anyone
have a good way to do this? So far my searching on the MySQL lists have
been fruitless more then anything, and I figured we've probably come
across this ourselves at some point.
[/snip]
More of a MySQL question, but
On Mon, June 5, 2006 10:32 am, Wolf wrote:
I have a php form that pulls data from the database (hence the
problems)
I need to do an OR search on three columns, and AND the rest, anyone
have a good way to do this? So far my searching on the MySQL lists
have
been fruitless more then
Thanks guys, I knew it was a stupid Q when I sent it, but I had another
one where I encapsulated them in () blow up on me, so I figured if I
asked and it was the same answer then I was on the right track.
And so far all the tests have shown positive. :)
Wolf
More of a MySQL question, but
Have you tried doing a search for the text php5 in the php.ini file that
sits in your c:\windows folder?
C.
-Original Message-
From: Ned Kotter [mailto:[EMAIL PROTECTED]
Sent: 26 July 2005 04:03
To: php-general@lists.php.net
Subject: [PHP] php mySql question
I have installed php 5.0.4
?
C.
-Original Message-
From: Ned Kotter [mailto:[EMAIL PROTECTED]
Sent: 26 July 2005 04:03
To: php-general@lists.php.net
Subject: [PHP] php mySql question
I have installed php 5.0.4 on my windows 2000, IIS 6.0 server. PHP works
but
when I try to connect to MySQL I get the Fatal error
Ned Kotter wrote:
I have installed php 5.0.4 on my windows 2000, IIS 6.0 server. PHP works but
when I try to connect to MySQL I get the Fatal error: Call to undefined
function mysql_connect(). I have uncommented the line in the php.ini file that
says 'extension=php_mysql.dll'. I have path
I have installed php 5.0.4 on my windows 2000, IIS 6.0 server. PHP works but
when I try to connect to MySQL I get the Fatal error: Call to undefined
function mysql_connect(). I have uncommented the line in the php.ini file that
says 'extension=php_mysql.dll'. I have path variables set for
I would have at least expected it give me 'margaret atwood' before it gives me
'margaret' and then 'atwood'.
Sorry, MySQL question. Any takers? If I search for 'margaret atwood', I get results
in no real structured heirachy. Any thoughts?
SELECT ST,BT,AT FROM ccl_main WHERE MATCH
John Taylor-Johnston wrote:
Sorry, MySQL question. Any takers? If I search for 'margaret atwood', I
get results in no real structured heirachy. Any thoughts?
SELECT ST,BT,AT FROM ccl_main WHERE MATCH (ST,BT,AT) AGAINST ('margaret
atwood' IN BOOLEAN MODE);h1Search font
I am sorry to post another mysql question, but this one is design related. I
need to create a relationship between two different tables in two different
databases. I feel like I am commiting a sin doing so, but it makes sence at
the application level, and to redesign everything would be
I am sorry to post another mysql question, but this one is design related. I
need to create a relationship between two different tables in two different
databases. I feel like I am commiting a sin doing so, but it makes sence at
the application level, and to redesign everything would be
Christian Calloway wrote:
I am sorry to post another mysql question, but this one is design related. I
need to create a relationship between two different tables in two different
databases. I feel like I am commiting a sin doing so, but it makes sence at
the application level, and to redesign
Ok, I want to delete only 1 row off of a database table...
Example:
I have a table with columns user and item...
Lets say the table contains the following rows (user | item):
582-668243 | Toothbrush
582-668243 | Toothbrush
582-668243 | Toothbrush
582-668243 | Trash can
582-668243 | Trash can
--- zavaboy [EMAIL PROTECTED] wrote:
Lets say the table contains the following rows (user | item):
582-668243 | Toothbrush
582-668243 | Toothbrush
582-668243 | Toothbrush
...
Anyway, how can I remove only 1 Toothbrush from user 582-668243?
With the information you provided, you can't. You
zavaboy [EMAIL PROTECTED] wrote:
Ok, I want to delete only 1 row off of a database table...
Example:
I have a table with columns user and item...
Lets say the table contains the following rows (user | item):
582-668243 | Toothbrush
582-668243 | Toothbrush
Note the 'LIMIT' part in the delete
Ok, I added a primary key. I figured it out and I have it working... Thanks!
Chris Shiflett [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
--- zavaboy [EMAIL PROTECTED] wrote:
Lets say the table contains the following rows (user | item):
582-668243 | Toothbrush
582-668243 |
has no rowid.
-Original Message-
From: zavaboy [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2003 2:13 PM
To: [EMAIL PROTECTED]
Subject: [PHP] A MySQL question
Ok, I want to delete only 1 row off of a database table...
Example:
I have a table with columns user and item...
Lets say
automatically appears (and if there should be a power failure orWindows
crashes, or whatever else - I want the process to start at the last player
being updated - I don't want to have to start again from player one). I'm
not sure if this is more a PHP or MySQL question - or both - so I have sent
). I'm
not sure if this is more a PHP or MySQL question - or both - so I have sent
it to both lists.
Thanks
Beauford
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
the next one
automatically appears (and if there should be a power failure
orWindows
crashes, or whatever else - I want the process to start at the last
player
being updated - I don't want to have to start again from player one).
I'm
not sure if this is more a PHP or MySQL question - or both - so I
Sorry for the OT post, quick mysql question...
I've found a couple of cool utilites that will create basic forms from a mysql table
(add/edit/delete/search), which look they could save some time coding.
However, I can't connect with them because my server is setup as localhost. I
How do you
http://www.mysql.com/doc/en/Adding_users.html
http://www.mysql.com/documentation/lists.html
Kelly Meeks wrote:
Sorry for the OT post, quick mysql question...
I've found a couple of cool utilites that will create basic forms from a mysql table (add/edit/delete/search), which look they could save
where can i find info on setting up a mysql database on a remote server?
i know how to set them up on a local machine, but i can't figure out
how to get to the command line setting on a remote server...
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
Hi Doug,
where can i find info on setting up a mysql
database on a remote server? i know how to
set them up on a local machine, but i can't
figure out how to get to the command line
setting on a remote server...
me@mybox:~$ ssh my.remote.server
Or am I missing something?
Cheers
Jon
jon - thanks for the reply.
i tried this:
prompt ssh server.net
i got an open failed: no such file or directoy
does that mean that ssh is not enabled on the server? i pinged the
server and it said it was alive...
Jon Haworth wrote:
Hi Doug,
where can i find info on setting up a mysql
1 - 100 of 119 matches
Mail list logo