vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   Hey there, my PHP friends. Help please =) (https://vborg.vbsupport.ru/showthread.php?t=276600)

DustyJoe 01-07-2012 09:48 PM
Hey there, my PHP friends. Help please =)
 
I'm having trouble with spaces within mysql table contents.

Everything pulls from the database fine, spaces and all... when I pull using an integer associated with that particular row, now when I try and pull from the database based upon a string with a space, it does not seem to pull the entire sting. Just the data before the space.

For instance, when I try to select and pull "AMC - Gremlin"..
I get Unknown column 'AMC' in 'where clause'

Here is the start:
Code:
$query = "SELECT * FROM BAMFG_vehicle";
$result = mysql_query($query) or die(mysql_error());


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

$output .= "<tr>
                <td width=100><img src='blank_img.gif'</td>
                <td><a href='bamfg_vehicle.php?do=view_vehicle&id=".$row['vehicle_id']."'>".$row['year']." - ".$row['make_model']."</a></td>
                <td width=50>".$row['view_cnt']."</a></td>
        </tr>";

$output2 .= "<OPTION VALUE=".$row['make_model'].">".$row['make_model']."";
}
Here is the code within the template:
Code:
<form action="bamfg_vehicle.php?do=search_vehicle" method="post" enctype="multipart/form-data">
<input type="hidden" name="securitytoken" value="{vb:raw bbuserinfo.securitytoken}" />
<input type="hidden" name="s" value="{vb:raw session.sessionhash}" />

<table width="500" border="1" align="center">
<tr><td width="80">
<SELECT SIZE="6" NAME="year">
<OPTION VALUE="2010"> 2013
<OPTION VALUE="2010"> 2012
<OPTION VALUE="2010"> 2011
<OPTION VALUE="2009"> 2009
<OPTION VALUE="2008"> 2008
<OPTION VALUE="2007"> 2007
<OPTION VALUE="2006"> 2006
<OPTION VALUE="2005"> 2005
<OPTION VALUE="2004"> 2004
<OPTION VALUE="2003"> 2003
</SELECT>
</td>

<td align="left">
<SELECT SIZE ="6" NAME="make_model">
    {vb:raw output2}
</SELECT>
<br>
</td>
</tr>
<tr><td colspan="2" align="right">
<input type="submit" />
</form>
</td></tr>
</table>

Here is my query code:
Code:
if($_REQUEST['do'] == 'search_vehicle') {

$year = $_POST['year'];
$make_model = $_POST['make_model'];

$query = "SELECT * FROM BAMFG_vehicle WHERE make_model = $make_model"; 
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result))
{
$vehicle_id = $row['vehicle_id'];
$year = $row['year'];
$make_model = $row['make_model'];

}



// *** SEND VARIABLES TO TEMPLATE
$templater = vB_Template::create('BAMFG_vehicle_view');
        $templater->register_page_templates();
        $templater->register('navbar', $navbar);
        $templater->register('vehicle_id', $vehicle_id);
        $templater->register('year', $year);
        $templater->register('make_model', $make_model);
print_output($templater->render());
}

kh99 01-07-2012 11:00 PM
The value needs quotes around it, so something like:

Code:
$query = "SELECT * FROM BAMFG_vehicle WHERE make_model = '$make_model'";

DustyJoe 01-13-2012 02:59 PM
Thanks for the help before, I have one more thing kicking my butt though..

my output code
Code:
$output2 .= "<OPTION VALUE=".$row['make_model'].'>'.$row['make_model']."";
produces this respectively.
Code:
<OPTION VALUE= AMC - Gremlin> AMC - Gremlin
I've tried different configurations of quotes and such with no avail, I cannot seem to get quotes to appear round the make_model variable within the code. The year is perfect, but the text is kicking my butt.

kh99 01-13-2012 03:03 PM
Try this:

PHP Code:
$output2 .= '<OPTION VALUE="' . $row['make_model'] . '">' . $row['make_model']; 

DustyJoe 01-13-2012 03:10 PM
That worked perfectly, thank you much.

You have helped me several times with random questions here and I really appreciate the time you take!

I'm slowly learning.


All times are GMT. The time now is 12:48 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01571 seconds
  • Memory Usage 1,725KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (6)bbcode_code_printable
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete