Write Forums

$_GET problem

Posted on 16th Feb 2014 07:03 pm by admin

Hi all,

Have a bit of a problem with a little piece of code, I am not sure if this should be under php or ajax as I am not sure where the problem lies. Basically here is the script:

Code: [Select]while($row = mysql_fetch_assoc($query))
{
echo "<center><tr><td style='color:#00F' align='center'>";
echo "<a href='./pages/stockpage.php?id=";
echo $row["stock_id"];
echo "' title='Contact Us' onclick='Modalbox.show(this.href, {title: this.title, width: 600}); return false;'>";
echo $row['stock_name'];
echo "</a></td><td align='center'>";
echo $row['t_val'];
echo "</td><td align='center'>";
echo $row['quant'];
echo "</td><td align='center' style='color:#00F'>";
echo $row['TotValue'];
echo "</td><td>buttonhere</td></tr>";

$TotValue += $row['TotValue'];
}
All this does is display info from the database, the problem I have is with the link. If I put my mouse over the link before clicking I get the correct url, ie http://localhost/stockluck/pages/stockpage.php?id=0.

The link is meant to open in a modalbox ajax popup, this is the code for stockpage is as follows:
Code: [Select]<?php
include('../common/dbconnect.php');

$stock_id = $_GET['stock_id'];
$query="SELECT * FROM stocks WHERE stock_id='$stock_id'"
or die(mysql_error());
while($row = mysql_fetch_assoc($query))
{
echo $row['stock_name'];
}
?>

However, the value for $stock_id is coming back as undefined. Any ideas what is causing this?

Thanks

No comments posted yet

200 34 Tweet

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
Can php detect connection speed and thereafter swap out elements? 
No code to post, lads, yet. Just looking for a yay or nay at this stage:

Can a php script be 
please, need help coding this voting for your favorite car polling system. 
hi, my code needs a lot of work, but i want to be able to let users vote on their favorite car, upda
Connection Timeout 
I'm using xmii 12.0



I'm calling a transaction as a web service from a windows application
Change Web page language 
i doing this thing first time but i dont find any suitable solution for it. On the demand of user. I
Socket Server Response Headers 
Earlier I had a post about my Socket Server, I wasn't able to get it to connect, now I can 

I
Recode Abap Dynpro into Web Dynpro 
Hi All,

A client has asked us to look at rearchitecting a custom transaction that was developed
Do While statement 
hi guys,

This may sound trivial but im new to php and as part of an assignmenti have to const