Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem with a Script!

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Jan 1, 1970
0
This script will read 4 pictures from a MySql-Database. When I`m click on a picture, I only see a

blanc site. How is the bug? (Sorry for my english, I am from germany).

<?php
require(&quot;config.php&quot;);
?>

<HTML>
<HEAD>
</HEAD>
<BODY>

<?php
mysql_connect(&quot;$host&quot;,&quot;$user&quot;,&quot;$pass&quot;);
mysql_select_db(&quot;$database&quot;);
$result = mysql_query(&quot;select * from products where(objekt_nr = '$objekt_nr') ORDER BY

'objekt_nr'&quot;);

$i = 0;

while($row = mysql_fetch_row($result)) {

$bild = array(1 => &quot;images/$row[26]&quot;,&quot;images/$row[27]&quot;,&quot;images/$row[28]&quot;,&quot;images/$row[29]&quot;);
$thumbs = array(1 => &quot;images/$row[26]&quot;,&quot;images/$row[27]&quot;,&quot;images/$row[28]&quot;,&quot;images/$row[29]&quot;);
if (!$gross) {
$gross = 1;
$klein1 = 2;
$klein2 = 3;
$klein3 = 4;
$klein4 = 1; }

echo &quot;<Table border=1>
<TR><TD align=\&quot;left\&quot; valign=\&quot;top\&quot;>
<img src=\&quot;$bild[$gross]\&quot; width=250><BR>
<a href=\&quot;$PHPSELF?klein1=$gross&gross=$klein1&klein2=$klein2&klein3=$klein3\&quot;><img

src=\&quot;$thumbs[$klein1]\&quot; border=0 width=80></a>
<a href=\&quot;$PHPSELF?klein2=$gross&gross=$klein2&klein1=$klein1&klein3=$klein3\&quot;><img

src=\&quot;$thumbs[$klein2] \&quot; border=0 width=80></a>
<a href=\&quot;$PHPSELF?klein3=$gross&gross=$klein3&klein1=$klein1&klein2=$klein2\&quot;><img

src=\&quot;$thumbs[$klein3]\&quot; border=0 width=80></a>
<P></table>&quot;;
}

?>

</BODY>
</HTML>
 
Sort by date Sort by votes
hello

check this

<a href=\&quot;$PHPSELF?klein1=$gross&gross=$klein1&klein2=$klein2&klein3=$klein3\&quot;>

do u mean predefined variable $PHP_SELF here.
it links to the same php script

cheers
spookie
 
Upvote 0 Downvote
Hello Spookie,
thank`s for your answer, but this was not the bug.

Thomas
 
Upvote 0 Downvote
$gross = 1;
$klein1 = 2;

$PHPSELF?klein1=$gross&gross=$klein1
translated form variables as listed above.
$PHP_SELF?klein1=1($gross)//you already told it its 2
and then gross=klein1 which was 2 but you told it now its 1 so make your mind up ;) ***************************************
Party on, dudes!
[cannon]
 
Upvote 0 Downvote
Das hat leider auch nicht geholfen. Ich werde dieses Problem wahrscheinlich in diesem Leben nicht mehr lösen können.
Trotzdem danke für die Versuche mir zu helfen!
Thomas
 
Upvote 0 Downvote
Das hat leider auch nicht geholfen. Ich werde dieses Problem wahrscheinlich in diesem Leben nicht mehr lösen können.
Trotzdem danke für die Versuche mir zu helfen!
Thomas
 
Upvote 0 Downvote
well ... my German is not that good, can anyone translate, please? Anikin
Hugo Alexandre Dias
Web-Programmer
anikin_jedi@hotmail.com
 
Upvote 0 Downvote
Thats exaclty what I asked on another forum... I got this reply :

Det hjälpte tyvärr inte heller. Jag kan aldrig i detta liv lösa detta problem.
Trots det tackar jag för dit försök att hjälpa mig !

:)
Still waiting for english translation .... ***************************************
Party on, dudes!
[cannon]
 
Upvote 0 Downvote
So it said:

That did not unfortunately also help. I will not be able to solve this problem probably in this life no more. Nevertheless thanks me for the attempts to help! ***************************************
Party on, dudes!
[cannon]
 
Upvote 0 Downvote
Theres also this change :
$result = mysql_query(&quot;select * from products where objekt_nr = '$objekt_nr' ORDER BY 'objekt_nr'&quot;);
***************************************
Party on, dudes!
[cannon]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

P
  • Locked
  • Question
JPgraph - How to stop a line graph from dropping to zero?
Replies
2
Views
364
Chris Miller
Chris Miller
sugram
  • Locked
  • Question
how start a second shell script
Replies
0
Views
112
sugram
sugram
EdLentz
  • Locked
  • Question
I need a simple example of how to send a table of info .
Replies
8
Views
404
EdLentz
EdLentz
Wand850
  • Locked
  • Question
Parsing XML with multiple namespaces using PHP
Replies
3
Views
223
spamjim
spamjim
R
  • Question
How Can I Use MySQL To Send Data To An Email
Replies
1
Views
248
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top