PHP - Help With Code That Works On One Server But Not Another

This is mind bender. I recently upgraded from a VPS to a Dedicated server. The script is a data mining tool that primarily uses cURL. It worked flawlessy on the the VPS. Because it was the same hosting company everything was migrated and done so smoothly to the new dedicated.

Now, the program hangs for no reason at all. The times vary but I'll usually get about an hour of the script before it hangs. It used to run for hours at a time on the VPS.

While I do see some 'notices' and cURL timeouts - there are no error messages echoed out when the program hangs and there is nothing within the error log on the server to indicate anything in terms of why. The program simply 'freezes'.

I think I've spent the last three days modifying the php.ini file. Here are some settings which may be of interest?

post_max_size = 16M
log_errors = On
max_execution_time = 0; (From what I understand is unlimited).
max_input_time = 0   ;
memory_limit = 128M;

At the top of every page within my script:

set_time_limit(0);
error_reporting(E_ALL);

The dedicated is an 8 gig Linux box running Apache. Speaking of which, here are some settings within WHM for Apache:

Max Clients 500
Max Requests Per Child - 0 (unlimited)
Keep-Alive - On
Keep-Alive Timeout - 50
Max Keep-Alive Requests - Unlimited
Timeout - 1000

Because the script works on another VPS that I have within the same hosting company can someone direct me with what I should be looking for and/or comparing between both servers?

What are the most common reasons for a PHP script to freeze from a server setting standpoint?

Hi, I have

Code: [Select]
$to      = 'rberbe2002@msn.com';
$subject = 'the subject';
$message = 'hello';
$headers = 'From: webmaster@example.com';

mail($to, $subject, $message, $headers);
which works fine on a shared hosting website I have, but not on a website I have on my dedicated server.

Any ideas or suggestions please?

I am moving my website to a new Service Provider. The script I use for multiple updating worked on the older server but not on the new one. It shows the information but does not update the records.
Any help would be greatly appreciated.

Old Server   : PHP 5.2.11    MYSQL: 5.0.92-community
New Server : PHP 5.2.17    MYSQL: 5.1.47-community

Script:
<?php 

include("head.php");
$host="localhost"; // Host name
$username="xxxxxxx"; // Mysql username
$password="xxxxxxx"; // Mysql password
$db_name="xxxxxxx"; // Database name
$tbl_name="xxxxxxx"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
 
$sql="SELECT * FROM $tbl_name limit 20";
$result=mysql_query($sql);

// Count table rows
$count=mysql_num_rows($result);
?>
<title>PowerMan South Africa</title>
   <META HTTP-EQUIV="Pragma" CONTENT="no-cache">
   <META HTTP-EQUIV="Expires" CONTENT="-1">
   <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
   <link rel="stylesheet" href="style.css" type="text/css" media="screen" />
      <style type="text/css" media="screen,projection">
         @import url(calendar.css);
      </style>
 
 
      </head>
<table width="500" border="0" cellspacing="1" cellpadding="0">
<form name="form1" method="post" action="">
<tr>
<td>
<table width="500" border="0" cellspacing="1" cellpadding="0">


<tr>
<td align="center"><strong>ID</strong></td>
<td align="center"><strong>Company</strong></td>
<td align="center"><strong>contact</strong></td>
<td align="center"><strong>Email</strong></td>
<td align="center"><strong>Telephone</strong></td>
<td align="center"><strong>Type</strong></td>

</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td align="center"><? $id[]=$rows['id']; ?><? echo $rows['id']; ?></td>
<td align="center"><input name="company[]" type="text" id="company" value="<? echo $rows['company']; ?>"></td>
<td align="center"><input name="contact[]" type="text" id="contact" value="<? echo $rows['contact']; ?>"></td>
<td align="center"><input name="email[]" type="text" id="email" value="<? echo $rows['email']; ?>"></td>
<td align="center"><input name="telephone[]" type="text" id="telephone" value="<? echo $rows['telephone']; ?>"></td>
<td align="center"><input name="type[]" type="text" id="type" value="<? echo $rows['type']; ?>"></td>
</tr>
<?php
}
?>
<tr>
<td colspan="4" align="center"><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
</td>
</tr>
</form>
</table>
<?php
// Check if button name "Submit" is active, do this
if($Submit){
for($i=0;$i<$count;$i++){
$sql1="UPDATE $tbl_name SET company='$company[$i]', contact='$contact[$i]', email='$email[$i]',type='$type[$i]', telephone='$telephone[$i]' WHERE id='$id[$i]'";
$result1=mysql_query($sql1);
}
}

if($result1){
header("location:update_multiple.php");
echo "<meta http-equiv=Refresh content=0;url=update_multiple.php>";
}
mysql_close();
?>

So, I'm trying to read a file from a different filepath than the current working directory.    I have some simple PHP like this :

<?php
 
    $input_map = "readfile.php";
    $map_contents = file_get_contents($input_map);
    echo $map_contents."<br />\n";
?>

And this'll work fine because it's in the same directory but if I try to set $input_map = "/home/...", the browser will return an empty string. This script will work from the command line though. So how do I get file_get_contents() to read from the server's file structure instead of just the working directory?   Edit : For example, this will not work through the browser :

<?php
 
    $input_map = 
"/home/...";
    $map_contents = file_get_contents($input_map);
 
    echo $map_contents."<br />\n";
    var_dump($map_contents);
?>

Edited by MutantJohn, 21 January 2015 - 06:35 PM.

I was hoping someone could help me figure out why my
  Code: [Select]
header('Location: .');works right on my localhost testing computer but not when I load it onto the actual server.

Here are the two files in question.  The first is a snippet from my index.php controller file.
Code: [Select]
if (isset($_POST['action']) and $_POST['action'] == 'Edit')
{
include '../../includes/db.inc.php';
  {
$id = mysqli_real_escape_string($link, $_POST['id']);
$sql = "Select * from s_times where id = '$id'";
$result = mysqli_query($link, $sql);
if (!$result)
{
$error = 'Error fetching service time details ' . mysqli_error($link);
include '../../includes/error.php';
exit();
}

$row = mysqli_fetch_array($result);
$pagetitle = 'Edit Category';
$action = 'editform';
$id =  $row['id'];
$day = $row['day'];
$time =  $row['time'];
$event =  $row['event'];
$avail =  $row['avail'];
$orderby = $row['orderby'];
$button = 'Update';

 }
include 'stimes_modify.php';
exit();
}

if (isset($_GET['editform']))
{
include '../../includes/db.inc.php';

$id = mysqli_real_escape_string($link, $_POST['id']);
$day = mysqli_real_escape_string($link, $_POST['day']);
$time = mysqli_real_escape_string($link, $_POST['time']);
$event = mysqli_real_escape_string($link, $_POST['event']);
$avail = mysqli_real_escape_string($link, $_POST['available']);
$orderby = mysqli_real_escape_string($link, $_POST['orderby']);
$sql = "Update s_times set
day = '$day',
time = '$time',
event = '$event',
avail = '$avail',
orderby = '$orderby'
where id = '$id'";
if (!mysqli_query($link, $sql))
{
$error = 'Error updating service times ' . mysqli_error($link);
include '../../includes/error.php';
exit();
}

header('Location: .');
exit();
}


here is the stimes_modify.php file code
Code: [Select]
if (isset($_POST['action']) and $_POST['action'] == 'Edit')
{
include '../../includes/db.inc.php';
  {
$id = mysqli_real_escape_string($link, $_POST['id']);
$sql = "Select * from s_times where id = '$id'";
$result = mysqli_query($link, $sql);
if (!$result)
{
$error = 'Error fetching service time details ' . mysqli_error($link);
include '../../includes/error.php';
exit();
}

$row = mysqli_fetch_array($result);
$pagetitle = 'Edit Category';
$action = 'editform';
$id =  $row['id'];
$day = $row['day'];
$time =  $row['time'];
$event =  $row['event'];
$avail =  $row['avail'];
$orderby = $row['orderby'];
$button = 'Update';

 }
include 'stimes_modify.php';
exit();
}

if (isset($_GET['editform']))
{
include '../../includes/db.inc.php';

$id = mysqli_real_escape_string($link, $_POST['id']);
$day = mysqli_real_escape_string($link, $_POST['day']);
$time = mysqli_real_escape_string($link, $_POST['time']);
$event = mysqli_real_escape_string($link, $_POST['event']);
$avail = mysqli_real_escape_string($link, $_POST['available']);
$orderby = mysqli_real_escape_string($link, $_POST['orderby']);
$sql = "Update s_times set
day = '$day',
time = '$time',
event = '$event',
avail = '$avail',
orderby = '$orderby'
where id = '$id'";
if (!mysqli_query($link, $sql))
{
$error = 'Error updating service times ' . mysqli_error($link);
include '../../includes/error.php';
exit();
}

header('Location: .');
exit();
}


The functionality of both pages seems to be working in relation to editing the database but the page will not redirect back to the main page when it gets back down to the header line.  Like I said it works on localhost just not on actual server.  I also tried putting in the full URL like this
Code: [Select]
header('Location: http://www.bbcpa.org/dbsite/admin/stimes/stimes/php');and still got a blank page.

The URL in the address bar shows this
http://www.bbcpa.org/dbsite/admin/stimes/?editform
it should show this
http://www.bbcpa.org/dbsite/admin/stimes/
so maybe something is wrong with this line in stimes_modify.php
Code: [Select]
<form action="?<?php htmlout($action); ?>" method="POST">
anyway any help would be greatly appreciated.
Thanks

    
    $account="54646456456464";
    $station= "12345";
    $options="11-1";
    $image="C:/Desktop/Sample Images/usco1.jpg";
    
    
$ch = curl_init();

curl_setopt($ch, CURLOPT_URL,"http://dfdgfsfs.com/kgdfgd.php");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, array(
            'image' => '@'.$image, 'account' => $account, 'station' => $station, 'options' => $options));


$postResult = curl_exec($ch);


curl_close ($ch);

$xmlobj = simplexml_load_string($postResult);

echo (string)$xmlobj->ID->attributes()->value;
echo (string)$xmlobj->FullName->attributes()->value;

All, I have spend days trying to figure this out without any luck.  I am now in crisis mode.  I need to get this working asap.  The following code works perfect on my local xampp machine.  As soon as I upload it to my web server, I don't get any data back.  I have narrowed it down to the image i am trying to send is not being received properly.  Thanks in advance.

Hi all,

I wonder if any of you have this problem before..

I have a login page with "checked box remember me" - It is working fine in my localhost machine I can see the COOKIE in my browser's option setting (Firefox).

But now the problem is: When I run the script in my test server; and do exactly the same thing..the COOKIE did not seem know.

When I logged in as an admin and checked the box. And closed all the browser. Then, open the browser (Firefox)and go to the index page (landing page) then it redirect me to the login page instead. I looked the at COOKIE setting in my Firefox and I can it is stored there.

Any ideas whats wrong?

Hi,

I'm having a first attempt at sanitising code, but I'm not actually sure what I'm doing and how I know if it works.

This is the code I have inserted, if I enter "description=re#d%widget" the description query ends so it displays everything 'red'.  Not just everything 'red widget'.


Code: [Select]
$description = mysql_real_escape_string($description);
$description = stripslashes($description);
$description = htmlentities($description);
return $var;

$price = mysql_real_escape_string($price);
$price = stripslashes($price);
$price = htmlentities($price);
return $var;




Code: [Select]
<?php

ini_set('display_errors', 1);
error_reporting(-1);



$query = "SELECT * FROM productfeed";

if(isset($_GET['description']) && !empty($_GET['description']))
{
$description = $_GET['description'];
$query .= " WHERE description like '%$description%'";
}

if(isset($_GET['price']) && !empty($_GET['price']))
{
$price = explode('-', $_GET['price']);
$lowPrice = (int)$price[0];
$highPrice = (int)$price[1];

$query .= " AND price BETWEEN $lowPrice AND $highPrice";
}


$result = mysql_query($query);

while($row = mysql_fetch_assoc($result))

{

$id = $row['id'];
$image = $row['awImage'];
$link = $row['link'];
$description = $row['description'];
$fulldescription = $row['fulldescription'];
$price = $row['price'];

echo "<div class='productdisplayshell'>
<div class='productdisplayoutline'>
<div class='productborder'><center>
<a href='$link' target='_blank'><img src='$image' width=\"95%\" /></a>
</center> </div></div>
<div class='productdescriptionoutline'>
<div class='productdescriptionbox'>
<a href='$link' target='_blank' >$description</a>
</div>
<div class='productfulldescriptionbox'>$fulldescription</div>
</div>
<div class='productpriceoutline'>
<div class='productpricebox'>
<center>&#38;#163; $price</center>
</div>
<div class='productbuybutton'>
<center><a href='$link' target='_blank' ><img src=/images/buybutton.png /></a></center>
</div>
</div>
</div>";
} 

if ($_GET['description'] == $description ) {
echo 'Sorry, this product is not available.  Please visit our <a href="http://www.domain.co.uk">Homepage</a>.';
}


?>

<?php
function sanitizeString($description)
{
$description = mysql_real_escape_string($description);
$description = stripslashes($description);
$description = htmlentities($description);
return $var;

$price = mysql_real_escape_string($price);
$price = stripslashes($price);
$price = htmlentities($price);
return $var;


}
?>

Hi all, Having an issue with some of my php code. The goal is to have two drop-down menus, one that pulls from "ahevents_scenarios". The second pulls the "sides" involved, however it does not go into dropdown. The other issue is that even though there are only 3 sides specified, all 5 show up on the webpage. This is in Joomla.     Here is my code...I think I've looked over this way too much and just can't find my errors anymore.

<?php



if (! $my->id) {

  // shouldn't even get here since menu is viewable only through logged in status

print "<b>Sorry, you must be registered and logged into this site to continue</b>\n";

}

else {



// include standard functions and db info

require_once($_SERVER['DOCUMENT_ROOT'] . "/inc/admin_functions.php");

require_once($_SERVER['DOCUMENT_ROOT'] . "/inc/db_admin_functions.php");



// which scenario we doing?  -- replace with table lookup in future



opendb('ahevents_scenarios');



if(!isset($_POST['action'])) { // display form

    $sqlstr2 = "select id, name from scenarios order by name";

    $result2 = mysql_query($sqlstr2) or die("Error: ".mysql_error()."<br>Query: $sqlstr2");

  // display form

?>



<form name="edit_reg" method="post" action="<? echo $_SERVER[ 'REQUEST_URI' ]; ?>"

<table>

<tr>

<td>Select Scenario: </td>

<td>

<select name="id">

<? while ( $row = mysql_fetch_array($result2)) {

    printf("<option value=\"%s\">%s</option>\n",$row['id'], $row['name']);

}

?>

</td></tr>

<tr>

<td>Which Side?</td>

<td><select name="side">

<option value="side_1">side_1</option>

<option value="side_2" >side_2</option>

<option value="side_3" >side_3</option>

<option value="all" selected>All</option>

</select>

</td></tr>

</table>

<p>

<input type="submit" name="action" value="Get Registrants">&nbsp;

<input type="reset" value="Reset">&nbsp;

<input type="button" name="" value="Back" onClick="history.back()">

</form>

The goal is to download the registrants into a .csv file, which it does, however due to not being able to select a "side", the .csv is blank with only headers, no content.   Thanks for your time Rob

Greetings to all!

Newbie here, I just signed up this morning. I have an issue with a code I have been using for several years with multiple files/directories. Until recently all of the files have worked flawlessly. Now I have one file in a directory that does not display the text I which I am attempting to call up and it was working until recently.

As stated above I have the same code in multiple directories and files and it works flawlessly in all files except for the one. I have spent a few hours attempting to remedy the situation with no success. I have looked at the source code for the errant file and that shows the text to be displayed but it is not displayed in any browser on several computers, whether Windows or Mac OSX. I even went so far as to delete the directory the file was in and re-uploaded the entire directory from a backup that is 2 or 3 years old, no change. I copied the entire coding from a working file with the same coding, deleted all the coding in the errant file and pasted the working coding into the errant file. - no change

I have attached screen shots of the coding in errant file and one of many other files that work flawlessly with the php code that is involved highligted. Also attached are the browser page source files for the same errant and working files. The screen shots in order are errant file code, working file code, errant file source, and working file source.

Every file with the same code as the errant one work flawlessly except for the errant one, and I have 11 files to be displayed on my website at https://TheLoveOfGod.org They are all listed under the Devotionals menu button except for one which is displayed on the home page. I have absolutely no training in web design, I am self taught. I began by hand typing html coding over 30 years ago and am now using Word Press with Elementor . I do not understand why this is happening. Can any of you offer assistance to resolve this. I thank you in advance for your assistance.

Respectfully,
dan

 

Edited September 25, 2020 by namednad
more explanation

I have made a bit of code that queries the database for articles published within the last year.

<?php echo $numposts = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->posts WHERE post_status = 'publish' AND post_type = 'post' AND 'post_date' > '" . date("Y") . "-01-01-01 00:00:00'");
if (0 < $numposts) $numposts = number_format($numposts); ?>

I really don't even know how it works and need to because I want to figure out how to make it also get articles published within the last day, month and week.

I suppose if I understood what needs changing I might be able to work with it but so far everything I've tried either returns the exact same number or nothing at all.

It's for Wordpress just to note.

Any ideas?

Dear php freaks,

In my test file the following code works perfectly:

Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 <html xmlns="http://www.w3.org/1999/xhtml">
 <head>
 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
 <script language="javascript" type="text/javascript">
 function dropdownlist(listindex)
 {
 
document.formname.subcategory.options.length = 0;
 switch (listindex)
 {
 
case "1" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 
break;
 
case "2" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 document.formname.subcategory.options[3]=new Option("2","2");
 
break;
 
case "3" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 document.formname.subcategory.options[3]=new Option("2","2");
 document.formname.subcategory.options[4]=new Option("3","3");
 
break;

case "4" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 document.formname.subcategory.options[3]=new Option("2","2");
 document.formname.subcategory.options[4]=new Option("3","3");
 document.formname.subcategory.options[5]=new Option("4","4");
 
break;

case "5" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 document.formname.subcategory.options[3]=new Option("2","2");
 document.formname.subcategory.options[4]=new Option("3","3");
 document.formname.subcategory.options[5]=new Option("4","4");
 document.formname.subcategory.options[6]=new Option("5","5");
 
break;

case "6" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 document.formname.subcategory.options[3]=new Option("2","2");
 document.formname.subcategory.options[4]=new Option("3","3");
 document.formname.subcategory.options[5]=new Option("4","4");
 document.formname.subcategory.options[6]=new Option("5","5");
 document.formname.subcategory.options[7]=new Option("6","6");

break;

case "7" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 document.formname.subcategory.options[3]=new Option("2","2");
 document.formname.subcategory.options[4]=new Option("3","3");
 document.formname.subcategory.options[5]=new Option("4","4");
 document.formname.subcategory.options[6]=new Option("5","5");
 document.formname.subcategory.options[7]=new Option("6","6");
 document.formname.subcategory.options[8]=new Option("7","7");
break;

case "8" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 document.formname.subcategory.options[3]=new Option("2","2");
 document.formname.subcategory.options[4]=new Option("3","3");
 document.formname.subcategory.options[5]=new Option("4","4");
 document.formname.subcategory.options[6]=new Option("5","5");
 document.formname.subcategory.options[7]=new Option("6","6");
 document.formname.subcategory.options[8]=new Option("7","7");
 document.formname.subcategory.options[9]=new Option("8","8");
break;

case "9" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 document.formname.subcategory.options[3]=new Option("2","2");
 document.formname.subcategory.options[4]=new Option("3","3");
 document.formname.subcategory.options[5]=new Option("4","4");
 document.formname.subcategory.options[6]=new Option("5","5");
 document.formname.subcategory.options[7]=new Option("6","6");
 document.formname.subcategory.options[8]=new Option("7","7");
 document.formname.subcategory.options[9]=new Option("8","8");
 document.formname.subcategory.options[10]=new Option("9","9");
break;

case "10" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 document.formname.subcategory.options[3]=new Option("2","2");
 document.formname.subcategory.options[4]=new Option("3","3");
 document.formname.subcategory.options[5]=new Option("4","4");
 document.formname.subcategory.options[6]=new Option("5","5");
 document.formname.subcategory.options[7]=new Option("6","6");
 document.formname.subcategory.options[8]=new Option("7","7");
 document.formname.subcategory.options[9]=new Option("8","8");
 document.formname.subcategory.options[10]=new Option("9","9");
 document.formname.subcategory.options[11]=new Option("10","10");
 
break;
 
}
 return true;
 }

 </script>
 </head>
 <title>Dynamic Drop Down List</title>
 <body>
 
<form id="formname" name="formname" method="post" action="submitform.asp" >
 <table width="50%" border="0" cellspacing="0" cellpadding="5">
 <tr>
 <td width="41%" align="right" valign="middle">Aantal kinderen :</td>
 <td width="59%" align="left" valign="middle"><select name="category" id="category" onchange="javascript: dropdownlist(this.options[this.selectedIndex].value);">
 <option value="">------</option>
 <option value="1">1</option>
 <option value="2">2</option>
 <option value="3">3</option>
 <option value="4">4</option>
 <option value="5">5</option>
 <option value="6">6</option>
 <option value="7">7</option>
 <option value="8">8</option>
 <option value="9">9</option>
 <option value="10">10</option>
 </select></td>
 </tr>
 <tr>
 <td align="right" valign="middle">Waarvan thuiswonend :
 </td>
 <td align="left" valign="middle"><script type="text/javascript" language="JavaScript">
 document.write('<select name="subcategory"><option value="">-----</option></select>')
 </script>
 <noscript><select name="subcategory" id="subcategory" >
 <option value="">Select Sub-Category</option>
 </select>
 </noscript></td>
 </tr>
 </table>
 
</form>
 
 
</body>
 </html>
 


When i want to implement it in my signup page, it doesnt do anything. I've checked it a thousand times, i double checked that also the

-formname of my signup page is 'formname'
-the element name stays 'subcategory'

I really need this to be implemented. Where can be the problem? What should i look for?

Hi all,
I am a bit of a noob when it comes to website building and php etc so please have patients with me I am learnig as I go.

I have come across this problem before and cannot remember what I did to fix it but any way it is presenting its self to me again.

I have this page: http://minecraftcons...a.com/index.php with an include file loading random images, however the same code on these pages:
http://minecraftconsolecrafting.comxa.com/sections/build-navi.php
http://minecraftconsolecrafting.comxa.com/sections/springhill-kingdom-01.php
are not working.

I have other websites that this method of coding is working fine on for example here is another of my websites:
http://divinegardensandlandscapes.com/index.php here the include code for random image loader is working fine on all pages it appears on so what is happening when this fail takes place?

Any help and or advice would be hugely appreciated, Thanks in advance.

Please remeber I am a noob when answering. Thanks
Edited by eGate-Network, 12 July 2014 - 10:55 PM.

Hi,

I have some code which works but when I created a function and call this same code it doesn't. The error I get is as follows:

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/fhlinux010/l/languageschoolsuk.com/user/htdocs/admin/email.php on line 42
Error retrieving schools

The code
function CreateSchoolCheckboxes()
{
echo '<div style="height:400px;width:400px;font:16px/26px Georgia, Garamond, Serif;overflow:scroll;">';

$querySchools = "SELECT * FROM school";
$result = mysql_query($querySchools, $conn)
or die ("Error retrieving schools ".mysql_error());

while($row = mysql_fetch_array($result))
{
$schoolname = $row['name'];    
echo '<input type="checkbox" name="school" value="'.$schoolname.'">';
echo $schoolname . '<br>';
}      

echo '</div>';
}

Im sure that this is probably something simple but any suggestions would be much appreciated.

Thanks,
Joe