problem with where phrase

Question

2.00/5 (1 vote)

See more:

hi all
my problem is abroblem with php
i wrote a code to do this
1-take the value of $_GET["id] from the link
2- bring the the that had the same id in the database
here is the code

HTML

<html>
<meta charset="utf-8">
</html>
include ('config.php');
$id=$_get["id"];
if (!$result) {
    die('Query failed: ' . mysql_error());
}
$sql = ('SELECT id as id, filename, link 
        FROM   link
        WHERE  id =$id');
$result = mysql_query ($sql);
if (!$result) {
    echo "Could not successfully run query ($sql) from DB: " . mysql_error();
    exit;
}

if (mysql_num_rows($result) == 0) {
    echo "No rows found, nothing to print so am exiting";
    exit;
}

// While a row of data exists, put that row in $row as an associative array
// Note: If you're expecting just one row, no need to use a loop
// Note: If you put extract($row); inside the following loop, you'll
//       then create $userid, $fullname, and $userstatus
while ($row = mysql_fetch_assoc($result)) {
    echo $row["id"];
    echo $row["filename"];
    echo $row["link"];
}

mysql_free_result($result);

?>

my problem is that $id in the line 12 doesn't give value because it is wrote in string
what can i do

Posted 16-Oct-11 1:30am

alfer3oon

Add a Solution

3 solutions

Solution 3

Hi.....

Replace your code

$sql = ('SELECT id as id, filename, link 
        FROM   link
        WHERE  id =$id');

by

$sql = ("SELECT id as id, filename, link 
        FROM   link
        WHERE  id ='".$id."'");

Above code produce output as....

SQL

SELECT id as id, filename, link
        FROM   link
        WHERE  id = '$id value'

Posted 17-Oct-11 17:33pm

arya1685

Solution 1

I know nothing about PHP but I believe you should replace

PHP

$sql = ('SELECT id as id, filename, link 
        FROM   link
        WHERE  id =$id');

with

PHP

$sql = ('SELECT id as id, filename, link 
        FROM   link
        WHERE  id = ' . $_get["id"]);

This assumes that $_get["id"] returns a string.

Posted 16-Oct-11 1:56am

André Kraak

Comments

[no name] 16-Oct-11 8:07am

I tried and it did't work

André Kraak 16-Oct-11 8:11am

So what is the value of the $sql?

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Accepted Answer · 2011-10-16T01:57:00

Solution 2

Convert the string to int - use intval. For more information, see here[^].

Posted 16-Oct-11 1:57am

Abhinav S