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:

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

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

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

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?

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)

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

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,

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

Encode/Decode Problem

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