Countries, cities, states database
Hi, I searching for a database, with the 'complete' world Countries, cities, states Just like http://www.datingplace.com/servlet/NewRegistration I need for an academic study. Thanks, Augusto -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Minutes Between Dates
HelpHi.
I'm using the timestamp format (AAMMDDHHMMSS) on my session.
how can I know the minutes between two dates.
I'm doing:
=20
$date =3D $row_secao['date'];
$date_now=3Ddate(ymdHis); =20
$x=3D$date_atual-$date;
if ($x 1000) {
echo Session expired.; =20
}
=20
but I have a problem when turns the hour, like this:
date=3D010803105958
date_now=3D010803110518
the sub is 4500 (45 minutes!), but in fact, the real time between is 6 =
=20
minutes...
is there any function in mysql that does it?
thanks.
Augusto
Select
HelpHi. I have a colun in my table for the birthday.: DD/MM/. It's varchar. In PHP, I can get the month of date, bu substr($date, 3, 2). (MM) Can I do a select with %LIKE% but saying the position of the varchar I want to find? thanks. Augusto
Getting the number of years between two dates
It's possible get the number of years between two dates in a mysql function? thanks, Augusto - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How can I know the version of mysql running on Linux (RedHat 6.2)
How can I know the version of mysql running on Linux (RedHat 6.2) thanks, Augusto - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Put mysql data from linux in Win98 mysql
I tried to put the data (.frm, .ISD and .ISM files) of my Linux into windows 98 put I can't use the data. When I open phpadmin2, he show how many registrys I have, but When I try to use/list the table is empty. Can I solve this problem? I need to use mysqldump to put the data into windows 98? thanks, Augusto - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
transfering data
How can I transfer the data from a MySQL 3.22.32 running on RedHat 6.2 Linux to a MySQL 2.23.37 running on Windows 98? thanks, Augusto - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql.sock error
I'm receiving the following error: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /home/httpd/html/phpadmin2/lib.inc.php on line 119 what could be? thanks, Augusto - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP + MySQL question
you can use fetch_array:
$data = mysql_query(select * from Categories);
$aux=select name=categorie;
while ($row = mysql_fetch_array($data)) {
$aux.=option value=,$row['id']..$row['Name']./option;
}
$aux.=/select;
echo $aux;
this code will print in html a combobox with the options, in php, the
variable $catagorie will have the id number of a categorie...
see you,
Augusto
On Sun, 10 Jun 2001, Vladimir Kravtsov wrote:
Here is my db hierarchy:
Database: xtopsites
Table: Categories
idName
1Name1
2Name2
3Name3
4Name4
5Name5
6Name6
I would like the user to get to a sign up form and have all the names of the
categories displayed.is this possible to do using fetch_array? If it isn't is
there another way? (Also could you provide a valid syntax?)
Thanks alot :)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help with select
Let me see if I understood your question: select * from tablename a, tablename2 b where a.account='BILL' and a.account=b.account It's tow tables or just one table? because if it's just one table just do select * from tablename where account='BILL' see you, Augusto On Sat, 9 Jun 2001, Jaime Teng wrote: Hi How do I perform this query using one operation? SELECT * FROM tablename WHERE account = (select account from tablename where name='BILL'); What I want is to lists all entries who's account is the same with 'BILL'. Thus far, what I know is to extract the account of 'BILL' and then perform another select of entries with the same account. I already tried: select * from user u, user r where r.account=u.account and r.name='BILL'; i got no result but no error. jaime database,sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Encode/Decode Problem
I'm using encode/decode with PHP to crypt my database. Until now was OK, but I one string, and the MySQL return the string this (without the []...): [Oõ#M¼ô«~àý~ªÔbë ÿ9S Z ] The fact is I can't insert this encode string into MySQL table! My select: select decode(Oõ#M¼ô«~àý~ªÔbë ÿ9S Z , lPi1QzB5%!.dC;@); I have a in the middle of the encoded string. How can I solve this problem? regards, Augusto Cesar Castoldi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
