SQL error

BluntedbyNature

ok im trying to make it so when you want to view the details of something you click on it and it will show everything doing something like view.php?sid=13 i have this code, and i thought this is how you do it but i guess not.

mysql_select_db($database_conn, $conn);
$query_scripts = "SELECT * FROM scripts WHERE scripts.s_id = $sid";
$scripts = mysql_query($query_scripts, $conn) or die(mysql_error());
$row_scripts = mysql_fetch_assoc($scripts);
$totalRows_scripts = mysql_num_rows($scripts);

can you help me out.

cgraz

You didn't really say much about the problem, but try this:

// i assume you have mysql_connect somewhere to establish a connection to your mysql server?

mysql_select_db($database_conn, $conn);

$query_scripts = "SELECT * FROM scripts WHERE s_id = '" . $_GET['sid'] . "'";
print $query_scripts . "<br>"; // you can delete if it prints correctly

$scripts = mysql_query($query_scripts) or die(mysql_error());

Cgraz

BluntedbyNature

i really dont get what you are telling me to do... still sort of a newbe, ok sorry about not explaining myself.
im trying to set up a section on my site for scripts and tutorials. i want to be able to view the details of each script and tutorial by using a link like view.php?sid=13 or what ever id the script has, i get some type of error, the error dont tell me much. it just says "SQL error near line '6' " which does nothing for me. im also constructing the site and the php in dreamweaver MX when i try to run it in there i get a error saying 'undefined table, $sid' i didnt think i needed a table for this.

and i dont get what the $_GET[sid] thing is or what it does?

cgraz

try the code i gave you.

The $_GET['sid'] gets the variable $sid out of the url.

Cgraz

BluntedbyNature

if it takes it out of the url how will i know which script i am linking to?

BluntedbyNature

-sorry double post-

cgraz

the variable is in your url

www.yourdomain.com/page.php?sid=whatever

then to access the variable on page.php (which is the page you are on),

$_GET['sid']

Cgraz