473,322 Members | 1,690 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

'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 2871
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

23
by: ian justice | last post by:
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...
14
by: CJM | last post by:
I have a query which produces different results in the Access query builder and in an ASP page (via ADO) An example of the query is: ----------------------------------------------------------...
2
by: ian justice | last post by:
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...
1
by: DrTebi | last post by:
Hello, I have the following problem: I used to "encode" my email address within links, in order to avoid (most) email spiders. So I had a link like this: <a...
16
by: Steven T. Hatton | last post by:
In the following code, the only way I can figure out to pass an array of const is by setting the template argument to const in the instanciation expression. It would be (or seem to me) better if I...
3
by: Tcs | last post by:
My backend is DB2 on our AS/400. While I do HAVE DB2 PE for my PC, I haven't loaded it yet. I'm still using MS Access. And no, I don't believe this is an Access question. (But who knows? I...
17
by: orekinbck | last post by:
Hi There Say I want to check if object1.Property1 is equal to a value, but object1 could be null. At the moment I have code like this: if (object1 != null) { if (object1.Property ==...
3
by: orekinbck | last post by:
Hi There Our test database has duplicate data: COMPANYID COMPANYNAME 1 Grupple Group 2 Grupple Group 5 Grupple Group 3 Yada Inc 4 Yada...
48
by: Jimmy | last post by:
thanks to everyone that helped, unfortunately the code samples people gave me don't work. here is what i have so far: <% Dim oConn, oRS, randNum Randomize() randNum = (CInt(1000 * Rnd) + 1) *...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.