dynamic heading

ceanth

Hi all, im a newbie so go easy on me if i ask silly questions.

OK here goes:

AIM: im trying to create a dynamic heading, i have a table in mysql, and linking to it works fine

CODE: this is the section of code which is causing all the problems:

$result = mysql_query ("
select product_desc
from product
where product_no = '$product'
");

echo "$result";

QUESTION: ok i have a form and $product is the input from user, if i type in the select command in mysql and replace $product with '1' i get my output, but i want user to type in 1 and produce the same output on screen.

I plan to use this in a heading, like Welcome u searched for "product_desc" when users type in the product no.

Any ideas if this code is correct, if not how would i achive what i am after.

thanks

ceanth

cgraz

Create a form:

<form method="post" action="page.php">

Product: <input type="text" name="product"><br><br>

<input type="submit" value="Submit">

</form>

Then on page.php

$product = $_POST['product'];
$query = mysql_query("SELECT product_desc FROM product WHERE product_no='$product'");

$row = mysql_fetch_array($query);

Welcome u searched for "product_desc"

They didn't search for what product_desc is, they searched for $product. That's what they typed into the form. You'd want to say something liike your search for $product returned product_desc or your search just display product_desc. To do this, after $row = . .

echo "Your search for " . $product . " found " . $row["product_desc"] . "<br>\n";

Cgraz

ceanth

umm it didnt seem to work.

Q. what is the purpose of $product=$_POST['product'];

and why is $row["product_desc"] in the output?

the url is: http://www.lgu.ac.uk/~cghe11/project/testing/form.html

this is an exact of what you said.

one more thing would all ouputs involve the use of the mysql_fetch_row command?

cgraz

I can see you're really new to this 😉

don't forget to put <? and ?> around all php (on page.php). That's why when you hit submit, you see php code instead of results.

Q. what is the purpose of $product=$POST['product'];

By default, register globals is off. That means to access variable $id from a form, yo'ud need to use $POST['id'] Have a look here: http://www.php.net/manual/en/configuration.directives.php#ini.register-globals

and why is $row["product_desc"] in the output?

$row is now an array (www.php.net/mysql_fetch_array) To access the field product_desc from your database, you need to use $row["product_desc"]

one more thing would all ouputs involve the use of the mysql_fetch_row command?

in this case, mysql_fetch_array (fetch_row and fetch_array are different. you can look 'em up at php.net for more info). mysql_fetch_array puts them all in array and allows you to call them by the field name within those brackets. $row["field_name"]

Cgraz

ceanth

aha, yea VERY new to it. i added the ?> but its still not happy

check out the url again, the error is on the display line, it is

echo"Your search for ".$product." found ".$row["product_desc"]._"<br>\n";

cgraz

hmm, nothing wrong with that line. Copy and paste all your code for page.php

Cgraz

ceanth

<?php

$query=mysql_query("SELECT_product_desc_FROM_product_WHERE_product_no='$product'");

$row=mysql_fetch_array($query);
echo"Your search for ".$product." found ".$row["product_desc"]._"<br>\n";
?>

cgraz

Do you actually have all those underscores there or did you add them in for your post. Copy and paste this

<?

$product = $_POST['product'];
$query = mysql_query("SELECT product_desc FROM product WHERE product_no='$product'");

$row = mysql_fetch_array($query);

echo "Your search for " . $product . " found " . $row["product_desc"] . "<br>\n";

?>

There are no parse errors in that. Unless you actually put those underscores in your php, then you shouldn't be getting any errors.

Cgraz

ceanth

ok i narrowed it down

if i leave line 3 in that is the error, if i take that out then the echo bit messes up.

Could it be due to the version of php or something?

cgraz

if $product = $_POST['product']; gives you an error then use $product = $HTTP_POST_VARS['product'];

ceanth

$product = $HTTP_POST_VARS['product']; worked, but the echo link gives the error