MySQL lost connection

2003-11-19 Thread John Cole
hi, I installed MySQL 4.0.16-nt on a Win2000 Pro platform. I want to implement a multi-table delete, so i type following SQL statement: Delete from tablea, tableb using tablea, tableb where tableb.number=2 and tableb.number=3; the server down and generate following message: `Mysql-nt has gener

MySQL connection with PHP

2003-09-24 Thread John Cole
hello, i am learning PHP and MySQL recently, i use PHP to connect to MySQL server, however, an error occur: "Fatal error: Call to undefined function: mysql_connect() in /var/... on line 2" Following is the PHP program: 1 "; 7 $result2 = mysql_list_tables($db_data[0]); 8 $num_rows2 = mysq

Dynamic output detail menus from a MySQL output page.

2002-10-13 Thread John Cole
in dabase1)a (onMouseOver) etc. Does anyone know of how to do this? btw, I have Apache and PHP installed on this server as well so if I can use PHP instead of Javascript that would be ok too. SQL, QUERY Thanks, John Cole Help Desk Administrator Lockheed Geor

Querying from a script.

2002-09-20 Thread John Cole
h1 = mysql_query($query_search1, $CATCH) or die(mysql_error()); $row_search1 = mysql_fetch_assoc($search1); $totalRows_search1 = mysql_num_rows($search1); - Does anyone have any ideas? Thanks, John Cole, TCISA Disclaimer: The information contained in this email is proprietary and conf

Syslog and MySql

2002-09-05 Thread John Cole
X firewall logs. Any ideas? Thanks, John Cole, TCISA Disclaimer: The information contained in this email is proprietary and confidential. It is intended solely for the use of the person identified and intended as the recipient. This document is forwarded to you in such a form (E-mail) that LGEFCU c