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
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,
@lists.php.net
Sent: Tuesday, April 07, 2009 3:05 PM
Subject: [PHP] PHP-MYSQL Question
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
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
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
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
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
On Fri, 26 Oct 2001 23:27, Gerard Onorato wrote:
Hello,
I am a recent return to the list. Wow has the traffic grown! This is
awesome.
I have a couple of questions and one may be a RTFM but I can't find the
answer.
#1) While I thought I was extremely familiar with the MYSQL functions
Hello,
I am a recent return to the list. Wow has the traffic grown! This is
awesome.
I have a couple of questions and one may be a RTFM but I can't find the
answer.
#1) While I thought I was extremely familiar with the MYSQL functions
available in PHP I found on e in a code snippet that I have
]]
Sent: Saturday, March 10, 2001 6:01 PM
To: [EMAIL PROTECTED]
Subject: [PHP] PHP/MySQL Question
Having some problems with syntax.
If I wanted to SELECT only 5 instances of something from a database and
order it by datetime, how would I do that?
- Kath
--
PHP General Mailing List (http
Is it possible to move through an array that is returned as a recordset
and then move back to the beginning of the array.
Julia
--
[ Julia Anne Case ] [Ships are safe inside the harbor, ]
[Programmer at large] [ but is that what ships are really for.]
[ Admining
reset($array), if this is what you need.
this resets (who would have thought it?) the internal pointer back to the
first
position.
""Julia A . Case"" [EMAIL PROTECTED] schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Is it possible to move through an array that is returned
usion, PHP, and mySQL
http://www.wizaerd.com
=
-Original Message-
From: Julia A . Case [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 29, 2001 4:15 PM
To: [EMAIL PROTECTED]
Subject: [PHP] PHP/MySQL question
Is it possible to move throug
34 matches
Mail list logo