[Resolved] "fetch" question

[NoBullMan]

Hi,
I am trying to fetch a record from a MySQL db, based on th eproduct ID passed to the php page in the URL and put the results in a table row.

php_page.php$prod_id=1234

can you tell me what is wrong with this:

$pid = $_GET['prod_id'];
$result = mysql_query("SELECT ProductName, Price, Flag from products WHERE ProductID=\"$pid\"");
$row = mysql_fetch_row($result);
print '<tr><td>$row[0]</td><td>$row[1]</td><td>&nbsp;</td><td>&nbsp;</td></tr>';

Thanks.

[kevinsequeira]

it has to be passed this way

php_page.php?prod_id=1234

not

php_page.php$prod_id=1234

reg
kevin

[Kinsbane]

Originally posted by NoBullMan
Hi,
I am trying to fetch a record from a MySQL db, based on th eproduct ID passed to the php page in the URL and put the results in a table row.

php_page.php$prod_id=1234

can you tell me what is wrong with this:


$pid = $_GET['prod_id'];
$result = mysql_query("SELECT ProductName, Price, Flag from products WHERE ProductID=\"$pid\"");
$row = mysql_fetch_row($result);
print '<tr><td>$row[0]</td><td>$row[1]</td><td>&nbsp;</td><td>&nbsp;</td></tr>';

Thanks.

Sometimes things are weird.. I've had better luck not using a variable to define a global variable. try using $_GET['prod_id'] in place of $pid. Worth a shot 🙂

[NoBullMan]

Hi,
sorry for the mis-print. I did use phphfile.php?prod_id=1234.
In my post I typed $ instead of ?.

[kevinsequeira]

<?php
$pid = $_GET['prod_id'];
//DEBUG ....
echo "pid is ".$pid;
//if ProductID is a number then use this $query
$query = "SELECT ProductName, Price, Flag from products WHERE ProductID=".$pid;
//if ProductID is a alphanumeric then use this $query
$query = "SELECT ProductName, Price, Flag from products WHERE ProductID='".$pid."'";
//DEBUG : print the query and try running it directly in the database to see if you get results
echo "query is ".$query;
$result = mysql_query($query) or die(mysql_error());
if(mysql_num_rows($result) < 1){
	print "<tr><td colspan=4>NO Product found with id".$pid."</td></tr>";
}else{		
	$row = mysql_fetch_row($result);
	print "<tr><td>".$row[0]."</td><td>".$row[1]."</td><td>&nbsp;</td><td>&nbsp;</td></tr>";
} 
?>

reg
kevin

[NoBullMan]

Thank you.🙂

[kevinsequeira]

no problem, if this solves the issue please mark this thread as resolved. there is a link below

reg
kevin