468,733 Members | 1,204 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,733 developers. It's quick & easy.

'Select' & 'Order By' OK- Where Does Not Work

Before i post actual code, as i need a speedyish reply.
Can i first ask if anyone knows off the top of their head, if there is
a likely obvious cause to the following problem.
For the moment i've reduced my form request to a simple text string
entry, instead of my desired optional parameters. As i have been stuck
with a single unfathomable glitch for over a year.
Basically, if i enter queries such as ;
"select * from table" "select * from table order by artist",
it works perfectly. However if i introduce the 'where' option, as in
"select * from table where artist like whatever". It comes back with
"could not execute query". This happens even if i append "order by" to
it.
I'll post all the various codes if anyone can please help.
Jul 19 '05 #1
18 2589
It might be a stupid question,
but sometimes the most stupid thing is the problem!!!

Did you by any chance forget quotes?
The way you typed it you're comparing to columns!!!

"ian justice" <i.*******@onmail.co.uk> schreef in bericht
news:f6**************************@posting.google.c om...
Before i post actual code, as i need a speedyish reply.
Can i first ask if anyone knows off the top of their head, if there is
a likely obvious cause to the following problem.
For the moment i've reduced my form request to a simple text string
entry, instead of my desired optional parameters. As i have been stuck
with a single unfathomable glitch for over a year.
Basically, if i enter queries such as ;
"select * from table" "select * from table order by artist",
it works perfectly. However if i introduce the 'where' option, as in
"select * from table where artist like whatever". It comes back with
"could not execute query". This happens even if i append "order by" to
it.
I'll post all the various codes if anyone can please help.

Jul 19 '05 #2
"Too Sexy" <so*****@nobody.com> wrote in message news:<bn**********@news3.tilbu1.nb.home.nl>...
It might be a stupid question,
but sometimes the most stupid thing is the problem!!!

Did you by any chance forget quotes?
The way you typed it you're comparing to columns!!!

I've tried every combination of single and double quotes.
Interestingly enough it actually sorts and fulfills requests
as detailed below ( 1 & 2 ), WITHOUT ANY QUOTES AT ALL !.
I enter it into my text field without any punctuation.
1. select * from table
2 .select * from table order by column

I'm sending this via web tv, so i'll post the scripts on a pc come Sunday.

The versions i am using are;
PHP4u Version 3.0 Based on PHP-4.3.2
MySQL 3.23.52
Jul 19 '05 #3
i.*******@onmail.co.uk (ian justice) wrote in message news:<f6**************************@posting.google. com>...
I'm sending this via web tv, so i'll post the scripts on a pc come Sunday. The versions i am using are;
PHP4u Version 3.0 Based on PHP-4.3.2
MySQL 3.23.52

The basic and simple form and scripts are given below.
#######SHORT FORM########
<form method="get" action="file_name.php">
Write In Here <input type="textarea" name="write" rows="1"
cols="400"><br><br>
<input type="submit" value="SEARCH">
<input type="reset" value="RESET">

######SHORT SCRIPT########
<?php
$conn=@mysql_connect("localhost", "user_name", "password") or
die("could not connect");
$rs=@mysql_select_db("database_name", $conn) or die("could not connect
to database");
$sql="$write";
$rs=mysql_query($sql, $conn) or die("could not execute query");
$list="<table border=\"1\" cellpadding=\"2\">";
$list.="<tr><th>SONG</th>";
$list.="<th>FOLDER</th>";
$list.="<th>FORMAT</th>";
$list.="<th>ARTIST</th></tr>";
while($row=mysql_fetch_array($rs))
{
$list.="<tr>";
$list.="<td>".$row["SONG"]."</td>";
$list.="<td>".$row["FOLDER"]."</td>";
$list.="<td>".$row["FORMAT"]."</td>";
$list.="<td>".$row["ARTIST"]."</td>";
$list.="</tr>";
}
$list.="</table>";
echo($list);
?>

################################################## #############################
BE A GOD----SEND ME TO HEAVEN
If you want to have a great time and loads of fun. Please feel free to
tackle the problem with my 'Utopian script', which would send me
soaring to Heaven, emotionally, that is.
It produces the following parse error "Parse error: parse error in
/data/members/paid/x/x/user_name/htdocs/directory_name/file_name.php
on line 9"

###LONG SCRIPT#######

<?php
$conn=@mysql_connect("localhost", "user_name", "password") or
die("could not connect");
$rs=@mysql_select_db("database_name", $conn) or die("could not connect
to database");
$sql="select * from table_name where";
if(isset($song)){
$sql.="song="$song" and"
}
if(isset($folder)){
$sql.="folder="$folder" and"
}
if(isset($format)){
$sql.="format="$format" and"
}
if(isset($artist)){
$sql.="artist="$artist" and"
}
$sql=ereg_replace("and", "", "$sql");
if(isset($order)){
$sql.="order="$order"
}
$rs=mysql_query($sql, $conn) or die("could not execute query");
$list="<table border=\"1\" cellpadding=\"2\">";
$list.="<tr><th>SONG</th>";
$list.="<th>FOLDER</th>";
$list.="<th>FORMAT</th>";
$list.="<th>ARTIST</th></tr>";
while($row=mysql_fetch_array($rs))
{
$list.="<tr>";
$list.="<td>".$row["song"]."</td>";
$list.="<td>".$row["folder"]."</td>";
$list.="<td>".$row["format"]."</td>";
$list.="<td>".$row["artist"]."</td>";
$list.="</tr>";
}
$list.="</table>";
echo($list);
?>

######LONG FORM#######

<form action="form_name.php" method="GET">

<b>SONG</b><br>
<input type="text" name="song" size="50"><br>
<b>FOLDER</b><br>
<input type="text" name="folder" size="2"><br>
<b>FORMAT</b><br>
<input type="text" name="format" size="20"><br>
<b>ARTIST</b><br>
<input type="text" name="artist" size="40"><br>

The percent sign can be used as a wildcard. You can place it at the
start, end or both ends with appropiate results.<br>

<b>ORDER RESULTS BY;</b><br>
<input type="radio" name="order" value="order by song"
checked><b>SONG</b><br>
<input type="radio" name="order" value="order by
folder"><b>FOLDER</b><br>
<input type="radio" name="order" value="order by
artist"><b>ARTIST</b>&nbsp

<input type="submit" value="SEARCH"><input type="reset"
value="RESET"><br><br>
</form>
Jul 19 '05 #4
$sql.="folder="$folder" and"
should be: $sql .= "folder=" . $folder ." and";
or: $sql.="folder=$folder and";

Please let me know if I'm a GOD ;)

Expect me when you se me!!!
BE A GOD----SEND ME TO HEAVEN
If you want to have a great time and loads of fun. Please feel free to
tackle the problem with my 'Utopian script', which would send me
soaring to Heaven, emotionally, that is.
It produces the following parse error "Parse error: parse error in
/data/members/paid/x/x/user_name/htdocs/directory_name/file_name.php
on line 9"

Jul 19 '05 #5
i.*******@onmail.co.uk (ian justice) wrote in message news:<f6**************************@posting.google. com>...
I'm sending this via web tv, so i'll post the scripts on a pc come Sunday. The versions i am using are;
PHP4u Version 3.0 Based on PHP-4.3.2
MySQL 3.23.52

The basic and simple form and scripts are given below.
#######SHORT FORM########
<form method="get" action="file_name.php">
Write In Here <input type="textarea" name="write" rows="1"
cols="400"><br><br>
<input type="submit" value="SEARCH">
<input type="reset" value="RESET">

######SHORT SCRIPT########
<?php
$conn=@mysql_connect("localhost", "user_name", "password") or
die("could not connect");
$rs=@mysql_select_db("database_name", $conn) or die("could not connect
to database");
$sql="$write";
$rs=mysql_query($sql, $conn) or die("could not execute query");
$list="<table border=\"1\" cellpadding=\"2\">";
$list.="<tr><th>SONG</th>";
$list.="<th>FOLDER</th>";
$list.="<th>FORMAT</th>";
$list.="<th>ARTIST</th></tr>";
while($row=mysql_fetch_array($rs))
{
$list.="<tr>";
$list.="<td>".$row["SONG"]."</td>";
$list.="<td>".$row["FOLDER"]."</td>";
$list.="<td>".$row["FORMAT"]."</td>";
$list.="<td>".$row["ARTIST"]."</td>";
$list.="</tr>";
}
$list.="</table>";
echo($list);
?>

################################################## #############################
BE A GOD----SEND ME TO HEAVEN
If you want to have a great time and loads of fun. Please feel free to
tackle the problem with my 'Utopian script', which would send me
soaring to Heaven, emotionally, that is.
It produces the following parse error "Parse error: parse error in
/data/members/paid/x/x/user_name/htdocs/directory_name/file_name.php
on line 9"

###LONG SCRIPT#######

<?php
$conn=@mysql_connect("localhost", "user_name", "password") or
die("could not connect");
$rs=@mysql_select_db("database_name", $conn) or die("could not connect
to database");
$sql="select * from table_name where";
if(isset($song)){
$sql.="song="$song" and"
}
if(isset($folder)){
$sql.="folder="$folder" and"
}
if(isset($format)){
$sql.="format="$format" and"
}
if(isset($artist)){
$sql.="artist="$artist" and"
}
$sql=ereg_replace("and", "", "$sql");
if(isset($order)){
$sql.="order="$order"
}
$rs=mysql_query($sql, $conn) or die("could not execute query");
$list="<table border=\"1\" cellpadding=\"2\">";
$list.="<tr><th>SONG</th>";
$list.="<th>FOLDER</th>";
$list.="<th>FORMAT</th>";
$list.="<th>ARTIST</th></tr>";
while($row=mysql_fetch_array($rs))
{
$list.="<tr>";
$list.="<td>".$row["song"]."</td>";
$list.="<td>".$row["folder"]."</td>";
$list.="<td>".$row["format"]."</td>";
$list.="<td>".$row["artist"]."</td>";
$list.="</tr>";
}
$list.="</table>";
echo($list);
?>

######LONG FORM#######

<form action="form_name.php" method="GET">

<b>SONG</b><br>
<input type="text" name="song" size="50"><br>
<b>FOLDER</b><br>
<input type="text" name="folder" size="2"><br>
<b>FORMAT</b><br>
<input type="text" name="format" size="20"><br>
<b>ARTIST</b><br>
<input type="text" name="artist" size="40"><br>

The percent sign can be used as a wildcard. You can place it at the
start, end or both ends with appropiate results.<br>

<b>ORDER RESULTS BY;</b><br>
<input type="radio" name="order" value="order by song"
checked><b>SONG</b><br>
<input type="radio" name="order" value="order by
folder"><b>FOLDER</b><br>
<input type="radio" name="order" value="order by
artist"><b>ARTIST</b>&nbsp

<input type="submit" value="SEARCH"><input type="reset"
value="RESET"><br><br>
</form>
Jul 19 '05 #6
$sql.="folder="$folder" and"
should be: $sql .= "folder=" . $folder ." and";
or: $sql.="folder=$folder and";

Please let me know if I'm a GOD ;)

Expect me when you se me!!!
BE A GOD----SEND ME TO HEAVEN
If you want to have a great time and loads of fun. Please feel free to
tackle the problem with my 'Utopian script', which would send me
soaring to Heaven, emotionally, that is.
It produces the following parse error "Parse error: parse error in
/data/members/paid/x/x/user_name/htdocs/directory_name/file_name.php
on line 9"

Jul 19 '05 #7
"Too Sexy" <so*****@nobody.com> wrote in message news:<bo**********@news4.tilbu1.nb.home.nl>...
$sql.="folder="$folder" and"
should be: $sql .= "folder=" . $folder ." and";
or: $sql.="folder=$folder and";

Please let me know if I'm a GOD ;)

Expect me when you se me!!!

I'm not going to be able to try this for a few days. Although, i fear
i've more mistakes than that in my script. I'll post immediately i've
tried it.
Jul 19 '05 #8
"Too Sexy" <so*****@nobody.com> wrote in message news:<bo**********@news4.tilbu1.nb.home.nl>...
$sql.="folder="$folder" and"
should be: $sql .= "folder=" . $folder ." and";
or: $sql.="folder=$folder and";

Please let me know if I'm a GOD ;)

Expect me when you se me!!!

I'm not going to be able to try this for a few days. Although, i fear
i've more mistakes than that in my script. I'll post immediately i've
tried it.
Jul 19 '05 #9
> I'm not going to be able to try this for a few days. Although, i fear
i've more mistakes than that in my script. I'll post immediately i've
tried it.


For sure you have more mistakes in the script, some more than once,
but I made one also,
the quotes should be in the querie and I assumed that it was used to put the
variable in the string, my mistake!

I looked a little closer over your scripts and made some adjustments, see
below (just the php has been modified)

Be aware that the GET variables you use are only global as of PHP 4.1 or
something in older version this might not be the case.

Good Luck

<?php
$conn=@mysql_connect("localhost", "user_name", "password") or die("could not
connect");
$rs=@mysql_select_db("database_name", $conn) or die("could not connect to
database");
$sql="select * from table_name where";
if(isset($song)) $sql.=" song=\"$song\" and"; // don't forget the spaces
before a new condition
if(isset($folder)) $sql.=" folder=\"$folder\" and";
if(isset($format)) $sql.=" format=\"$format\" and";
if(isset($artist)) $sql.=" artist=\"$artist\" and";

//$sql=ereg_replace("and", "", "$sql"); // see next comment, probably wrong
thinking this replaces each instance of "and" for ""
if(substr($sql, -4 ,4)==" and")$sql=substr($sql, 0 ,-4); // remove last "
and" if any

if(isset($order)) $sql.=" order=\"$order\""; // perhaps the \" should be
removed 2x

$rs=mysql_query($sql, $conn) or die("could not execute query");
$list="<table border=\"1\" cellpadding=\"2\">";
$list.="<tr><th>SONG</th>";
$list.="<th>FOLDER</th>";
$list.="<th>FORMAT</th>";
$list.="<th>ARTIST</th></tr>";
while($row=mysql_fetch_array($rs))
{
$list.="<tr>";
$list.="<td>".$row["song"]."</td>";
$list.="<td>".$row["folder"]."</td>";
$list.="<td>".$row["format"]."</td>";
$list.="<td>".$row["artist"]."</td>";
$list.="</tr>";
}
$list.="</table>";
echo($list);
?>

######LONG FORM#######

<form action="form_name.php" method="GET">

<b>SONG</b><br>
<input type="text" name="song" size="50"><br>
<b>FOLDER</b><br>
<input type="text" name="folder" size="2"><br>
<b>FORMAT</b><br>
<input type="text" name="format" size="20"><br>
<b>ARTIST</b><br>
<input type="text" name="artist" size="40"><br>

The percent sign can be used as a wildcard. You can place it at the
start, end or both ends with appropiate results.<br>

<b>ORDER RESULTS BY;</b><br>
<input type="radio" name="order" value="order by song"
checked><b>SONG</b><br>
<input type="radio" name="order" value="order by
folder"><b>FOLDER</b><br>
<input type="radio" name="order" value="order by
artist"><b>ARTIST</b>&nbsp

<input type="submit" value="SEARCH"><input type="reset"
value="RESET"><br><br>
</form>
Jul 19 '05 #10
> I'm not going to be able to try this for a few days. Although, i fear
i've more mistakes than that in my script. I'll post immediately i've
tried it.


For sure you have more mistakes in the script, some more than once,
but I made one also,
the quotes should be in the querie and I assumed that it was used to put the
variable in the string, my mistake!

I looked a little closer over your scripts and made some adjustments, see
below (just the php has been modified)

Be aware that the GET variables you use are only global as of PHP 4.1 or
something in older version this might not be the case.

Good Luck

<?php
$conn=@mysql_connect("localhost", "user_name", "password") or die("could not
connect");
$rs=@mysql_select_db("database_name", $conn) or die("could not connect to
database");
$sql="select * from table_name where";
if(isset($song)) $sql.=" song=\"$song\" and"; // don't forget the spaces
before a new condition
if(isset($folder)) $sql.=" folder=\"$folder\" and";
if(isset($format)) $sql.=" format=\"$format\" and";
if(isset($artist)) $sql.=" artist=\"$artist\" and";

//$sql=ereg_replace("and", "", "$sql"); // see next comment, probably wrong
thinking this replaces each instance of "and" for ""
if(substr($sql, -4 ,4)==" and")$sql=substr($sql, 0 ,-4); // remove last "
and" if any

if(isset($order)) $sql.=" order=\"$order\""; // perhaps the \" should be
removed 2x

$rs=mysql_query($sql, $conn) or die("could not execute query");
$list="<table border=\"1\" cellpadding=\"2\">";
$list.="<tr><th>SONG</th>";
$list.="<th>FOLDER</th>";
$list.="<th>FORMAT</th>";
$list.="<th>ARTIST</th></tr>";
while($row=mysql_fetch_array($rs))
{
$list.="<tr>";
$list.="<td>".$row["song"]."</td>";
$list.="<td>".$row["folder"]."</td>";
$list.="<td>".$row["format"]."</td>";
$list.="<td>".$row["artist"]."</td>";
$list.="</tr>";
}
$list.="</table>";
echo($list);
?>

######LONG FORM#######

<form action="form_name.php" method="GET">

<b>SONG</b><br>
<input type="text" name="song" size="50"><br>
<b>FOLDER</b><br>
<input type="text" name="folder" size="2"><br>
<b>FORMAT</b><br>
<input type="text" name="format" size="20"><br>
<b>ARTIST</b><br>
<input type="text" name="artist" size="40"><br>

The percent sign can be used as a wildcard. You can place it at the
start, end or both ends with appropiate results.<br>

<b>ORDER RESULTS BY;</b><br>
<input type="radio" name="order" value="order by song"
checked><b>SONG</b><br>
<input type="radio" name="order" value="order by
folder"><b>FOLDER</b><br>
<input type="radio" name="order" value="order by
artist"><b>ARTIST</b>&nbsp

<input type="submit" value="SEARCH"><input type="reset"
value="RESET"><br><br>
</form>
Jul 19 '05 #11
SORTED-
Finally, sorted everything out, especially the long script.
If anyone down the line comes across this posting and it helps them
out, please say so. I'm delighted to have solved the matter after a
horrifically long time.
The two major problems lay where i had realised they were likely to
be. That is, in the necessary use of the 'stripslashes' function.
Also, with just one exception, absolutely no punctuation should be
used in the sql query syntax. I had feared that server
specific/website provider nuances would play a part in the matter. The
only bit that needed it was the Wild-Card part using '%%'.
The form and scripts are detailed below.

######INPUT FORM######

<form method="POST" action="script_name.php">
<b>
<dl>
<dt><font color="#000099">SELECT ALL WHERE </font> <br>
<dd><input type="radio" name="a" value="song" checked><b>SONG</b><br>
<dd><input type="radio" name="a" value="folder"><b>FOLDER</b><br>
<dd><input type="radio" name="a" value="format"><b>FORMAT</b><br>
<dd><input type="radio" name="a" value="artist"><b>ARTIST</b><br><br>

<dt><font color="#000099">LIKE </font><br>
<dd><input type="textarea" name="b" rows="1" cols="50"> <font
color="#ff0000">If you don't know the exact wording, enter what you
know. As the Search employs an automatic Wild-Card
system.</font><br><br>

<dt><font color="#000099">ORDER BY</font> <br>
<dd><input type="radio" name="c" value="song" checked><b>SONG</b><br>
<dd><input type="radio" name="c" value="folder"><b>FOLDER</b><br>
<dd><input type="radio" name="c" value="artist"><b>ARTIST</b><br><br>

<input type="submit" value="SEARCH"><input type="reset" value="RESET">
</form>
######PHP SCRIPT######

<a href="form_name.php">Submit New Search</a>
<?php
$conn=@mysql_connect("localhost", "user", "password") or die("could
not connect");
$rs=@mysql_select_db("database_name", $conn) or die("could not connect
to database");
$sql=stripslashes ("select * from database_name where $a like '%$b%'
order by $c");

$rs=mysql_query($sql, $conn) or die("could not execute query because
".mysql_error());
$list="<table border=\"1\" cellpadding=\"2\">";
$list.="<tr><th>SONG</th>";
$list.="<th>FOLDER</th>";
$list.="<th>FORMAT</th>";
$list.="<th>ARTIST</th></tr>";
while($row=mysql_fetch_array($rs))
{
$list.="<tr>";
$list.="<td>".$row["SONG"]."</td>";
$list.="<td>".$row["FOLDER"]."</td>";
$list.="<td>".$row["FORMAT"]."</td>";
$list.="<td>".$row["ARTIST"]."</td>";
$list.="</tr>";
}
$list.="</table>";
echo($list);
?>
<a href="form_name.php">Submit New Search</a>

I'll be well chuffed if it helps someone else out in the future.
Jul 19 '05 #12
SORTED-
Finally, sorted everything out, especially the long script.
If anyone down the line comes across this posting and it helps them
out, please say so. I'm delighted to have solved the matter after a
horrifically long time.
The two major problems lay where i had realised they were likely to
be. That is, in the necessary use of the 'stripslashes' function.
Also, with just one exception, absolutely no punctuation should be
used in the sql query syntax. I had feared that server
specific/website provider nuances would play a part in the matter. The
only bit that needed it was the Wild-Card part using '%%'.
The form and scripts are detailed below.

######INPUT FORM######

<form method="POST" action="script_name.php">
<b>
<dl>
<dt><font color="#000099">SELECT ALL WHERE </font> <br>
<dd><input type="radio" name="a" value="song" checked><b>SONG</b><br>
<dd><input type="radio" name="a" value="folder"><b>FOLDER</b><br>
<dd><input type="radio" name="a" value="format"><b>FORMAT</b><br>
<dd><input type="radio" name="a" value="artist"><b>ARTIST</b><br><br>

<dt><font color="#000099">LIKE </font><br>
<dd><input type="textarea" name="b" rows="1" cols="50"> <font
color="#ff0000">If you don't know the exact wording, enter what you
know. As the Search employs an automatic Wild-Card
system.</font><br><br>

<dt><font color="#000099">ORDER BY</font> <br>
<dd><input type="radio" name="c" value="song" checked><b>SONG</b><br>
<dd><input type="radio" name="c" value="folder"><b>FOLDER</b><br>
<dd><input type="radio" name="c" value="artist"><b>ARTIST</b><br><br>

<input type="submit" value="SEARCH"><input type="reset" value="RESET">
</form>
######PHP SCRIPT######

<a href="form_name.php">Submit New Search</a>
<?php
$conn=@mysql_connect("localhost", "user", "password") or die("could
not connect");
$rs=@mysql_select_db("database_name", $conn) or die("could not connect
to database");
$sql=stripslashes ("select * from database_name where $a like '%$b%'
order by $c");

$rs=mysql_query($sql, $conn) or die("could not execute query because
".mysql_error());
$list="<table border=\"1\" cellpadding=\"2\">";
$list.="<tr><th>SONG</th>";
$list.="<th>FOLDER</th>";
$list.="<th>FORMAT</th>";
$list.="<th>ARTIST</th></tr>";
while($row=mysql_fetch_array($rs))
{
$list.="<tr>";
$list.="<td>".$row["SONG"]."</td>";
$list.="<td>".$row["FOLDER"]."</td>";
$list.="<td>".$row["FORMAT"]."</td>";
$list.="<td>".$row["ARTIST"]."</td>";
$list.="</tr>";
}
$list.="</table>";
echo($list);
?>
<a href="form_name.php">Submit New Search</a>

I'll be well chuffed if it helps someone else out in the future.
Jul 19 '05 #13
Updated Form to include instant A-Z, with simple HTML and 3 copies of
the PHP script;
<form method="POST" action="artist_script.php">
<center>ARTIST A-Z</center>
<input type="radio" name="aaz" value="A">A
<input type="radio" name="aaz" value="B">B
<input type="radio" name="aaz" value="C">C
<input type="radio" name="aaz" value="D">D
<input type="radio" name="aaz" value="E">E
<input type="radio" name="aaz" value="F">F
<input type="radio" name="aaz" value="G">G
<input type="radio" name="aaz" value="H">H
<input type="radio" name="aaz" value="I">I
<input type="radio" name="aaz" value="J">J
<input type="radio" name="aaz" value="K">K
<input type="radio" name="aaz" value="L">L
<input type="radio" name="aaz" value="M">M
<input type="radio" name="aaz" value="N">N
<input type="radio" name="aaz" value="O">O
<input type="radio" name="aaz" value="P">P
<input type="radio" name="aaz" value="Q">Q
<input type="radio" name="aaz" value="R">R
<input type="radio" name="aaz" value="S">S
<input type="radio" name="aaz" value="T">T
<input type="radio" name="aaz" value="U">U
<input type="radio" name="aaz" value="V">V
<input type="radio" name="aaz" value="W">W
<input type="radio" name="aaz" value="X">X
<input type="radio" name="aaz" value="Y">Y
<input type="radio" name="aaz" value="Z">Z
<input type="radio" name="aaz" value="0-9">0-9<br><br>
<input type="submit" value="SEARCH"><input type="reset" value="RESET">
</form>
<form method="POST" action="folder_script.php">
<center>FOLDER A-Z</center>
<input type="radio" name="faz" value="A">A
<input type="radio" name="faz" value="B">B
<input type="radio" name="faz" value="C">C
<input type="radio" name="faz" value="D">D
<input type="radio" name="faz" value="E">E
<input type="radio" name="faz" value="F">F
<input type="radio" name="faz" value="G">G
<input type="radio" name="faz" value="H">H
<input type="radio" name="faz" value="I">I
<input type="radio" name="faz" value="J">J
<input type="radio" name="faz" value="K">K
<input type="radio" name="faz" value="L">L
<input type="radio" name="faz" value="M">M
<input type="radio" name="faz" value="N">N
<input type="radio" name="faz" value="O">O
<input type="radio" name="faz" value="P">P
<input type="radio" name="faz" value="Q">Q
<input type="radio" name="faz" value="R">R
<input type="radio" name="faz" value="S">S
<input type="radio" name="faz" value="T">T
<input type="radio" name="faz" value="U">U
<input type="radio" name="faz" value="V">V
<input type="radio" name="faz" value="W">W
<input type="radio" name="faz" value="X">X
<input type="radio" name="faz" value="Y">Y
<input type="radio" name="faz" value="Z">Z
<input type="radio" name="faz" value="0-9">0-9<br><br>
<input type="submit" value="SEARCH"><input type="reset" value="RESET">
</form>
<form method="POST" action="song_script.php">
<center>SONG A-Z</center>
<input type="radio" name="saz" value="A">A
<input type="radio" name="saz" value="B">B
<input type="radio" name="saz" value="C">C
<input type="radio" name="saz" value="D">D
<input type="radio" name="saz" value="E">E
<input type="radio" name="saz" value="F">F
<input type="radio" name="saz" value="G">G
<input type="radio" name="saz" value="H">H
<input type="radio" name="saz" value="I">I
<input type="radio" name="saz" value="J">J
<input type="radio" name="saz" value="K">K
<input type="radio" name="saz" value="L">L
<input type="radio" name="saz" value="M">M
<input type="radio" name="saz" value="N">N
<input type="radio" name="saz" value="O">O
<input type="radio" name="saz" value="P">P
<input type="radio" name="saz" value="Q">Q
<input type="radio" name="saz" value="R">R
<input type="radio" name="saz" value="S">S
<input type="radio" name="saz" value="T">T
<input type="radio" name="saz" value="U">U
<input type="radio" name="saz" value="V">V
<input type="radio" name="saz" value="W">W
<input type="radio" name="saz" value="X">X
<input type="radio" name="saz" value="Y">Y
<input type="radio" name="saz" value="Z">Z
<input type="radio" name="saz" value="0-9">0-9<br><br>
<input type="submit" value="SEARCH"><input type="reset" value="RESET">
</form>
Jul 19 '05 #14
Updated Form to include instant A-Z, with simple HTML and 3 copies of
the PHP script;
<form method="POST" action="artist_script.php">
<center>ARTIST A-Z</center>
<input type="radio" name="aaz" value="A">A
<input type="radio" name="aaz" value="B">B
<input type="radio" name="aaz" value="C">C
<input type="radio" name="aaz" value="D">D
<input type="radio" name="aaz" value="E">E
<input type="radio" name="aaz" value="F">F
<input type="radio" name="aaz" value="G">G
<input type="radio" name="aaz" value="H">H
<input type="radio" name="aaz" value="I">I
<input type="radio" name="aaz" value="J">J
<input type="radio" name="aaz" value="K">K
<input type="radio" name="aaz" value="L">L
<input type="radio" name="aaz" value="M">M
<input type="radio" name="aaz" value="N">N
<input type="radio" name="aaz" value="O">O
<input type="radio" name="aaz" value="P">P
<input type="radio" name="aaz" value="Q">Q
<input type="radio" name="aaz" value="R">R
<input type="radio" name="aaz" value="S">S
<input type="radio" name="aaz" value="T">T
<input type="radio" name="aaz" value="U">U
<input type="radio" name="aaz" value="V">V
<input type="radio" name="aaz" value="W">W
<input type="radio" name="aaz" value="X">X
<input type="radio" name="aaz" value="Y">Y
<input type="radio" name="aaz" value="Z">Z
<input type="radio" name="aaz" value="0-9">0-9<br><br>
<input type="submit" value="SEARCH"><input type="reset" value="RESET">
</form>
<form method="POST" action="folder_script.php">
<center>FOLDER A-Z</center>
<input type="radio" name="faz" value="A">A
<input type="radio" name="faz" value="B">B
<input type="radio" name="faz" value="C">C
<input type="radio" name="faz" value="D">D
<input type="radio" name="faz" value="E">E
<input type="radio" name="faz" value="F">F
<input type="radio" name="faz" value="G">G
<input type="radio" name="faz" value="H">H
<input type="radio" name="faz" value="I">I
<input type="radio" name="faz" value="J">J
<input type="radio" name="faz" value="K">K
<input type="radio" name="faz" value="L">L
<input type="radio" name="faz" value="M">M
<input type="radio" name="faz" value="N">N
<input type="radio" name="faz" value="O">O
<input type="radio" name="faz" value="P">P
<input type="radio" name="faz" value="Q">Q
<input type="radio" name="faz" value="R">R
<input type="radio" name="faz" value="S">S
<input type="radio" name="faz" value="T">T
<input type="radio" name="faz" value="U">U
<input type="radio" name="faz" value="V">V
<input type="radio" name="faz" value="W">W
<input type="radio" name="faz" value="X">X
<input type="radio" name="faz" value="Y">Y
<input type="radio" name="faz" value="Z">Z
<input type="radio" name="faz" value="0-9">0-9<br><br>
<input type="submit" value="SEARCH"><input type="reset" value="RESET">
</form>
<form method="POST" action="song_script.php">
<center>SONG A-Z</center>
<input type="radio" name="saz" value="A">A
<input type="radio" name="saz" value="B">B
<input type="radio" name="saz" value="C">C
<input type="radio" name="saz" value="D">D
<input type="radio" name="saz" value="E">E
<input type="radio" name="saz" value="F">F
<input type="radio" name="saz" value="G">G
<input type="radio" name="saz" value="H">H
<input type="radio" name="saz" value="I">I
<input type="radio" name="saz" value="J">J
<input type="radio" name="saz" value="K">K
<input type="radio" name="saz" value="L">L
<input type="radio" name="saz" value="M">M
<input type="radio" name="saz" value="N">N
<input type="radio" name="saz" value="O">O
<input type="radio" name="saz" value="P">P
<input type="radio" name="saz" value="Q">Q
<input type="radio" name="saz" value="R">R
<input type="radio" name="saz" value="S">S
<input type="radio" name="saz" value="T">T
<input type="radio" name="saz" value="U">U
<input type="radio" name="saz" value="V">V
<input type="radio" name="saz" value="W">W
<input type="radio" name="saz" value="X">X
<input type="radio" name="saz" value="Y">Y
<input type="radio" name="saz" value="Z">Z
<input type="radio" name="saz" value="0-9">0-9<br><br>
<input type="submit" value="SEARCH"><input type="reset" value="RESET">
</form>
Jul 19 '05 #15
After using the Database over a period of time. I came across
performance glitches. Not least, that i no longer had the ability to
put forward more complex queries involving several fields, than
provided for at present.
However, if anyone in the future comes across the same type of
problems. Just reply to this posting and i'll post the scripts
necessary.
Everything on the Database and interacting page is perfectly tailored
to my needs and working as desired.
When i get the time, i will post ALL the scripts and forms involved,
in a single post.
Jul 19 '05 #16
After using the Database over a period of time. I came across
performance glitches. Not least, that i no longer had the ability to
put forward more complex queries involving several fields, than
provided for at present.
However, if anyone in the future comes across the same type of
problems. Just reply to this posting and i'll post the scripts
necessary.
Everything on the Database and interacting page is perfectly tailored
to my needs and working as desired.
When i get the time, i will post ALL the scripts and forms involved,
in a single post.
Jul 19 '05 #17
i.*******@onmail.co.uk (ian justice) wrote in message news:<f6**************************@posting.google. com>...
After using the Database over a period of time. I came across
performance glitches. Not least, that i no longer had the ability to
put forward more complex queries involving several fields, than
provided for at present.
However, if anyone in the future comes across the same type of
problems. Just reply to this posting and i'll post the scripts
necessary.

I guess that's as clear as mud !. To clarify, i am now able to sucessfully
enter complex queries with my updated scripts.
Jul 19 '05 #18
i.*******@onmail.co.uk (ian justice) wrote in message news:<f6**************************@posting.google. com>...
After using the Database over a period of time. I came across
performance glitches. Not least, that i no longer had the ability to
put forward more complex queries involving several fields, than
provided for at present.
However, if anyone in the future comes across the same type of
problems. Just reply to this posting and i'll post the scripts
necessary.

I guess that's as clear as mud !. To clarify, i am now able to sucessfully
enter complex queries with my updated scripts.
Jul 19 '05 #19

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

23 posts views Thread by ian justice | last post: by
2 posts views Thread by ian justice | last post: by
16 posts views Thread by Steven T. Hatton | last post: by
3 posts views Thread by Tcs | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
xarzu
2 posts views Thread by xarzu | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.