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
> 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
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"
To:
Sent: Tuesday, April 07, 2009
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
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 application, and it's taking a set of m
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
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
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
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
Yes, it is quite possible that you have more than one php.ini file. Check
this and delete as appropriate.
""Shaw, Chris - Accenture"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
...
Have you tried doing a search for the text "php5" in the php.ini file that
sits in your c:\windows f
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.
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
That is database specific no standard SQL.
To make it non specific.
you can put it in a for loop. remember to check for eof.
Rick
At 06:01 PM 3/10/01 -0600, you wrote:
>Select * from table limit 5;
>
>http://www.calevans.com
>
>
>-Original Message-
>From: Kath [mailto:[EMAIL PRO
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 som
// loops through the entire recordset
while( $qrResults = mysql_fetch_array( $rQuery )) {
print( $qrResults["SomeField"]
}
// reset the recordpointer to the first record
mysql_data_seek( $rQuery, 0 );
Joseph E. Sheble
a.k.a. Wizaerd
Wizaerd's Realm
Canvas, 3D, Graphics,
ColdFusion, PHP,
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
26 matches
Mail list logo