[[SOLVED] Help needed with passing 'id' through url]

The function is spelled wrong, should be:

 

mysql_real_escape_string($_GET['cat']);

[[SOLVED] Help needed with passing 'id' through url]

Did you change the (int) to mysql_real_escape_string() as suggested by gevans?

[[SOLVED] Help needed with passing 'id' through url]

that would do it  

 

Out of curiosity does that throw a php error or simply convert it to 0?

[[SOLVED] Help needed with passing 'id' through url]

Ok - assuming you're no longer getting the 'Category isn't specified' error... I'm not seeing where the $sitelocation variable is created, but it's being called in the echo string.

 

Is there any output at all?  Any php errors?

[[SOLVED] Help needed with passing 'id' through url]

Can you post the most recent version of your code again

[[SOLVED] Help needed with passing 'id' through url]

It means that there is no "?cat=child" in the url.  So the script attempts to pull the $_GET['cat'] but can't because the variable doesn't exist in the url.

 

You need to make sure the variable exists in the url before the script can pull the category and execute the query.

 

Make sense?

[[SOLVED] Help needed with passing 'id' through url]

do an isset() to check if the field exists

 

if(!isset($_GET['cat'])){
   die("Category isn't specified");
}

[[SOLVED] Help needed with passing 'id' through url]

If echoing the $_GET['cat'] isn't displaying anything, then the variable?cat=child isn't accessible via the url.  Could you paste the actual url (the actual results of your previous post) so I can confirm that the variable is present and rule that out as an issue.

[[SOLVED] Help needed with passing 'id' through url]

No I mean the exact url that contains the $_GET['cat'] script.

 

So http://www.sample.com/filename.php?cat=3

 

Should be something like that... I want to confirm the $_GET vars.

[[SOLVED] Help needed with passing 'id' through url]

Can you show us the exact url in the address bar for this page?

[[SOLVED] Help needed with passing 'id' through url]

Does echoing the value of the $_GET var work?

 

echo $_GET['cat'];

 

If it doesn't then the $_GET var isn't accessible from the url.

[[SOLVED] Help needed with passing 'id' through url]

Try the following, it'll display mysql errors and php errors.

 

<?php

/* Enable displaying of errors */
error_reporting(E_ALL);
ini_set('display_errors', 'On');

$cat = (int) $_GET['cat'];
$get_items = "SELECT * FROM poj_products WHERE cat='$cat'";
$get_items = mysql_query($get_items);
if($get_items){
$item_row = mysql_fetch_assoc($get_items);
echo '<a href="'.$sitelocation.$item_row['url'].'?item_desc='.$item_row['id'].'>view details/order</a>';
}else{
die("Unable to connect to database.".mysql_error());
}

?>

[[SOLVED] Help needed with passing 'id' through url]

That works too

[[SOLVED] Help needed with passing 'id' through url]

You should also protect the $cat var from sql injection.

 

$cat = mysql_real_escape_string($_GET['cat']);

[[SOLVED] get image width & height with php]

No problem... if it solves your issue, could you mark the topic as "solved"?

 

Cheers,

p2grace

[Can I know who called my php page?]

Do you use google analytics (or any other visitor tracking service) to track website visitors?

[[SOLVED] get image width & height with php]

Yes it is:

 

http://us3.php.net/getimagesize

[[SOLVED] Quick question]

Glad it helped you out... could you mark the topic as solved?

 

Cheers,

p2grace

[[SOLVED] Quick question]

lol - if your code is clean you shouldn't have any

[[SOLVED] Quick question]

Add this to the script:

 

<?php
/* Enable displaying of errors */
error_reporting(E_ALL);
ini_set('display_errors', 'On');
?>

[[SOLVED] Quick question]

How about php errors?

[[SOLVED] Quick question]

I'd recommend checking if it returned a mysql error.

[[SOLVED] return statement]

If your question has been answered could you also mark the post topic as "Solved"?

 

Cheers,

p2grace

[[SOLVED] Redefining a variable in an array]

An assignment only uses one equal sign.

 

if ($user['gender']=="m") {$user['gender']="Male";}

[[SOLVED] return statement]

It isn't necessary if you are not actually returning a variable.  It just acts as a void.