[Resolved] Now... a search problem

blaster_master

i have an html page and a php page which is a part of the html one. and they are supposed to do an extremely simple type of searching. when i click on submit i see nothing on my php page.

it probably has nothing to do with my code, but here they're:

search.html

...
<FORM ACTION ="results.php" METHOD="POST">
Enter something:
<BR>
<INPUT NAME="name" TYPE=TEXT>
<BR>
<INPUT TYPE=SUBMIT VALUE="search">
...

results.php

<HTML>
<HEAD>
<TITLE>Search results</TITLE>
</HEAD>

<BODY>
<?
	$db = mysql_connect("localhost", "......", ".........");
	mysql_select_db("my_db", $db);
	$query = "select my_table.tune, my_table.year
		from my_table where name like '%".$name."%'";
	$result = mysql_query($query);
	while ($audio = mysql_fetch_assoc($result)) {
		while (list($fieldname, $fieldvalue) = each ($audio)) {
			echo $fieldname.": <B>.$fieldvalue."</B><BR>";
	}
	echo "<BR>";
}
?>
</BODY>
</HTML>

the reason why i say it's probably not from the coding is that my code is taken from a working tutorial.

i absolutely don't know what to do. i did search and read through like 3-4 pages and found some good posts but not my case.
i'm using PHP 4, Apache 1.3.xx and mySQL 4.1.xx

Frederick

For starters, change this
$query = "select my_table.tune, my_table.year
from my_table where name like '%".$name."%'";

to:

$query = "select tune, year from my_table where name like '%$name%' ";

Change this
while ($audio = mysql_fetch_assoc($result)) {
while (list($fieldname, $fieldvalue) = each ($audio)) {
echo $fieldname.": <B>.$fieldvalue."</B><BR>";
}

To:

while ($audio = mysql_fetch_array($result)) {
    echo $audio["fieldname"]."<br>\n";
}

See what you get.

blaster_master

thnx. at least now i get something on my page! but not quite what it should be... when i hit the search button it returns nothing.
before changing my php code to what you suggested, the result page was blank. now it shows the title of the page and stuff, but no search results are returned.

EDIT: ok, to add something else, when i code my php page as:

<?
echo $name;
?>

i still get nothing when in fact i should be able to see the entered text by the user as the output :queasy:

rehfeld

this is good security wise, but you will need to change your code.

instead of echo $name

you need to do echo $GET['name'] or $POST['name'] etc....

do a search on register globals to learn more.

another thing, i dont recomend using short php tags, use the full ones eg: <?php

some servers disable short tags. if you ever move to such a server you code will not work at all. imo not worth the risk to save yourself such a tiny extra effort.

blaster_master

thnx... that was the prob