Warning: Mysql_num_rows(): Supplied Argument Is Not A Valid MySQL Result Resource In *** On Line 9
I keep getting an error result saying:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in *** on line 9
Warning: Cannot modify header information - headers already sent by (output started at ***:9) in **** on line 12
I'm pretty new to PHP so I'm thinking its a problem with syntax. Any help is appreciated. Code is below.
<?PHP
$ni = trim($_POST['ni']);
require 'db_connect.php'
$sql = "SELECT * FROM $db_table WHERE ni = '$ni'";
$query = "mysql_query($sql) or die (mysql_error())";
if (mysql_num_rows($query) < 1) {
require 'db_close.php'
header("location: DESIRED LOCATION");
}
else{
require 'db_close.php'
header("Location: EXIT ");
}
?>
View Complete Forum Thread with Replies
Related Forum Messages:
Warning: Mysql_num_rows(): Supplied Argument Is Not A Valid MySQL Result Resource In /mounted-storage/
my code: $username = mysql_real_escape_string($username); $result= mysql_query("SELECT * from `admin_login WHERE username=".$username); if (mysql_num_rows($result) != 0) { echo ("That Username is already being used. Please try a different username."); } I know that there is a row that has the same username as $username, but i keep getting an error like: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mounted-storage/home23a/sub001/sc21473-GRUR/www/inphp/members/register.php on line 56 Line 56 being: if (mysql_num_rows($result) != 0)
View Replies !
Mysql_num_rows(): Supplied Argument Is Not A Valid MySQL Result Resource
I've got the following error: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wbdfdart/public_html/wbdfforum/verwijder.php on line 13 verwijder.php 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 <?php include "connect.php"; if (isset ($cat) AND isset ($topic) AND isset ($message)) { $query = "SELECT user FROM reply WHERE id='$message'"; $exec = mysql_query($query); $result = mysql_fetch_array($exec); $owner = $result["user"]; $moderator_check_query = "SELECT * FROM moderator WHERE category=$cat AND user=$myid"; $moderator_check_exec = mysql_query($moderator_check_query); $moderator_result = mysql_num_rows($moderator_check_exec); if ($moderator_result == 1 OR $owner == $myid) { $moderator = 1; } else { $moderator = 0; } if ($moderator == 1) { $replydelete_query="DELETE FROM reply WHERE id ='$id'"; mysql_query($replydelete_query) or die(mysql_error()); $topicmineen_query="UPDATE topic SET replies='replies -1' WHERE id='$topic'"; mysql_query($topicmineen_query) or die(mysql_error()); echo "<script>location.href='index.php?cat=".$cat."&topic=".$topic."&page=".$page."'</script>"; } else { echo "<script>location.href='index.php?cat=".$cat."&topic=".$topic."&page=".$page."'</script>"; }} ?>
View Replies !
Warning: Supplied Argument Is Not A Valid MySQL Result Resource
<? Warning: Supplied argument is not a valid MySQL result resource if (mysql_num_rows($result) >0 ) !Didnt have this problem before session_start(); if ($username && $password) { // if the user has just tried to log in $db_conn = mysql_connect("localhost", "*****", "*******"); mysql_select_db("micro_db.adf", $db_conn); $query = "select * from users " ."where name='$username' " ." and pass=password('$password')"; $result = mysql_query($query, $db_conn); if (mysql_num_rows($result) >0 ) { // if they are in the database register the username $valid_user = $username; session_register("valid_user"); } } ?>
View Replies !
Warning Mysql_fetch_array(); Supplied Argument Is Not A Valid MySQL Result Resource?
i am getting the following error with this bit of code? Warning mysql_fetch_array(); supplied argument is not a valid MySQL result resource? Code: <?php /* Connect to database */ $extra = 'blah' $size= Ƈ' $paper= 'matte' $db= mysql_connect("localhost", "", ""); mysql_select_db("", $db); $sql="select type_id FROM type WHERE extra=".$extra." AND size=".$size. " AND paper=".$paper ; $type_id=mysql_query($sql); ............
View Replies !
Warning: Mysql_select_db(): Supplied Argument Is Not A Valid MySQL-Link Resource In E:htmldbconn.php On Line 4
I submitted the question about text files I decided to have a go with a database instead though Im having problems connecting to the Database. As a PHP novice Im not entirely sure where Im going wrong but I have been getting the following error: Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in E:htmldbconn.php on line 4 Can't select entries from table. SELECT * FROM Entry ORDER BY Entry.entryDate DESC LIMIT 5 No Database Selected Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:htmldbconn.php on line 11 The code I'm using looks like this: ....
View Replies !
Supplied Argument Is Not A Valid MySQL Result Resource
Before I get in trouble, I have searched extensively for this one, in the PHP Docs, online etc. I have a simple page: <?php $un="jim"; $pw="jim"; $db="localhost"; $link = mysql_connect($db,$un,$pw) or die("Could not connect: " . mysql_error()); $sql2 = "SELECT * FROM eib.book ORDER BY bookid"; $op = mysql_query($sql2) ; $num= mysql_numrows($op); ?> When I run the page I keep getting this error: Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in C:Program FilesApache GroupApache2htdocseibphpitemadd2.php on line 34
View Replies !
Mysql_fetch_array :: Supplied Argument Is Not A Valid MySQL Result Resource
I've got a problem with mysql_fetch_array function. I have two function: function db_query($dbh,$qw) { db_test($dbh); $result = mysql_query($qw); return $result; } function db_insert($dbh,$table,$what,$info) { db_test_table($dbh,$table); $id=0; $qw="insert into $table $what values $info"; $result = db_query($dbh, $qw); return $result; } Then I have the following piece of code: $result = db_insert($dbh, $table1, $what1, $info1); $row = mysql_fetch_array($result); The db_insert call workes fine, 'cause a new record is inserted into the table. The problem is that when I call mysql_fetch_array I got the following error: "Supplied argument is not a valid MySQL result resource".
View Replies !
Mysql_fetch_array(): Supplied Argument Is Not A Valid Mysql Result Resource
i recieve this error from this part of the code: mysql_fetch_array(): supplied argument is not a valid mysql result resource it's returning a long text from the database which is about 200 characters long. <?php if ($_SESSION['is_town'] = 1){ $query = "SELECT usemap FROM town WHERE town_id = " . $_SESSION['townID'][0]; $db_result = mysql_query($query); $db_usemap = mysql_fetch_array($db_result); echo $db_usemap;} ?>
View Replies !
Warning: Mysql_fetch_array(): Supplied Argument Is Not A Valid MySQL Result
Here is my script: <?php $dbh=mysql_connect("localhost", "my_username", "my_password") or die ('No can do!'); mysql_select_db ("my_databasename"); $query = "SELECT * FROM contacts"; while($i = mysql_fetch_array($query)){ echo $i[first]; echo $i[last]; echo $i[email]; } ?> Get this error message: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home2/my_username/my_domain/my_databasename/test.php on line 6.
View Replies !
Warning: Rewind() Supplied Argument Is Not A Valid Stream Resource In...
I am implementing Iterator in a class, I have pretty much copied the code from php.net on Object Iteration. Adding all the normal methods for the task...rewind, current, next, etc. I was attempting to add a seek method but am stymied by the above warnin, as well getting a seek on index 0 (zero) to work. public function __construct($contents) { if ( is_array($contents)) { if ( is_array($contents[1])) { $this->cktl = $contents[1]; } } } public function rewind() { $cktl = rewind($this->cktl); return $cktl; } public function current() { $cktl = current($this->cktl); return $cktl; } public function key() { $cktl = key($this->cktl); return $cktl; } public function next() { $cktl = next($this->cktl); return $cktl; } public function valid() { $cktl = $this->current() !== FALSE; return $cktl; } public function myseek($intPos) { $myPos = 0; $this->rewind(); while ( $myPos < $intPos && $this->valid() ) { $cktl = $this->next(); $myPos++; } if ( !$this->valid() ) { die("Invalid seek position"); } return $cktl; }
View Replies !
Warning: Fread(): Supplied Argument Is Not A Valid Stream Resource
am trying to upload images in MySql using php. whenever I run the following code I get this message: Warning: fread(): supplied argument is not a valid stream resource in C:webs estCNST ProjectsGenaral Upload FormfigUpload.php on line 6 config.php is where I assign the database, the user, and the password. openDB.php is where the database is opened closeDB.php is where the database is closed <?php include'phpFigures/config.php'; include'phpFigures/openDB.php'; include'phpFigures/assignValues.php'; if (isset($figpath)){ $figImage=addslashes(fread(fopen($figpath,"r"),filesize($figpath))); $query = "INSERT INTO images(description, image) VALUES ('$figdescription', '$figImage')";
View Replies !
"Supplied Argument Is Not A Valid MySQL Result Resource"
this is one of the first scripts im writing completely by myself but its driving me crazy. the errors its returning are: Quote: Warning: Supplied argument is not a valid MySQL result resource in c:apachehtdocsquiz_chap12_view.php on line 16 There are currently in the table: PHP Code:
View Replies !
Counter - Warning: Fwrite(): Supplied Argument Is Not A Valid Stream Resource
I am trying to put one counter in my php with the next code: <?php $hitfile = "/admin/contador.txt"; if (!file_exists($hitfile)) { $file = fopen($hitfile,"r+"); $hits = fread($file,filesize($hitfile)); fclose ($file); } else { $hits = 0; } $file = fopen($hitfile,"w+"); fwrite ($file, ++$hits); fclose ($file); ?> but when i try to see the php page appears this error: Warning: fopen(/admin/contador.txt) [function.fopen]: failed to create stream: No such file or directory in /home/usuairo/pagina.php on line 9 Warning: filesize() [function.filesize]: Stat failed for /admin/contador.txt (errno=2 - No such file or directory) in /home/usuairo/pagina.php on line 10 Warning: fread(): supplied argument is not a valid stream resource in /home/usuairo/pagina.php.php on line 10 Warning: fclose(): supplied argument is not a valid stream resource in /home/usuairo/pagina.php.php on line 11 Warning: fopen(/admin/contador.txt) [function.fopen]: failed to create stream: No such file or directory in /home/usuairo/pagina.phpcontacto.php on line 19 Warning: fwrite(): supplied argument is not a valid stream resource in /home/usuairo/pagina.phpcontacto.php on line 20 Warning: fclose(): supplied argument is not a valid stream resource in /home/usuairo/pagina.phpcontacto.php on line 21
View Replies !
Fopen :: Warning: Fwrite(): Supplied Argument Is Not A Valid Stream Resource
I tried to store the file pointer returned by fopen as a session variable. I get a warning: fopen to open stream: HTTP wrapper does not support writeable connections. Thisis followed by a bunch of: warning: fwrite(): supplied argument is not a valid stream resource if (!isset($_SESSION['fh'])) { $fh = fopen("http://www.mydomain.com/somedir/debug", "w"); $_SESSION['fh'] = $fh; } ...... ...... fwrite($_SESSION['fh'], " some debugging text msg: ".$msg."msg_type: ".$msg_type);
View Replies !
Mysql_query(): Supplied Argument Is Not A Valid MySQL-Link Resource
I use the following fragment of code to output datf from MySQL: ================================================== ==== $chan = mysql_connect ($db_host, $username, $password); mysql_select_db ($DB_name, $chan); $resultid = mysql_query ("select name_ru, description_ru, retail, dealer from lasershot WHERE le=Ƈ'", $chan); ........ ================================================== ==== This was working fine. Code:
View Replies !
Mysql_num_rows(): Not A Valid MySQL Result Resource?
i'm getting three unusual errors which i can't figure out how to correct-- or even necessarily what's causing them. (note: not that you'd 'count' the lines, but these numbers might not match the code below as i've done some editing in between when i started this post and now) Code:
View Replies !
Mysql_fetch_row(): Supplied Argument Is Not A Valid MySQL Result
Here is my script and when i get the data from a database it gives this error: Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in D:Fluke_Mambocomponentscom_confirmationorder_status.php on line 33 if you want to know where $my->username comes from it is defined from the user logged in at the moment becouse this file is included....
View Replies !
MySQL Error - Supplied Argument Is Not A Valid MySQL-Link Resource
I am getting the error Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/server7/public_html/71/arranholloway/database4.php on line 7 I tested my code on local computer and there were no problems, the error message only appeared when I loaded it onto my web hosters server. I'm new to PHP so its probably something simple but any help would be appreciated.
View Replies !
Supplied Argument Not Valid Resource?
I'm making an upload script to insert into my MySQL database, but it keeps on giving me an error message. "Warning: fread(): supplied argument is not a valid stream resource in /home/john1704/public_html/photos/upload.php on line 29" Here's the code I'm using:
View Replies !
Supplied Argument Is Not A Valid Stream Resource
I'm running PHP 4.x with an Apache web server on Macintosh OS 10.3.9. It's an internal school web server that sits on my desk, so I have complete control over it. I've hit a wall with a script I'm working on right now. This is not a web page. It's a php application that reads a directory and uses the data it gathers to write a web page that lets students view thumbnails of and vote on other students' graphic or Flash projects. Code:
View Replies !
Warning: Mysql_num_rows(): Supplied Argument Error
I'm receiving the error above in my shopping cart application. I sell one-off items and use Paypal as the payment engine. In the remote possibility an item was previously purchased I loop through each order and update one at a time. I'm counting rows so if a record is not updated, I'd like to know. Strangely, it's working as designed (sending emai), but don't want to deploy unless I know why this error is occuring. Here's what I've got so far. Here's the full error: 1. :confused: is not a valid MySQL result resource in cartworks15.php on line 105. 2. Do I need to change the variable to a different function. Is my syntax correct. Code:
View Replies !
Warning: Mysql_fetch_array(): Supplied Argument Is Not A Valid
When I run this script It says Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in blah blah. <? session_start(); include "db.php"; $username = $_SESSION['username']; $result = mysql_query("SELECT * FROM users WHERE to='$username'"); while ($row = mysql_fetch_array($result)) { ?> From: <? $row['from'] ?><br> Subject: <? $row['subject'] ?><br> Message: <? $row['message'] ?><br> <? } ?>
View Replies !
Warning: Feof(): Supplied Argument Is Not A Valid Stream
i am using fopen to open a webpage, it works great when the page is not located on a secure server but as soon as i point it to look at that page i get the following error Warning: feof(): supplied argument is not a valid stream resource in C:AppServwwwSJMDBv2database_eagaDupChecker.php on line 11 Warning: fgets(): supplied argument is not a valid stream resource in C:AppServwwwSJMDBv2database_eagaDupChecker.php on line 14 this is the code for the page in question $fp = @fopen("https://somesecured.server", 'r'); while (!feof($fp)) { $buffer = fgets($fp, 4096); echo $buffer; } fclose($fp); i have tried it on several diffrent server and the only one i can get working are the normal http.
View Replies !
Ldap_get_values() Stating That The Supplied Resource Is Not A Valid Ldap Result
I'm checking a user identity on a secure LDAP server using the following code: $ldapconn = ldap_connect("ldaps://myserver.mycompany.ch", 636 ) or die( "Can't connect to LDAP" ) ; $ldapresult = ldap_search( $ldapconn,"o=mycompany,c=ch","cn=".$name); if( $ldapresult ) { $entries = ldap_get_entries( $ldapconn, $ldapresult ) ; if( $entries["count"] ) { $ldapbind = ldap_bind( $ldapconn, $entries[0]['dn'], $pwd ) ; if( $ldapbind ) { echo "Connected: user exists, password checked<br>" ; } } This works ok if I submit the right $name and $pwd Then I'd like to retrieve some data from the specified user, say the givenName and sn but can't figure out a way to retrieve those values using ldap_read or ldap_get_values For example: $results = ldap_read($ldapconn, "cn=myname,o=mycompany,c=ch", '(objectclass=person)', array( "givenname", "sn" ) ) ; $firstname = ldap_get_values($ldapconn, $results, "givenname" ) ; $lastname = ldap_get_values($ldapconn, $results, "sn" ) ; This fails on the ldap_get_values() stating that the supplied resource is not a valid ldap result entry resource. If I use something like: $firstname = ldap_get_values($ldapconn, $ldapresult, "givenname" ) ; $lastname = ldap_get_values($ldapconn, $ldapresult, "sn" ) ; It fails too...
View Replies !
LEFT JOIN - Get The "Warning: Mysql_fetch_array(): Supplied Agrument Is Not A Valid MySQL Resource".
I am trying to merge results from two tables, but this is something I haven't done so far, so manybe my mistake will look stupid to Pro's. I get the "Warning: mysql_fetch_array(): supplied agrument is not a valid MySQL resource". Here is my code: $result = mysql_query("SELECT * FROM az_mustseethis LEFT JOIN az_articles ON az_mustseethis.art_id = az_articles.art_id WHERE az_articles.category = 'Must See This' ORDER BY art_id DESC LIMIT $from, $max_results",$connect); Instead of adding the latest entry in the "az_mustseethis" table, I want to take it from the "az_articles" table, where it has already been added.
View Replies !
Paginating (mysql_fetch_array(): Supplied Argument Is Not A Valid MySQL)
when I try to run my code it works..but sometimes it returns me these error : Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/dev/rob/SearchRND.php on line 44 Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /var/www/html/dev/rob/SearchRND.php on line 65 PREV 10 NEXT 10; ( total) it happens whenever I try to refresh the browser or even if I reached the end of the records..here's my code PHP Code:
View Replies !
Not A Valid MySQL Result Resource
I have a website which i have a login script for however I want to users to be able to have an account balance. I have set up a field for balance in the users table of my database however I am having problems fetching the correct row for each user. Code:
View Replies !
|
TRACKER
