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:h

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 exp

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 arc

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 ---

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:/

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? th

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

Re: Another PHP/MySQL question

You have a problem with "... " is reserved word, put \ before it... try this: $sql = "select id, siteurl, sitename, from sitesats where validated = \"$validated\""; regards, Augusto On Sun, 10 Jun 2001, Vladimir Kravtsov wrote: > > > > connectdb(); > mysql_select_db(xtopsites); > $valid

Re: PHP + MySQL question

you can use fetch_array: $data = mysql_query("select * from Categories"); $aux=""; while ($row = mysql_fetch_array($data)) { $aux.="".$row['Name'].""; } $aux.=""; echo $aux; this code will print in html a combobox with the options, in php, the variable "$catagorie" will have the "id" number o

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, Jai

Encode/Decode Problem

"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