Can;t parse to Query - sample inside

Anon

fellas.. i got a problem here

http://www.something.com/index.php?from_url=data&id=8

$cari_result = mysql_query("SELECT * FROM $from_url WHERE id=$id",$db);

and It's not working. what do you think the best way to do that ?

thanks for read my problem

jcornett

Put the id variable in single quotes within your SQL statement like this:

$cari_result = mysql_query("SELECT * FROM $from_url WHERE id='$id'",$db);

John

Anon

i don;t know it's still not working 🙁

Anon

Put your coding in your next reply and we can all take a look at it. The first thing I would do is make sure your variables are getting populated by echoing it out to the screen. If it is showing as blank, you know where to look.

$sql = "SELECT * FROM $from_url WHERE id='$id'";
echo "SQL Statement: $sql<br>";
$cari_result = mysql_query($sql);

Let us know what it did when you see the sql statement.

John

Anon

The $cat value, is parsing thru the url
like : http://www.mysite.com/index.php?cat=newbook

<?
echo("
<IMG SRC=http://www.mysite.com/images/head-$cat-submit.gif width=464 height=92>
");

$db = mysql_connect("localhost", "myuser","mypass");
mysql_select_db("mydatabase",$db);

if ($submit) {

if ($id) {

} else {

// update the restarutant add with this review

$cari_result = mysql_query("SELECT * FROM $cat WHERE rest_id='$rest_id'",$db);

while ($cari_row = mysql_fetch_row($cari_result)) {
$tot_star = $star + $cari_row[15];
$tot_comment = 1 + $cari_row[16];
}

$add_sql = "UPDATE $cat SET tot_star=$tot_star,tot_comment=$tot_comment WHERE rest_id=$rest_id";

// update the restarutant add with this review

$lookin = "$cat";
$lookin .= "_comments";
$sql = "INSERT INTO $lookin (title,name,star,comments,rest_id) VALUES ('$title','$name','$star','$comments','$rest_id')";

}
$result = mysql_query($add_sql);
$result = mysql_query($sql);
echo "<CENTER><BR><BR><BR><BR><BR><FONT FACE=VERDANA SIZE=-2><B>Thank you ";
} elseif ($delete) {
} else {
if (!$rest_id) {
$result = mysql_query("SELECT * FROM $cat",$db);
while ($myrow = mysql_fetch_array($result)) {
}
}
?>
<form method="post" action="<?php echo $PHP_SELF?>">
<?php
if ($rest_id) {
?>
<input type=hidden name="rest_id" value="<?php echo $rest_id ?>">
<?php
}
?>

Write your own review for this list<br>
<FONT FACE=VERDANA SIZE=-2 COLOR=#666666>review guidelines</FONT>
</TD>
</TR>

<TR>
<TD>
<FONT FACE=VERDANA SIZE=-2 COLOR=#666666><B>
Title for your review<BR>
<input type="text" name="title" value="<?php echo $title ?>" CLASS=nicefield SIZE=60>
</TD>
</TR>
<TR>
<TD>
<FONT FACE=VERDANA SIZE=-2 COLOR=#666666><B>
5 stars being the best - 1 stars being the worst, how would you rate<BR>

<select name="star" CLASS=nicefield>
<option value="5">5 Stars
<option value="4">4 Stars
<option value="3">3 Stars
<option value="2">2 Stars
<option value="1">1 Stars
</select>
</TD>
</TR>

<TR>
<TD>
<FONT FACE=VERDANA SIZE=-2 COLOR=#666666><B>
Type your review (maximum length is 200 words)<BR>
<textarea name="comments" rows=8 cols=62 maxlength=200 class=nicefield value="<?php echo $review ?>"></textarea>
</TD>
</TR>

</TABLE>

</form></B><FONT FACE=VERDANA SIZE=-2>

<?php

}

Anon

have u figure it out, whereis the problelm