[SOLVED] Can't understand why it won't work!

[seabro]

The following script was working on another server but stopped working when I moved to new server. 

 

The script returns Test 1 but not Test 2.  It is dying at the line beginning $connect...  I even commented out the Die() but that didn't help. 

 

Why won't it get past $connect?

 

Assistance appreciated.

 

<h1>Select Report Date</h1>

<?php

echo "test 1";

$connect = mysql_pconnect("localhost","user","pass"); //  or Die("connect failed");

echo "test 2";

echo $connect;

$selectdb = mysql_select_db("asterisk") or Die("select failed");

echo $selectdb;

$query  = "SELECT DISTINCT date_format(calldate,'%Y-%m-%d') as new_date from cdr ORDER BY new_date DESC LIMIT 50 ";

echo $query;

$connect;

$selectdb;

mysql_query($query) or die ("query x failed");

$res = mysql_query($query,$connect) or die("failed");

echo $res;

print"<table align='center' border='1' cellspacing='0' cellpadding='5'>";

print "<tr>";

 

print "<td align='center'>";

print "Date";

print "</td>";

 

print "</tr>";

 

while($qry = mysql_fetch_array($res)) {

 

$calldate=$qry["new_date"];

 

print "<tr>";

print "<td align='center'>";

print "<a href='incoming2.php?date=";

print "$calldate'>";

print "$calldate";

print "</a>";

print "</td>";

 

};

?>

[ILMV]

What's the error?

[MasterACE14]

change this line...

$connect = mysql_pconnect("localhost","user","pass");

to...

$connect = mysql_pconnect("localhost","user","pass") or die(mysql_error());

and see what it says then.

[seabro]

I did this and there is still no error at all.  The only thing on my page is the text between the H1 tags and test 1.

 

The script is stopping at $connect=.........

 

For the record I have tried a echo phpinfo() and that works and I have logged into the mysql database from the command line using the dbasename, username and password from the script.

 

I have also change the localhost to 127.0.0.1 but get same result.

 

I am baffled.. any more ideas?

[mayfair]

what happens if you change

 

$connect = mysql_pconnect("localhost","user","pass") or die(mysql_error());

 

to

 

$connect = mysql_connect("localhost","user","pass") or die(mysql_error());

[seabro]

what happens if you change

 

$connect = mysql_pconnect("localhost","user","pass") or die(mysql_error());

 

to

 

$connect = mysql_connect("localhost","user","pass") or die(mysql_error());

 

 

No change / no error unfortunately.

[Pickle]

don't add or die(mysql_error()); to the end of all mysql queries.

 

Read this page: http://www.phpfreaks.com/blog/or-die-must-die

[seabro]

any more ideas on this one people?

 

I looked in /var/log/mysql - nothing relevant.

 

is there a PHP log?

 

Any more troubleshooting I can do?

 

I appreciate your help.

[seabro]

I tried from command line..

 

Does the following help troubleshoot or is it to be expected when execute from command line?

 

[root@localhost ~]# php /var/www/html/stats/incoming.php

Content-type: text/html

X-Powered-By: PHP/4.3.9

 

<H1>Report Date</H1>

PHP Fatal error:  Call to undefined function:  mysql_pconnect() in /var/www/html/stats/incoming.php on line 3

[root@localhost ~]#

 

[Pickle]

hi

 

have you tried

 

$connect = @mysql_connect

 

 

[seabro]

FIXED!

 

Thanks for all your help.

 

After I saw the error on the command line (that I wasn't seeing on my web page). I did some searching and one of the troubleshooting measures was

 

Check if the php-mysql package is installed by opening a terminal window (bash), and typing, rpm -qa | grep php. If you don't see it, make a note of the exact version of PHP that is installed.

 

I did this and I did not see php-mysql

 

So I did yum install php-mysql, restarted apache and it all worked.

 

sorry if I wasted anyones time I am a relative newbie.

 

 

(I thought having PHP and MySQL installed was enough but there is obviously this php-mysql that glues them together).