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] mysql question

2008-12-29 Thread Phpster
The mysql forum is the best place. Note that their holiday schedule may mean some lag in getting answers. Bastien Sent from my iPod On Dec 29, 2008, at 7:51 AM, ann kok wrote: Hi all Do you know any websites for mysql question? I do submit the mysql forum but I would like to have more to

[PHP] mysql question

2008-12-29 Thread ann kok
Hi all Do you know any websites for mysql question? I do submit the mysql forum but I would like to have more to learn Now I have mysql replication question. Thank you __ Ask a question on any topic and get answers from rea

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

2008-10-26 Thread Carlos Medina
Rob Gould schrieb: 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

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

2008-10-24 Thread Colin Guthrie
Robert Cummings wrote: 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

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] mysql question #2

2008-02-14 Thread Richard Heyes
At any rate, just seeing this tells me that you've got a real mess on your hands... Or you could say, "You're going to have some fun cleaning that". -- Richard Heyes http://www.websupportsolutions.co.uk Knowledge Base and Helpdesk software hosted for you - no installation, no maintenance, new

Re: [PHP] mysql question

2008-02-14 Thread Richard Lynch
On Sun, February 10, 2008 11:52 am, Per Jessen wrote: > nihilism machine wrote: > >> $ret = mysql_result($r, 0); >> mysql_free_result($r); >> if ($this->auto_slashes) return stripslashes($ret); >> else return $ret; >> } >> >> >> what is $ret, an array? > > No, it's a mysql result object. No, it'

Re: [PHP] mysql question #2

2008-02-14 Thread Richard Lynch
On Sun, February 10, 2008 12:12 pm, nihilism machine wrote: > public function select_one($sql) { > if ($this->auto_slashes) { > return stripslashes($ret); If you have to call stripslashes() on data coming FROM MySQL, then you have really messed up... You

Re: [PHP] mysql question

2008-02-11 Thread Daniel Brown
On Feb 10, 2008 1:03 PM, Per Jessen <[EMAIL PROTECTED]> wrote: > Yep, you're right - I read mysql_query where the OP said mysql_result. Don't feel bad. I did the exact same thing when I was reading over the post just now. -- Daniel P. Brown Senior Unix Geek -- PHP General Mailing List

Re: [PHP] mysql question #2

2008-02-10 Thread Zoltán Németh
2008. 02. 10, vasárnap keltezéssel 13.12-kor nihilism machine ezt írta: > 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) { >

Re: [PHP] mysql question #2

2008-02-10 Thread Nathan Nobbe
On Feb 10, 2008 1:12 PM, nihilism machine <[EMAIL PROTECTED]> 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) { >

[PHP] mysql question #2

2008-02-10 Thread nihilism machine
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(); ret

Re: [PHP] mysql question

2008-02-10 Thread Per Jessen
Nathan Nobbe wrote: >> > what is $ret, an array? >> >> No, it's a mysql result object. >> > > no, its the contents of the first cell in the first record of the > result set; from the doc on mysql_result(), > http://www.php.net/manual/en/function.mysql-result.php > which is what the function is us

Re: [PHP] mysql question

2008-02-10 Thread Nathan Nobbe
On Feb 10, 2008 12:52 PM, Per Jessen <[EMAIL PROTECTED]> wrote: > nihilism machine wrote: > > > $ret = mysql_result($r, 0); > > mysql_free_result($r); > > if ($this->auto_slashes) return stripslashes($ret); > > else return $ret; > > } > > > > > > what is $ret, an array? > > No, it's a mysql result

Re: [PHP] mysql question

2008-02-10 Thread Per Jessen
nihilism machine wrote: > $ret = mysql_result($r, 0); > mysql_free_result($r); > if ($this->auto_slashes) return stripslashes($ret); > else return $ret; > } > > > what is $ret, an array? No, it's a mysql result object. > if so how can i access the individual rows in it? Look up mysql_fetch_a

[PHP] mysql question

2008-02-10 Thread nihilism machine
i have this functuon: public function select_one($sql) { $this->last_query = $sql; $r = mysql_query($sql); if (!$r) { $this->last_error = mysql_error(); return false; }

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

[PHP] mysql question

2007-07-16 Thread Man-wai Chang
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? -- .~. Might. Courage.

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

[PHP] Re: php mySql question

2005-07-27 Thread axel
Sure that your php.ini is located correctly? 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=ph

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] very basic php mysql question

2004-09-20 Thread Jason Davidson
add mysql_error() to your die string so you can report what the error is. Jason "AMC" <[EMAIL PROTECTED]> wrote: > > Thanks, > > the script runs now, but I cannot open a connection. I know the user name, > and password are correct. What could be the cause? > > > > > $user = "aclark"; > >

Re: [PHP] very basic php mysql question

2004-09-20 Thread AMC
I figured it out - using the wrong info for host Thanks again "Amc" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Thanks, > > the script runs now, but I cannot open a connection. I know the user name, > and password are correct. What could be the cause? > > > > > $user = "aclark";

Re: [PHP] very basic php mysql question

2004-09-20 Thread AMC
Thanks, the script runs now, but I cannot open a connection. I know the user name, and password are correct. What could be the cause? "Matthew Sims" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > > > I have a php page with the code below. The page doesn't show the record > > fr

Re: [PHP] very basic php mysql question

2004-09-20 Thread Victor Saldaña D.
On Mon, 20 Sep 2004 15:17:33 -0700, AMC <[EMAIL PROTECTED]> wrote: > http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] very basic php mysql question

2004-09-20 Thread Matthew Sims
> > I have a php page with the code below. The page doesn't show the record > from > the database when it runs and I'm not sure why. I'm not getting any error > message, just a blank page. There is one record in the tabele I'm trying > to > query. > I'm brand new to php so I'd really appreciate the

[PHP] very basic php mysql question

2004-09-20 Thread AMC
Hi, I have a php page with the code below. The page doesn't show the record from the database when it runs and I'm not sure why. I'm not getting any error message, just a blank page. There is one record in the tabele I'm trying to query. I'm brand new to php so I'd really appreciate the help. -

[PHP] MySQL question

2004-06-22 Thread John Taylor-Johnston
Sorry, MySQL question. Any takers? If I search for 'margaret atwood', I get results in no real structured heirachy. Any thoughts? Search ccl.ccl_main For: margaret atwood - 275 record(s) found John -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsu

Re: [PHP] mysql question

2004-01-16 Thread Christian Calloway
Hey Mike, That is almost exactly what I am doing. I have a table, lets say "product_fields" which describes each characteristic/field of a product (with N possible fields). A definition of a field includes, its name (as the customer see's it), its type, a named-reference to the field in the data t

Re: [PHP] mysql question

2004-01-16 Thread Miles Thompson
Christian, I did a bit of digging in the MySQL docs to try and find the limits on number of fields in a table, etc. Didn't have much luck. I would not worry about thousands, or even hundreds of thousands of rows in a table for two reasons. First MySQL is becoming a heavier-duty database, and se

Re: [PHP] mysql question

2004-01-16 Thread Christian Calloway
Well let me try and describe a simplified version of what I am doing. I work for a group of analysts, and they analyse technical products. Each products has about 300+ fields associated with it, and each product is vastly different from the other. Let's say the product "foo" has a table "fields" as

Re: [PHP] mysql question

2004-01-15 Thread Miles Thompson
Christian, A red flag is flying. Usually, when people start talking about how the number of tables will multiply in an application, there is a problem with the design of data structures. If that's the case, now is the time to fix it. Miles At 05:35 PM 1/15/2004 +, Christian Calloway wrote

[PHP] mysql question

2004-01-15 Thread Christian Calloway
Hey, Sorry to post a mysql question here, but I wanted an answer from a PHP perspective. I am currently working on a database (for work) which contains 40 tables, and will continue to expand. The reason for expansion of tables is to obscure to get into, but the relationships all do make sence. I h

Re: [PHP] MySQL Question

2004-01-15 Thread CPT John W. Holmes
From: "John Taylor-Johnston" <[EMAIL PROTECTED]> > Sorry, don't want to be off-topic, but have found something curious about MySQL 4.0.16-standard. > > It does not seem to prioritise properly. Searching for 'English Canada' > (as opposed to +English +Canada) > gives me all instances of both words

[PHP] MySQL Question

2004-01-15 Thread John Taylor-Johnston
Sorry, don't want to be off-topic, but have found something curious about MySQL 4.0.16-standard. It does not seem to prioritise properly. Searching for 'English Canada' (as opposed to +English +Canada) gives me all instances of both words but does not prioritize the display order for 'English Can

Re: [PHP] Mysql question

2003-11-18 Thread Greg Donald
On Tue, 18 Nov 2003, Lists wrote: >I have a db in sql, and I need a php/mysql query/command to copy the >entire db (schema and data) to a new db. I know how to do this with a >table, but I can not figure out how to do this with a whole db. I also >know that I could do it using mysql dump, but

Re: [PHP] Mysql question

2003-11-18 Thread John W. Holmes
Lists wrote: I have a db in sql, and I need a php/mysql query/command to copy the entire db (schema and data) to a new db. I know how to do this with a table, but I can not figure out how to do this with a whole db. I also know that I could do it using mysql dump, but I don't want to have to

Re: [PHP] Mysql question

2003-11-18 Thread Raditha Dissanayake
Hi John, ASAIK you are right. Michael, if you use the root account in php you will be able to do what John says. John Nichel wrote: Lists wrote: I have a db in sql, and I need a php/mysql query/command to copy the entire db (schema and data) to a new db. I know how to do this with a table, b

Re: [PHP] Mysql question

2003-11-18 Thread John Nichel
Lists wrote: I have a db in sql, and I need a php/mysql query/command to copy the entire db (schema and data) to a new db. I know how to do this with a table, but I can not figure out how to do this with a whole db. I also know that I could do it using mysql dump, but I don't want to have to

RE: [PHP] Mysql question

2003-11-18 Thread Vail, Warren
18, 2003 5:37 PM To: [EMAIL PROTECTED] Subject: [PHP] Mysql question I have a db in sql, and I need a php/mysql query/command to copy the entire db (schema and data) to a new db. I know how to do this with a table, but I can not figure out how to do this with a whole db. I also know that I c

Re: [PHP] Mysql question

2003-11-18 Thread Lists
This is for an intranet application, I trust my users. Michael On Wed, 19 Nov 2003, Raditha Dissanayake wrote: > Creating new databases is usually done with the mysql root account. Bad > idea to use this account in a php script. > > Lists wrote: > > >I have a db in sql, and I need a php/mysql

Re: [PHP] Mysql question

2003-11-18 Thread Raditha Dissanayake
Creating new databases is usually done with the mysql root account. Bad idea to use this account in a php script. Lists wrote: I have a db in sql, and I need a php/mysql query/command to copy the entire db (schema and data) to a new db. I know how to do this with a table, but I can not figure

[PHP] Mysql question

2003-11-18 Thread Lists
I have a db in sql, and I need a php/mysql query/command to copy the entire db (schema and data) to a new db. I know how to do this with a table, but I can not figure out how to do this with a whole db. I also know that I could do it using mysql dump, but I don't want to have to run a shell c

Re: [PHP] mysql question

2002-10-30 Thread 1LT John W. Holmes
: "scott" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 30, 2002 3:43 PM Subject: [PHP] mysql question > Very slightly OT but great minds here > > I have a table with two columns and I need to get all the items that are > not in the shop numb

[PHP] mysql question

2002-10-30 Thread scott
Very slightly OT but great minds here I have a table with two columns and I need to get all the items that are not in the shop number I select, with the exception of items that are in the shop number I select. Table Shopnumber item 1 orange 1

[PHP] mySQL question

2002-09-26 Thread drparker
I'm just starting to use PHP with mySQL, and I have a few basic questions. I've successfully created a mySQL database on my local machine, was able to create tables and populate them (from the command line), query it with php from the browser, etc - no problems there. Now I need to create one on

Re: [PHP] mysql question

2002-07-26 Thread Tech Support
hristian Calloway" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 26, 2002 3:30 PM Subject: [PHP] mysql question > Sorry this may be a little offtopic, but I am currently moving a site I was > developing from coldfusion+MSAccess to PHP+MySQL. I remembered rea

[PHP] mysql question

2002-07-26 Thread Christian Calloway
Sorry this may be a little offtopic, but I am currently moving a site I was developing from coldfusion+MSAccess to PHP+MySQL. I remembered reading somewhere that there is a utility that will convert/transfer (data and structure) a MSAcess database to Mysql, and vice versa. Anyone know? Thanks Chr

Re: [PHP] mysql question

2002-07-26 Thread Lowell Allen
> From: "Christian Calloway" <[EMAIL PROTECTED]> > > Sorry this may be a little offtopic, but I am currently moving a site I was > developing from coldfusion+MSAccess to PHP+MySQL. I remembered reading > somewhere that there is a utility that will convert/transfer (data and > structure) a MSAcess

Re: [PHP] mysql question

2002-07-12 Thread Alberto Serra
ðÒÉ×ÅÔ! John Holmes wrote: > Gesundheit >>*if* that was on Oracle *and* the table was big you'd notice that your >>performance goes down. Don't ask me why. And I never checked it on >>MySql. But watch out for betweens. Check them. > > Yes, good point. I don't know if it matters in MySQL either, b

RE: [PHP] mysql question

2002-07-11 Thread John Holmes
> ðÒÉ×ÅÔ! Gesundheit > 1LT John W. Holmes wrote: > > How about > > > > SELECT * FROM table WHERE $current_shot BETWEEN start_shot AND end_shot > > *if* that was on Oracle *and* the table was big you'd notice that your > performance goes down. Don't ask me why. And I never checked it on > MySql.

Re: [PHP] mysql question

2002-07-11 Thread Alberto Serra
ðÒÉ×ÅÔ! Alexander Ross wrote: > I realize this isn't a php question, but I figured that someone here knows > of a good mysql newsgroup and in the mean time someone here probaby knows > the answer to my question. > > Can I set up a query like this: > > select * from table where start_shot <= $cu

Re: [PHP] mysql question

2002-07-11 Thread Alberto Serra
ðÒÉ×ÅÔ! 1LT John W. Holmes wrote: > How about > > SELECT * FROM table WHERE $current_shot BETWEEN start_shot AND end_shot *if* that was on Oracle *and* the table was big you'd notice that your performance goes down. Don't ask me why. And I never checked it on MySql. But watch out for betweens

Re: [PHP] mysql question

2002-07-11 Thread 1LT John W. Holmes
ohn Holmes... - Original Message - From: "Miles Thompson" <[EMAIL PROTECTED]> To: "Alexander Ross" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, July 11, 2002 12:24 PM Subject: Re: [PHP] mysql question > Yes, though I'd probably add

Re: [PHP] mysql question

2002-07-11 Thread Miles Thompson
Yes, though I'd probably add parentheses to make it clearer. select * from table where ((start_shot <= $current_shot) and (end_shot >= $current_shot)) Though that's probably not necessary. Make certain you have your less than's and greater thans set the right way, I've often sat slack-mouthed

[PHP] mysql question

2002-07-11 Thread Alexander Ross
I realize this isn't a php question, but I figured that someone here knows of a good mysql newsgroup and in the mean time someone here probaby knows the answer to my question. Can I set up a query like this: select * from table where start_shot <= $current_shot and end_shot >= $current_shot not

RE: [PHP] MySQL question

2002-04-21 Thread .ben
echo "\n"; echo " $myrow[0]\n"; echo " $myrow[1]\n"; echo "\n"; } echo "\n"; ?> hth, .ben > -Original Message- > From: Mantas Kriauciunas [mailto:[EMAIL

[PHP] MySQL question

2002-04-21 Thread Mantas Kriauciunas
Hey PHP General List, Amm... can anybody point me to some good tutorial that talks about SELECT from detabase? what i need is ... like i have table with lots of rows and i need to output them all to the page... it goes like most of news sections in the page... thanks for help. (i ne

[PHP] mysql question --

2002-04-12 Thread Jason Caldwell
does anyone know how to copy a tables structure (only) within mysql? thanks. jason -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] RE:[PHP] mysql question

2002-04-08 Thread Julian
Thanks James! It is the perfect answer for my cuestion!!! Regards! Julian - Original Message - From: James E. Hicks III To: Julian ; [EMAIL PROTECTED] Sent: Monday, April 08, 2002 5:12 PM Subject: RE: [PHP] mysql question Why don't you just increment a counter as yo

RE: [PHP] mysql question

2002-04-08 Thread James E. Hicks III
){ extract($row); $rowcounter++; echo("You are on Row $rowcounter wich contains the"); echo(" data $some_data for the field named some_data"); } James -Original Message- From: Julian [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 3:59 PM To: [EMAIL PROTECTED

Re: [PHP] mysql question

2002-04-08 Thread Miguel Cruz
On Mon, 8 Apr 2002, Julian wrote: > I want to know if there is a function to know which is the number of the row > that I selected. Not in MySQL. You should add an auto_increment index field to your table, and then you can always use that to see where you are. miguel -- PHP General Mailing

RE: [PHP] mysql question

2002-04-08 Thread Rick Emery
mysql is a relational database. therefore, the concept of a row number is irrelevant. that said, what do you REALLY want to do -Original Message- From: Julian [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 2:59 PM To: [EMAIL PROTECTED] Subject: [PHP] mysql question Hi!!! I

[PHP] mysql question

2002-04-08 Thread Julian
Hi!!! I want to know if there is a function to know which is the number of the row that I selected. Please, help me! Julian -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] mysql question

2002-03-19 Thread Hiroshi Ayukawa
Hello, The length of VARCHAR must be specified like; CREATE TABLE sailordata ( sailorid INT(8) NOT NULL DEFAULT 0, lastname VARCHAR(255) NOT NULL, firstname VARCHAR(255) NOT NULL, middlenames VARCHAR(255) NOT NULL, dob VARCHAR(255) NOT NULL, telephone VARCHAR(255) NOT NULL, fa

[PHP] mysql question

2002-03-19 Thread Denis L. Menezes
Hello friends, Can someone tell me what is wrong with the foll script? CREATE TABLE `sailordata` (`sailorid` INT(8) DEFAULT '' NOT NULL, `lastname` VARCHAR NOT NULL, `firstname` VARCHAR NOT NULL, `middlenames` VARCHAR NOT NULL, `dob` VARCHAR NOT NULL, `telephone` VARCHAR NOT NULL,

Re: [PHP] MySQL question...not sure if this is the correct forum to ask.

2002-02-14 Thread DL Neil
Peter, > I have a quick MySQL question...if this is not the correct forum for > it, then someone please point me to the right one. > > Can the UPDATE statement have conditional check embedded in it? I > have a page that displays a record (in a FORM format) that the user can > change the inf

[PHP] MySQL question...not sure if this is the correct forum to ask.

2002-02-14 Thread Peter Ruan
Hi, I have a quick MySQL question...if this is not the correct forum for it, then someone please point me to the right one. Can the UPDATE statement have conditional check embedded in it? I have a page that displays a record (in a FORM format) that the user can change the information on each

Re: [PHP] Mysql question

2002-02-06 Thread Emiliano Marmonti
AIL PROTECTED]> To: Emiliano Marmonti <[EMAIL PROTECTED]> Date: Wednesday, February 06, 2002 12:45 PM Subject: Re: [PHP] Mysql question > >This is really a question for a MySQL mailing list, not a PHP list since >this question has nothing to do with PHP. You can email the M

[PHP] Mysql question

2002-02-06 Thread Emiliano Marmonti
I have a site using PHP & Mysql. About a month ago to now one of the tables gets corrupted with the message Got Error 127... I fix it and everything works OK, except every time I loose 1 record. Today I could obtain mysql.err from the machine and I could see whenever an error is produced by date,

[PHP] Re: Newbie PHP/MySQL Question

2001-12-06 Thread Peter van der Maas
Think i figured out my problem...next time i will RTFM!!! Sorry! "Peter Van Der Maas" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Ok, Im' pretty new at this, but I can't see what may be wrong here: > > Table IMT > - > User (char) > Se

[PHP] Newbie PHP/MySQL Question

2001-12-06 Thread Peter van der Maas
Ok, Im' pretty new at this, but I can't see what may be wrong here: Table IMT - User (char) SessionID (char) StartTime(TIMESTAMP) EndTime(TIMESTAMP) Code on first page: INSERT INTO IMT VALUES ('testuser', '$id', CURRENT_TIMESTAMP, '/0'); Code on second page: UPDATE IMT SET E

[PHP] Re: [PHP-DB] PHP/MySQL Question

2001-11-19 Thread RNie
Look at the MySQL manual that came along with it when you downloaded it: manual.html#String_comparison_functions or manual.html#Comparison_Operators May be that helps you. René www.comunica2.net -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] F

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

[PHP] MySQL question

2001-10-05 Thread Georgie Casey
I have a table set as auto_update for the primary ID field, but sometimes the PHP script adds fields which don't fill up all of the ID numbers, as I delete a few records manually. is there any way to ensure all primary id field nos. are filled up is this a potential problem -- Regards, Georgie Ca

  1   2   >