Changing field size

I've a VARCHAR(4) field that I want to change to a VARCHAR(6) field. What would happen to the existing data in MySQL db? Thanks! Tony ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (t

Help w/ "join" syntax

When I call the following PHP script, $qry_1 doesn't work (No query # 1!). DONE"; flush(); exit; ?> Thank you! Anthony F. Rodriguez ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (th

Changed localhost?

All of a sudden Apache and MySQL are not running correctly under Windows 98. It appears that somehow localhost was changed from 127.0.0.1 to something else. Could the fact that I NOW have a 24/7cable connection to the Net cause the problem? Thanks! Anthony Rodriguez ([EMAIL PROTECTED

Plz help w/ query

The following query displays 0 e-mails. Why? Tbl con_inf holds 51 records w/ 51 usernames. Tbl scr_149 holds 37 records with 37 equivalent usernames of which 14 show date_done=0. Thanks! Anthony F. Rodriguez ([EMAIL PROTECTED]) ---

Plz help w/ php/MySQL

The following php script successfully e-mails both messages but it doesn't update in the table "scr_149" the column "notified". Why? \n"); $result_2=mysql_query($qry_2,$connection) or die ("No query # 2!"); }; mysql_free_result($result_1); $qry_3="select * from scr_149 where q05a=\"0\" && not

Going blind? Plz hlp w/ parse error

Please help! There is a parse error in line10: etc. Thank you! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thr