PHP - Whats The Technique Used In Navigation Of A Long Page?

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=327715.0

Hi,

I am am looking to develop further the code below. This code allows me to display a left navigation bar with Main Links and then if you click a Main link, that link is listed first in the list and its' submenu appears below. For the majority of links in the navigation bar this is fine. But for about 2 of the Main links this basic navigation is not suitable.

I need the navigation for 2 of the links to offer more depth. So, for example, if you click Accessories in:

Shoes
Trousers
Shirts
Accessories

Looks like this if Accessories is clicked:

Accessories
Belts
Cuff Links
Wallets
Shoes
Trousers
Shirts

Looks like this if belts is clicked (Main link name changed and submenu changed):

Accessories - Belts
Brown leather
Black Leather
Multicolour Designs
All casual
All formal
Shoes
Trousers
Shirts

Looks like this is Brown Leather is clicked:

Brown Leather Belts
Armani Brown Leather Belt 32"
Armani Brown Leather Belt 34"
Hugo Boss Brown Leather Belt 32"
Hugo Boss Brown Leather Belt 34"
Shoes
Trousers
Shirts


Currently the code does not allow for this depth in the navigation bar. Any ideas how it could be done? Do I need additional tables for each subcategory. How do I ensure the category clicked does not appear in the rest of the navigation bar, as in the code I have at the moment?

Currently the code is:


$res = mysql_query("SELECT * FROM categories");
while($row = mysql_fetch_array($res)) {
  $cats[$row['categoryid']] = $row['categoryname'];
}
if(isset($_GET['category'])) {
 $selcat = $_GET['category'];
}
if(isset($_GET['product'])) {
 $prod_info = mysql_fetch_array(mysql_query("SELECT * FROM products WHERE productid = ".$_GET['product']));
 //Prod_Info now gets stored for use in the main display.
 $selcat = $prod_info['categoryid'];
}
if(isset($selcat)) {
  echo "<a href='categorylist.php?category=".$selcat."'>".$cats[$selcat]."</a>";
  unset($cats[$selcat]); //Gets rid of it for later.
  $res = mysql_query("SELECT productid,name FROM products WHERE categoryid = ".$selcat);
  while($row = mysql_fetch_array($res)) {
   echo "<a href='product.php?product=".$row['productid']."'>".$row['name']."</a>";
  }
}
foreach($cats AS $key => $cat)  {
  echo "<a href='categoryview.php?category=".$key."'>".$cat."</a>";
}



Thank you for looking at this post,

Matt.

<?php
require_once('upper.php');
require_once('database.php');
echo $error_msg='';
if(isset($_POST['submit']))
{
$LoginId=mysqli_real_escape_string($dbc,trim($_POST['LoginId']));
$Password1=mysqli_real_escape_string($dbc,trim($_POST['Password1']));
$Password2=mysqli_real_escape_string($dbc,trim($_POST['Password2']));
$Name=mysqli_real_escape_string($dbc,trim($_POST['Name']));
$Age=mysqli_real_escape_string($dbc,trim($_POST['Age']));
$BloodGroup=mysqli_real_escape_string($dbc,trim($_POST['BloodGroup']));
if(!isset($_POST['Sex']))
{
echo 'Please enter Sex<br>';
}
else{
$Sex= mysqli_real_escape_string($dbc,trim($_POST['Sex']));
}
$Qualification=mysqli_real_escape_string($dbc,trim($_POST['Qualification']));
$ContactNumber=mysqli_real_escape_string($dbc,trim($_POST['ContactNumber']));
$Email=mysqli_real_escape_string($dbc,trim($_POST['Email']));
$Address=mysqli_real_escape_string($dbc,trim($_POST['Address']));
$AboutYourself=mysqli_real_escape_string($dbc,trim($_POST['AboutYourself']));
//$countCheck=count($_POST['checkbox']);
//echo $countCheck;
//$checkbox=$_POST['checkbox'];
//$countCheck=count($checkbox);
if(empty($LoginId)){echo 'Please enter Login Id';}
elseif(empty($Password1)){echo 'Please enter Password';}
elseif(empty($Password2)){echo 'Please confirm Password';}
elseif($Password1!==$Password2){echo 'Password didn\'t match';}
elseif(empty($Name)){echo 'Please enter Name';}
elseif(empty($Age)){echo 'Please enter Age';}
elseif(!isset($_POST['Sex'])){}
elseif(empty($Qualification)){echo 'Please enter Qualification';}
elseif(empty($ContactNumber)){echo 'Please enter Contact Number';}
elseif(empty($Email)){echo 'Please enter Email';}
elseif(empty($Address)){echo 'Please enter Address';}
elseif(empty($AboutYourself)){echo 'Please enter About Yourself';}
elseif(!isset($_POST['checkbox'])){ echo 'You have to register at least one activity.';}
elseif(!isset($_POST['TermsAndConditions'])){ echo 'You have to agree all Terms and Conditions of Elite Brigade.';}
else
{
require_once('database.php');
$query="select * from registration where LoginId='$LoginId'";
$result=mysqli_query($dbc,$query);
if(mysqli_num_rows($result)==0)
{
$checkbox=$_POST['checkbox'];
$countCheck=count($_POST['checkbox']);
$reg_id=' ';
for($i=0;$i<$countCheck;$i++)
{
$reg_id=$reg_id.$checkbox[$i].',';
$query="insert into activity_participation (LoginId,Title,Date) values ('$LoginId','$checkbox[$i]',CURDATE())";
$result=mysqli_query($dbc,$query) or die("Not Connected");
}
$query="insert into registration (LoginId,Password,Name,Age,BloodGroup,Sex,Qualification,ContactNumber,Email,Address,AboutYourself,Activity)values ('$LoginId'[B],SHA('$Password1'),[/B]'$Name','$Age','$BloodGroup','$Sex','$Qualification','$ContactNumber','$Email','$Address','$AboutYourself',',$reg_id')";
$result=mysqli_query($dbc,$query) or die("Not Connect");

echo ' Dear '.$Name.'.<br>Your request has been mailed to admin.<br>Your account is waiting for approval<br>';
$from= 'Elite Brigade';
$to='ankitp@rsquareonline.com';
$subject='New User Registration';
$message="Dear admin,\n\nA new user request for registration. Please check it out.\n\nRegards\nMicro";
mail($to,$subject,$message,'From:'.$from);
//header('Location: index.php');
// header('Location: Registration.php');
}
else
{
echo 'Dear '.$Name. ', <br> An account already exist with login-id<b> '.$LoginId.'</b> <br>Please try another login-id';
}}
}
?>

<html>
<head>
<script src="jquery-latest.js"></script>
  <script type="text/javascript" src="jquery-validate.js"></script>
<style type="text/css">
* { font-family: Verdana;  }

label.error {  color: white;  padding-left: .5em; }
p { clear: both; }
.submit { margin-left: 12em; }
em { font-weight: bold; padding-right: 1em; vertical-align: top; }
</style>
  <script>
  $(document).ready(function(){
    $("#commentForm").validate();
  });
  </script>
  
</head>

<body>

<?php
echo $error_msg; ?>

<form action='<?php echo $_SERVER['PHP_SELF'];?>' id="commentForm" method='post'>
<div class="registration_and_activity">

<table border="0" width="380">
<tr><td colspan="2">
<h3>New User?</h3></td></tr>
<tr><td width="120">

<em>*</em>Enter Login id</td><td width="150"><input type='text' name='LoginId'  minlength="4" value='<?php if(!empty($LoginId))echo $LoginId;?>' /></td></tr>
<tr><td>
<em>*</em>Enter Password</td> <td><head>
   <div id="divMayus" style="visibility:hidden">Caps Lock is on.</div>
   <SCRIPT language=Javascript>

function capLock(e){
 kc = e.keyCode?e.keyCode:e.which;
 sk = e.shiftKey?e.shiftKey:((kc == 16)?true:false);
 if(((kc >= 65 && kc <= 90) && !sk)||((kc >= 97 && kc <= 122) && sk))
  document.getElementById('divMayus').style.visibility = 'visible';
 else
  document.getElementById('divMayus').style.visibility = 'hidden';
}

</SCRIPT>
   </HEAD>
<input onkeypress='return capLock(event)' type='password' name='Password1' value='<?php if(!empty($Password1))echo $Password1;?>' /></td></tr>

<tr><td>
<em>*</em>Confirm Password</td><td><input type='password' name='Password2' value='<?php if(!empty($Password2))echo $Password2;?>' /></td></tr>
<tr><td width="120">
<em>*</em>Enter Name</td> <td><input type='text'  name='Name' value='<?php if(!empty($Name))echo $Name;?>' /></td></tr>
<tr><td>
<em>*</em>Enter Age</td><HEAD>
   <SCRIPT language=Javascript>
      
      function isNumberKey(evt)
      {
         var charCode = (evt.which) ? evt.which : event.keyCode
         if (charCode > 31 && (charCode < 48 || charCode > 57))
            return false;

         return true;
      }
  
  
     
   </SCRIPT>
   </HEAD>
<td><INPUT onkeypress='return isNumberKey(event)'  type='text' name='Age' value='<?php if(!empty($Age))echo $Age;?>'/></td></tr>

<tr><td>
<em>*</em>Enter Blood</td><td><input type='text' name='BloodGroup' value='<?php if(!empty($BloodGroup))echo $BloodGroup;?>' /></td></tr>

<tr><td>
<em>*</em>Enter Sex</td><td><input type='radio' name='Sex'  style='width:16px; border:0;' 'value='Male' />Male   <input type='radio' name='Sex' style='width:16px; border:0;' 'value='Female' />Female</td></tr>

<tr><td>
<em>*</em>Enter Qualification</td><td><input type='text' name='Qualification'  value='<?php if(!empty($Qualification))echo $Qualification;?>' /></td></tr>

<tr><td>
<em>*</em>Contact Number </td><td><input onkeypress='return isNumberKey(event)'type='text'  name='ContactNumber' value='<?php if(!empty($ContactNumber))echo $ContactNumber;?>' /></td></tr>

<tr><td>
<em>*</em>Enter Email</td><td><input type='text' name='Email'class="email" value='<?php if(!empty($Email))echo $Email;?>' /></td></tr>

<tr><td>
<em>*</em>Enter Address</td><td><input type='text'   name='Address' value='<?php if(!empty($Address))echo $Address;?>' /></td></tr>


<tr ><td >
<em>*</em>About Yourself </td></tr>
<tr><td colspan="2"><textarea rows='10' cols='40'  name='AboutYourself'  /><?php if(!empty($Address))echo $Address;?></textarea></td></tr>
<tr><td>

<?php echo"
<tr><td colspan='2'><em>*</em><b>Select fields for which you want to register</b></td></tr>";

require_once('database.php');
$query="select * from activity";
$result=mysqli_query($dbc,$query);
while($row=mysqli_fetch_array($result)){
$Title=$row['Title'];
$ActivityId=$row['ActivityId'];
echo "<tr><td>$Title</td>";
echo "<td><input type='checkbox' name='checkbox[]' value='$Title' style='width:14px; text-align:right;'/></td></tr>";//value=$ActivityId tells ActivityId variable extracts with name="checkbox"
echo "<br/>";
}
echo "<td><em>*</em><input type='checkbox' name='TermsAndConditions'  style='width:14px; text-align:right;'/></td><td> I agree all <a href='TermsAndConditions.php'>Terms and conditions </a>of Elite Brigade</td></tr>";
echo "<tr><td colspan='2' align='center'><input type='submit' value='Register' name='submit' style='background:url(./images/button_img2.png) no-repeat 10px 0px; width:100px; padding:3px 0 10px 0; color:#FEFBC4; border:0;'/></td></tr><br>";

echo " </td></tr></table>

</div>

</form>
</body>
</html>";
require_once('lower.php');

?>


Hi Friends ....
I encrypt user password by SHA('$Password') method but now i want to add "Forget Password Module" for which I need to decrypt it first before tell my user but I don't Know how to decrypt it.
Please help me........

Hi again,

Here is the code     $string .= (substr($string,-1) == '-') ? '' : '-';

I know what this code does but to increase my knowledge could some one tell me what is the
question mark symbol for ( ? ) and what is the colon doing. As I have seen the ?  in a lot of scripts but have no clue what it does and what its used for cheers!

Hi Friends, I wanted to know what is new in PHP version 5.6.0. How is it different from its previous versions? How will benefit the security of PHP websites? Thanks in advance.

So im using textwrangler and usually when you click on the '{' or '}' it will highlight everything inbetween them, well on the top one on line 7 it does not, and i tried messing around with it to try to get it to work cause i keep getting an error on line 8 that says "Parse error: syntax error, unexpected '{' in /home/truckste/public_html/create_topic_parse.php on line 8"

Code: [Select]
<?php
if($username){
header("Location: index.php");
exit();
}

if(isset($_POST['topic_submit'])){
if (($_POST['topic_title'] == "" && ($_POST['topic_content'] == "")){
echo "You Did Not Fill In Both Fields. Please Return To The Previous Page.";
exit();
}
else{
requre('scripts/connect.php');
$cid = $_POST['cid'];
$title = $_POST['topic_title'];
$content= $_POST['topic_content'];
$creator = $_POST['uid'];
$sql = "INSERT INTO topics (category_id, topic_title, topic_creator, topic_date, topic_reply_date) VALUES ('".$cid."', '".$title."', '".$creator."', now(), now())";
$res = mysql_query($sql) or die(mysql_error());
$new_topic_id = mysql_insert_id();
$sql2 = "INSERT INTO posts (category_id, topics_id, post_creator, post_content, post_date) VALUES ('".$cid."', '".$new_topic_id."', '".$creator."', '".$content."', now())";
$res2 = mysql_query($sql2) or die(mysql_error());
$sql3 = "UPDATE categories SET last_post_date=now(), last_user_posted'".$creator."', WHERE id='".$cid."' LIMIT 1";
if (($res) && (res2) && (res3)){
header("Location: view_topic.php?cid".$cid."$tid=".$new_topic_id)
}
else{
echo "There Was A Problem Creating Your Topic. Please Try Again.";
}

}


?>

hi all me again

i have this bit of code


mysql_connect($db_hostname,$db_username,$db_password);
@mysql_select_db($db_database) or die( "Unable to select database");

$whereClauses = array();
if(isset($_GET['bi'])) { $whereClauses[] = "bi=1"; }
if(isset($_GET['print'])) { $whereClauses[] = "print=1"; }
if(isset($_GET['online'])) { $whereClauses[] = "online=1"; }

$query = "SELECT * FROM  `project` ORDER BY  `project`.`position` ASC ";
if(count($whereClauses))
{
    $query .= " WHERE " . implode(" AND ", $whereClauses);
}


with this error msg
There was a problem with the SQL query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE online=1' at line 3

I get this kinda error a lot as im still learning is there any way to better find out whats going wrong i use

error_reporting(E_ALL);
ini_set('display_errors', '1');
at the start of my scripts but it dont tell me a lot. i can work  out it some thing to do with the $whereClauses  as the page displays ok on show all.

Im bit stumped here not even sure what to call the prob is it sql query error or php array problem

thanks for any help 

Good evening my PHP experts!!!

OK so heres the problem...I have been at this for about 2 DAYS now and for the life of me I just don't understand what I could possibly be doing wrong.

I have 3 of 4 variables outputting correctly but without my id being pulled from the URL NOTHING will get written to my database. I have ran some tests and I came to learn that my $_POST['id']; function is not working properly for some strange reason. As always, any help would be greatly appreciated. Please see below PHP code. I also have posted the HTML code for your reference purposes...thanks in advance. Please helpppp!!!!

Code: [Select]
<?php

session_start();

$id = '';

if (isset($_POST['password'])) {

include_once "scripts/connect_to_mysql.php";

$id = $_POST['id'];
$id  = mysql_real_escape_string($id );
$id = eregi_replace("`", "", $id);


    $cust_password = $_POST['password'];
    $hashedPass = md5($cust_password); 

$sql = mysql_query("UPDATE customers SET password='$hashedPass' WHERE id='$id'");

$update_success = 'You have successfully updated your Password. Please click <a href="customer_login.php">HERE</a> to log into your account.';

//Output to test whether or not my variables have anything in them.
//$update_success, $hashedPass, $cust_password all Output just fine. $id displays nothing at all.
echo $update_success;
echo $hashedPass;
echo $cust_password;
echo $id;

exit();

}

?>

<!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" />
<title>Untitled Document</title>
<link rel="stylesheet" type="text/css" href="style.css"/>

<script type="text/javascript">
<!-- Form Validation -->
function validate_form ( ) {
valid = true;
if ( document.form.password.value == "" ) {
alert ( "Password field must not be blank." );
valid = false;
}
return valid;
}
<!-- Form Validation -->
</script>

</head>

<body>

<div id="pg_container">

<!--HEADER SECTION-->
<div id="header">
<div id="header_logo"></div>
    <div id="header_right">Welcome to Built 2 Manage.</div>
</div>
<!--HEADER SECTION-->

<!--PAGE CONTAINER-->
<div id="pgbdy_container">
<form action="cust_acc_conf.php" method="post" id="form" name="form" enctype="multipart/form-data" onsubmit="return validate_form ( );">
<div id="login_header">
    <p>
        Please log into your account below.
        </p>
    </div>
   
    <div id="cust_choose_pass_form">
    <div id="cust_choose_pass_text">
        <p>
            Password:
            </p>
        </div>
        <div id="cust_choose_pass_field">   
            <p>
            <input name="password" type="text" id="password" /><br /><br />
                <input name="submit_password" type="submit" id="submit_password" value="Submit Password" /><br />
               </p>
        </div>
    </div>
    </form>
</div>

<!--PAGE CONTAINER-->

<div id="footer"></div>

</div>
</body>
</html>

Code: [Select]
$correct_numbers = 0;
$correct = 0;
$numbers_chosen = @explode("|",$ticket['numbers_chosed']);
$your_numbers = array();
$array1 = array_count_values($numbers_chosen);
$array2 = array_count_values($winning_numbers);
foreach($array1 as $number1 => $count1)
{
foreach($array2 as $number2 => $count2)
{
if($number2 == $number1 and $count2==$count1)
$correct_numbers += $count2;
}
}
$use = 0;
$numbers = @implode("|",$winning_numbers);
echo $correct_numbers;
echo "<br>";
echo $lottery['balls'];
I have no idea wthell this does
Code: [Select]
$correct_numbers += $count2;
What's that += suppose to mean?

I know the $correct_numbers is supposed to be a matching array count from the for eachs right?


$ticket['numbers_chosed']

is

Code: [Select]
8|18|3

Cant Figure Out Whats Wrong With it..
Code:
Code: [Select]
<?php
if(isset($_SESSION['user']))
{
$bb = mysql_query("SELECT * FROM main WHERE id=". $_SESSION['id']) or die ("An error has occured: " . mysql_error());
while($n=mysql_fetch_array($bb)) 
{
?>
                            <div class='cs_article'>
                           
                                <div class='left'>
                                    <h2>User Control Panel</h2>
                                    <p><a href="usercp.php">User CP</a><?php 
if($n['rights'] == 1)
{
echo ", <a href="modcp.php">Mod CP</a>";
}?>
<?php
if($n['rights'] == 2)
{
echo ", <a href="aa/">Admin CP</a>";
}?>
                                   
                                    <div class='button'><a href='usercp.php'>Read more</a></div>
                                </div>
                                <div class='right'>
<h1>User CP</h1>
</div>
                                                               
                            </div>
<?php
}}
?>
What its doing: Mod-Justin Compared to Mod-Justin

Ive created a process which automatically creates a form for all of the "courses" that are listed in a database. This table shows the name, the course code, the current program the course is under and an option to delete the course. I have created a drop down menu for the user to select any of the current programs to switch the course into. My problem is I have X amount of select fields and radio buttons and I dont know how to tell which one has been changed below is my code, appreciate the help!:



        case "ep":
        
        if (isset ($_GET['id'])){
            $id = $_GET['id'];
                    echo "Below lists all of the current courses under this program. Once you have made all of the changes click the submit button at the bottom of the page. <br><br><br>";
                    $query = "SELECT * FROM courses WHERE cid = $id";
                    $result = mysql_query($query) or die (mysql_error());
                    echo "<form action=\"course_process.php\" method=\"post\">";
                    echo "<table><tr><td><strong>Course Name</strong></td><td><strong>Course Code</strong></td><td><strong>Change Course Program</strong></td><td><strong>Delete</strong></td></tr>";
                    $i = 0;
                    
                    while ($row = mysql_fetch_assoc($result)){
                        $r = $row['id'];
                        $query2 = "SELECT * from catagories";
                        $result2 = mysql_query($query2) or die (mysql_error());
                        echo "<tr><td> ". $row['name']. " </td><td> ".$row['code']." </td><td><select name=\"".$row['id']."\">";
                        
                        while ($row2 = mysql_fetch_assoc($result2)){
                        
                        echo "<option value=".$row2['id'].">".$row2['name']. "</option>";
                            }
                            
                             echo "</select></td><td><input name=\"".$row['id']."\" type=\"radio\" value=\"Click to delete\" /></td></tr>";
                    }
                    echo "<tr><td></td><td></td><td></td><td><input name=\"submit\" type=\"submit\" value=\"Commit Changes\" /> </td></tr></table></form>";
                    
                    
                }else{
                    echo "Invalid action request. ERROR CODE 1";
                    
                }
                
        break;

can you tell me whats wrong with this?

Code: [Select]
<?php
$age= 60;
if( isset($_SESSION['logedin']) ) {
$q = mysql_query('SELECT id=`$id`, DATE_FORMAT(`last_activity`,"%a, %b %e %T") as `last_activity`,UNIX_TIMESTAMP(`last_activity`) as `last_activity_stamp`FROM `mymembers`WHERE `$logOptions_id` <> "'.($_SESSION['logedin']).'"');
$isonlinecheck = mysql_query($q);
if ($isonlinecheck ="last_activity_stamp + $age "< time()){
$isonline =  "is <font color='green'>online!</font>";}
else {
$isonline = "is<font color='red'> offline!</font>";
}

}
?>

Its a page 'Downloads'. Works great at localhost but doesnt show up @ web hosting.

Code: [Select]
<?php

define('IN_PHPBB', true);
$page = !isset($_GET["page"]) ? "None" : $_GET['page'];
$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);

// Start session management
$user->session_begin();
$auth->acl($user->data);
$user->setup();

page_header('Downloads');

if(strcmp($page,"org") == 0)
{
$template->set_filenames(array('body' => 'download/org.html',));
}
else if(strcmp($page,"audi") == 0)
{
$template->set_filenames(array('body' => 'download/audi.html',));
}
else if(strcmp($page,"bmw") == 0)
{
$template->set_filenames(array('body' => 'download/bmw.html',));
}
else if(strcmp($page,"vw") == 0)
{
$template->set_filenames(array('body' => 'download/vw.html',));
}
else if(strcmp($page,"nissan") == 0)
{
$template->set_filenames(array('body' => 'download/nissan.html',));
}
else if(strcmp($page,"opel") == 0)
{
$template->set_filenames(array('body' => 'download/opel.html',));
}
else if(strcmp($page,"ford") == 0)
{
$template->set_filenames(array('body' => 'download/ford.html',));
}
else if(strcmp($page,"chevrolet") == 0)
{
$template->set_filenames(array('body' => 'download/chevrolet.html',));
}
else if(strcmp($page,"other") == 0)
{
$template->set_filenames(array('body' => 'download/other.html',));
}
else
{
$template->set_filenames(array('body' => 'download/org.html',));
}

make_jumpbox(append_sid("{$phpbb_root_path}viewforum.$phpEx"));
page_footer();
?>

and the html:


Code: [Select]
<table class="tablebg" cellspacing="1" width="100%">
<tr>
<th>BMW</th>
</tr>
<tr class="row1">
<td align="center" style="padding:5px 5px 5px 5px;">
<center>
<hr width="60%" size="3" />
<table width="70%">
<tr>
<td width="10%"><a href="http://www.upload.ee/image/1626514/325i_2.jpg" target = "_blank">
<img src="http://www.upload.ee/thumb/1626514/325i_2.jpg" border="0"/></a>
<a href="http://www.upload.ee/image/1626518/325i_3.jpg">
<img src="http://www.upload.ee/thumb/1626518/325i_3.jpg" border="0"/></a>
<td width="0%"><a href="http://www.upload.ee/image/1626519/325i_1.jpg" target = "_blank">
<img src="http://www.upload.ee/thumb/1626519/325i_1.jpg" border="0"/></a>
<a href="http://www.upload.ee/image/1626521/325i_4.jpg" target = "_blank">
<img src="http://www.upload.ee/thumb/1626521/325i_4.jpg" border="0"/></a></td></td>
<td><b><font color="white">Name:</font></b> 1996 BMW 325i e36 Convertible</br>
<b><font color="white">Original Author:</font></b> ikey07</br>
<b><font color="white">Size:</font></b> 3.89MB</br></br>
<b><font color="white">Description:</font></b></br>
Tunable in WAA</br>
2 Body kits included</br>
1. BMW M e36 series + Hood Vents</br>
2. BMW M e46 series + Masked Lights</br>
New 2 M series wheels e36/e46</br>
Realistic heavy damaged model</br>
Model accuracy as real car 96%</br>
Openable petrolcap</br>
If you replace this car as BF Injection, the front fan is working ( spining )</br></br>
<a href="http://ikey07.c-rp.net/viewtopic.php?f=6&t=2"><b><font color="white">Comments</font></b></a></br>
</br>
<ul id="nav">
<a class="downl" href="http://ikey07.c-rp.net/download/1996_BMW_325i_e36.rar" title="Download"><span>{L_DOWN}</span></a>
        </div>
</br>
</td>
</tr>
</table>
<hr width="60%" size="3" />
</center>
</td>
</tr>
</table>
<br />

$search    = $_POST['search'];
$replace  = $_POST['replace'];
$zero = 0;
$gibs = mysql_query("SELECT * FROM anime"); 
while ($gib = mysql_fetch_assoc($gibs)) {
$new_description[] = str_replace($search,$replace,$gib['description']);
$new_history[]  = str_replace($search,$replace,$gib['history']);
$anime_id[] = $gib['anime_id'];
$numberlinks = ++$zero;
}

for($i=0; $i<$numberlinks; $i++) {
$thequery[] = mysql_query("UPDATE anime SET description = '".mysql_real_escape_string($new_description[$i])."', history='".mysql_real_escape_string($new_history[$i])."' WHERE anime_id='".$anime_id[$i]."'");
}
foreach ($thequery as $query){
mysql_query($query) or die (mysql_error());
echo "<span style='color:green'>Edited sucessfully <b>Anime ".++$one."</b> </span><br/>";
} 

echo "<meta http-equiv='refresh' content='2;url=http://www.website.com/forums/downloads-manager.php?task=fix-descriptions'>";

output:
Code: [Select]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1' at line 1[/b]

Inputs:
$search:  ’
$replace:  "