Learn VBA & Macros in 1 Week!

PHP - Mysql Resource Is Not Valid

Full Excel VBA Course - Beginner to Expert

Mysql Resource Is Not Valid	View Content

I always use my queries like below
mysql_query("SELECT id FROM someTable", $cn);

but some times i see in my error_log says: mysql_fetch_array(): supplied argument is not a valid MySQL result resource. Why is this happening?
I mean, there is no problem with my sites and all they are working as they should be but why php generates this error?

Full Excel VBA Course - Beginner to Expert

Supplied Argument Is Not A Valid Mysql Result Resource

Similar Tutorials

View Content

Thanks for reading! I'm working on a site and it won't display my records from the database. I have a little filter system that did work, but now it doesn't. I get the following error message:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/60608.glrdmd.eu/httpdocs/jakesite/select3.php on line 26

Relevant code to the error is:

Code: [Select]
<?php
include("connection.php");

if(isset($_POST['Graphic']) &&
   $_POST['Graphic'] == 'yes')
{
$result1 = "graphic";
}
if(isset($_POST['Interactive']) &&
   $_POST['Interactive'] == 'yes')
{
$result2 = "interactive";
}
if(isset($_POST['Websites']) &&
   $_POST['Websites'] == 'yes')
{
$result3 = "websites";
}
$order = $_POST['group1'];
$sql = ("SELECT * FROM 'jake_portfolio' WHERE CAT = '$result1' OR CAT = '$result2' OR CAT = '$result3' ORDER BY '$order' LIMIT 0, 4");
$result = mysql_query($sql);
$checked = "checked";
$row = mysql_fetch_array($result);
?>

Does anyone see what I am doing wrong here?

Supplied Argument Is Not A Valid Mysql Result Resource

Similar Tutorials

View Content

$getURL = mysql_fetch_assoc(mysql_query("SELECT `urlname` FROM `workingurls` ORDER BY RAND() LIMIT 1"));

spits out

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /public_html/script.php on line 130

How do you make mysql_fetch_assoc a valid MySQL result resource?

Mysql_num_rows(): Supplied Argument Is Not A Valid Mysql Result Resource

Similar Tutorials

View Content

Hi everyone!

I have the following error message:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /hermes/bosweb25a/b109/ipg.removalspacecom/checklogin.php on line 47
Wrong Username or Password

by using the below code:

Code: [Select]
<?PHP

include ('db.php');

// Define $username and $password
$username=$_POST['username'];
$password=$_POST['password'];

// To protect MySQL injection (more detail about MySQL injection)
$username = stripslashes($username);
$password = stripslashes($password);
$username = mysql_real_escape_string($username);
$password = mysql_real_escape_string($password);

$sql="SELECT * FROM $companies WHERE username='$username' and password='$password'";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $username and $password, table row must be 1 row

if($count==1){
// Register $username, $password and redirect to file "login_success.php"
session_register("username");
session_register("password");
header("location:login_success.php");
}
else {
echo "Wrong Username or Password";
}

ob_end_flush();
?>

Does anyone have an idea of whats happening? from a guess it's looking for the username and password in the database, but i've made sure that this username and password in IN the correct fields in the table ect??

Thanks

Mysql_fetch_array(): Supplied Argument In Not A Valid Mysql Result Resource.

Similar Tutorials

View Content

Hi Guys,

I have been working on a recursive select box that will allow sub-categories and keep getting the error:

<b>Warning</b>: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>test.php</b> on line <b>22</b><br /

i have a table as follows:

Code: [Select]
CREATE TABLE IF NOT EXISTS `ost_help_topic` (
`topic_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`isactive` tinyint(1) unsigned NOT NULL DEFAULT '1',
`noautoresp` tinyint(3) unsigned NOT NULL DEFAULT '0',
`priority_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
`dept_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
`CatParent` bigint(11) unsigned DEFAULT NULL,
`topic` varchar(32) NOT NULL DEFAULT '',
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`topic_id`),
UNIQUE KEY `topic` (`topic`),
KEY `priority_id` (`priority_id`),
KEY `dept_id` (`dept_id`)
)
Code: [Select]
<?php

$db_host = "localhost";
$db_un = "user";
$db_pass = "pass";
$Item_DB = "data";
$table = "ost_help_topic";

$link = mysql_connect($db_host, $db_un, $db_pass);

$tab = "        "; // this is 8 spaces, which works as a pseudo-tab character inside the <option>s
$tablvl = 1;
function print_kids($pos) { // $pos is the current position inside the hierarchy (curr item's ID)
   global $link;
   global $tab;
   global $tablvl;
   $pos = ($pos?$pos:null);
   $query = "SELECT * from $table WHERE isactive=1 AND CatParent".($pos == null ? " IS NULL" : "=".$pos);
         // NULL parent == top level item.  For 0-parents, replace " IS NULL" with "=0"
   $res = mysql_db_query($Item_DB, $query, $link);
   if (!$res) print(mysql_error());
   while($row = mysql_fetch_array($res)) {
      $has_kids = mysql_fetch_array(mysql_db_query($Item_DB, "SELECT * from $table where isactive=1 AND CatParent=$row[0]", $link)) != null;
      print("<option value=\"$row[0]\">");
      for ($i=0; $i<$tablvl; $i++) print($tab);
      print("$row[6]</option>\n");
      if ($has_kids) {
         $tablvl++;
         print_kids($row[0]); // <span class="posthilit">recursive</span> call
         $tablvl--;
      }

   }
}

$numrows = 1;

$res = mysql_db_query($Item_DB, "SELECT * FROM $table", $link);

while (mysql_fetch_array($res)) $numrows++;

// Yes, I'm sure there's a more efficient way to do this <img src="./images/smilies/icon_razz.gif" alt=":P" title="Razz" />

print("<select name=\"hierarchy\" size=\"$numrows\">\n");
print("<option value=\"null\" selected=\"selected\">Root of all items</option>\n");
print_kids(0);
print("</select>");
mysql_close($link);
?>

Moved: Joining 3 Tables And Get - Not A Valid Mysql Result Resource

Similar Tutorials

View Content

This topic has been moved to MySQL Help.

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

Mysql_num_rows(): Supplied Argument Is Not A Valid Mysql Result Resource

Similar Tutorials

View Content

I get the following error:

with the following code:

Code: [Select]

$username="****";
$password="****";
$database="checkmyw_database";
mysql_connect('localhost',$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query3="SELECT * FROM hours WHERE (out1<>'0' AND in1=='0' OR out2<>'0' AND in2=='0') && (date==$date)";
$result3=mysql_query($query3);
$num3=mysql_numrows($result3);
mysql_close();

if($num3==0){
$clockedout="true";}

echo $clockedout;

Any ideas why

Mysql_num_rows(): Supplied Argument Is Not A Valid Mysql Result Resource

Similar Tutorials

View Content

Hi guys,

I have this code here working which will show certain data in the table depending on what string the user searches for, and with the records that pop up you are able to delete these records too.. now all this is working but after I delete records I get this error:

"Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/define/public_html/golf/Pete/php/searchcallback.php on line 22"

I assume this is because num rows are empty after the deletion is done/ and this now shows "no records showing" can anyone help me why this error is popping up? Although deletion does work, I would like to get rid of this error message.

Code: [Select]

<?php
include "connect.php";

$searchvalue = $_POST['searchvalue'];
$su = $_POST['search'];

//Check if records were submitted for deletion
if(isset($_POST['callbackid']) && count($_POST['callbackid']))
{
    //Ensure values are ints
    $deleteIDs = implode(', ', array_map('intval', $_POST['callbackid']));
    $query = "DELETE FROM callback WHERE callbackid IN ({$deleteIDs})";
    //Debug line
    echo "<br/>Successfuly deleted callback(s) <br/>";
    mysql_query($query) or die(mysql_error());
}

$result = mysql_query("SELECT * FROM callback WHERE $searchvalue LIKE '%$su%'");
$num_rows = mysql_num_rows($result);

?>
<link rel="stylesheet" type="text/css" href="view.css" media="all">
<script type="text/javascript" src="view.js"></script>
<body id="main_body" >

<img id="top" src="top.png" alt="">
<div id="form_container">

<h1>Show, Search or Delete Callback Records<</h1>

<form id="form_362567" class="appnitro" method="post" action="searchcallback.php">
<div class="form_description">
<h2> Show, Search or Delete Callback Records</h2>
<p></p>
</div>
<ul >

<li class="section_break">
<?php
if ($num_rows==0){
?>

<br>No records found<br><br>
<INPUT TYPE="button" VALUE="Go Back" onClick="history.go(-1);return true;"><br>
<?php
} else{
while($row = mysql_fetch_array($result))
{

//..results as in your post.

echo "<form action='' method='POST'>";
echo "<br/>";
echo "<b>Callback ID:</b>";
echo "<br/>";
echo $row['callbackid'];
echo "<br/>";
echo "<b>Full Name:</b>";
echo "<br/>";
echo $row['fullname'];
echo "<br/>";
echo "<b>E-mail:</b>";
echo "<br/>";
echo $row['email'];
echo "<br/>";
echo "<b>Phone Number:</b>";
echo "<br/>";
echo $row['phone'];
echo "<br/>";
echo "<b>Comment:</b>";
echo "<br/>";
echo $row['comment'];
echo "<br/>";
echo "<input type='checkbox' name='callbackid[]' value='{$row['callbackid']}' /> <b>Delete</b>\n";
?>
<li class="section_break">

<?php
}
?>
<br><input type='submit' value='Delete Records' name='delete' /><INPUT TYPE="button" VALUE="Cancel" onClick="history.go(-1);return true;"><br>
</form>
<div id="footer">

</div>
</div>
<img id="bottom" src="bottom.png" alt="">
</body>
<?php

}
?>

Thanks for any help in advance

Getting An Error Supplied Argument Is Not A Valid Mysql Result Resource

Similar Tutorials

View Content

This is the full error...Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in

This is what I am trying to do...
1. get data from the page before which it gets fine in the $_GET function...
2. then set the sersion[username] to $username...(I think I am doing something wrong there)
3. then if the $username doesnt match the username pulled from the database (according to the $_GET info) then open a different databse and update a value in that table.
4. then kill the code die ();

someone please help I have been trying to figure this out all day

Code: [Select]
<?php

$username = $_SESSION['username'];
$deleted = $_GET['deleted'];

// Connect to MySQL
$connect = mysql_connect("db","user","pass") or die("Not connected");
mysql_select_db("dv") or die("could not log in");

// grab the information according to the isbn number
$query = "SELECT * FROM 'boox' WHERE isbn='$deleted'";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{

if ($username==$row['username'])
{
echo"Welcome, ".$_SESSION['username']."";
// Delete entry where isbn number matches accordingly
mysql_query("DELETE * FROM 'boox' WHERE isbn='$deleted'");
}
elseif ($username!=$row['username'])

{
$username = $_SESSION['username'];

$connect = mysql_connect("db","user","pass") or die("Not connected");
mysql_select_db("db") or die("could not log in");

// run a query to deactivete a account
$acti = mysql_query("UPDATE 'desiredusers' SET activated='2' WHERE username='$username'");
$byebye = "SELECT * FROM 'desiredusers' WHERE isbn='$deleted'";
$results = mysql_query($byebye);
while($row2 = mysql_fetch_array($results))
echo "here".$username."here";
die("Your account is deactivated contact College Boox Store to get your account back.");
}
else
echo "there is nothing being checked" . $username . "";
}
?>

Warning: Mysql_query(): Supplied Argument Is Not A Valid Mysql-link Resource In

Similar Tutorials

View Content

I have a function that generates a random number and checks to make sure it does not exists in the database.

I call this function using
Code: [Select]
$ref = get_record_ref();

I get the following error.

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in line 68

EDITED....
if i place the code from the function in my script and not use it as a function the script works.
why would this be?

Code: [Select]
<?php
  db_connect() or die('Unable to connect to database server!');

  function db_connect($server = 'localhost', $username = 'username', $password = 'password', $database = 'databasename', $link = 'db_link') {
    global $$link;

    $$link = mysql_connect($server, $username, $password);

    if ($$link) mysql_select_db($database);

    return $$link;
  }

//Function to handle database errors.
  function db_error($query, $errno, $error) {
die('<font color="#000000"><strong>' . $errno . '<br><br><br><br><small><font color="#ff0000">[STOP]</font></small><br><br></strong><br><br><br>One of our coders have been informed of this problem and shall be working on it very shortly.<br><br>Please try again in a few minutes or so when we should have this issue fixed.<br><br>Thank you.</font>');
  }

//Function to query the database.
  function db_query($query, $link = 'db_link') {
    global $$link;
$theip = $_SERVER['REMOTE_ADDR'];
$httpuseragent = $_SERVER['HTTP_USER_AGENT'];
$fromlink4 = gethostbyaddr($_SERVER['REMOTE_ADDR']);

// this next line is the error line 68
    $result = mysql_query($query, $$link) or db_error($query, mysql_errno(), mysql_error());

    return $result;
  }

function get_record_ref() {
// /*
// set new $record_ref.
$record_ref =  (rand(10, rand(10, 1000000000)));
// check if exisits in DB.
$sql = "SELECT * FROM `table` WHERE `record_ref` = '". $record_ref ."'";
$get_records_with_record_ref = db_query($sql,'');
// count entries in DB for $record_ref.
$count_record_ref =  mysql_num_rows($get_records_with_record_ref);

while ($count_record_ref > 0) {
// set new $record_ref.
$record_ref =  (rand(10, rand(10, 1000000000)));
// check if exisits in DB.
$sql = "SELECT * FROM `table` WHERE `record_ref` = '". $record_ref ."'";
$get_records_with_record_ref = db_query($sql);
// count entries in DB for $record_ref.
$count_record_ref =  mysql_num_rows($get_records_with_record_ref);
}
// */
return $record_ref;
}
?>

Chat Script Mysql_fetch_array(): Supplied Argument Is Not A Valid Mysql Result Resource

Similar Tutorials

View Content

Hi I'm currently having a problem with my chat script each time I'm trying to insert " or brackets etc... I get the error Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/u471530368/public_html/chat/page.php on line 201 Here is the lines at line 201


// check to see if a duplicate exists
$sql = "SELECT * FROM StringyChat WHERE StringyChat_ip=\"$ip\" AND StringyChat_message=\"$msg\" AND StringyChat_time>($post_time - 30 )";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);

if($myrow["StringyChat_message"] == "") {    // Checks if record not matching in db
// Save the record
$sql = "INSERT INTO StringyChat (StringyChat_ip,StringyChat_name,StringyChat_message,StringyChat_time) VALUES (\"$ip\",\"$name\",\"$msg\",$post_time)";
$result = mysql_query($sql);
                
                 $theTo = $email_notification_to;
                 $theSubject = "New StringyChat post at ".$domain_installed;
                 $theMessage = "A new StringyChat post has been made.\n\n";
                 $theMessage .= $name . "\n";
                 $theMessage .= date("H:i - d/m/y", $post_time) . "\n";
                 $theMessage .= $message_emailable . "\n\n";
                 $theMessage .= "Visit ".$domain_installed." to view StringyChat and much more!";
                 $theHeaders = "From: StringyChat at ".$domain_installed." <".$email_notification_to.">\r\n";
                
                 mail($theTo,$theSubject,$theMessage,$theHeaders);

} else {
echo "<span style='color:#10ce59'>Duplicate post detected!</span><p>";
}
}
else {
echo "<span style='color:#10ce59'>You can't send blanks!</span><br><br>";
}

My full script is

<?php




define('TIMEZONE', 'Africa/Harare');
date_default_timezone_set(TIMEZONE);
?>
<html><br>
<b><u>Chat Beta:</u></b> 
<span style="color:#ff0000"><br>Errors may apply please send feedback with contact us regarding problems!</span>
<br><a href="page.php">Reload</a>
</html>
<?
// database connection info
$conn = mysql_connect('*******','********','*****') or trigger_error("SQL", E_USER_ERROR);
$db = mysql_select_db('*******',$conn) or trigger_error("SQL", E_USER_ERROR);




// find out how many rows are in the table 
$sql = "SELECT COUNT(*) FROM StringyChat";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
$r = mysql_fetch_row($result);
$numrows = $r[0];


// number of rows to show per page
$rowsperpage = 20;
// find out total pages
$totalpages = ceil($numrows / $rowsperpage);


// get the current page or set a default
if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) {
   // cast var as int
   $currentpage = (int) $_GET['currentpage'];
} else {
   // default page num
   $currentpage = 1;
} // end if


// if current page is greater than total pages...
if ($currentpage > $totalpages) {
   // set current page to last page
   $currentpage = $totalpages;
} // end if
// if current page is less than first page...
if ($currentpage < 1) {
   // set current page to first page
   $currentpage = 1;
} // end if


// the offset of the list, based on current page 
$offset = ($currentpage - 1) * $rowsperpage;








    /*
     * StringyChat
     *
* Please refer to readme.txt supplied with the StringyChat distribution for information on
* installing and configuring. 
*
     */










define('TIMEZONE', 'Africa/Harare');
date_default_timezone_set(TIMEZONE);






    include("chat_code_header.php");


    $result = mysql_query("SELECT * FROM ".$ConfigTable, $db); 
    $myrow = mysql_fetch_array($result); 


    $domain_installed = $myrow["domain_installed"]; // The domain StringyChat is installed on
$install_url = $myrow["install_url"]; // URL to install dir of StringyChat
    $name_size = $myrow["name_size"]; // Maximum size of the name
    $message_size = $myrow["message_size"]; // Maximum message size. Do not exceed 250 as this is the database limit.
    $line_length = $myrow["line_length"]; // Maximum length of words in a line. Anything above this value will be split.
    $ShowPostNum = $myrow["show_posts"]; // The number of historic posts to load and display.
    $email_notification = $myrow["email_notification"]; // Send email to administrator when new posts are made. 0 = No, 1 = Yes
$email_notification_to = $myrow["email_notification_to"]; // The email address to send notifications to


    
if ($_SERVER['REQUEST_METHOD'] == "POST" && !empty($_POST['StringyChat_name'])) 
    { 
    $StringyChat_name = $_POST['StringyChat_name'];
    $StringyChat_message = $_POST['StringyChat_message'];
    }


?>


<div id="StringyChat">


<?
    // Check if visitor's IP is banned.  If so, do not display the form,
    // show a banned IP message instead.


$name = $_SERVER["HTTP_X_MXIT_NICK"];
if(!isset($name))
{
$name = "SYSOP";
}








    $ip = $_SERVER["REMOTE_ADDR"];
    $sql = "SELECT * FROM StringyChat_IPBan WHERE ip=\"$ip\"";
    $result = mysql_query($sql);
    $myrow = mysql_fetch_array($result);
    if($myrow["ip"] == "") { // Checks if IP not found in banned list








?>
<html><form name="StringyChat_form" method="POST" action="<? echo $_SERVER['REQUEST_URI']; ?>">
      <input type="hidden" name="StringyChat_name" class="StringyChatFrm" value="<?php echo $name ?>" size="20">
      <textarea name="StringyChat_message" class="StringyChatFrm" cols="20" rows="1"></textarea>
      <br>
      <input name="StringyChat_submit" class="StringyChatFrm" type="submit" value="Post Message">
    </form>
</html>


<?


    } else {
      echo "<span style='color:#10ce59'><u>Dear User, you have been banned from the Chat due to not following the rules. You will need to come back regularly to see if you were unbanned. Until then, goodbye!</u></span>";
    }
    
    // Should we try to create a post?
    if (isset($StringyChat_name) && isset($StringyChat_message)) {


        // Remove whitespaces and slashes.
        $name = trim(stripslashes($StringyChat_name));
        $message = trim(stripslashes($StringyChat_message));


        
            // Check name and message have been entered.
            if (strlen($name) > 0 && strlen($message) > 0) {
                
                // Limit the size of the fields as per variable defnitions.
                if (strlen($name) > $name_size) {
                    $name = substr($name, 0, $name_size);
                }
                if (strlen($message) > $message_size) {
                    $message = substr($message, 0, $message_size);
                }
                
                // Remove new lines from name.
                $name = str_replace("\n", " ", $name);
                
// Stripping out \r's so email formattnig appears correctly.
$message = str_replace("\r", "", $message);


// Create an email-friendly version of the message.
$message_emailable = str_replace("<br>", "\n", $message);
$result_wordswap = mysql_query("SELECT * FROM ".$WordBanTable,$db);
                while ($myrow_wordswap = mysql_fetch_array($result_wordswap)) {
             $the_word = $myrow_wordswap["word"];
                  $message_emailable = ereg_replace($the_word, "!*#$%",$message_emailable);
                }


                // Replace the new lines with encoded line breaks for HTML (thanks milahu).
                $message = str_replace("\n", "c#lb", $message);


                // Use HTML encoding on ame and message so database doesn't misinterpret data.
           $name = htmlentities($name);
                $message = htmlentities($message, ENT_COMPAT);


                
                
                // IP address of submitter and time of post.
$ip = $_SERVER["REMOTE_ADDR"];
$name = $_SERVER["HTTP_X_MXIT_NICK"];
$msg = $_POST['StringyChat_message'];
$post_time = date("U");
$mxitid = $_SERVER["HTTP_X_MXIT_LOGIN"];






if(!isset($mxitid))
{
$mxitid = "DEFAULT";


}
if(!isset($name))
{
$name = "SYSOP";
}








                // check to see if a duplicate exists
                $sql = "SELECT * FROM StringyChat WHERE StringyChat_ip=\"$ip\" AND StringyChat_message=\"$msg\" AND StringyChat_time>($post_time - 30 )";
                $result = mysql_query($sql);
                $myrow = mysql_fetch_array($result);


                if($myrow["StringyChat_message"] == "") { // Checks if record not matching in db
                  // Save the record
                  $sql = "INSERT INTO StringyChat (StringyChat_ip,StringyChat_name,StringyChat_message,StringyChat_time) VALUES (\"$ip\",\"$name\",\"$msg\",$post_time)";
                  $result = mysql_query($sql);


 $theTo = $email_notification_to;
 $theSubject = "New StringyChat post at ".$domain_installed;
 $theMessage = "A new StringyChat post has been made.\n\n";
 $theMessage .= $name . "\n";
 $theMessage .= date("H:i - d/m/y", $post_time) . "\n";
 $theMessage .= $message_emailable . "\n\n";
   $theMessage .= "Visit ".$domain_installed." to view StringyChat and much more!";
 $theHeaders = "From: StringyChat at ".$domain_installed." <".$email_notification_to.">\r\n";


 mail($theTo,$theSubject,$theMessage,$theHeaders);


                } else {
                  echo "<span style='color:#10ce59'>Duplicate post detected!</span><p>";
                }                
            }
            else {
                echo "<span style='color:#10ce59'>You can't send blanks!</span><br><br>";
            }


      unset($_POST["StringyChat_name"]);
      unset($_POST["StringyChat_message"]);
      unset($StringyChat_ip);
      unset($StringyChat_name);
      unset($StringyChat_message);
      unset($StringyChat_time);
      unset($mxit_id);


    }
    
// get the info from the db 
$sql = "SELECT StringyChat_time, StringyChat_name, StringyChat_message FROM StringyChat ORDER BY id DESC LIMIT $offset, $rowsperpage";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);






function filterBadWords($str)
{




    $result1 = mysql_query("SELECT word FROM StringyChat_WordBan") or die(mysql_error()); 
    $replacements = ":-x";
    
    while($row = mysql_fetch_assoc($result1))
    {
          $str = eregi_replace($row['word'], str_repeat(':-x', strlen($row['word'])), $str);
    }  
    
    return $str;
}






// while there are rows to be fetched...
while ($list = mysql_fetch_assoc($result)) 
//while (($pmsg = $list['StringyChat_message'] == $bwords) ? ":-x" : $list['StringyChat_message'])
 {
   // echo data
   //echo ($pmsg = ($list['StringyChat_message'] == $bwords) ? ":-x" : $list['StringyChat_message'])
$admin = array('cobusbo','Admin+TT');






if (in_array($list['StringyChat_name'], $admin))
{
   print '<span style="color:#828282">' . '(' . date( 'D H:i:s', $list['StringyChat_time'] )  . ') ' . '</span>' . '<span style="color:red">' .  '<b>' . $list['StringyChat_name'] . '</b>' . ' : ' . filterBadWords($list['StringyChat_message']) . '</span>' . '<br />' . '<p>';
}
else
{
   print '<span style="color:#828282">' . '(' . date( 'D H:i:s', $list['StringyChat_time'] )  . ') ' . '</span>' .  '<b>' . $list['StringyChat_name'] . '</b>' . ' : ' . filterBadWords($list['StringyChat_message']) . '<br />' . '<p>';
}












}












    // Load up the last few posts.  The number to load is defined by the "ShowPostNum" variable.
    $result = mysql_query("SELECT * FROM ".$dbTable." ORDER BY StringyChat_time DESC LIMIT " . $ShowPostNum,$db);


    include("sort_widths.php");


    while ($myrow = mysql_fetch_array($result)) {
      $msg = $myrow["StringyChat_message"];


 // Convert the encoded line break into an actual <br> tag (thanks milahu)
      $msg = str_replace("c#lb", "<br>", $msg);


      // Convert the encoded image tag into a html tag
      $msg = eregi_replace("im#([a-z]{3})", "<img src=\"http://".$install_url."images/\\1.gif\" alt=\"emoticon\">",$msg);


 // split the lines
      $msg = htmlwrap($msg, $line_length);


      $result_wordswap = mysql_query("SELECT * FROM ".$WordBanTable,$db);
      while ($myrow_wordswap = mysql_fetch_array($result_wordswap)) {
   $the_word = $myrow_wordswap["word"];
        $msg = ereg_replace($the_word, ":-x",$msg);
      }


   
    }
   ?>     
<?


















// end while


/******  build the pagination links ******/
// range of num links to show
$range = 3;


// if not on page 1, don't show back links
if ($currentpage > 1) {
   // show << link to go back to page 1
   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=1'><<</a> ";
   // get previous page num
   $prevpage = $currentpage - 1;
   // show < link to go back to 1 page
   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'><</a> ";
} // end if 


// loop to show links to range of pages around current page
for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) {
   // if it's a valid page number...
   if (($x > 0) && ($x <= $totalpages)) {
      // if we're on current page...
      if ($x == $currentpage) {
         // 'highlight' it but don't make a link
         echo " [<b>$x</b>] ";
      // if not current page...
      } else {
         // make it a link
         echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a> ";
      } // end else
   } // end if 
} // end for


// if not on last page, show forward and last page links        
if ($currentpage != $totalpages) {
   // get next page
   $nextpage = $currentpage + 1;
    // echo forward link for next page 
   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>></a> ";
   // echo forward link for lastpage
   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>>></a> ";
} // end if
/****** end build pagination links ******/


?><br>
    <html>  <span style="color:grey"><i>Type Your Message NOW!</i></span>
<p><a href="page.php">Reload</a> | <a href="http://tt.2fh.co">Home</a><br></html>

Any help please... If I send normal messages I don't get any errors...

Not A Valid Result Resource; What?

Similar Tutorials

View Content

Okay, I have a table with two columns..'annoyed' and 'ignored'. I poulated 'annoyed' with Bob and 'ignored' with Sally. I ran the following test due to problems I was having in my main script and I get the old MySQL "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home2/testing_ig.php on line 16

Here is the code:

<?php
$DBhost = "localhost";
$DBuser = "xxxxx";
$DBpass = "xxxxx";
$DBName = "xxxxx";
$table = "ignore";

mysql_connect($DBhost,$DBuser,$DBpass) or die();
@mysql_select_db("$DBName") or die();

$ignorequery = "SELECT * FROM $table WHERE annoyed='Bob' AND ignored='Sally'";
$checkignore = mysql_query($ignorequery);
$ifignored = mysql_num_rows($checkignore); //<--- This is line 16

if ($ifignored >= 1) {
echo "exists";
} else {
echo "doesn't exist";
}
?>

I must be really tired because I'm not seeing the problem...?

Warning: Fgets(): Supplied Argument Is Not A Valid Stream Resource

Similar Tutorials

View Content

Hi guys, I'm doing a website for the condo and I'm having troubles with the new year party registration form. I think it's got something to do with my file handling. When I run it on my wamp server, it works fine. But when I upload it onto the internet it gives me a whole bunch of warnings:
Warning: fopen(newYearParty.txt) [function.fopen]: failed to open stream: Permission denied in /www/zymichost.com/i/n/d/inderasubangcondo/htdocs/newYrRegTq.php on line 18

Warning: fgets(): supplied argument is not a valid stream resource in /www/zymichost.com/i/n/d/inderasubangcondo/htdocs/newYrRegTq.php on line 19

Warning: fgets(): supplied argument is not a valid stream resource in /www/zymichost.com/i/n/d/inderasubangcondo/htdocs/newYrRegTq.php on line 20

Heres my code:
<?php
   $nam = $_POST["nam"];
   $block = $_POST["block"];
   $floor = $_POST["floor"];
   $house = $_POST["house"];
   $adults = $_POST["adults"];
   $children = $_POST["children"];
   $guests = $_POST["guests"];
   $nam = $_POST["nam"];

   global $fn, $ft;

   //set id and update total numbers
   $fn = fopen("newYearParty.txt","a+");
   $line1 = fgets($fn); $arr1 = explode(": ", $line1);   //adults
   $line2 = fgets($fn); $arr2 = explode(": ", $line2);   //children
   $line3 = fgets($fn); $arr3 = explode(": ", $line3);   //guests
   $line4 = fgets($fn); $arr4 = explode(": ", $line4);   //total
   $line4 = fgets($fn);   //blank line

   $numAdults = $arr1[1]+$adults;
   $numChildren = $arr2[1]+$children;
   $numGuests = $arr3[1]+$guests;
   $numTotal = $numAdults+$numChildren+$numGuests;

   $id = "nothing";
   while(!feof($fn))
   {   $line = fgets($fn);      //id
      $arr = explode(": ", $line);
      $id = $arr[1] + 1;      //get latest id and add 1 to it
      for($i=0; $i<6; $i++)
      {   $line = fgets($fn);
      }
   }

   fclose($fn);
   if($id == "nothing")
   {   $id = "0";
   }
   //end of set id

   //write to file
   $line0 = "\r\nId: ".$id."\r\n";
   $line1 = "Name: ".$nam."\r\n";
   $line2 = "Unit: ".$block."-".$floor."-".$house."\r\n";
   $line3 = "Adults: ".$adults."\r\n";
   $line4 = "Children: ".$children."\r\n";
   $line5 = "Guests: ".$guests."\r\n";

   $fn = fopen("newYearParty.txt","a+");
   fwrite($fn, $line0);
   fwrite($fn, $line1);
   fwrite($fn, $line2);
   fwrite($fn, $line3);
   fwrite($fn, $line4);
   fwrite($fn, $line5);
   fclose($fn);
   //end of write to file

   //write new numbers to file
   $ft = fopen("newYearPartyTemp.txt","a+");
   $lineA = "Adults: ".$numAdults."\r\n";
   $lineC = "Children: ".$numChildren."\r\n";
   $lineG = "Guests: ".$numGuests."\r\n";
   $lineT = "Total: ".$numTotal."\r\n\r\n";

   fwrite($ft, $lineA);
   fwrite($ft, $lineC);
   fwrite($ft, $lineG);
   fwrite($ft, $lineT);

   $fn = fopen("newYearParty.txt","a+");
   for($i=0; $i<5; $i++)
   {   $line = fgets($fn);
   }
   while(!feof($fn))
   {   $line = fgets($fn);
      fwrite($ft, $line);
   }

   fclose($fn);
   fclose($ft);
   unlink("newYearParty.txt");      //delete newYearParty.txt
   rename("newYearPartyTemp.txt","newYearParty.txt");   //rename newYearPartyTemp.txt to newYearParty.txt
   //end of write new numbers to file

?>

Any ideas on how to fix this up? Thanks a lot in advance.

Warning: Readdir(): Supplied Argument Is Not A Valid Directory Resource

Similar Tutorials

View Content

My new host (Siteground) cloned and moved my html/php site (built by the previous owner) from Heart Internet server.

All of the site works except for the sidebar, I get these 2 errors. Anyone shed any light on these at all?

Warning: readdir(): supplied argument is not a valid Directory resource in /home/customer/www/dunster.org.uk/public_html/include/toolbox.php on line 97

Warning: opendir(/home/sites/dunster.org.uk/public_html//local_information) [function.opendir]: failed to open dir: No such file or directory in /home/customer/www/dunster.org.uk/public_html/include/toolbox.php on line 86

Warning: Imagecopyresized(): Supplied Argument Is Not A Valid Image Resource

Similar Tutorials

View Content

so I have an array with a bunch of photos, and I'm trying to create a thumbnail of each to display on a page with a link to the full sized image but I'm getting the error in the subject title... if I just display the images in the array without trying to resize them it works fine... can anyone clue me into why this isn't working please.

echo ("<a href='" . $img['file'] . "'>");
$new_width = (floor($img['size'][0] * ".25"));
$new_height = (floor($img['size'][1] * ".25"));
$tmp_img = imagecreatetruecolor($new_width, $new_height);
imagecopyresized($tmp_img, $img['file'], 0, 0, 0, 0, $new_width, $new_height, $img['size'][0], $img['size'][1]);
echo ("<img src='" . $tmp_img . " . $img['size'][3] , "' alt=''><br>\n");
echo basename($img['file']);
echo "</a><br>\n";

I Keep Getting Mysql Resource Id #4.. Not Sure Why

Similar Tutorials

View Content

I keep getting the mysql resource id #4 on a query that I am running and I have tried everything that I have read to fix it and nothing is working. I tried using the mysql_fetch_array, mysql_fetch_accoc, and the mysql_fetch_row functions

I would appreciate any help that can be given to me.

Here is my code as it stands now
Code: [Select]
<?php

include('includes/config.php');

$last = $_GET['l_name'];
$first = $_GET['f_name'];

$sql = 'SELECT * FROM `ttmautos` WHERE `l_name` LIKE \'$last\' AND `f_name` LIKE \'$first\'';
$autographs = mysql_query($sql, $connection)or die(mysql_error());
$row = mysql_fetch_array($autographs);

echo $sql;
echo $autographs;

$l_name = $row['l_name'];
$f_name = $row['f_name'];
$sent = $row['date_sent'];
$return = $row['date_return'];
$address = $row['address'];
$isent = $row['item_sent'];
$ireturn = $row['item_return'];
$project = $row['project'];
$team = $row['team'];

$address = stripslashes($address);

?>

Mysql-link Not Valid

Similar Tutorials

View Content

What is wrong?

Warning: mysql_select_db(): supplied resource is not a valid MySQL-Link resource in /home/rweekly/public_html/2012/view_arguments.php on line 41

Warning: mysql_query(): supplied resource is not a valid MySQL-Link resource in /home/rweekly/public_html/2012/view_arguments.php on line 43

Code: [Select]
mysql_select_db($database_news, $news);
$query_news = "SELECT * FROM news WHERE id = '$id'";
$news = mysql_query($query_news, $news) or die(mysql_error());
$row_news = mysql_fetch_assoc($news);
$totalRows_news = mysql_num_rows($news);

mysql_select_db($database_news, $news);
$query_arguments = "SELECT * FROM argue WHERE pid = '$id'";
$arguments = mysql_query($query_arguments, $news) or die(mysql_error());
$row_arguments = mysql_fetch_assoc($arguments);
$totalRows_arguments = mysql_num_rows($arguments);

<b>warning</b>: Mysql_fetch_array(): Supplied Argument Is Not A Valid Mysql Res

Similar Tutorials

View Content

Mysql_fetch_array(): Supplied Argument Is Not A Valid Mysql Result

Similar Tutorials

View Content

I am getting an error message. Quote

mysql_fetch_array(): supplied argument is not a valid MySQL result

My Sql seems to work fine. But I kept on getting this error message whenever I try to view orderid. I have option to view different field such as orderid, orderdate, price and profit. When the page loads its fine. But when I try to view orderdate the orderid I get the error message

Error code is on the first line and the other places where it says $result.
Code: [Select]
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td align='left'>" . $row['orderid'] . "</td>";
echo "<td align='left' style='font-size:12px;'>" . $row['orderdate'] . "</td>";
echo "<td align='left' style='font-size:12px;'>" . $row['updated'] . "</td>";
echo "<td align='left' style='font-size:12px;'>" . $row['name'] . "</td>";
echo "<td align='left' style='font-size:12px;'>" . $row['price'] . "</td>";
echo "<td align='left'>" . $row['salesman'] . "</td>";
echo "<td align='left'>" . $row['origsalesman'] . "</td>";
echo "<td align='left'>" . $row['status'] . "</td>";
echo "<td align='left'>" . $row['product'] . "</td>";
echo "<td align='left'>£" . $row['profit'] . "</td>";
echo "</tr>";

echo "<tr><td colspan='10'><hr></td></tr>";
}

if ( mysql_num_rows( $result ) == 0 )
echo "<tr><td colspan='10'>No orders found<hr></td></tr>";
echo "</table></form>";

mysql_free_result( $result );code]

Please help me.

<b>warning</b>: Mysql_fetch_array(): Supplied Argument Is Not A Valid Mysql Res

Similar Tutorials

View Content

Warning: Mysql_fetch_array(): Supplied Argument Is Not A Valid Mysql Result: ?

Similar Tutorials

View Content

Hi, first post, and yes it is a question.

I am stuck, and not by choice, this error has given me more headaches than I care to admit.

I have a script that I am attempting here, that is very simple for now, all I want to show is the Added_By field to show it is accessing the database correctly and the right row/line all together.

The page to test this at is he

http://kaboomlabs.com/PDI/@dm!n/viewncmr.php?id=2

The Error is this:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/pawz/public_html/kaboomlabs.com/PDI/@dm!n/viewncmr.php on line 18

This is row 18: $row = mysql_fetch_array($data);

Now I know this is not a secure form yet, I am working on getting the basic functions down then I'll secure it, so please let me worry about that when the time comes.

Here is the script, can anyone see a blatant issue or not? Thanks in advance.

Code: [Select]
<?php
  require_once('../connectvars.php');

        // Connect to the database
        $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

  // Grab the profile data from the database
  if (!isset($_GET['id'])) {
    $query = "SELECT * FROM ncmr WHERE id = '" . $_SESSION['id'] . "'";
  }
  else {
    $query = "SELECT * FROM ncmr WHERE id = '" . $_GET['id'] . "'";

  $data = mysqli_query($dbc, $query);
  }
  if (mysqli_num_rows($data) == 1) {
    // The user row was found so display the user data
    $row = mysql_fetch_array($data);

echo '<fieldset>';

        if (!empty($row['Added_By'])) {
        echo '<div id ="added"><label>Added By:</label>' . $row['Added_By'] . '</div></fieldset>';
        }
}
  // End of check for a single row of user results
  else {
    echo '<p class="error">There was a problem accessing your profile.</p>';
  }

  mysqli_close($dbc);
?>