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
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
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
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
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
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
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
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'
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
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
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) {
>
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) {
>
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
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
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
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
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;
}
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
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.
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
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
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
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";
>
>
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";
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
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
>
> 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
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.
-
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
: "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
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
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
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
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
> 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
ðÒÉ×ÅÔ!
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
> ðÒÉ×ÅÔ!
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.
ðÒÉ×ÅÔ!
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
ðÒÉ×ÅÔ!
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
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
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
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
echo "\n";
echo " $myrow[0]\n";
echo " $myrow[1]\n";
echo "\n";
}
echo "\n";
?>
hth,
.ben
> -Original Message-
> From: Mantas Kriauciunas [mailto:[EMAIL
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
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
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
){
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
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
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
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
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
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,
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
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
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
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,
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
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
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
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
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 - 100 of 121 matches
Mail list logo
