PHP - Noob! Dynamic Drop Down Menu To Change Query Or Result Help!!!!

I am having a lot of trouble with this code, and I have no clue how to fix it.  Right now, I have a GUI for a fictitious car dealership that has 5 populated drop down menus called Make, Model, Year, Color, and Mileage.  What I want the code to do is read the selections made by the user with the drop down menus once the user hits the submit button and then filter the tables that I have in a mysql database to meets the choice requirements of the user.

The code will bring up the GUI, but once I hit the submit button, I get the following errors

Please if anyone can help me that would be fantastic.  I really have no clue

In an .html, before : <!-- BEGIN myquery -->

I need to stop output and check the content of "myquery"

Is there a command for that ?

Thank You.

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.

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

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 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!

Hello.  This one is driving me up the wall.  It used to work,

I have a sports league database (MsSql) and one of the tables contains team Captain's first name, last name, etc..  To create a unique but simple login, the query searches for the captain's first initial of their first name + lastname + league.  However since there is the remote possibility of two similar usernames (i.e. David Smith) if the last name is found, the query adds an integer to the end of the last name.

So the result would look like this:  DSmithM4A

At the moment, my database is completely blank.  However what is happening when I run the query below is I get: DSmith1M4A

Can someone figure out why this code is not working correctly?  If there is not more than one "Smith" no integer is supposed to be returned.  There is something in the "Captain Count" that I think is not working correctly.

Code: [Select]
    /*
     * Gather captian information
     */
    $strCaptainFirstInitial = substr($arrPost['cpt_first'],0,1);
    $strCaptainLastName = preg_replace("/[^a-zA-Z]/","",$arrPost['cpt_last']);
    $strCaptainName = strtolower($strCaptainFirstInitial.$strCaptainLastName);
    $sqlCaptainSearch = sprintf
    (
        $strCaptainSearch,
        $strCaptainName
    );
    $resCaptainSearch = mssql_query($sqlCaptainSearch,$conDB);
 
    /*
     * Create unique captain login and Password
     */
    $strCaptainCount = (mssql_num_rows($resCaptainSearch) > 0)
        ? mssql_num_rows($resCaptainSearch)
        : "" ;
    $strLeagueTypeInitial = substr($arrLeagueSearch['type'],0,1);
    $strCaptainLogin =
        $strCaptainName .
        $strCaptainCount .
        $strLeagueTypeInitial .
        $arrLeagueSearch['size'] .
        $arrLeagueSearch['division'];

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 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!

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 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

This topic has been moved to MySQL Help.

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