Brian E Boothe wrote:
i'm needing assistance in table Cell color thru MySQL
i have a project were im listing a projects in a table either Complete
/ Active / Pending / now im needing these refrances cells to change
Color whenver its lists them out on a page,
[Complete] = green[Active] =
Daevid Vincent wrote:
I have a SQL challenge I'm not sure how to solve. But it's so common, I feel
kind of stupid asking this...
I have a 'user' table with 'login_date' which is an auto updated DATETIME
column and a 'created_on' which is a DATETIME (but not updated after the
record is created th
nd my last
question (which no one answered by the way :) )
Respectfully,
Ligaya Turmelle
--
life is a game... so have fun.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
*Disclaimer - this will be kind of vague mainly because I only vaguely
recall the material.
I am trying to create a stored procedure. Now I vaguely recall reading
something that says I have to match a column type if I am messing with
one. Something like I want to match a table column type...
Grzegorz Smith wrote:
Hi all. In my apps I use two languages: english and my national polish.
Translates i keep in MySQL 5.0 in text field (MyISAM engine) with utf8
encodings. I don't know why but i can get polish translates from databes
properly, my national character are seen from webb like sig
the study guide?
Adrian Bruce wrote:
Hi
Does anybody know where i can get a load of sample questiosn for the
MySQL certificate exams, i know there are a few on mysql's site but i
was hoping to find quite a few to practice on.
Thanks
Ade
--
life is a game... so have fun.
--
MySQL Gene
remove the @ - it surpresses the errors. set your error_reporting to
E_ALL and find out the DB error message with mysql_error.
error_reporting(E_ALL);
$SvrConn = mysql_connect($MySQLServer, $MySQLUser, $MySQLPassword);
if(!$SvrConn)
{
echo 'Failure to connect! Error message returned: '.mysql
google on any and all: codewalkers, phpfreaks, sitepoint, zend, onlamp,
devnetwork, phpbuilder, and of course look at all their manuals/docs.
Jon Miller wrote:
Does anyone know of some good tutorial sites of using Apache, PHP and MySQL.?
Just starting out and want to create a website (mine) w
A couple of good links for databases.
Database Design (quick and dirty, but gets the points across):
http://www.geekgirls.com/menu_databases.htm - the from scratch side
SQL:
Basics: http://www.sqlcourse.com (you probably already know this stuff -
but just in case.
semi-Advanced: http://s
SET v = v + 1;
IF v >= 5 THEN
LEAVE loop_label;
END IF;
END LOOP;
END; //
--
Respectfully,
Ligaya Turmelle
"Life is a game so have fun"
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
procedure has the
authority/permissions to do everything in it and runs or not based on
that
--
Respectfully,
Ligaya Turmelle
"Life is a game so have fun"
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.
everything in it and runs or not based on that
--
Respectfully,
Ligaya Turmelle
"Life is a game so have fun"
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ables within the same database have to overlap (same field name) in order
for joins to work? I'm currently naming fields in such a manner:
TABLE1
table1_alpha
table1_bravo
TABLE2
table2_firstname
table2_lastname
Appreciate any guidance on these two questions.
Cheers
--
Respectful
a database. Visualization would be nice
too, so that I could quickly see the relations
between tables.
__
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
--
Respectfully,
Ligaya Turmelle
"Life is a
dle ground. Is
there anywhere I can go to get a reasonable working knowledge of database
design just so I can get started with the task I have been given. In the
meantime I can make my way through this book.
So, where do I go to learn about the initial design, seeing as it is so
crucial?
--
Respe
setting mysql charset to utf-8, and beside making sure the data
> is encoded in utf-8 properly (which i think i did), what else do i
> need to do on the programming level?
> or could i have done wrong in some of the steps?
> or could i have not done some necessary steps to work with
in the docs - column types:
http://dev.mysql.com/doc/mysql/en/column-types.html
Respectfully,
Ligaya Turmelle
Mohsen Pahlevanzadeh wrote:
Dear,I need to MySQL data type or another.
But i dont know name of their header file.
Please guide me..
Yours,Mohsen
--
MySQL General Mailing List
For
1):
mysql> SELECT * FROM table LIMIT 5,10; # Retrieve rows 6-15
[/quote]
Respectfully,
Ligaya Turmelle
Aji Andri wrote:
here a syntax
$query=&$conn->Execute("select * from itemlocation
where id limit 1 - 50");
$result=mysql_query($query);
$num_result=mysql_num_rows($result);
and
I'm a beginner - but can't you also use mysqlimport?
Respectfully,
Ligaya Turmelle
Tom Crimmins wrote:
[snip]
I am doing backup for tables using Mysqldump. But while doing the restore I
am not able to do that using the same Mysqldump. Could you please help me in
that.
[/snip]
mysqld
those links help you because I do not understand your question.
Respectfully,
Ligaya Turmelle
---
Life is a game... so have fun.
---
www.PHPCommunity.org
Open Source, Open Community
Visit for more information or to join the movement
Dave Dyer wrote:
Is there a trick to remember the sort order? I wa
Have you tried posting this to the PHP general mailing list?
Respectfully,
Ligaya Turmelle
---
Life is a game... so have fun.
---
www.PHPCommunity.org
Open Source, Open Community
Visit for more information or to join the movement
Fernando F. Retagi wrote:
Hi All!
I have installed mysql 4.0.20
Looks good to me but I'm a relative beginner. Maybe another option -
make Spanish, English, and German tables, then link those to the main
table. This however can slow you down if you are doing multiple reads
of the various tables.
Respectfully,
Ligaya Turmelle
Graham Anderson wrote:
I
Think I found it. I made the changes with explanations of what I did.
If you have any further questions feel free to ask. Oh and this should
be on the list for others to see and maybe learn from
Respectfully,
Ligaya Turmelle
[DATABASE CONNECTION
a2 F
WHERE (C.Nationality is not null)
AND (F.IDArea = \'eur\')
ORDER BY ' . {$_POST['order']} . ',' . {$_POST['direction']};
and try it again. Note the variables are outside the string and
surounded by brackets.
Respectfully,
Ligaya Turmelle
Michae
sibilities.
Respectfully,
Ligaya Turmelle
Yahoo Default User wrote:
Hi Guys,
I have a problem with MySQL in conjunction with PHP so
I also decided to post here:
I have a PHP script that contains two consecutive
MySQL queries, something like this:
Query 1: Delete some rows from Table A
Query 2: Insert
Don't know a whole lot about this but - Is the data escaped when you
inserted it? Maybe one of these options for the mysqldump would help
--fields-enclosed-by=...
--fields-optionally-enclosed-by=...
--fields-escaped-by=...
or
--set-charset ...
Respectfully,
Ligaya Turmelle
Juan Alvarado
Why not set the table to -
CHARACTER SET utf8;
Respectfully,
Ligaya Turmelle
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I am just beginning down this roadso the answer may be obvious
>
> Is there an efficient way to design a database where the table data
&g
Why not set the DB character set to utf8 and probably cover all of them?
CHARACTER SET utf8;
Respectfully,
Ligaya Turmelle
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I am just beginning down this roadso the answer may be obvious
>
> Is there an efficient
comfortable
doing it.
To get a stronger idea though of your design I would need to see either a
logical ER diagram or all of the creates (I am very visual so I like
pictures). *shrugs* whether or not you want to pass those along is up to
you.
Respectfully,
Ligaya Turmelle
""Robert A. Rosenberg
"I want to make an exact copy named "works2.""
what about
INSERT INTO table1 (table1Columns)
SELECT table2Columns FROM table2;
"David Blomstrom" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> --- Schalk <[EMAIL PROTECTED]> wrote:
> > I would suggest exporting your current datab
are you using:
INSERT INTO
SELECT
FROM ;
I am still a relative beginner and this was the way I was taught. I have
personally never had a problem (but then I was using Oracle in school).
Respectfully,
Ligaya Turmelle
"David Blomstrom" <[EMAIL PROTECTED]> wrote
doing it). I
noticed that you CCODE in the Nations table wasn't the same size as in the
Continent table. Fixed that.
Good luck!
Respectfully,
Ligaya Turmelle
"David Blomstrom" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> OK, I've made some cha
Don't quote me on this but I don't think it makes a difference what
datatypes you use with multiple languages (I never even considered it with
English, Japanese and Korean) as long as the field is large enough to handle
the multiple bytes. You might wish to check out the Unicode support pages o
Only way I know of is to write a program for it. But I am a beginner.
Respectfully,
Ligaya Turmelle
"beginner" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
> i just created a db with around 30 tables and i need
> to populate it. Is there any soft
Don't foreign keys need to be explicitly indexed?
Respectfully,
Ligaya Turmelle
"saiph" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
> hi list,
>
> i'm studing foreign keys but my sql code does not react as
> would imagine when i inse
stuff.
Hope that helps.
Respectfully,
Ligaya Turmelle
""SeeNewIdeas"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Hi Rhino,
What I was referring to was the mySQL statements. I'm working on redoing
the form so there is no problem there, it is how to
Check out DISTINCT.
Respectfully,
Ligaya Turmelle
""Clive Luk"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Use
>
> Select * from a
> Group by [your_field_name]
>
> -Original Message-
> From: nullevent [mailto:[EMAIL PR
sounds like you need a join.
Select * from Poll, poll_votes where (Poll.poll_id = poll_votes.poll_id) and
(poll_votes.user_ID = WHATEVER);
But I'm still a beginner so
Respectfully,
Ligaya Turmelle
""Anders Gjermshus"" <[EMAIL PROTECTED]> wrote in mess
Maybe something like:
Select LIKE pkg_name%, LIKE site_%, version from table group by LIKE
pkg_name% , LIKE site_%;
but I'm still a beginner.
Respectfully,
Ligaya Turmelle
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hello all,
>
> I've a tab
Or all the values in Tuesday?
(SELECT DAYNAME('2004-03-23') FROM inventoryRoom;) Please clarify.
Respectfully,
Ligaya Turmelle
""Yoed Anis"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
>
> I have a table that looks like this:
I'm a beginner so don't quote me. I beleive you need something like:
Select hs_identifiers.hs_id_num from hs_identifiers,
where (accession_num LIKE (result of another select statement)%);
I beleive that should give you the first part and if there is anything after
it.
Respectful
You're using a foreign key.
http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html. In order
for the constraints to work, the DB must be type InnoDB. Otherwise the data
checks for integrety must be done by you in the INSERT program.
Respectfully,
Ligaya Turmelle
"pramila
Can I use LIKE in an UPDATE statement when it is not in the WHERE clause?
I only know what the attribute name will end with (may be prefixed).
Example:
UPDATE table SET LIKE '%donut' = valueColumn1 WHERE condition1 = value1;
Respectfully,
Ligaya Turmelle
--
MySQL General Mailin
lly,
Ligaya Turmelle
PHPCommunity.org: Open Source, Open Community
For more information or to join the movement
www.phpcommunity.org
""Theodosios Paschalidis"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Hi all,
I was just testing if my utf8 table would res
ibute in
a table data .
Respectfully,
Ligaya Turmelle
"Seena Blace" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
> Does any one help me in formating the output result in PHP with mysql?
> The code is here.
>
>
> $username="root"
check into innodb and transactions
Respectfully,
Ligaya Turmelle
""Paul Higgins"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi everyone,
>
> I want to create a table that will consistently have data added and
removed
> from it. Is there
You might want to post this on the PHP user lists at news.php.net sub-group
php.general
Respectfully,
Ligaya Turmelle
""David Jackson"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I was wondering if I can user libmysqld with PHP.
>
> If it
ff with bgcolor = something else";
end if
echo "$col3";
make sense?
Respectfully,
Ligaya Turmelle
""CurlyBraces Technologies ( Pvt ) Ltd"" <[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
- Original Message -
From: CurlyBraces Technologies (
hphelp.com.
Respectfully,
Ligaya Turmelle
""Togochog Enhebatu"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> hi,
>
> I am new in PHP, and I would like to create some user interface with PHP.
> Could anyone tell me what is the easies
90% of the time you forgot the ";" on the line before the parse error. if
not then I would need to see the code to help you.
Respectfully,
Ligaya Turmelle
""Nitin Mehta"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
there must be some pro
ot; and "Multicolumn
output from a database with PHP". If you have questions on the PHP their
are multiple forums to go to for help. I personally use www.phphelp.com.
Good luck
Respectfully,
Ligaya Turmelle
""CurlyBraces Technologies ( Pvt ) Ltd"" <[EMAIL PROTE
version 4.1 and up are the versions to be unicode enabled.
Ligaya Turmelle
""Beau Hartshorne"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Hi,
I am about to start using UTF-8 for my internal data storage and display
for a CMS that I'm building. Are
ly
gives me the right info or if I would have to "tweek" it.
Respectfully,
Ligaya Turmelle
Computer Programmer
Guam International Country Club
495 Battulo Street
Dededo, Guam 96912
Tel: (671) 632-4445
Fax: (671) 632-4440
Reservations: (671) 632-4422 (GICC)
-Original Message-
From
Go here http://www.php.net/manual/en/function.mysql-field-type.php in the
PHP manual and you will find in example 1 how to get all the information
about a table. You can then pare it down just to get the information you
want.
Respectfully,
Ligaya Turmelle
""Luiz Rafael Culik Guimaraes
I am pretty new myself but can't you do it with a join? Like SELECT AVG(avg)
FROM table_a, table_b GROUP BY id_field.
Respectfully,
Ligaya Turmelle
""John McCaskey"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
First of all I am using mysql 4.0.18
You can set it as an alias using AS .
Respectfully,
Ligaya Turmelle
"James E Hicks III" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Isn't there a way to prefix (or postfix) a tables column names in the
results
> of a select. For example I have a tab
I have never done this but...
Go to your php.ini file and see if changing the [MySQL] mysql.default_host =
is set to the database.
Respectfully,
Ligaya Turmelle
-Original Message-
From: Eric W. Holzapfel [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 12:00 PM
To: [EMAIL
Boy do I feel dumb. :^)
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Monday, February 09, 2004 4:54 PM
To: [EMAIL PROTECTED]
Subject: RE: is it possible...
UPDATE EMAIL_TEST_LIST SET EMAIL_DATE = curdate();
-Original Message-
From: Ligaya Turmelle [mailto
Is it possible to have an update statement that uses curdate()?
Example:
UPDATE EMAIL_TEST_LIST SET EMAIL_DATE = "(SELECT curdate())";
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
set" options to
multiple character sets (EUC-JP, EUC-KR, and ISO-8859-1) rather then just
one. (I wish 4.1 was production right now and use UTF8)?
Respectfully,
Ligaya Turmelle
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is your host name "rh01"? That is supposted to be the host name
(www.rh01.com) or IP address(127.0.0.1). also try adding this:
$db_connection = mysql_connect ("rh01", "llama", "camel") OR die ("Could not connect to database. Please try
again later". mysql_error());
At the very least it will all
I noticed you got a lot of feed back. Another site to take a look at for php
is www.codewalkers.com. They have some excellent tutorials. And as a forum
to ask questions in I would recommend www.phphelp.com. I have been to
sitepoint and it is a good site but I prefer these for my php development.
L
Can anyone tell me what the current support for the UTF8 character set is?
How strong is it? Do I have to do anything special to save the characters?
I will be getting the characters from a webpage form and inserting the
characters with PHP.
--
MySQL General Mailing List
For list archives: htt
What has to be done to mysql to allow for the insertion and extraction of
Japanese and Korean characters? ( I will not be searching by them only
displaying and saving them.) Do I only have to have the set the "characater
set" in the table declaration or is there more to it? Also does the newest
v
there is no acknowledgement when a table is created. You don't find out
about it until you turn off the gui and restart it.
Respectfully,
Ligaya Turmelle
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
65 matches
Mail list logo