MySql Problem

[DigitalExpl0it]

Well Im having a little trouble with this, Ive converted my access database to a mysql database and now im converting asp script to php.

Everything is working but two things

one is the url, I cannot send variables thru a url string, very weird. This is on IIS with PHP 4.2.3

now the next thing is, trying to take a record form the database and put it in a LIKE statement

$test = addslashes("Alberto Martinez\\2002 Digital photos\\Eastvale Line E 5-1-2002");
$test2 = "Alberto Martinez\2002 Digital photos\Eastvale Line E 5-1-2002";
$test2 = ereg_replace("€1", "\\2001 ", $test2);
$test2 = ereg_replace("€2", "\\2001 ", $test2);
$test2 = addslashes($test2, $test2);
$connect = mysql_connect("localhost", "root", "") or die ("Couldnt connect");
$db = mysql_select_db("Photos", $connect) or die ("Couldnt open Database");
$sql = "select * from photos WHERE PhotoLocation = '$test' Order by Photoid ASC LIMIT 0,24";
$sql_result = mysql_query($sql, $connect) or die ("Access Denied!");

echo "<center>Location: $test2<br>$test</center><br>";
while ($row = mysql_fetch_array($sql_result)){
 $rs_fld1 = $row["PhotoName"];
$rs_fld2 = $row["PhotoLocation"];
$rs_fld3 = $row["PhotoThumbnail"];
}

now i have added $test2 as a phonny record from the database

the problem is the \

If I use $test in the LIKE string it works. But If I use the $test2 it comes up with a blank screen

another thing, I keep getting this from $test2 €

this is a real record thats in the databse already

$test2 = "Alberto Martinez\2002 Digital photos\Eastvale Line E 5-1-2002";

any ideas

[DigitalExpl0it]

oops my mistake

after I used

$_REQUEST[test2]

that worked fine weird (thru url string)

[DigitalExpl0it]

ok now its working, though

im adding a next/prev to it

and now each screen its adding more \

example

Alberto Martinez\\2002 Digital photos\\Eastvale Line E 5-1-2002 

to

Alberto Martinez\\\\2002 Digital photos\\\\Eastvale Line E 5-1-2002 

how do I make it so its

Alberto Martinez\2002 Digital photos\Eastvale Line E 5-1-2002

all the time

the url string well be this

Alberto Martinez\2002 Digital photos\Eastvale Line E 5-1-2002

then when its in the LIKE statement its
Alberto Martinez\2002 Digital photos\Eastvale Line E 5-1-2002

then the next page from prev/next

its

Alberto Martinez\\2002 Digital photos\\Eastvale Line E 5-1-2002

[DigitalExpl0it]

if this helps here is the code

<?
	if ($offset == "" and $onset == "") {
	  $offset = "10";
	  $onset = "0";
	}
//echo "$onset/$offset | $onset2/$offset2";
$offset2 = $offset + 11;
$onset2 = $offset - 11;
	if ($onset2 < 0) {
	  $onset2 = "0";
	}
$test = addslashes("Alberto Martinez\\2002 Digital photos\\Eastvale Line E 5-1-2002");
//$test2 = "Alberto Martinez\2002 Digital photos\Eastvale Line E 5-1-2002";
$test4 = $_REQUEST[test3];
		$connect = mysql_connect("localhost", "root", "") or die ("Couldnt connect");
		$db = mysql_select_db("Photos", $connect) or die ("Couldnt open Database");
		$sql = "select * from photos WHERE PhotoLocation = '$_REQUEST[test3]' Order by Photoid ASC LIMIT $onset,24";
		$sql_result = mysql_query($sql, $connect) or die ("Access Denied!");
		$count = mysql_num_rows($sql_result);
$half = ceil($count*0.5);
echo "<center>Location: $test4 <br>$test</center><br>";
//echo "$onset/$offset | $onset2/$offset2";
?>
<table width="640" border=0 align="center" cellpadding="0" cellspacing="6">
  <?
$i = 1;
?>
  <tr>
<?
	while ($row = mysql_fetch_array($sql_result)){
		$rs_fld1 = $row["PhotoName"];
		$rs_fld2 = $row["PhotoLocation"];
		$rs_fld3 = $row["PhotoThumbnail"];
	if ($i == 7) {
	   $i = 1;
?>
</tr><tr>
<?
	 }
?>
<td align="center" valign="middle" width="100%">
<? 
if ($rs_fld1 == "HomeLand.zip" or $rs_fld1 == "Homeland MDP 1.zip" or $rs_fld1 == "Homeland MDP 2.zip") {
	echo "<a href='$rs_fld2\\$rs_fld1'><img src='../common/zipfile.jpg' width='100' height='100'><br><font size='2'>$rs_fld1</font></a>"; 
} else {
	echo "<a href='$rs_fld2\\$rs_fld1'><img src='$rs_fld3' width='100' height='100'><br><font size='2'>$rs_fld1</font></a>"; 
}
?>
</td>
<?
	 $i++;
	}
?>
</tr></table>
<?
if ($rs_fld1 == "") {
	echo "No more Data<br><a href='view.php'>Home</a><br>";
} else {
?>
<A HREF="view.php?&test3=<? echo $_REQUEST[test3]; ?>&onset=<? echo "$onset2"; ?>&offset=<? echo "$offset2"; ?>">Next</A>&nbsp;&nbsp;<A href='view.php'>Home</A>
<?
}
?>