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 images
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
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
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,
@lists.php.net
Sent: 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
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
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 doing wrong with the code below? It
keep returning unsuccessful.
Why
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
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 oiyan...@yahoo.ca wrote:
Hi all
Do you know any websites for mysql question?
I do submit the mysql forum but I would
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
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
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
La Chapelle
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's a single field
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 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've
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.
--
/Dan
Daniel P. Brown
Senior Unix Geek
? while(1) { $me = $mind--;
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;
}
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 object.
no, its the
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_assoc().
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();
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 using.
Yep,
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) {
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) {
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 database server, comparing the query plan
to
the actual code
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
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
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
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 mySQL
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
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 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 sure why, but i
-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, Andrew Ballard [EMAIL
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
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
[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
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
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
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.4
?
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 to connect to MySQL I get the Fatal error
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
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
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
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.
?
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.
On Mon, 20 Sep 2004 15:17:33 -0700, AMC [EMAIL PROTECTED] wrote:
? php
change that for ?php and try again
--
Victor Saldaña D.
User #330054 counter.li.org
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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?
?php
$user = aclark;
$host = localhost;
$password = ajaxx;
$database = corrigent;
$connection = mysql_connect($host, $user, $password) or die(can't open
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?
?php
$user = aclark;
$host
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?
?php
$user = aclark;
$host =
Sorry, MySQL question. Any takers? If I search for 'margaret atwood', I get results in
no real structured heirachy. Any thoughts?
SELECT ST,BT,AT FROM ccl_main WHERE MATCH (ST,BT,AT) AGAINST ('margaret atwood' IN
BOOLEAN MODE);h1Search font color=blueccl.ccl_main/font For: font
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
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
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
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
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 but does
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
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
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
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
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
: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 could do
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,
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
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 I
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
: 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 number I select, with the exception of items
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
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 database
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
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 reading
somewhere that there is a utility
ðÒÉ×ÅÔ!
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, but
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
note
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
...
- 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 parentheses to make it clearer.
select * from table where
ðÒÉ×ÅÔ!
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.
ðÒÉ×ÅÔ!
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 =
ðÒÉ×ÅÔ!
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. But watch
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
;
}
echo /table\n;
?
hth,
.ben
-Original Message-
From: Mantas Kriauciunas [mailto:[EMAIL PROTECTED]]
Sent: 22 April 2002 01:07
To: PHP General List
Subject: [PHP] MySQL question
Hey PHP General List,
Amm... can anybody point me to some good tutorial that talks about
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
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
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
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
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]
Subject: [PHP] mysql question
Hi!!!
I want to know
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 you
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,
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,
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
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
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,
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 MySQL mailing
list at [EMAIL
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
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)
SessionID
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]
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 functions
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
1 - 100 of 116 matches
Mail list logo