[SOLVED] Queries doen't appear until I refresh the page

[theblokgroup]

I am entirely baffled by this problem.  I have created a basic php script that queries a mysql database and

displays the information using a while loop.

 

Sometimes, when a user visits the website page, none of the queries show

up but once you refresh the page, they appear.

 

I have modified max_connections in my.cnf, that is not the problem.  I

have also tried recoding it, that didn't help.  Any suggestions would be

great!

 

I have also turned on all errors in PHP and there are no errors showing up.

 

Specs: Dedicated Fedora Server, Plesk Control Panel, 4GB RAM, 16-GB Storage, MySQL 5.0.45, PHP 5.2.6

 

 

Here is the connection string and code (there is also an attached image that displays what is happening - notice recent jobs, blogs and events are blank):

 

<?php $connection = mysql_pconnect('', '', '', $new_link= true) or die('MySQL Connection Error: The Connection String Malfunctioned.');

mysql_select_db('') or die ('MySQL Connection Error: Cannot connect to the DB: '.mysql_error() ); ?>

 

<?php

$sqlrecc = mysql_query("SELECT * FROM events WHERE active = '1' AND home =

'1' ORDER BY first_date ASC LIMIT 5");

while($rowrecc = mysql_fetch_assoc($sqlrecc))

{

echo "<p><a

href=\"viewevent.php?id=".$rowrecc['id']."\">".ucwords($rowrecc['event_name'])."

»</a><br />";

echo

ucwords($rowrecc['event_date'])."<br/>".ucwords($rowrecc['location'])."</p>";

}

?>

 

 

[attachment deleted by admin]

[fenway]

Stop using persistent connections.

[theblokgroup]

Tried that, same result.  Whether it is persistent or non, hasn't made a difference.

[Ken2k7]

Do you know if the SQL runs upon first visit?

[theblokgroup]

Ken2k7... It runs upon first visit about 70-75% of the time.  If you set the screen aside for about 5 mins, come back to it and refresh, the queries go blank.  Here is a link to the page:  http://www.latinograduate.com/index.php

[Ken2k7]

Why does it run only 70-75% of the time?

[Potatis]

Do you have any session code on this page at all?

[theblokgroup]

Ken2K...  That is what I am trying to figure out.

 

Potatis... there is only a session_start(); at the top.

[Ken2k7]

Can you post the script rather than that snippet at the top? I think this  is more PHP-related than it is MySQL-related.

[fenway]

Can you post the script rather than that snippet at the top? I think this  is more PHP-related than it is MySQL-related.

We frown upon posting entire scripts... that's never the answer.  And if it's php-related, then it doesn't belong on this board.

[theblokgroup]

Hi All, we found the problem.  There were two connection strings, one serving our ad server and the other our content.  We didn't specify in the content which connection to use.  It is now working fine.