gamerzfuse

I now have a working http://www.craighooghiem.com/goodwills/final/inventory.php?type=car But, as soon as you sort a column on this page, it reverts back to a URL without type. Can i edit this function to include the GET _type ? // Sort Url function SortUrl(&$fld) { if ($this->CurrentAction <> "" || $this->Export <> "" || ($fld->FldType == 205)) { // Unsortable data type return ""; } else { $sUrlParm = $this->UrlParm("order=" . urlencode($fld->FldName) . "&ordertype=" . $fld->ReverseSort()); return ew_CurrentPage() . "?" . $sUrlParm; } }

I couldn't get it to output, but string(44) "SELECT * FROM `vehicles` ORDER BY `year` ASC" echo nl2br("\n\n").$sSql.nl2br("\n\n"); Gave me: SELECT * FROM `vehicles` ORDER BY `year` ASC Does that help? The related Function is: // Table SQL function SQL() { $sFilter = $this->CurrentFilter; $sSort = $this->getSessionOrderBy(); return ew_BuildSelectSql($this->SqlSelect(), $this->SqlWhere(), $this->SqlGroupBy(), $this->SqlHaving(), $this->SqlOrderBy(), $sFilter, $sSort); } (as far as I can gather) EDIT: Finally fixed this mother F*er. Don't ask why, but by commenting out $sFilter = $this->CurrentFilter; //$sSort = $this->getSessionOrderBy(); In the above function, it solved my problem! Unfortunately now my sort won't work?

It's definitely not. If it was only that simple, they are stored as Car SUV etc

Does it make sense that I got: NULL when var_dump($sSql) was output?

I'm still getting the same error. right syntax to use near 'WHERE type = 'car' LIMIT 0, 46' at line 1 Does this mean that type=car is the function that is not working?

Unfortunately I think I'm missing something. http://craighooghiem.com/goodwills/final/inventory.php?order=type&ordertype=DESC&type=car still flags an issue with the code. Am I missing something? I have the code supplied in my inventory.php file, but I when I type in the URL I get those errors. I used to type that URL in and just get no results.. so I feel like I'm getting closer. Anything wrong with: $sSql = ($_GET['type']) ? $vehicles->SQL() . " WHERE type = '" . mysql_real_escape_string($_GET['type']) . "'" : $vehicles->SQL(); (tried with isset() and empty(), but both just gave me errors the same as this [while empty() gave me errors even on just inventory.php without any extras in the URL])

What? It doesn't make scenes, but it makes sense. Awesome! If this works I will be so relieved! brb. ..ok!? EDIT: <?php // Load list page SQL isset($_GET['type']); $sSql = ($_GET['type']) ? $vehicles->SQL() . " WHERE type = '" . mysql_real_escape_string($_GET['type']) . "'" : $vehicles->SQL(); if ($offset > -1 && $rowcnt > -1) $sSql .= " LIMIT $offset, $rowcnt"; ?> Am I doing this right? (site says: Failed to execute SQL. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE type = 'car' LIMIT 0, 46' at line 1)

Ok.. but I don't know how to do this? http://craighooghiem.com/goodwills/final/inventory.php?order=type&ordertype=DESC That is how the site is currently sorting by type. I don't want to sort the table though, I want to.. only show one type? Like I said, if it's too difficult just say the word and I'll give up. Just got this reply mid my reply. Does the mysql_real_escape_string get the type from somewhere? I'll plug it in and see what happens!

Can't say whether we have ack or not. I also run openSUSE but I'm doing this project in Windows as I've been using Photoshop for various things and GIMP rubs me the wrong way. Regardless, I can sort by type in my inventory, so does this help? I'm sorry for my incompetence.. I'm so far behind the ball here.

Like I said, still a beginner, but thanks for bearing (baring?) with me so far! I don't know how to check if it has been passed through the URL.. and I don't necessarily know what amending the SQL means. I understand the WHERE type= and it works when I use that, I just don't know where exactly I would put that. Ideally I would have a button that performs: Change SELECT * FROM `vehicles` to SELECT * FROM `vehicles`WHERE type="car" If this is going to be too much work, then I will just try and change the function to select only cars and make it cars.php, but I'm trying to cut down on the amount of files.

Windows Grep found: 00258: function SqlSelect() { // Select 00262: function SqlWhere() { // Where 00266: function SqlGroupBy() { // Group By 00270: function SqlHaving() { // Having 00274: function SqlOrderBy() { // Order By 00291: function SQL() { 00374: function SqlKeyFilter() { Which relates to the block of code: // Table level SQL function SqlSelect() { // Select return "SELECT * FROM `vehicles`"; } function SqlWhere() { // Where return ""; } function SqlGroupBy() { // Group By return ""; } function SqlHaving() { // Having return ""; } function SqlOrderBy() { // Order By return ""; } // SQL variables var $CurrentFilter; // Current filter var $CurrentOrder; // Current order var $CurrentOrderType; // Current order type // Get SQL function GetSQL($where, $orderby) { return ew_BuildSelectSql($this->SqlSelect(), $this->SqlWhere(), $this->SqlGroupBy(), $this->SqlHaving(), $this->SqlOrderBy(), $where, $orderby); } // Table SQL function SQL() { $sFilter = $this->CurrentFilter; $sSort = $this->getSessionOrderBy(); return ew_BuildSelectSql($this->SqlSelect(), $this->SqlWhere(), $this->SqlGroupBy(), $this->SqlHaving(), $this->SqlOrderBy(), $sFilter, $sSort); } // Return table sql with list page filter function SelectSQL() { $sFilter = $this->getSessionWhere(); if ($this->CurrentFilter <> "") { if ($sFilter <> "") $sFilter = "($sFilter) AND "; $sFilter .= "(" . $this->CurrentFilter . ")"; } $sSort = $this->getSessionOrderBy(); return ew_BuildSelectSql($this->SqlSelect(), $this->SqlWhere(), $this->SqlGroupBy(), $this->SqlHaving(), $this->SqlOrderBy(), $sFilter, $sSort); }

SELECT * FROM something WHERE type IN ('Car', 'SUV', 'Truck', 'Van'); I understand this perfectly. The only problem is that there is not SELECT action like this in the file as of now, so I don't even know where to find the current reference for the table. I only have Cars, SUVs, Trucks, Vans and As Is in the type options. I can use the SELECT * FROM etc to make a new file called cars.php etc, but I don't know how to do this within the one inventory.php file. Example search URL for Cars: http://craighooghiem.com/goodwills/final/inventory.php?t=vehicles&psearch=Car&Submit=Search+&psearchtype=

This is good. I know how to use the very basic SQL and I used it on my item viewing pages.. I just don't know how the other Select things work. // Load sql based on filter $vehicles->CurrentFilter = $sFilter; $sSql = $vehicles->SQL(); if ($rs = $conn->Execute($sSql)) { if ($rs->EOF) { $LoadRow = FALSE; } else { $LoadRow = TRUE; $rs->MoveFirst(); $this->LoadRowValues($rs); // Load row values I don't know if this is the related code or not? I am more than willing to read tutorials, I just don't know what to Google even? Everything I try comes up with unrelated information or the basic syntax I've been using.

Yeah.. ok. The only problem there is that I have no idea how to do that. I'm still very much in the learning phase here. I wouldn't know how to use SQL to do this? I know that I can search for Car and it will show all the cars and technically I could just use the Search URL except that Caravans would show up under car and van. Any hints, tutorials or guidance would be great.. I'm trying to find my way through this but haven't the slightest clue really..

And I could find this? Wherever that is defined, or am I SOL as far as that goes? Would it be elsewhere in inventory.php or in one of the declared files or do I have to create it? This? <?php // Load sql based on filter $vehicles->CurrentFilter = $sFilter; $sSql = $vehicles->SQL(); if ($rs = $conn->Execute($sSql)) { if ($rs->EOF) { $LoadRow = FALSE; } else { $LoadRow = TRUE; $rs->MoveFirst(); $this->LoadRowValues($rs); // Load row values // Call Row Selected event $vehicles->Row_Selected($rs); } $rs->Close(); } else { $LoadRow = FALSE; } return $LoadRow; } ?>

I just recently did this, not sure exactly how yours works but if this is of any help: ADDING IMAGE: <?php if ($vehicles->picture->Visible) { // picture ?> <tr<?php echo $vehicles->picture->RowAttributes ?>> <td class="ewTableHeader">Picture</td> <td<?php echo $vehicles->picture->CellAttributes() ?>><span id="el_picture"> <input type="file" name="x_picture" id="x_picture" size="30"<?php echo $vehicles->picture->EditAttributes() ?>> </div> </span><?php echo $vehicles->picture->CustomMsg ?></td> </tr> <?php } ?> Referencing Image <?php if ($vehicles->picture->Visible) { // picture ?> <tr<?php echo $vehicles->picture->RowAttributes ?>> <td<?php echo $vehicles->picture->CellAttributes() ?>> <?php if ($vehicles->picture->HrefValue <> "") { ?> <?php if (!is_null($vehicles->picture->Upload->DbValue)) { ?> <a href="<?php echo ew_UploadPathEx(FALSE, "images/") . $vehicles->picture->Upload->DbValue ?>" target="_blank"> <img src="<?php echo ew_UploadPathEx(FALSE, "images/") . $vehicles->picture->Upload->DbValue ?>" border=0 width=300<?php echo $vehicles->picture->ViewAttributes() ?>> </a> <?php } elseif (!in_array($vehicles->CurrentAction, array("I", "edit", "gridedit"))) { ?> <?php } ?> <?php } else { ?> <?php if (!is_null($vehicles->picture->Upload->DbValue)) { ?> <a href="<?php echo ew_UploadPathEx(FALSE, "images/") . $vehicles->picture->Upload->DbValue ?>" target="_blank"> <img src="<?php echo ew_UploadPathEx(FALSE, "images/") . $vehicles->picture->Upload->DbValue ?>" border=0 width=300<?php echo $vehicles->picture->ViewAttributes() ?>> </a> <?php } elseif (!in_array($vehicles->CurrentAction, array("I", "edit", "gridedit"))) { ?> <?php } ?>

Back again, sorry to bother you folks but you've been my saving grace here. I need to build a menu on my inventory page (I can do this easily) but I need it to link to things like: Cars, SUVs, Trucks, Vans, As Is from the inventory.php file. I'm sure I can edit the file to display only one type, rename it to cars.php, etc but I would rather not if possible. As far as I can gather, the values are loaded: // Load recordset function LoadRecordset($offset = -1, $rowcnt = -1) { global $conn, $vehicles; // Call Recordset Selecting event $vehicles->Recordset_Selecting($vehicles->CurrentFilter); // Load list page SQL $sSql = $vehicles->SelectSQL(); if ($offset > -1 && $rowcnt > -1) $sSql .= " LIMIT $offset, $rowcnt"; // Load recordset $conn->raiseErrorFn = 'ew_ErrorFn'; $rs = $conn->Execute($sSql); $conn->raiseErrorFn = ''; // Call Recordset Selected event $vehicles->Recordset_Selected($rs); return $rs; } In there. Any ideas as to how I might make a variable or somehow come up with a working URL like URL/inventory.php?type=car Any help would be just awesome

Russel... you are my hero today. I have been struggling with this application all week.. it's been one hell of a journey. You just helped relieve the stress of a week's work crashing down around me!

Thanks. *dumb moment* Now Can I just change that to "> or am I removing this?

Yeah, thanks! I figured it out shortly before that, but only because I read over your original posts and figured it out. You've been a huge help! Only a huge Internet Explorer issue to work out, and one issue with a database call wrecking all my PHP

Meaning I should be changing it in the database itself? The $model has worked everywhere else.. I'll look into it. The IE issue you helped me with is more pressing at this time.

Thanks again Russel, I know most of these tricks.. unfortunately that doesn't appear to be the problem. The checkboxes in the bottom left of my Firefox page don't even show up in Internet Explorer: <td class="pcdoptions2"> <?php $checked = ($powermirros == 1) ? 'checked="checked"' : ''; echo '<input type="checkbox" id="powermirrors" name= "powermirrors" onclick="return false;" '.$checked.' "/>'; ?>Power Mirrors<br> <?php $checked = ($powerseats == 1) ? 'checked="checked"' : ''; echo '<input type="checkbox" id="powerseats" name= "powerseats" onclick="return false;" '.$checked.' "/>'; ?>Power Seats<br /> <?php $checked = ($powersteering == 1) ? 'checked="checked"' : ''; echo '<input type="checkbox" id="powersteering" name= "powersteering" onclick="return false;" '.$checked.' "/>'; ?>Power Steering<br /> <?php $checked = ($powerwindows == 1) ? 'checked="checked"' : ''; echo '<input type="checkbox" id="powerwindows" name= "powerwindows" onclick="return false;" '.$checked.' "/>'; ?>Power Windows<br /> <?php $checked = ($quadseats == 1) ? 'checked="checked"' : ''; echo '<input type="checkbox" id="quadseats" name= "quadseats" onclick="return false;" '.$checked.' "/>'; ?>Quad Seats<br /> <?php $checked = ($roofrack == 1) ? 'checked="checked"' : ''; echo '<input type="checkbox" id="roofrack" name= "roofrack" onclick="return false;" '.$checked.' "/>'; ?>Roof Rack<br /> <?php $checked = ($spoiler == 1) ? 'checked="checked"' : ''; echo '<input type="checkbox" id="spoiler" name= "spoiler" onclick="return false;" '.$checked.' "/>'; ?>Sun Roof<br /> </td> That's one <td> of the two that are meant to display checkboxes with titles (as seen in Firefox) Any reason these wouldn't be showing up in Internet Explorer? EDIT: Using View Source in IE I see this: <td class="pcdoptions2"> <input type="checkbox" id="powermirrors" name= "powermirrors" onclick="return false;" "/>Power Mirrors<br> <input type="checkbox" id="powerseats" name= "powerseats" onclick="return false;" checked="checked" "/>Power Seats<br /> <input type="checkbox" id="powersteering" name= "powersteering" onclick="return false;" "/>Power Steering<br /> <input type="checkbox" id="powerwindows" name= "powerwindows" onclick="return false;" checked="checked" "/>Power Windows<br /> <input type="checkbox" id="quadseats" name= "quadseats" onclick="return false;" "/>Quad Seats<br /> <input type="checkbox" id="roofrack" name= "roofrack" onclick="return false;" "/>Roof Rack<br /> <input type="checkbox" id="spoiler" name= "spoiler" onclick="return false;" checked="checked" "/>Sun Roof<br /> </td> So why is it not showing up?

I made the age old mistake of not checking my work in Internet Explorer periodically. Somehow it's all F-ed up.. http://craighooghiem.com/goodwills/final/view.php?stock=1878 The page views great in Firefox, but in Internet Explorer it's all screwed up. Which is most likely the problem: (if you don't mind helping me out, not sure if PHP related) a) I have declared two stylesheets b) I'm missing a <table> or <td> tag somewhere? c) CSS issues. Anyone have any hints?

onclick="return false;" Did the trick.

One problem: <?php //Make first query to database $query = "SELECT * FROM vehicles"; $result = mysql_query($query) or die ("Couldn’t execute query."); //Set Variables $vehiclemodel = $vehicles->model->ViewValue; $query = "SELECT * FROM vehicles WHERE model='$vehiclemodel'"; $result = mysql_query($query) or die ("Couldn't execute query."); // Display results in a table echo "<tr><td colspan='5'></td></tr>"; while ($row = mysql_fetch_array($result)) { extract($row); //Table Contents $show_price = number_format($price); echo "<tr class='dataright'>\n <td colspan='5' class='dataleft'><a href='view.php?stock=$stock'> $year $model</a></td>\n <td>$odometer km </td>\n <td align='right'>$$show_price.00 </td>\n </tr>\n"; echo "<tr><td colspan='3'></td></tr>\n"; } ?> <!--end right column Make--> <!--start right column Model--> <tr> <td colspan="7" class="pcdrb">Other <?php echo $vehicles->make->ViewValue ?>s</td> </tr> <?php //Make first query to database $query = "SELECT * FROM vehicles"; $result = mysql_query($query) or die ("Couldn’t execute query."); //Set Variables $query = "SELECT * FROM vehicles WHERE make= '$make' AND stock != '$stock'"; $result = mysql_query($query) or die ("Couldn't execute query."); // Display results in a table echo "<tr><td colspan='5'></td></tr>"; while ($row = mysql_fetch_array($result)) { extract($row); //Table Contents $show_price = number_format($price); echo "<tr class='dataright'>\n <td colspan='5' class='dataleft'><a href='view.php?stock=$stock'> $year $model</a></td>\n <td>$odometer km </td>\n <td align='right'>$$show_price.00 </td>\n </tr>\n"; echo "<tr><td colspan='3'></td></tr>\n"; } ?> <!--end right column Model--> <!--start right column Other +-2000--> <tr> <td colspan="7" class="pcdrb">Other <?php echo $vehicles->type->ViewValue ?>s ± $2,000.00</td> </tr> <?php //Make first query to database $query = "SELECT * FROM vehicles"; $result = mysql_query($query) or die ("Couldn’t execute query."); //Set Variables $query = "SELECT * FROM `vehicles` WHERE `price` >= ($price - 2000) AND `price` <= ($price + 2000)"; $result = mysql_query($query) or die ("Couldn't execute query."); // Display results in a table echo "<tr><td colspan='5'></td></tr>"; while ($row = mysql_fetch_array($result)) { extract($row); //Table Contents $show_price = number_format($price); echo "<tr class='dataright'>\n <td colspan='5' class='dataleft'><a href='view.php?stock=$stock'> $year $model</a></td>\n <td>$odometer km </td>\n <td align='right'>$$show_price.00 </td>\n </tr>\n"; echo "<tr><td colspan='3'></td></tr>\n"; } ?> I have these three separate tables. Pricing one (last one) works great. Make (middle one) works great. As soon as I try to add the code SELECT * FROM `vehicles` WHERE `model` = '{$model}' AND `stock` != '{$stock}' to the first one, which is the Similiar Models table, all three of them break and my checkboxes later in the page also all show no results. Is using this statement for make and model both somehow causing a problem?