heading problem

[ceanth]

Hey all i got a php site up and running:

http://www.lgu.ac.uk/~cghe11/project/customersearch.html

enter "ghed"

Ok this brings cust_no, cust_fname, cust_sname in that order (no is the "order history" button.

Click "order history"

This uses the cust_no and brings the order_no and date.

My question is this, how do i get the cust_fname and cust_sname on the order history screen, i want the title to say "history for "cust_fname, sname" but i get the error which is showen.

im using this for the title:

<h2>The Customers Which Have a Surname containing
<?php
$link = mysql_connect("localhost", "user", "pass");
mysql_select_db ("table") ;
$result = mysql_query("
select cust_fname, cust_sname
from customer
where cust_no = '$customerno'
");
while ($row1 = mysql_fetch_row ($result))
$name = strtoupper($result);

echo "$result" ; ?></h2>

Any ideas?

[ceanth]

DOH i figured it out, below is the code if anyone has same problem:

mysql_select_db ("db") ;
$result = mysql_query("
select cust_fname, cust_sname
from customer
where cust_no = '$customerno'
");
while ($row1 = mysql_fetch_row ($result))

echo "$row1[0] $row1[1]" ; ?></h2>

[volleytotal_ch]

have you seen what happens when you insert '%%%' into the search field :p Doesn't make sense, does it 😉