PHP - Php Query Always Returns A Result As Interger

this is supposed to display the distinct first two characters of a string(billnmbr) in a combobox
ive tried this on phpmyadmin and it returns 08..
which is correct
when i run this on my server, it returns nothing..
there must be something wrong with the way i called the billnmbr
does anybody have an idea on how i could call and display this correctly?
thanks and have a nice day.

<?php
  $mquery = "select distinct(substring(`billnmbr`, 1, 2)) from `tbltest`";
  $mres =mysql_query($mquery) or die(mysql_error());
   while($mrow=mysql_fetch_array($mres)){
$mm = $mrow['billnmbr'];
 echo "<option value=" . $mrow['billnmbr'] . ">";
 echo $mrow['billnmbr'] . "</option>"; 
} 
 echo " </select>";
  ?>

Hi all ! The following code has two similar queries. Query 1 and Query 2. While Query 1 works just fine, Query 2 simply fails persistently. I have not been able to figure out why?   I have checked every single variable and field names but found no discrepancy of any sort or any mismatch of spelling with the fields in the database.   I would be grateful if anybody can point out what is preventing the second query from returning a valid mysqli object as the first one does. Here is the code for the two.

<?php
$db_host = "localhost";
$db_user ="root";
$db_pass ="";
$db_database ="allscores";

//////////////// CHECKING VARIABLE FILEDS IN A UPDATE QUERY //////////////////////////////////
//////////////// QUERY 1 /////////////////////////////////////////////////////////////////////

/*
$db_database ="test";
$db_table ="users";
$RecNo = 1;			
		
$field1 = 'name';
$field2 = 'password';
$field3 = 'email'; 
$field4 = 'id';
$val1 = "Ajay";
$val2 = "howzatt";
$val3 = "me@mymail.com";


					$con = mysqli_connect($db_host,$db_user,$db_pass,$db_database) or die('Unable to establish a DB connection');
					$query = "UPDATE $db_table SET $field1 = ?,
							$field2 = ?, $field3 = ?
							WHERE $field4 = ? ";   // session terminated by setting the sessionstatus as 1 
					$stmt = $con->prepare($query);
					var_dump($stmt); 
					$stmt->bind_param('sssi',$val1,$val2,$val3,$RecNo);
					if($stmt->execute())
					{
						$count = $stmt->affected_rows;
						echo $count;
					}		
//////////////// QUERY 1  END /////////////////////////////////////////////////////////////////////
*/



//////////////// QUERY 2 /////////////////////////////////////////////////////////////////////

$con = mysqli_connect($db_host,$db_user,$db_pass,$db_database) or die('Unable to establish a DB connection');
$table = 'scores';
$date = date('Y-m-d H:i:s');


/*
$prestr 	= "Mrt_M_";		
$STATUS		= $prestr."Status";
$S_R1 		= $prestr."Scr_1";
$S_R2 		= $prestr."Scr_2";
$PCT 		= $prestr."PPT";
$DPM 		= $prestr."DSP";
$TIMETAKEN 	= $prestr."TimeTaken";
*/


$STATUS		= "Mrt_M_Status";
$S_R1 		= "Mrt_M_Scr_1";
$S_R2 		= "Mrt_M_Scr_2";
$PPT 		= "Mrt_M_PPT";
$DSP 		= "Mrt_M_DSP";
$TIMETAKEN 	= "Mrt_M_TimeTaken";

$TimeOfLogin	=	$date;	
$no_of_logins	=	10;
$time_of_nLogin	=	$date;
$m_scr_row1		=	5;
$m_scr_row2		=	5;
$m_ppt			=	20;
$m_dsp			=	60;
$m_time			=	120;
$date			=	$date;
$RecNo			=	24;

		$query = "UPDATE $table SET 
				TimeOfLogin = ?,
				no_of_logins = ?,
				time_of_nLogin = ?,
				$S_R1 = ?,					
				$S_R2 = ?,					
				$PPT = ?,						
				$DSP = ?,						
				$TIMETAKEN = ?,				
				$STATUS = '1',				
				TimeOfLogout = ?,
				WHERE RecNo = ?";			
		$stmt = $con->prepare($query);

		var_dump($stmt);

		$stmt->bind_param('sisiiddssi',$TimeOfLogin,$no_of_logins,$time_of_nLogin,$m_scr_row1
					$m_scr_row2,$m_ppt,$m_dsp,$m_time,$date,$RecNo);
		if($stmt->execute()) echo " DONE !";


?>	

Thanks to all

Hi,

I have a sql query that executes perfectly in phpMyAdmin but when applied to a PHP script returns nothing. It won't even start a "while" loop. Please review code snippits below.

Submission Script calls function in Database Class:

$result = $database->testReturnId($_POST['years'], $_POST['model']); 
while($row = mysql_fetch_array($result))
{
$i = $i + 1;
echo "ROW " . $i . "&nbsp;" . $row['auto_id'] . "&nbsp;" . $row['auto_year'] . "&nbsp;" . $row['auto_year_high'] . "&nbsp;" . $row['auto_make'] . "&nbsp;" . $row['auto_model'] . "<br />";
}

Database Class Function:

function testReturnId($year, $model){ 
global $form;
$q = 'SELECT * FROM tbl_svc_auto WHERE auto_model = "$model" AND "$year" BETWEEN auto_year AND auto_year_high';
if(!mysql_query($q, $this->connection)){
return false;
}else{
return $result = mysql_query($q, $this->connection);
}
}



I have moved the query to the submission script and replaced the variables with actual data and it still will not work. I can take the same query with out the variables and input it into phpMyAdmin and it works great. On the submission script, I added a row number to the echo thinking that it would a least return the word "ROW" and it does not. I have tested each step of the execution of the query and have not returned any errors. I do not receive any errors at all even during execution. It just seems to refuse to run the "while" statement. I do not know where my problem is......Please help.

Thank you in advance for any assitance you can offer.

Joshua

I'm having problems running a php program on my Linux box which runs fine on my Windows box.   I traced the problem down to a line of code:   $higherValue = 0xFFFFFFFF;   This should be an maximum unsigned int value of 4294967295, but PHP doesn't handle unsigned int so it should convert it to a float. This is not happening on my system. Instead it is just converting it to a max int value of 2147483647.   I wrote a small php test script:   var_dump(0x00000000);

Hello all.   I am using a premade login script which has some very powerful function built in, the one I am looking at using is as follows:

  /** 
    * query - Performs the given query on the database and 
    * returns the result, which may be false, true or a 
    * resource identifier. 
    */ 
   function query($query){ 
      return mysqli_query( $this->connection, $query); 
   } 

The issue is, displaying the results.  I call is via the following code:

$database->query('SELECT LastName, Firstname FROM Patrons WHERE LastName = "Delude"');

But I have no idea how to display it.  I have attempted to echo it out, but I get the following error in the logs:   PHP Catchable fatal error:  Object of class mysqli_result could not be converted to string    

Hi all !,   I am stuck on the following piece of code which does not give an error nor does it give a result. ( i.e. it gives 0 num_rows which should be > 1).    If, however, I execute the query in phpmyadmin by simply substituting the values of $pp,$ll and $room_no in the query it gives the correct result.      Please can someone tell me what I may be doing wrong here.  Thanks !

	$fcon = mysqli_connect($db_host,$db_user,$db_pass,$db_database) or die('Unable to establish a DB connection');

				$pp = "(ms.level = 'Beginner' || ms.level = 'Intermediate')";	  
				$ll = 'ms.diff <= 7';
				$room_no = 4;

				$query = "SELECT md.Member_reg_id, md.fname, md.lname, md.email, md.cell, 
						ms.level, ms.diff, ms.score,  
						r.ID_Status 
						FROM register as r
						JOIN member_detail as md ON r.ID = md.Member_reg_id  
						JOIN memstatus as ms On r.ID = ms.ID  
						WHERE r.CENTERCODE = ? AND r.ID_Status ='A' AND ? AND ?
						ORDER by level, diff, score DESC";
		
				$stmt=$fcon->prepare($query);
				$stmt->bind_param('iss',$room_no,$pp,$ll);
				if(!$stmt->execute()) die('Failed to execute the query'.$fcon->error);
				else
				{
					echo "Executed";
					$stmt->bind_result($Member_reg_id,$fname,$lname,$email,$cell,$level,$diff                                               ,$score,$ID_Status);
					$numrows = $stmt->num_rows;
					$stmt->store_result();
//					echo $numrows;
					while($stmt->fetch())
					{
						echo "<br>".$fname.' '.$lname;
						echo "<br>".$level;
						echo "<br>".$diff;
						echo "<br>".$score;
						echo "<br>".$cell;
						echo "<br>".$email;
					}
				}

Edited by ajoo, 03 January 2015 - 08:00 AM.

hello
I'm using this code:
Code: [Select]
$query="SELECT * FROM `second_content` WHERE CHANGED =0 limit 0,1";to query first row data when I want see it and echo it I recived :
Code: [Select]
Resource id #2can anyone help me ?


thank you

Hi everyone. I have this code that suppose to divide the query result 3 columns in a row. Like this :
Shoes   Hats   Jeans
Shorts  Shirts  Belts
But for some reason this one doesn't work. It gave me everything in a single row. Like this: Shoes Hats jeans Shorts Shirts Belts. I noticed that before I put this two 2 lines of code, it's working fine. It didn't give me any error messages or anythings. Can someone point me out what did I did wrong?

This is two lines I put in:
Code: [Select]
$vuong_query = tep_db_query("select categories_id from " . TABLE_GENDER_CATEGORIES . " where parent_id = 1");
 while ($product_check = tep_db_fetch_array($vuong_query)) {
This is the whole piece of code:
    Code: [Select]
  <tr>
    <td><table width = "100%" border="1" bordercolor="maroon">
      <tr>
<?php
$vuong_query = tep_db_query("select categories_id from " . TABLE_GENDER_CATEGORIES . " where parent_id = 1");
 while ($product_check = tep_db_fetch_array($vuong_query)) {

$categories_querys = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . $product_check['categories_id'] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name");
    

    $number_of_categories = tep_db_num_rows($categories_querys);

    $rows = 0;
    while ($categories = tep_db_fetch_array($categories_querys)) {
      $rows++;
      $cPath_new = tep_get_path($categories['categories_id']);
      $width = (int)(100 / MAX_DISPLAY_CATEGORIES_PER_ROW) . '%';
      echo '         <td align="center" class="smallText" width="' . $width . '" valign="top"><a href="' . tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">' . tep_image(DIR_WS_IMAGES . $categories['categories_image'], $categories['categories_name'], SUBCATEGORY_IMAGE_WIDTH, SUBCATEGORY_IMAGE_HEIGHT) . '<br>' . $categories['categories_name'] . '</a></td>' . "\n";
      if ((($rows / MAX_DISPLAY_CATEGORIES_PER_ROW) == floor($rows / MAX_DISPLAY_CATEGORIES_PER_ROW)) && ($rows != $number_of_categories)) {
echo '       </tr>' . "\n";
echo '       <tr>' . "\n";
      }
    }
}
    ?>
      </tr>
            </table>
          </td>
        </tr>
Thanks anyone for helping me out.
Vanvoquan

Hi there I am new to this forum and not much of a php expert. I hope you can assist me. My problem is as follows: I have a column consisting of several values (in this case: sceience, art, humanistics and music) I would like to use the following mysqli query in order to count the appearances of each value in this column:     $query = "SELECT SUM (IF(department = 'science', 1, 0)) AS science, SUM(IF(department = 'art', 1, 0))-> AS art FROM new2"   I have tried lots of ways to loop the results but couldn't get the it working. Can anyone suggest any idea?   Thanks   Hanan  

Hello,
So I have a content management site set up, but I'm stuck on one part. I have a query. Code: [Select]
Select `email` FROM author WHERE author.id IN(SELECT authorid FROM job WHERE id = '$_POST[id]')
I'm a beginner in PHP and SQL. Basically I need the query to run, it will come out with one result and I need that to be where the email is sent to.

This is the existing code I have for sending out the email $subject = " Job Application Confirmation";

$message = "Hello $_POST[name] , \r\rYou, or someone using your email address, has applied for the job: $text Using the Resource Locator at Prahan.com. Keep this as future reference. \r\r Full Name: $_POST[name] \r Location: $_POST[location] \r Email: $_POST[email] \r Additional Information: $_POST[info] \r Job ID: $id  \r Job Name: $text  \r \r Expect a response shortly. \r\r Regards, Prahan.com Team";

$headers = 'From: Prahan.com Team <noreply@prahan.com>';

    'Reply-To: noreply@prahan.com' . "\r\n" .

    'X-Mailer: PHP/' . phpversion();

$to1      = 'pratik@prahan.com';

mail($to1, $result, $message, $headers);


Thanks in Advance!

Hi,

I have attached sql script for table structure and sample data.

When I run following sql query ,I get result set.

Code: [Select]
select * from tablename order by col10 desc
I want to create array using result set.

Following is the require structure of array.

Code: [Select]
<?php

$resultSet[]=array
    (
        ('0') =>array (
              ('col10value1') => array
                    (
                        ('0') => array
                            (
                                ('col1') => 'col1',
                                ('col2') => 'col2',
                                ('col3') => 'col3',
                                ('col4') => 'col4',
                                ('col5') => 'col5',
                                ('col6') => 'col6',
                                ('col7') => 'col7',
                                ('col8') => 'col8',
                            ),
                        ('1') => array
                            (
                                ('col1') => 'col1',
                                ('col2') => 'col2',
                                ('col3') => 'col3',
                                ('col4') => 'col4',
                                ('col5') => 'col5',
                                ('col6') => 'col6',
                                ('col7') => 'col7',
                                ('col8') => 'col8',
                            ),
                    ),
            ),
 

        ('1') => array (
          ('col10value2') => array
                (
                    ('0') => array
                        (
                            ('col1') => 'col1',
                            ('col2') => 'col2',
                            ('col3') => 'col3',
                            ('col4') => 'col4',
                            ('col5') => 'col5',
                            ('col6') => 'col6',
                            ('col7') => 'col7',
                            ('col8') => 'col8',
                        ),
                ),
        ),
    );   
?>

Hello!

I am busy developing a script that returns all users that have the cell "Available" set to 1
but I am unsure how to do this, I am familiar with basic SQL and I have made this:

$sql = "SELECT * FROM `clans` WHERE `available` =1 LIMIT 0 , 30";
if ($result = mysql_query($sql)) {
if (mysql_num_rows($result)) { 
$row = mysql_fetch_assoc($result);
echo ($row['name']);

but it only displays information from the first row found, and I want it to display all the rows found, how can I do this?
Thanks

- GreenFanta

I have this query to show the current class I'm in:
Code: [Select]
$GetTimeTable = "SELECT * FROM timetable WHERE username='$username' AND Subject_date='$today_date'";
Then I have this to display current class:
Code: [Select]
if($TimeNow >= $Start_time && $TimeNow <= $End_time){
echo "Current Class: ";
echo $Subject;}
How would I find next class that day?

Hello, I am new to the board and PHP. I created a simple store locator app with PHP. It pulls the info from a database. I want to  take the website field from the table, once it is returned from the query, and have it print out a a hyperlink.
Please help.

Thanks, I have posted most of the relevant code.


<?php   if (isset ($stores)) {     if (!empty ($stores)) {       
   echo '<p><strong>' . count ($stores) . ' results were found.</strong></p>';     foreach ($stores as $value) {         
   echo '<p><strong>' . $value['name'] . '</strong><br />';       
   echo $value['address'] . '<br />';       
   echo $value['town'] . ', ' . $value['state'] . ' ' . $value['postal'];     
   echo '&nbsp;<a target="_blank" href="http://maps.google.com/maps?q=',
            $value['address'], ' ', $value['town'], ', ', $value['state'], ' ',
            $value['postal'],'">Map this location</a><br />';       
   echo 'Phone: ' . $value['phone'] . '<br />';
   echo 'Website: ' . $value['website'] .  '<br />'; 
   echo 'Email: ' . $value['email'] . '<br />';   
   echo 'Hours: ' . $value['hours'] ;     
   echo '</p>';       }     }
      else {     
   echo '<p><strong>No results found</strong></p>';   }   }   
   ?>
   

Hi all,

Just a pretty basic question that I can't find the asnwer to:

I have a MySQL query of the following form:
Code: [Select]
$result = mysql_query (" SELECT $cols FROM tablename   WHERE.......");
Where $cols is as follows:
Code: [Select]
$cols = firstname, lastname, $price1, $price2, etc.
($price1 and $price2 are variable column names that contains prices)

How do I find the lowest value for $price1 and/or $price2 out of the results set of this query?

Thanks!