[Resolved] What did I miss here????

hodge

ok here is my selection script that is working fine. Now once I make the submit and call the next module with the hidden filed is where I'm
having trouble.

"this is working ok"

<html>
<SCRIPT>
function preprocess () {

mainform.DETAILS.value=mainform.FIRSTNAME.value+;
}
</SCRIPT>

<?php
//Get vendor
$vendor=$_POST['vendor'];

$db = mysql_connect("localhost", "xxx", "xxx");
mysql_select_db("vendors",$db);
$query = "SELECT * FROM data WHERE 2";
$result = mysql_query($query);

if (mysql_num_rows($result)) {
// loop through resulting rows, creating options
while ($row = mysql_fetch_row($result)) {
echo "<option value=\"".$row[0]."</option>"."\">".$row[2]."</option>";

}
?>

</select>
<input type = "submit">
<input type="hidden" name="vendor">
</form>
</body>
</html>

"This is the trouble area I need some help with"
<html>

<body bgcolor="#D3FFD0"><center>
<table>
<tr>
</tr>
<tr>
</tr>
<tr>
<?php
$db = mysql_connect("localhost","xxx","xxx");
mysql_select_db("vendors",$db);

$result = mysql_query("SELECT * FROM data where name=$_POST["vendor"]");

Note: the above query is NOT working but the one below "hand coded is" What am I doing wrong in the $_POST section??

$result = mysql_query("SELECT * FROM data where name='david'");

echo "<table border=1 bgcolor=teal>\n";
echo "<tr bgcolor=#d3ffdo><td>acct_num</td><td>name</td><td>addr1</td>
<td>city</td><td>st</td><td>zip</td><td>ph</td></tr>\n";

while ($myrow = mysql_fetch_row($result)) {

printf("<tr bgcolor=yellow> <td>%s</td><td>%s</td><td>%s<td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>\n",
$myrow[1], $myrow[2], $myrow[3], $myrow[4], $myrow[5]

, $myrow[6], $myrow[7]);
}
echo "</table>\n";

</tr>
</table>
</body>
</html>

for some reason when I do the query with the name=$POST["vendor"]; it never brings back my information.
But if I hard code the name it works just fine.
So something in my use of the $POST is out of wack.
Any offers to adjust and / or fix would sure help me out a lot .
Thanks
Hodge.

LordShryku

Try some conditionals, concat the superglobal, and use single quotes in the sql query around the value.

if(!empty($_POST['vendor'])) {
   $result = mysql_query("SELECT * FROM data where name='".$_POST['vendor']."'");

hodge

well I just placed the code into the module
and still no data back.
This is such a simple function to give me such a hard time LOL
but yet if like I said I hand code the query
name ie name='david' it works just fine.

As well I have added this line to the top of the list.

$ven_name = $_POST['vendor'];
and now my new string using it looks like this

result = mysql_query("SELECT * FROM data where name='$ven_name' ");
and that dont even work.
Hummm this must be something real simple to
be over looked this much.

hodge

found the trouble myself

I found the trouble and will post the update for others to use as a guide.

The trouble was really in the layout of the first module I will make the changes to show the before and after code sections.

<html>
<SCRIPT>
function preprocess () {

mainform.DETAILS.value=mainform.FIRSTNAME.value+;
}
</SCRIPT>

<?php
//Get vendor
$db = mysql_connect("localhost", "xxx", "xxx");
mysql_select_db("vendors",$db);
$query = "SELECT * FROM data WHERE 2";
$result = mysql_query($query);

if (mysql_num_rows($result)) {
// loop through resulting rows, creating options
while ($row = mysql_fetch_row($result)) {

this section of code will provide no value based on the hidden field

echo "<option value=\"".$row[0]."</option>"."\">".$row[2]."</option>";

Heres the corrected code section.

echo <option> $row[ Put what ever section for database you wish to view here I needed row 3 ] </option>
}
}
?>

</select>
<input type = "submit">
<input type="hidden" name="vendor">
</form>
</body>
</html>

TheDefender

Hodge, for future reference, and to save everyone some headaches (including yourself), don't post your question to multiple threads... It does 2 things:

1) Causes people to sometimes torubleshoot in two different directions, and causes you to possibly take longer to find a resolve. Plus you could inadvertently mix up the help, and be in worse shape than when you started.

2) Can cause confusion for other new users, who see one answer on one board, and another on another... The differences can be confusing to newbs.

hodge

Yep;
Going to have to AGREE with that statement.
sorry guess I took to much Geritol today LOL
anyway I found the trouble and it's now working fine. But to all who have taken the time
to view the posting here and as well the other spot , Thanks for your time to help an Old man out.