I had this working earlier today, so I entered some new test data and tidyed up the code. Now it doesn't work🙁
FYI, I have it on a free Tripod account, so that could be a factor. Here's the code:
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN">
<HTML>
<HEAD>
<TITLE>Test Site</TITLE>
</HEAD>
<BODY BGCOLOR="#F7F7F7">
<CENTER>
<BR>
<TABLE ALIGN="center" CELLSPACING=0 CELLPADDING=0>
<TR WIDTH=100% VALIGN="top">
<TD>
</TD>
<TD ALIGN="left" WIDTH=70%>
<IMG SRC="logo.gif">
</TD>
<TD ALIGN="left">
<BR>
<BR>
<FORM ACTION="index.php" METHOD="post">
<INPUT TYPE=TEXT NAME=search MAXLENGTH=30 SIZE=12><SELECT NAME=subj SIZE=1>
<OPTION SELECTED VALUE=all>All
<OPTION VALUE=artist>Artist
<OPTION VALUE=title>Title
<OPTION VALUE=label>Label
</SELECT><INPUT TYPE=SUBMIT VALUE=Search></FORM>
</TD>
</TR>
</TABLE>
<TABLE ALIGN=center CELLSPACING=0 CELLPADDING=8>
<TD>
<A HREF="index.php" TARGET="parent" ONMOUSEOVER="document.images[1].src='newa.gif'; return true;" onmouseout="document.images[1].src='newi.gif'; return true;">
<IMG SRC="newi.gif" BORDER=0></A>
</TD>
<TD>
<A HREF="index.php" TARGET="parent" ONMOUSEOVER="document.images[2].src='browsea.gif'; return true;" onmouseout="document.images[2].src='browsei.gif'; return true;">
<IMG SRC="browsei.gif" BORDER=0></A>
</TD>
<TD>
<A HREF="index.php" TARGET="parent" ONMOUSEOVER="document.images[3].src='carta.gif'; return true;" onmouseout="document.images[3].src='carti.gif'; return true;">
<IMG SRC="carti.gif" BORDER=0></A>
</TD>
<TD>
<A HREF="index.php" TARGET="parent" ONMOUSEOVER="document.images[4].src='foruma.gif'; return true;" onmouseout="document.images[4].src='forumi.gif'; return true;">
<IMG SRC="forumi.gif" BORDER=0></A>
</TD>
<TD>
<A HREF="index.php" TARGET="_parent" ONMOUSEOVER="document.images[5].src='helpa.gif'; return true;" onmouseout="document.images[5].src='helpi.gif'; return true;">
<IMG SRC="helpi.gif" BORDER=0></A>
</TD>
</TABLE>
<BR>
<?php
$Host = "localhost";
$User = "me";
$Password = "********";
$DBName = "myDB";
$Link = mysql_connect ($Host, $User, $Password);
if (($subj = artist) || ($subj = title) || ($subj = label)){
$Query = "SELECT * FROM stock WHERE $subj LIKE '%$search%'";}
elseif ($subj = all) {
$Query = "SELECT * FROM stock WHERE artist LIKE '%$search%' || title LIKE '%$search%' || label LIKE '%$search%'";}
else{
$Query = "SELECT * FROM stock WHERE recent = 'Y' AND available = 'Y'";}
$Result = mysql_db_query ($DBName, $Query, $Link);
print ("<TABLE BORDER=0 WIDTH\"75%\" CELLSPACING=6 CELLPADDING=2 ALIGN=center>\n");
print ("<TR ALIGN=center VALIGN=top>\n");
print ("<TD ALIGN=center VALIGN=top><B>Artist</B></TD>\n");
print ("<TD ALIGN=center VALIGN=top><B>Title</B></TD>\n");
print ("<TD ALIGN=center VALIGN=top><B>Label</B></TD>\n");
print ("<TD ALIGN=center VALIGN=top><B>Price</B></TD>\n");
print ("</TR>\n");
while ($Row = mysql_fetch_array ($Result)) {
print ("<TR ALIGN=center VALIGN=top>\n");
print ("<TD ALIGN=center VALIGN=top>$Row[artist]</TD>\n");
print ("<TD ALIGN=center VALIGN=top>$Row[title]</TD>\n");
print ("<TD ALIGN=center VALIGN=top>$Row[label]</TD>\n");
print ("<TD ALIGN=center VALIGN=top>£$Row[price]</TD>\n");
print ("</TR>\n");
}
mysql_close ($Link);
print ("</TABLE>\n");
?>
</CENTER>
</BODY>
</HTML>
Surely this should work, but it returns everything from the database when I first open the page. When I search, it returns nothing...
I'm not an expert PHP programmer, but I am pretty sure the above should work.
I appreciate any help.
Thanks,
Nick🙂
