Hello,
Try this
<?
function samp_db_connect()
{
$hostname = "localhost";
$username = "joe";
$password = "user";
$dbName = "test";
$link = @mysql_pconnect($hostname, $username, $password);
if ($link && mysql_select_db($dbName))
return $link;
return FALSE;
}
samp_db_connect() or exit();
?>
good luck
Andrew Rich wrote:
> 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
---------------------------------------------------------------------
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
