[SOLVED] Mysql_num_rows problem.

[GB_001]

I keep getting an odd error with this code.

 

<?php
@mysql_connect("mysql.x10hosting.com", "gb_GB", "********") or die(mysql_error());
@mysql_select_db("gb_USERInfo") or die(mysql_error());

session_start();
//specify how many results to display per page
$limit = 20;

// Get the search variable from URL
$var = @$_GET['q'] ;
//trim whitespace from the stored variable
$trimmed = trim($var);
//separate key-phrases into keywords
$trimmed_array = explode(" ",$trimmed);

// check for an empty string and display a message.
if ($trimmed == "") {
$resultmsg = "<p>Search Error</p><p>Please enter a search...</p>" ;
}

// check for a search parameter
if (!isset($var)){
$resultmsg = "<p>Search Error</p><p>We don't seem to have a search parameter! </p>" ;
}
// Build SQL Query for each keyword entered
foreach ($trimmed_array as $trimm){

// EDIT HERE and specify your table and field names for the SQL query
$query = "SELECT * FROM Ysers WHERE School/Office LIKE \"%$trimm%\" OR Location LIKE \"%$trimm%\" OR email LIKE \"%$trimm%\" ORDER BY field1 DESC" ;
// Execute the query to get number of rows that contain search kewords
$results= mysql_query($query);
$row_num = mysql_numrows ($results);

// next determine if 's' has been passed to script, if not use 0.
// 's' is a variable that gets set as we navigate the search result pages.
if (empty($s)) {
$s=0;
}

// now let's get results.
$query .= " LIMIT $s,$limit" ;
$results = mysql_query ($query) or die ( "Couldn't execute query" );
$row= mysql_fetch_array ($results);
}

if($row_num_links_main == 0 && $row_set_num == 0){
$resultmsg = "<p>Search results for:" . $trimmed ."</p><p>Sorry, your search returned zero results</p>" ;
}

else{

// Make a MySQL Connection

while($row = mysql_fetch_array($result)){
echo $row['firstname'];
echo $row['School/Office'];
echo $row['Location'];
echo "<br />";
}
}

?>

 

Error: Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/gb/public_html/Friendsearch.php on line 32

Couldn't execute query

 

Thankyou for your help, this is a great community.

[phpSensei]

What error does this spit out ?

 

<?php
@mysql_connect("mysql.x10hosting.com", "gb_GB", "redman12345") or die(mysql_error());
@mysql_select_db("gb_USERInfo") or die(mysql_error());

session_start();
//specify how many results to display per page
$limit = 20;

// Get the search variable from URL
$var = @$_GET['q'] ;
//trim whitespace from the stored variable
$trimmed = trim($var);
//separate key-phrases into keywords
$trimmed_array = explode(" ",$trimmed);

// check for an empty string and display a message.
if ($trimmed == "") {
$resultmsg = "<p>Search Error</p><p>Please enter a search...</p>" ;
}

// check for a search parameter
if (!isset($var)){
$resultmsg = "<p>Search Error</p><p>We don't seem to have a search parameter! </p>" ;
}
// Build SQL Query for each keyword entered
foreach ($trimmed_array as $trimm){

// EDIT HERE and specify your table and field names for the SQL query
$query = "SELECT * FROM Ysers WHERE School/Office LIKE \"%$trimm%\" OR Location LIKE \"%$trimm%\" OR email LIKE \"%$trimm%\" ORDER BY field1 DESC" ;
// Execute the query to get number of rows that contain search kewords
$results= mysql_query($query)or die (mysql_error());
$row_num = mysql_numrows ($results);

// next determine if 's' has been passed to script, if not use 0.
// 's' is a variable that gets set as we navigate the search result pages.
if (empty($s)) {
$s=0;
}

// now let's get results.
$query .= " LIMIT $s,$limit" ;
$results = mysql_query ($query) or die (mysql_error());
$row= mysql_fetch_array ($results);
}

if($row_num_links_main == 0 && $row_set_num == 0){
$resultmsg = "<p>Search results for:" . $trimmed ."</p><p>Sorry, your search returned zero results</p>" ;
}

else{

// Make a MySQL Connection

while($row = mysql_fetch_array($result)){
echo $row['firstname'];
echo $row['School/Office'];
echo $row['Location'];
echo "<br />";
}
}

?>

[Dane]

$row_num = mysql_numrows ($results);

 

should be

 

$row_num = mysql_num_rows ($results);

 

at line 32

[GB_001]

Okay, so I redid the code and I still get the same error.

 

<?php
@mysql_connect("mysql.x10hosting.com", "gb_GB", "***********") or die(mysql_error());
@mysql_select_db("gb_USERInfo") or die(mysql_error());

session_start();
//specify how many results to display per page

// Get the search variable from URL
$var = @$_GET['Email'] ;

$trim = trim($var);

$array = explode(" ",$trim);

foreach ($array as $array){

if ($trim == "") {
$resultmsg = "<p>Search Error</p><p>Please enter an email...</p>" ;
}

$query = "SELECT * FROM Ysers WHERE email LIKE \"%$array%\" ORDER BY email DESC" ;
$results=mysql_query ($query) or die (mysql_error());
$row_num =mysql_num_rows ($numresults) or die (mysql_error());;

$numresults = mysql_query ($query) or die ( "Couldn't execute query" );
$row= mysql_fetch_array ($numresults);

do{
//EDIT HERE and specify your field name that is primary key
$adid_array[] = $row[ 'id' ];
}while( $row= mysql_fetch_array($numresults));
} //end foreach

$tmparr = array_unique($adid_array);
$i=0;
foreach ($tmparr as $v) {
$newarr[$i] = $v;
$i++;
}

while($row = mysql_fetch_array( $numresult ) or die (mysql_error())) {
// Print out the contents of each row
echo $row['name']." - ".$row['email']. "<br />";
} 

 

Error: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/gb/public_html/Friendsearch.php on line 24

[GingerRobot]

You're passing the wrong variable to the mysql_num_rows() function. It should be be $results, not $numresults. Same goes for call to mysql_fetch_array():

 

 

$query = "SELECT * FROM Ysers WHERE email LIKE \"%$array%\" ORDER BY email DESC" ;
$results=mysql_query ($query) or die (mysql_error());
$row_num =mysql_num_rows ($results);
$row= mysql_fetch_array ($results);

 

Dane: FYI, mysql_numrows() is an alias for mysql_num_rows(), though it is depreciated.

[GB_001]

Thankyou, I have one more error though. I get an unexpected end error on line 41.

[darkfreaks]

please comment line 41 so we can find the error thank you

[GB_001]

[code][code]<?php
@mysql_connect("mysql.x10hosting.com", "gb_GB", "********") or die(mysql_error());
@mysql_select_db("gb_USERInfo") or die(mysql_error());

session_start();

$var = @$_GET['Email'] ;

$trim = trim($var);

$array = explode(" ",$trim);

foreach ($array as $array){

if ($trim == "") {
$resultmsg = "<p>Search Error</p><p>Please enter an email...</p>" ;
}

$query = "SELECT * FROM Ysers WHERE email LIKE \"%$array%\" ORDER BY email DESC" ;
$results=mysql_query ($query) or die (mysql_error());
$row_num =mysql_num_rows ($results);
$row= mysql_fetch_array ($results);
$numresults = mysql_query ($query) or die ( "Couldn't execute query" );


do{

$adid_array[] = $row[ 'id' ];
}while( $row= mysql_fetch_array($numresults));

$tmparr = array_unique($adid_array);
$i=0;
foreach ($tmparr as $v) {
$newarr[$i] = $v;
$i++;
}

while($row = mysql_fetch_array( $numresult ) or die (mysql_error())) {
echo $row['name']." - ".$row['email']. "<br />";
}
?> //Line 41

[/code][/code]

[darkfreaks]

there was no ending bracket i added it goodluck

 

<?php
@mysql_connect("mysql.x10hosting.com", "gb_GB", "********") or die(mysql_error());
@mysql_select_db("gb_USERInfo") or die(mysql_error());

session_start();

$var = @$_GET['Email'] ;

$trim = trim($var);

$array = explode(" ",$trim);

foreach ($array as $array){

if ($trim == "") {
$resultmsg = "<p>Search Error</p><p>Please enter an email...</p>" ;
}

$query = "SELECT * FROM Ysers WHERE email LIKE \"%$array%\" ORDER BY email DESC" ;
$results=mysql_query ($query) or die (mysql_error());
$row_num =mysql_num_rows ($results);
$row= mysql_fetch_array ($results);
$numresults = mysql_query ($query) or die ( "Couldn't execute query" );


do{

$adid_array[] = $row[ 'id' ];
}while( $row= mysql_fetch_array($numresults));

$tmparr = array_unique($adid_array);
$i=0;
foreach ($tmparr as $v) {
$newarr[$i] = $v;
$i++;
}

while($row = mysql_fetch_array( $numresult ) or die (mysql_error())) {
echo $row['name']." - ".$row['email']. "
";
}
}

?>

[GB_001]

Thankyou so much.

 

My script has no more errors, but due to cruel fate stopped working.

So I decided to start over with something simple and that didn't work.

 

<?php

@mysql_connect("mysql.x10hosting.com", "gb_GB", "************") or die(mysql_error());

@mysql_select_db("gb_USERInfo") or die(mysql_error());

 

session_start();

 

$var = $_POST['email'] ;

$trim = trim($var);

$earray = explode(" ",$trim);

 

$query = "SELECT * FROM Ysers WHERE email LIKE '%$earray%'";

$result = mysql_query($query);

echo $trim;

while($row = mysql_fetch_array( $result )) {

echo $row['email'];

echo"<br/>";

}

?>

 

It displays no errors.

[papaface]

Remove the @ signs then it WILL display errors!

[GB_001]

Sorry, that did not seem to work.

[papaface]

Add:

error_reporting(E_ALL);

to the top and try again.

[papaface]

The problem is that you're putting an array into a WHERE ???

You need to specify which element it is in the array:

e.g

$query = "SELECT * FROM Ysers WHERE email LIKE '%{$earray[0]}%'";

[GB_001]

Thankyou for all your help, but when I search it brings up every email in the database.

[GB_001]

Bumped.