[RESOLVED] problem with like and get rows

[system_critical]

I'm trying to search for things in a table using LIKE. The query returns the correct number of results through PHP MyAdmin, but when I use the following PHP I only get 2. There should be four.

The table looks like this.

object_key
primary key
not null

object_name
text
not null

object_description
text
not null

Their are four rows with the object name set to honey crisp apple. The PHP My Admin query returns 4, PHP returns 2. Can anyone see why?

<?php
	$my_id = "myid";
	$my_pass = "mypass";
	$my_db = "mydb";

$connect = mysql_connect('localhost', $my_id, $my_pass);
$select = mysql_select_db($my_db);

if(isset($_POST['submit'])){
	$var_from_form_input ='%'.$_POST['var'];
	if($select){

// FIND THE MATCHES
$match_query = "SELECT object_name FROM mytable WHERE object_name LIKE '$var_from_form_input'";
$result = mysql_query($match_query);
$result_rows = mysql_fetch_array($result);
$result_num = count($result_rows);
echo $result_num.' number of results<br/>';
    echo $result_rows[0]';
}
}
?>

Thanks

[djjjozsi]

Change that line:
from
$var_from_form_input ='%'.$_POST['var'];

into this:
$var_from_form_input ='%'.mysql_real_escape_string($_POST['var']).'%';

system_critical;10891859 wrote:

I'm trying to search for things in a table using LIKE. The query returns the correct number of results through PHP MyAdmin, but when I use the following PHP I only get 2. There should be four.

The table looks like this.

object_key
primary key
not null

object_name
text
not null

object_description
text
not null

Their are four rows with the object name set to honey crisp apple. The PHP My Admin query returns 4, PHP returns 2. Can anyone see why?

<?php
	$my_id = "myid";
	$my_pass = "mypass";
	$my_db = "mydb";

$connect = mysql_connect('localhost', $my_id, $my_pass);
$select = mysql_select_db($my_db);

if(isset($_POST['submit'])){
	$var_from_form_input ='%'.$_POST['var'];
	if($select){

// FIND THE MATCHES
$match_query = "SELECT object_name FROM mytable WHERE object_name LIKE '$var_from_form_input'";
$result = mysql_query($match_query);
$result_rows = mysql_fetch_array($result);
$result_num = count($result_rows);
echo $result_num.' number of results<br/>';
    echo $result_rows[0]';
}
}
?>

Thanks

[system_critical]

I made the changes and I still get just two rows. When I echo those two rows, the first one is correct and the second one is empty. Any thoughts? Thanks.

[djjjozsi]

hey, you might use mysql_num_rows function to get the result's rows namber.

and see the while how to get the results value ...

<?php
    $my_id = "myid";
    $my_pass = "mypass";
    $my_db = "mydb";

$connect = mysql_connect('localhost', $my_id, $my_pass);
$select = mysql_select_db($my_db);

if(isset($_POST['submit'])){
    $var_from_form_input =mysql_real_escape_string($_POST['var']);
    if($select){

// FIND THE MATCHES
$match_query = "SELECT object_name FROM mytable WHERE object_name LIKE '%$var_from_form_input%'";
$result = mysql_query($match_query);

$result_num = mysql_num_rows($result_rows);
echo $result_num.' number of results<br/>';
$i=0;  
while(  $result_rows = mysql_fetch_assoc($result))    
{   
   echo "$i. result :". $result_rows["object_name"]."<br>";
   $i++;    
 }

  }
}
?> 

[Weedpacket]

system_critical wrote:

   $result_rows = mysql_fetch_array($result);
    $result_num = count($result_rows);
    echo $result_num.' number of results<br/>';
        echo $result_rows[0]';

You ask for an array containing the values from one row. The "object_name" value will be in that array twice. Once as $result_rows[0] and once as $result_rows["object_name"]. Total: two.

And you only look at one row.

[system_critical]

Using mysql_num_rows, got the correct results and I think that circumvents what I was doing wrong. Thanks, I really appreciate it.