Re: [PHP] PHP+MySQL question

2011-02-16 Thread Robert Cummings
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

Re: [PHP] PHP+MySQL question

2011-02-16 Thread Robert Cummings
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

[PHP] PHP+MySQL question

2011-02-16 Thread דניאל דנון
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

RE: [PHP] PHP-MYSQL Question

2009-04-07 Thread abdulazeez alugo
> 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

Re: [PHP] PHP-MYSQL Question

2009-04-07 Thread Per Jessen
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

Re: [PHP] PHP-MYSQL Question

2009-04-07 Thread HostWare Kft.
: 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,

[PHP] PHP-MYSQL Question

2009-04-07 Thread abdulazeez alugo
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

Re: [PHP] PHP/mySQL question using ORDER BY with logic

2008-10-23 Thread Robert Cummings
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

[PHP] PHP/mySQL question using ORDER BY with logic

2008-10-23 Thread Rob Gould
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

RE: [PHP] PHP/mySQL question about groups

2008-02-07 Thread Warren Vail
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

Re: [PHP] PHP/mySQL question about groups

2008-02-07 Thread Andrew Ballard
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

RE: [PHP] PHP/mySQL question about groups

2008-02-06 Thread Warren Vail
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,

Re: [PHP] PHP/mySQL question about groups

2008-02-06 Thread Andrew Ballard
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

Re: [PHP] PHP/mySQL question about groups

2008-02-06 Thread Nathan Nobbe
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

Re: [PHP] PHP/mySQL question about groups

2008-02-06 Thread Andrew Ballard
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

RE: [PHP] PHP/mySQL question about groups

2008-02-06 Thread Bastien Koert
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

Re: [PHP] PHP/mySQL question about groups

2008-02-06 Thread Nathan Nobbe
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

[PHP] PHP/mySQL question about groups

2008-02-06 Thread Rob Gould
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

Re: [PHP] php - mysql question

2006-10-15 Thread Chris
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

[PHP] php - mysql question

2006-10-13 Thread Dave Goodchild
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

Re: [PHP] PHP/MySQL question

2006-06-05 Thread Wolf
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

Re: [PHP] PHP/MySQL question

2006-06-05 Thread Richard Lynch
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

RE: [PHP] PHP/MySQL question

2006-06-05 Thread Jay Blanchard
[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

[PHP] PHP/MySQL question

2006-06-05 Thread Wolf
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

Re: [PHP] php mySql question

2005-07-27 Thread John Nichel
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

Re: [PHP] php mySql question

2005-07-27 Thread Mark Rees
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

RE: [PHP] php mySql question

2005-07-27 Thread Shaw, Chris - Accenture
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

[PHP] php mySql question

2005-07-26 Thread Ned Kotter
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

Re: [PHP] php-mysql question

2001-10-28 Thread David Robley
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

[PHP] php-mysql question

2001-10-26 Thread Gerard Onorato
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

RE: [PHP] PHP/MySQL Question

2001-03-10 Thread Rick St Jean
: 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

RE: [PHP] PHP/MySQL Question

2001-03-10 Thread Cal Evans
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

[PHP] PHP/MySQL Question

2001-03-10 Thread Kath
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

RE: [PHP] PHP/MySQL question

2001-01-29 Thread Joe Sheble (Wizaerd)
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

Re: [PHP] PHP/MySQL question

2001-01-29 Thread Johannes Janson
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

[PHP] PHP/MySQL question

2001-01-29 Thread Julia A . Case
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