Further to this, I removed the "@" symbol and got:- Fatal Error: Call to undefined function: mysql_connect() in /var/www/html/results.php
@ $db = mysql_pconnect("localhost", "user", "password"); $db = mysql_pconnect("localhost", "user", "password"); Ideas ? Why is it now a undefined function ? Andrew -----Original Message----- From: Andrew Rich [mailto:[EMAIL PROTECTED]] Sent: Thursday, 25 April 2002 11:14 AM To: [EMAIL PROTECTED] Subject: PHP and MySQL help please ! + PHP Installed and going - I can write to files, retrieve flatfiles + Apache running servers outpages nop probes Trying to talk to SQL using PHP. ---------------------------------------------------------------------------- ---------- <html> <body> <h1>Go to SQL now</h1> <? echo "looking"; @ $db = mysql_pconnect("localhost", "user", "password"); if (!$db); { echo "Error: Could not connect to database. Please try again later."; exit; } mysql_select_db("test"); $query = "select * from logbook" ; $result = mysql_query($query); $num_results = mysql_num_rows($result); echo "<p>Number of books found: ".$num_results."</p>"; ?> </body> </html> ---------------------------------------------------------------------------- ------------- What gets me if I can do all this from the mysql prompt:- laptop>mysql -u user -p (enterpassword gets me in) mysql>use test; OK mysql>select * from logbook; OK (shows entries no probs); ---------------------------------------------------------------------------- ------------- What am I doing wrong ? It doesnt get past the @ $db = mysql_pconnect("localhost", "user", "password"); in the code. ?????????????? Andrew ------------------------------------------- Andrew Rich Callsign: VK4TEC [EMAIL PROTECTED] www.users.bigpond.com/andrew.rich/vk4tec.htm ------------------------------------------- Andrew Rich Callsign: VK4TEC [EMAIL PROTECTED] www.users.bigpond.com/andrew.rich/vk4tec.htm --------------------------------------------------------------------- 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