Jump to content

Mod-Jay

Members
 View Profile  See their activity

  • Posts

    155

  • Joined

  • Last visited

    Never

 Content Type 

Posts posted by Mod-Jay

    Little Error

    in PHP Coding Help

    Posted

    The bracket that is messing up your code is at the beginning of this line:

     

    } echo '<p class="info" id="error"><sp...

     

    Remove it and it should parse fine.

    look at the line above it..

        if(mysql_num_rows($rrr) > 0) {
    } echo '<p class="info" id="error"><sp

    Mysql ERROR

    in PHP Coding Help

    Posted

    Error:

    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

     

    Code:

    <?php
session_start();
include "includes/connect.php";
include "includes/config.php";
if(isset($_SESSION['admin2'])){
include 'includes/getuserinfo.php';
?>
<!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>Dashboard | Modern Admin</title>
<link rel="stylesheet" type="text/css" href="css/960.css"  webstripperwas="css/960.css" />
<link rel="stylesheet" type="text/css" href="css/reset.css"  webstripperwas="css/reset.css" />
<link rel="stylesheet" type="text/css" href="css/text.css"  webstripperwas="css/text.css" />
<?php if($acptheme == '') {
echo '<meta http-equiv=Refresh content=0;url="nocss.php">';
} else { echo '<link rel="stylesheet" type="text/css" href="css/'.$acptheme.'.css"  webstripperwas="css/<?php echo $acptheme ?>.css" />'; } ?>
<link type="text/css" href="css/smoothness/ui.css"  webstripperwas="css/smoothness/ui.css" rel="stylesheet" />  
    <script type="text/javascript" src="ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"  webstripperwas="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js" ></script>
    <script type="text/javascript" src="js/blend/jquery.blend.js"  webstripperwas="js/blend/jquery.blend.js" ></script>
<script type="text/javascript" src="js/ui.core.js"  webstripperwas="js/ui.core.js" ></script>
<script type="text/javascript" src="js/ui.sortable.js"  webstripperwas="js/ui.sortable.js" ></script>    
    <script type="text/javascript" src="js/ui.dialog.js"  webstripperwas="js/ui.dialog.js" ></script>
    <script type="text/javascript" src="js/ui.datepicker.js"  webstripperwas="js/ui.datepicker.js" ></script>
    <script type="text/javascript" src="js/effects.js"  webstripperwas="js/effects.js" ></script>
    <script type="text/javascript" src="js/flot/jquery.flot.pack.js"  webstripperwas="js/flot/jquery.flot.pack.js" ></script>
    <![if IE]>
    <script language="javascript" type="text/javascript" src="js/flot/excanvas.pack.js"  webstripperwas="js/flot/excanvas.pack.js" ></script>
    <![endif]>
<![if IE 6]>
<link rel="stylesheet" type="text/css" href="css/iefix.css"  webstripperwas="css/iefix.css" />
<script src="js/pngfix.js"  webstripperwas="js/pngfix.js" ></script>
    <script>
        DD_belatedPNG.fix('#menu ul li a span span');
    </script>        
    <![endif]>
    <script id="source" language="javascript" type="text/javascript" src="js/graphs.js"  webstripperwas="js/graphs.js" ></script>

</head>

<body>
<!-- WRAPPER START -->
<div class="container_16" id="wrapper">	
<!-- HIDDEN COLOR CHANGER -->      
      <div style="position:relative;">
      </div>
<?php
include 'inc/inc/logo.php';
include 'inc/inc/user.php';
?>
<!-- USER TOOLS END -->    
<div class="grid_16" id="header">
<!-- MENU START -->
<div id="menu">
<ul class="group" id="menu_group_main">
	<li class="item first" id="one"><a href="dashboard.php" class="main current"><span class="outer"><span class="inner dashboard">Dashboard</span></span></a></li>
        <li class="item middle" id="two"><a href="page.php" class="main"><span class="outer"><span class="inner content">Pages</span></span></a></li>
        <li class="item middle" id="three"><a href="#" class="main"><span class="outer"><span class="inner users">Users</span></span></a></li>    
	<li class="item middle" id="four"><a href="#" class="main"><span class="outer"><span class="inner event_manager">Event Manager</span></span></a></li>        
	<li class="item middle" id="five"><a href="#" class="main"><span class="outer"><span class="inner newsletter">Newsletter</span></span></a></li>        
	<li class="item last" id="six"><a href="#" class="main"><span class="outer"><span class="inner settings">Settings</span></span></a></li>        
    </ul>
</div>
<!-- MENU END -->
</div>
<div class="grid_16">
<!-- TABS START -->
    <div id="tabs">
         <div class="container">
            <ul>
                      <li><a href="dashboard.html" class="current"><span>Dashboard elements</span></a></li>
                      <li><a href="dash/news.php"><span>News</span></a></li>
                      <li><a href="dash/topnews.php"><span>Top News</span></a></li>             </ul>
        </div>
    </div>
<!-- TABS END -->    
</div> 

<!-- CONTENT START -->
    <div class="grid_16" id="content">
    <!--  TITLE START  --> 
    <div class="grid_9">
    <h1 class="dashboard">Dashboard</h1>
    </div>
    <!--RIGHT TEXT/CALENDAR-->
    <div class="grid_6" id="eventbox"><a href="#" class="inline_calendar">You don't have any events for today! Yay!</a>
    	<div class="hidden_calendar"></div>
    </div>
    <!--RIGHT TEXT/CALENDAR END-->
    <div class="clear">
    </div>
    <!--  TITLE END  -->    
    <!-- #PORTLETS START -->
    <div id="portlets">
    <!-- FIRST SORTABLE COLUMN START -->
      <div class="column" id="left">
        <div class="portlet">
	<div class="portlet-header">Insert News</div>

	<div class="portlet-content">

	  <p> </p>
	</div>
        </div>
      </div>
      <!-- FIRST SORTABLE COLUMN END -->
      <!-- SECOND SORTABLE COLUMN START -->
      <div class="column">
      <!--THIS IS A PORTLET-->        
      <div class="portlet">
	<div class="portlet-header"><img src="images/icons/comments.gif"  webstripperwas="images/icons/comments.gif" width="16" height="16" alt="Comments" />Change Theme</div>

	<div class="portlet-content">
         <p class="info" id="success"><span class="info_inner">Change Theme To GEEN</span></p>
    <p class="info" id="error"><span class="info_inner">Change Theme To RED</span></p>
<p class="info" id="info"><span class="info_inner">Change Theme To BLUE</span></p>
</div>
       </div>    
      <!--THIS IS A PORTLET--> 
      <div class="portlet">
	<div class="portlet-header"><img src="images/icons/feed.gif"  webstripperwas="images/icons/feed.gif" width="16" height="16" alt="Feeds" />Current News					</div>
	<div class="portlet-content">
        <ul class="news_items">
        	<li>NEWS</li>
            <li>NEWS</li>
            <li>NEWS</li>
            <li>NEWS</li>
            <li>NEWS</li>
        </ul>
        <a href="#">» View all news items</a>
        </div>
       </div>                         
    </div>
<!--  SECOND SORTABLE COLUMN END -->
    <div class="clear"></div>
    <!--THIS IS A WIDE PORTLET-->
    <div class="portlet">
        <div class="portlet-header fixed"><img src="images/icons/user.gif"  webstripperwas="images/icons/user.gif" width="16" height="16" alt="Latest Registered Users" /> Last Registered users Table Example</div>
	<div class="portlet-content nopadding">
        <form action=""  webstripperwas method="post">
          <table width="100%" cellpadding="0" cellspacing="0" id="box-table-a" summary="Employee Pay Sheet">
            <thead>
              <tr>
                <th width="34" scope="col"><input type="checkbox" name="allbox" id="allbox" onclick="checkAll()" /></th>
                <th width="136" scope="col">Name</th>
                <th width="102" scope="col">Username</th>
                <th width="109" scope="col">Date</th>
                <th width="129" scope="col">Location</th>
                <th width="171" scope="col">E-mail</th>
                <th width="123" scope="col">Phone</th>
                <th width="90" scope="col">Actions</th>
              </tr>
            </thead>
            <tbody>

              <tr class="footer">
                <td colspan="4"><a href="#" class="edit_inline">Edit all</a><a href="#" class="delete_inline">Delete all</a><a href="#" class="approve_inline">Approve all</a><a href="#" class="reject_inline">Reject all</a></td>
                <td align="right"> </td>
                <td colspan="3" align="right">      
                </td>
              </tr>
            </tbody>
          </table>
        </form>
	</div>
      </div>
<!--  END #PORTLETS -->  
   </div>
    <div class="clear"> </div>
<!-- END CONTENT-->    
  </div>
<div class="clear"> </div>

	<!-- This contains the hidden content for modal box calls -->
	<div class='hidden'>
		<div id="inline_example1" title="This is a modal box" style='padding:10px; background:#fff;'>
		<p><strong>This content comes from a hidden element on this page.</strong></p>
            			
		<p><strong>Try testing yourself!</strong></p>
            <p>You can call as many dialogs you want with jQuery UI.</p>
		</div>
	</div>
</div>
<!-- WRAPPER END -->
<!-- FOOTER START -->
<div class="container_16" id="footer">
Website Administration by <a href="http://www.webgurus.biz" >WebGurus</a></div>
<!-- FOOTER END -->
</body>
</html>
<?php } else { echo 'You are not logged in as an administrator.'; } ?>

     

    Whats in Connect:

    <?php
include 'config.php';
DEFINE ('DB_HOST', DB_HOST); // This will most likely stay the same.
DEFINE ('DB_USER', DB_USER); // Insert your database username into the quotes.
DEFINE ('DB_PASSWORD', DB_PASSWORD); // Insert your database password into the quotes.
DEFINE ('DB_NAME', DB_NAME);// Insert your actual database name in the quotes.
$con = @mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
//$con = mysql_connect(':/tmp/mysql', $dbuser, $dbpass);

mysql_select_db(DB_NAME ,$con);

include 'functions.php';

if (isset($_SESSION['user'])) {
  if($result = mysql_query("SELECT username, rights FROM users WHERE username='{$_SESSION['user']}'"));
  $n = mysql_fetch_assoc($result);
  if($n['banned'] == 1)
  {
    header("Location: logout.php");
  }
  else
  {
    if($n['rights'] == 2)
    {
      $_SESSION['admin'] = $n['username'];
      $_SESSION['user'] = $n['username'];
    }
    elseif($n['rights'] == 1)
    {
      $_SESSION['mod'] = $n['username'];
      $_SESSION['user'] = $n['username'];
    }
    elseif($n['rights'] == 0)
    {
      $_SESSION['user'] = $n['username'];
    }
   }
}

     

    Whats in Config.php:

    <?php
DEFINE ('DB_HOST', 'localhost'); // This will most likely stay the same.
DEFINE ('DB_USER', 'root'); // Insert your database username into the quotes.
DEFINE ('DB_PASSWORD', ''); // Insert your database password into the quotes.
DEFINE ('DB_NAME', 'school');// Insert your actual database name in the quotes.
$dbc = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die ('Could not connect to MySQL: ' . mysql_error());
mysql_select_db (DB_NAME) OR die('Could not select the database: ' . mysql_error() );

?>

     

    whats in Functions.php:

    <?php
function ___($_)
{
  return base64_decode($_);
}
function realEscape($string)
{
  if(get_magic_quotes_gpc())
  {
    return mysql_real_escape_string(stripslashes($string));
  }
  else
  {
    return mysql_real_escape_string($string);
  }
}
function capitalize($value)
{
$capitalize = preg_replace('/[a-z]/ie', 'strtoupper($0);', $value, 1);
return htmlspecialchars($capitalize);
}
function encrypt($value)
{
return md5(md5(base64_encode($value)));
}
$w = 1;
function smileys($value)
{
  global $ln;
  $codes = array(
    '',
    ':angel:',
    ':@',
    '',
    ':s',
    ':dodgy:',
    ':!:',
    ':heart:',
    '',
    '',
':tired:',
':-/',
'',
':cool:',
'',
'',
'',
'');
  $img = array(
    '<IMG alt="Smile" title="Smile" src="http://runelegend.com/images/smilies/smile.gif">',
    '<IMG alt="Angel" title="Angle" src="http://runelegend.com/images/smilies/angel.gif">',
    '<IMG alt="Angry" title="Angry" src="http://runelegend.com/images/smilies/angry.gif">',
    '<IMG alt="Shy" title="Shy" src="http://runelegend.com/images/smilies/blush.gif">',
    '<IMG alt="Confused" title="Confused" src="http://runelegend.com/images/smilies/confused.gif">',
    '<IMG alt="Dodgy" title="Dodgy" src="http://runelegend.com/images/smilies/dodgy.gif">',
    '<IMG alt="Exclamation" title="Exclamation" src="http://runelegend.com/images/smilies/exclamation.gif">',
    '<IMG alt="Heart" title="Heart" src="http://runelegend.com/images/smilies/heart.gif">',
    '<IMG alt="Confused" title="Confused" src="http://runelegend.com/images/smilies/huh.gif">',
    '<IMG alt="Idea" title="Idea" src="http://runelegend.com/images/smilies/lightbulb.gif">',
'<IMG alt="Sleepy" title="Sleepy" src="http://runelegend.com/images/smilies/sleepy.gif">',
'<IMG alt="Undecided" title="Undecided" src="http://runelegend.com/images/smilies/undecided.gif">',
'<IMG alt="Wink" title="Wink" src="http://runelegend.com/images/smilies/wink.gif">',
'<IMG alt="Cool" title="Cool" src="http://runelegend.com/images/smilies/cool.gif">',
'<IMG alt="Biggrin" title="Biggrin" src="http://runelegend.com/images/smilies/biggrin.gif">',
'<IMG alt="Tongue" title="Tongue" src="http://runelegend.com/images/smilies/tongue.gif">',
'<IMG alt="Rolleyes" title="Rolleyes" src="http://runelegend.com/images/smilies/rolleyes.gif">',
'<IMG alt="Sad" title="Sad" src="http://runelegend.com/images/smilies/sad.gif">');
  return str_ireplace($codes, $img, $value);
}
function bbcodes($value)
{
$value1 = htmlspecialchars($value);
  $bbcodes = array(
'/\[url=(.*)\](.*)\[\/url\]/isU',
'/\[b\](.*)\[\/b\]/isU',
'/\[img\](.*)\[\/img\]/isU',
'/\[u\](.*)\[\/u\]/isU',
'/\[i\](.*)\[\/i\]/isU',
'/\[url\](.*)\[\/url\]/isU',
'/\[s\](.*)\[\/s\]/isU',
'/\[color=(#?[a-z0-9]+)\](.*)\[\/color\]/isU',
'/\[center\](.*)\[\/center\]/isU',
'/\[big\](.*)\[\/big\]/isU',
'/\[small\](.*)\[\/small\]/isU',
  );
  $html = array(
'<a class="hrefblack" href="$1">$2</a>',
'<b>$1</b>',
'<img src="$1">',
'<u>$1</u>',
'<i>$1</i>',
'<a href="$1">$1</a>',
'<s>$1</s>',
'<div style="color: $1">$2</div>',
'<div style="text-align: center">$1</div>',
'<div style="font-size: 3em">$1</div>',
  '<div style="font-size: 0.8em">$1</div>',
);
$result = preg_replace($bbcodes, $html, $value1);
return $result;
}
/*
if(isset($_SESSION['admin']) || isset($_SESSION['user']))
{
  if($news1 = mysql_query("SELECT * FROM ".$prefix."users WHERE uname='". $_SESSION['user'] ."'"))
  {
  if(mysql_num_rows($news1) > 0)
  {
    while($n = mysql_fetch_array($news1))
    {
      if($n['banned'] == 1)
      {
        header("Location: logout.php");
      }
    }
  }
  }
}
if($checkipban = mysql_query("SELECT * FROM ". $prefix ."ipban WHERE ip='". $_SERVER['REMOTE_ADDR'] ."'"))
{
  if(mysql_num_rows($checkipban) > 0)
  {
    header("Location: ipbanned.php");
  }
}*/
?>
<?php
function capitalizeFirstCharacter($value)
{
  $capitalize = preg_replace('/[a-z]/ie', 'strtoupper($0);', $value, 1);
  return $capitalize;
}
?>

     

    Whats in getuserinfo.php:

    <?php
$result = mysql_query("SELECT * FROM main id=". $_SESSION['id']) or die(mysql_error());
$row = mysql_fetch_assoc($result);
$acptheme = $row["acptheme"];
?>

     

    Please Help.

    Downloading

    in PHP Coding Help

    Posted

    Error:

    No error, Im trying to Make it Download But it wont Download...

     

    Code:

    <table border="2" cellpadding="2" cellspacing="2" width="100%">
<tr>
<td>ID</td><td>NAME</td><td>TYPE</td><td>SIZE</td><td>DATE ADDED</td><td>DOWNLOAD</td>
</tr>
<?php

//porperties
$result = mysql_query("SELECT * FROM uploaded");
while($r=mysql_fetch_array($result))
{
		   $link=$r["link"];
		   $name=$r["name"];
		   $type=$r["type"];
		   $size=$r["size"];
		   $date=$r["date"];
		   $id=$r["id"];
echo "
<tr>
<td>$id</td><td>$name</td><td>$type</td><td>$size</td><td>$date</td><td><a href='$link'>Download $name</a></td>
</tr>
";
}
?>           
</table>

    Whats Wrong With This

    in PHP Coding Help

    Posted

    Cant Figure Out Whats Wrong With it..

    Code:

    			<?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

    Selecting a certain amount

    in PHP Coding Help

    Posted

    Error:

    No error, Im have trouble Having This Loop Select Only 2 Uploads At a Time.

     

    Code:

    					<?php

//porperties
$result = mysql_query("SELECT * FROM uploaded");
while($r=mysql_fetch_array($result))
{
		   $link=$r["link"];
		   $name=$r["name"];
		   $type=$r["type"];
		   $size=$r["size"];
		   $date=$r["date"];
		   $id=$r["id"];
echo "
The File $name Was Currently Updated<br>
Size: $size<br>
Type: $type<br>
Date Updated: $date<br>
Link: <a href='$link'>Download</a><br><br>
";
}
?> 

     

    Couldn't Think of a Good name For this,Sorry

    Just need help..

    in PHP Coding Help

    Posted

     

    Error:

    No error, IT dont loop, Idk why.. help please

     

    Code:

    <?php

$rr = mysql_query("SELECT * FROM news");
while($r = mysql_fetch_array($rr))
{
$name1=$r["name"];
$desr=$r["desr"];
$link1=$r["link"];
$date1=$r["date"];
$datem1=$r["datem"];
}
echo "
                            <div class='cs_article'>
                            	
                                <div class='left'>
                                    <h2>$name1</h2>
                                    <p>$desr</p>
                                    
                                    <div class='button'><a href='$link1'>Read more</a></div>
                               	</div>
                                <div class='right'>
							<h1>$name1</h1>
							</div>
                                                                
                            </div>
";
?>

    Just need help..

    in PHP Coding Help

    Posted

    Error:

    The edit is supposed to add the updated into the database, but it dont add... Help please

     

    Code:

    <?php
if(isset($_GET['action']) && $_GET['action'] == 'edit') {
$id="{$_GET['id']}";

if ($list_q = mysql_query("SELECT * FROM blog WHERE ID='$id'")) {
  if (mysql_num_rows($list_q)) {
    while($list_b=mysql_fetch_array($list_q)) 
    {
if(empty($C_Error) and !empty($_POST['Submit'])) {
mysql_query("UPDATE blog SET name='". realEscape($_POST['name']) ."', descr='". realEscape($_POST['descr']) ."' WHERE id=$id") or die(mysql_error());
echo 'News Updated';
}
?><hr><center>
<form action="news.php?action=edit&id=<?php echo $list_b['id'];?>" method="post">
Name:<br>
<input type="text" class="textbox" name="name" maxlength="25" size="25" value="<?php echo $list_b['name'];?>" /><br>
Content:<br>
<textarea name="descr" rows="5" cols="60" maxlength="10000"><?php echo $list_b['descr'];?></textarea><br>
<input type="submit" class="button" name="Submit" value="Edit News" />
</form></center>
<?php
}}}}
?>

    ERROR

    in PHP Coding Help

    Posted

    Error:

    Fatal error: Query Error: No database selected in /home/a5640714/public_html/school/aa/pages/news.php on line 38

     

    Code:

    	                <?php
include '../inc/connect.php';
		$result = mysql_query("SELECT * FROM blog ORDER BY id ASC") or trigger_error('Query Error: ' . mysql_error(), E_USER_ERROR);
		//the while loop
		while($r=mysql_fetch_array($result))
		{
$id=$r["ID"];
$name=$r["name"];
$desc=$r["descr"];
$date=$r["date"];
echo "
<tr>
<td>
News Name: $name
</td>
<td>
News Desc: $desc
</td>
<td>
Date Posted: $date
</td>
<td>
<a href='news.php?action=edit&id=$id'>Edit</a>
</td>
<td>
<a href='news.php?action=delete&id=$id'>Delete $name</a>
</td>
</tr>
";
}
?>

    Line 38:

    			$result = mysql_query("SELECT * FROM blog ORDER BY id ASC") or trigger_error('Query Error: ' . mysql_error(), E_USER_ERROR);

    Just need help..

    in PHP Coding Help

    Posted

    Error:

    No error, Having Trouble Making My Blod Editer.. Do what You can Please..

     

    Code:

    <?php
if(isset($_GET['action']) && $_GET['action'] == 'edit') {
echo "
<hr><center><h1>Editing News $name</h1>
<form action='news.php?action=edit123' method='POST'>
Your News Name:<br>
<input id='name' type='text' name='name' autocomplete='off' maxlength='25'><br>Your News Description: <br>
<textarea name='descrr' id='descrr' rows='3' cols='60' maxlength='250'> </textarea><br>
<input type='submit' name='submit' value='Add News'>
</form></center><hr>
";
}
?>
<?php
if(isset($_GET['action']) && $_GET['action'] == 'edit123') {
  if( isset($_GET['id']) && is_numeric($_GET['id']))
  {
    $id = (int) $_GET['id'];
    mysql_query("UPDATE blog SET name=name WHERE descr=$descrr") or die(mysql_error());
    echo "News: $name Updated";
  }
   else
  {
     echo "Name is Empty";
  }
}
?>

     

    LOL @ Thorpe, Yea i do. I Need to Make Edit123 update the One Selected, And "Editing News $name" Have the One Selected, Thanks in Advanced. Once I have the Things i asked for . Im Good.

    Another Error!

    in PHP Coding Help

    Posted

    Thats it :P

     

    Fatal error: Query Error: 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 'desc' at line 1 in C:\Users\cory\Desktop\xampp\htdocs\Starter Kit(2)\admincp\pages\news.php on line 38

     

     

    Line 38 Is the Query. Wild Gave me

    Another Error!

    in PHP Coding Help

    Posted

    Error:

     

    Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\Users\cory\Desktop\xampp\htdocs\Starter Kit(2)\admincp\pages\news.php on line 40

     

    Code:

     

    	                <?php		$result = mysql_query("SELECT * FROM blog ORDER BY desc");		//the while loop		while($r=mysql_fetch_array($result))		{$id=$r["ID"];$name=$r["name"];$desc=$r["descr"];$date=$r["date"];echo "<tr><td>News Name: $name</td><td>News Desc: $desc</td><td>Date Posted: $date</td><td><a href='edit.php'>Edit</a></td><td><a href='news.php?action=delete&id=$id'>Delete $name</a></td></tr>";}?>

     

    Line 40:

     

    while($r=mysql_fetch_array($result))

     

    Error!!

    in PHP Coding Help

    Posted

    THANK YOU IT WORKS 100% Thanks WILDTEEN88

     

    @@@@ ALSO how do i make it do ORDER BY desc ?

     

    I added it , Got

    Error:

     

     

    Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\Users\cory\Desktop\xampp\htdocs\Starter Kit(2)\admincp\pages\news.php on line 40

     

    Code:

     

    	                <?php		$result = mysql_query("SELECT * FROM blog ORDER BY desc");		//the while loop		while($r=mysql_fetch_array($result))		{$id=$r["ID"];$name=$r["name"];$desc=$r["descr"];$date=$r["date"];echo "<tr><td>News Name: $name</td><td>News Desc: $desc</td><td>Date Posted: $date</td><td><a href='edit.php'>Edit</a></td><td><a href='news.php?action=delete&id=$id'>Delete $name</a></td></tr>";}?>

     

    Line 40:

     

    while($r=mysql_fetch_array($result))

     

    Error!!

    in PHP Coding Help

    Posted

    Change this: realEscape('name') to this: '$name'.

    WHERE name = name will match every record in the table.  Also, its already been escaped once, so it doesn't need it again.

     

    Didnt work.. I also have ID so if u got anything to match it with an id , lets hear it..

     

    **EDIT**

    Edited Code So far..

     

    	                <?php		$result = mysql_query("SELECT * FROM blog");		//the while loop		while($r=mysql_fetch_array($result))		{$id=$r["ID"];$name=$r["name"];$desc=$r["descr"];$date=$r["date"];if(isset($_GET['action']) && $_GET['action'] == 'delete') {  $id = realEscape($r["ID"]);  if( isset($id) && $id != "")  {    $sql_delete = sprintf("DELETE FROM blog WHERE ID='%s' ", realEscape($r["ID"]) );    echo "SQL is |$sql_delete|";  //remove after debugging    mysql_query("DELETE FROM blog WHERE ID='$id'") or die(mysql_error());    echo "News Deleted";  }   else  {     echo "name is empty";  }}echo "<tr><td>News Name: $name</td><td>News Desc: $desc</td><td>Date Posted: $date</td><td><a href='edit.php'>Edit</a></td><td><a href='news.php?action=delete'>Delete $name</a></td></tr>";}?>

     

    Error!!

    in PHP Coding Help

    Posted

    Replace this

     

     

    if(isset($_GET['action']) && $_GET['action'] == 'delete') {mysql_query("DELETE FROM blog WHERE name='". realEscape('name') ."'") or die(mysql_error());echo "News Deleted";}

     

     

    with this

     

     

    if(isset($_GET['action']) && $_GET['action'] == 'delete') {  $name = realEscape($r["name"]);  if( isset($name) && $name != "")  {    $sql_delete = sprintf("DELETE FROM blog WHERE name='%s' ", realEscape($r["name"]) );    echo "SQL is |$sql_delete|";  //remove after debugging    mysql_query("DELETE FROM blog WHERE name='". realEscape('name') ."'") or die(mysql_error());    echo "News Deleted";  }   else  {     echo "name is empty";  }}

     

     

     

    It didnt work.. Im having problems with it deleting everything.. i just want the delete to Delete that Just One im Deleting, If u have a Team-Veiwer Ill try to show u what i mean.

    EDIT

     

    Actully it did work.. It now Shows IT deleting Everything.. LOL.. Now how do i stop it? And make it Delete The Name Itself

     

    EDIT

    Now i Got it to Say its name.. it says correct name.. But it still Deletes them all ,I think it has Something to do With 

    <td><a href='news.php?action=delete'>Delete $name</a></td>

     

     

    EDIT

    My Edited Code:

     

    	                <?php		$result = mysql_query("SELECT * FROM blog");		//the while loop		while($r=mysql_fetch_array($result))		{$id=$r["ID"];$name=$r["name"];$desc=$r["descr"];$date=$r["date"];if(isset($_GET['action']) && $_GET['action'] == 'delete') {  $name = realEscape($r["name"]);  if( isset($name) && $name != "")  {    $sql_delete = sprintf("DELETE FROM blog WHERE name='%s' ", realEscape($r["name"]) );    echo "SQL is |$sql_delete|";  //remove after debugging    mysql_query("DELETE FROM blog WHERE name='". realEscape($name) ."'") or die(mysql_error());    echo "News Deleted";  }   else  {     echo "name is empty";  }}echo "<tr><td>News Name: $name</td><td>News Desc: $desc</td><td>Date Posted: $date</td><td><a href='edit.php'>Edit</a></td><td><a href='news.php?action=delete'>Delete $name</a></td></tr>";}?>

     

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.