How should i capture an id

**TobiaZ** · 14.06.2003, 20:48

should it be like this:

PHP-Code:


echo 'openWindow('contact_form.php?id=$row[id]','','toolbar=no,status=no','724','470','true');">Contact the Person</a>';

**minds_gifts** · 14.06.2003, 21:27

Hallo Tobiaz,

Sorry thats does'nt even help me.The profile id does'nt get inserted.Do you want me to post the code of all the 3 forms??I dont have any problems with my forms other than this id.

Thanks

**TobiaZ** · 14.06.2003, 21:31

i think, the problem is, that the id isnt available at your contactform. and for that you have to submit it in the URL. like i posted.

NOTE: You have to edit the line i postet, because i can't know how your variable with the id is called.

so please change it to the right name, or perhaps post the code of the first (list) page

**minds_gifts** · 14.06.2003, 21:43

Tobiaz,

Heres the code of the page (ess.php) which displays all the profiles:

PHP-Code:


<html> 

<head>

<link REL=stylesheet href="mystyle.css" TYPE="text/css">

<script type="text/javascript">



function open_phone_number_window(number)

{

    window_html_code = "<html>";

    window_html_code += "<head><title>Phone number</title></head>";

    window_html_code += "<body>";

    window_html_code += "<table width=\"100%\" height=\"100%\">";

    window_html_code += "<tr><td valign=\"middle\" align=\"center\">";

    window_html_code += number;

    window_html_code += "<br>";

    window_html_code += "<a href=\"javascript:window.close();\">close window</a>";

    window_html_code += "</td></tr></table>";

    window_html_code += "</body>";

    window_html_code += "</html>";

    

    win = window.open("","win","top=100,left=200,width=225,height=100");

    win.document.write(window_html_code);

}



</script>



<script type="text/javascript"> 



function openWindow(theURL,winName,features, myWidth, myHeight, isCenter) { 

if(window.screen)if(isCenter)if(isCenter=="true"){ 

var myLeft = (screen.width-myWidth)/2; 

var myTop = (screen.height-myHeight)/2; 

features+=(features!='')?',':''; 

features+=',left='+myLeft+',top='+myTop; 

} 

window.open(theURL,winName,features+((features!='')?',':'')+'width='+myWidth+',height='+myHeight); 

} 



</script> 



</head>



<body bgcolor="#FFFFCC"> 

<?php 



// Lets create MySQL connection 



// Lets select the database 



// Lets select the record fields from our database table and check for results 



    $query="SELECT introtext,zipcode,image,telephone,description FROM tbl_personals ORDER BY id"; 



    $numresults=mysql_query($query,$connection); 

    $numrows=mysql_num_rows($numresults); 



// get results



  $result = mysql_query($query) or die("Couldn't execute query");



// We carry out the table population using a 'while' loop 



while ($row=mysql_fetch_array($result)) 

{ 

$var_7=$row["id"];

$var_1=$row["introtext"]; 

$var_2=$row["zipcode"]; 

$var_3=$row["image"]; 

$var_4=$row["telephone"]; 

$var_6=$row["description"]; 



// Display the results 



echo '<table width="80%">';

echo '<tr>';

echo '<td width="100%" colspan="2"><b>'.$var_1.'</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

'.$var_7.'';

echo '</td> 

  </tr>';

echo '<tr>

    <td width="50%">Zip Code:'.$var_2.'</td>

    <td width="50%" rowspan="4" bordercolorlight="#C0C0C0" bordercolordark="#C0C0C0">'.$var_6.'</td>

  </tr>';

echo '<tr>

    <td width="50%"><img src="'.$var_3.'"></td>

      </tr>';

echo '<tr>';

echo '<td width="50%">';

echo '<a href="javascript:';

echo 'open_phone_number_window(\''.$row['telephone'].'\');">Telephone number</a>';

echo '</td>';

echo '</tr>';

echo '<tr>';

echo '<td width="50%">';

echo '<a href="javascript:';

echo 'openWindow(\'contact_form.php?id=$row[id]\',\'\',\'toolbar=no,status=no\',\'724\',\'470\',\'true\');">Contact the Person</a>'; 

echo '</tr>';

echo '</table>

&nbsp';



} 



//We close the MySQL connection 



    mysql_close($connection); 



?> 



</TABLE> 

</body> 

</html>

**TobiaZ** · 14.06.2003, 21:45

you should use the right queries:

$query="SELECT introtext,zipcode,image,telephone,description FROM tbl_personals ORDER BY id";

schould be

$query="SELECT id,introtext,zipcode,image,telephone,description FROM tbl_personals ORDER BY id";

**minds_gifts** · 14.06.2003, 22:00

Sorry Tobiaz.My code was messed up and i did something wrong.

well, mysql query in the code contains id field actually.That has'nt even helped me though:-(

Any other ideas??

Thanks for your time.

**TobiaZ** · 14.06.2003, 22:20

try to use $var_6 in the url.

btw. please output the ID in your onlineversion whith each entry, please.

**minds_gifts** · 14.06.2003, 22:52

Tobiaz,
Sounds really weird.what-ever changes i do, it does'nt help me, gosh!!

btw. please output the ID in your onlineversion whith each entry, please.

I dont get you, my on-line version is the latest code i have.I dont think $var_6 is going to help me, because that is nothing related with my id field.or do you mean something like this:

PHP-Code:


echo 'openWindow(\'contact_form.php?id=$var_7\',\'\',\'toolbar=no,status=no\',\'724\',\'470\',\'true\');">Contact the Person</a>';

Thanks once again

**TobiaZ** · 14.06.2003, 22:56

as you know, this is an entry;

BrownEyedGrrrl 1
Zip Code:67663

Hello to all ... to you soon

Telephone number
Contact the Person

i think the 1 is from a counter?

so then, could you please output the ID next to the Name (Brown Eyed Gril)

**minds_gifts** · 14.06.2003, 23:08

oh NO, you mis-understood me.

BrownEyedGrrrl 1

1 is not from the counter.It is the id field in the table.That is the very first record.Well,I'm using this id as my profile id.

I hope this was a confusion right from the beginning.

Thanks once again.

**TobiaZ** · 14.06.2003, 23:15

thats wunderful!!!!

so we have no problems anymore!

so i supose $var_7 is your id, as it stands in your code. did you test this, because you posted this solution some posts ago.

**minds_gifts** · 14.06.2003, 23:37

hmm...NO way!
Sounds like a nightmare for me,huh!
I dont see any improvements with my code.yep, this is the one which i've it :

PHP-Code:


echo 'openWindow(\'contact_form.php?id=$var_7\',\'\',\'toolbar=no,status=no\',\'724\',\'470\',\'true\');">Contact the Person</a>';

and dont you think when i right-click and view the source i should be able to see the id value, that is, if its first profile, i guess i should see 1.BUt, i dont see such.so, theres a problem which is killing me-I'm going blind.

Thanks for your valuable time.

**TobiaZ** · 14.06.2003, 23:42

so try to use " instead of ' for the echo. because in ' no variables are parsed.

**minds_gifts** · 14.06.2003, 23:57

Tobiaz,

I cant belive!I can see the id passing out but, something strange happened.Dont you think this is the right way of coding?

echo '<a href="javascript:';
echo "openWindow('contact_form.php?id=$var_7','','toolbar=no,status=no','724','470','true');'>Contact the Person</a>";

If you see my on-line page, you can visualise what has happened now?

thanks

How should i capture an id