[mivec]

hi all,
i am not sure if this syntax is correct for the following page where it is called..the value was not passed. here is the code.

PHP Code:

<td width="82%"><font face="Arial, Helvetica, sans-serif" size="2" color="#104071"><a href="photoUpload.php?mode=list&username="'.$_POST["txtUserID"].'"">-Upload New Photo</a></font></td> 

and the other page calling the $_POST value is:

PHP Code:

 $sql = "SELECT * FROM tblgallery WHERE username = ' " . $_GET["username"] . " ' ";
   $rs = mysql_query($sql);
   $nRows = mysql_num_rows($rs); 

could someone pls help?i dunno if it's syntax error at the a href area or i can't use that kinda way to call it. there are no forms included here as u can see...thank you

[the_mole001]

Hello mivec,

I think your problem is in your href:

You have:
<a href="photoUpload.php?mode=list&username="'.$_POST["txtUserID"].'"">

However I think you want:
<a href="photoUpload.php?mode=list&username=".$_POST["txtUserID"]."">

Note i removed 2 ' s from where u were inserting the $_POST variable. I think instead of sedning a desired number such as 1 it was send '1' which the db might now of been able to find, returning no results.

Peter

[NeverMind]

how many times do I have to answer this ? (j/k)
as I said before ... remove the last double quote in the href tag .. to this:

PHP Code:

echo'<td width="82%"><font face="Arial, Helvetica, sans-serif" size="2" color="#104071"><a href="photoUpload.php?mode=list&username='.$_POST['txtUserID'].'">-Upload New Photo</a></font></td>'; 

but if you were using quoble quotes from the begining of the printing process you need to escape them !

PHP Code:

echo"<td width=\"82%\"><font face=\"Arial, Helvetica, sans-serif\" size=\"2\" color=\"#104071\"><a href=\"photoUpload.php?mode=list&username=".$_POST['txtUserID']."\">-Upload New Photo</a></font></td>"; 

and in your sql query, don't put spaces before and after the variable value !

PHP Code:

$sql = "SELECT * FROM tblgallery WHERE username='{$_GET['username']}'"; 

this one should work .. just don't open with double quotes and attempt to close it with single quotes !!
and note that you are using GET not POST !!

[mivec]

thanks for the reply...sometimes i get confused about the double quotes and the single quotes on when or how to use them.....so sorry ler.but anyway..i have tried ur ways but it didn't work too...mebbe i should try posting u the whole thing. here it is:

PHP Code:

echo('<tr bgcolor="#FEDCED"> 
          <td width="12%">&nbsp;</td>
          <td width="6%">&nbsp;</td>
          <td width="82%"><font face="Arial, Helvetica, sans-serif" size="2" color="#104071"><a href="photoUpload.php?mode=list&username="'.$_POST["txtUserID"].'"">-Upload New Photo</a></font></td>'); 
    </tr> 

the sql query remains the same. tried ur way but didn't work...