Can anyone here see anything wrong with this, it shows Pics that are in my database, (connection not shown), it shows different pics on a different page for different people, the $person is the persons name that is shown in the url like show.php?find=Erik, the only problem is is that it only shows Eriks, and will not show anyone elses. Anyone got any ideas
| Code: |
$row = mysql_fetch_array($result);
extract($row);
if (@$_GET["find"] == $person)
{
$per_row = 4;
echo "$person";
$result2 = mysql_query("SELECT pic,person FROM pics WHERE person='$person'");
for ($i=1; $i<mysql_num_rows($result2); $i++)
{
$pic2 = mysql_result($result2,($i-1));
echo "<td align='center'><img src='$pic2'></td>";
if ($i%$per_row == 0)
echo "</tr><tr>";
}
}
else {
echo "<font face='Verdana, Arial, Helvetica, sans-serif' size='2'>Sorry no pics found</font>";
}
|
Glancing over very briefly...
if you are getting the error
'Sorry no pics found'
I suggest you go through the script and find where $person is. My guess is that somewhere you have $person=Erick or something similar.
If thats not it I'll have a deeper look when I can.
Matt
Sorry I meant to say that, the extract($row); bit is where it takes $row(which is the only part of the MySQL connection shown) and turns all its content into variables
( just for me ) line 3 : @ before a variable, I've never seen that. does the expression $_GET['smtg'] return an error if smtg doesn't exist ?
The @ gets the ?find=$person from the URL
mmmh, a simple $_GET[' '] without @ does the same, so, what is the @ used for ?
Hmm It does......, still didn't fix it tho, it only shows the first persons who has pics in my database
SELECT pic,person FROM pics WHERE person='$person'
You will only select pics from one person, because $_GET['find'] contains only one name.
if you want to select all pics in one time, then
SELECT pic,person FROM pics
When the url is online its like show.php?find=Erik or show.php?find=kv007, and when I take it away it shows all the pics from all the different people, have you got a MSN?
