I have edited a PHP script - but obviously not very well as it wont work - can any one help?
This is the code - I am just trying to get the info out the data base and on the page - nothing fancy:

PHP Code:

<?php
mysql_connect("localhost", "axarquia_axarquia", "Paco123")OR DIE (mysql_error());
mysql_select_db("axarquia_properties")OR DIE (mysql_error());
$num_results_per_page = 10;
$start_offset = 0;
$current_page = 1;
if ($_GET['page'] > 0) {
  $current_page = (int)$_GET['page'];
  $start_offset = ($current_page-1)*$num_results_per_page;
}
$results = mysql_query("select SQL_CALC_FOUND_ROWS letra,tipo,extras,1_dia,2_dias,3_dias,4_dias,5_dias,6_dias,7_dias from car_hire order by Date DESC limit ".$start_offset.",".$num_results_per_page);
echo '<h3><?php echo $content_rent_car; ?></h3>';
if ($results && mysql_num_rows($results) > 0) {
     echo '</div>';
  while($a_result = mysql_fetch_assoc($results)) {
    echo '
 <table><tr><td></td><td>Type of Car</td><td>1 Day</td><td>2 Days</td><td>3 Days</td><td>4 Days</td><td>5 Days</td><td>6 Days</td><td>7 Days</td></tr>
<tr><td>'.$a_result['letra'].'</td><td>'.$a_result['tipo'].'</td><td>'.$a_result['extras'].'</td><td>'.$a_result['1_dia'].'</td><td>'.$a_result['2_dias'].'</td><td>'.$a_result['3_dias'].'</td><td>'.$a_result['4_dias'].'</td><td>'.$a_result['5_dias'].'</td><td>'.$a_result['6_dias'].'</td><td>'.$a_result['7_dias'].'</tr></table>
';
   }
 
     echo '</div>';
   }
?>

Please help if you can see a error
Thanks

What error message are you getting? I don't catch anything at first glance other than some questionable formatting (I'm a formatting nazi). There might be something wrong with you sql query considering that there are no quotes around any of your values, but I may be wrong.

If you give me your error message I should be able to pick out the error... Or someone with a better eye than me will come by and pick it out before you get a chance.

It doesnt come up with an error - just doesnt work! - Ive no idea!

If it was me i'd cut it down to a basic query that works and build it back up again.

PHP Code:

<?php
mysql_connect("localhost", "axarquia_axarquia", "Paco123")or die (mysql_error());
mysql_select_db("axarquia_properties")or die (mysql_error());

$results = mysql_query("select letra,tipo,extras,1_dia,2_dias,3_dias,4_dias,5_dias,6_dias,7_dias from car_hire order by Date");

if (mysql_num_rows($results) > 0) {
     echo '</div>';
  while($a_result = mysql_fetch_assoc($results)) {
    echo '
 <table><tr><td></td><td>Type of Car</td><td>1 Day</td><td>2 Days</td><td>3 Days</td><td>4 Days</td><td>5 Days</td><td>6 Days</td><td>7 Days</td></tr>
<tr><td>'.$a_result['letra'].'</td><td>'.$a_result['tipo'].'</td><td>'.$a_result['extras'].'</td><td>'.$a_result['1_dia'].'</td><td>'.$a_result['2_dias'].'</td><td>'.$a_result['3_dias'].'</td><td>'.$a_result['4_dias'].'</td><td>'.$a_result['5_dias'].'</td><td>'.$a_result['6_dias'].'</td><td>'.$a_result['7_dias'].'</tr></table>
';
   }
 
     echo '</div>';
   }
?>

You need to echo out all your variables to see whats going on - almost certainly the select statement and your quotes. Try using
<?php echo "<pre>"; print_r($GLOBALS) ?>

at end of script.

I don't understand this line:

echo '<h3><?php echo $content_rent_car; ?></h3>';

I think right is:

echo "<h3>$content_rent_car</h3>";

Shivaji

Have you got an error log:
- standard local error logs on your PC (if you are running this on a dev server) are in the PHP folder errorlog.txt or similar
- on your web admin bit of your hosting

The error might be recorded in there and it would help. Shijavi is right as well.