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
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 su
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 ima
> 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 doin
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 (http://www
: 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,
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,
s
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
>
> L
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
6 AM
> To: PHP General 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 databas
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
Vail
-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,
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
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 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 Sil
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 appl
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
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
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
ind
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 eas
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 an
[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 easil
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 ou
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 v
ni 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 on my windows 2000, IIS 6.0 server. PHP works
but
when I try
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 ins
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 bot
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 functi
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
: Kath [mailto:[EMAIL PROTECTED]]
>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
Select * from table limit 5;
http://www.calevans.com
-Original Message-
From: Kath [mailto:[EMAIL PROTECTED]]
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
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
ColdFusion, 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
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
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 Li
36 matches
Mail list logo
