[SOLVED] MySQL Query not working

[Vivid Lust]

This is my PHP:

 

<?php
@mysql_select_db( "inf_1235727_test", $conn )
or die( "could not select database" );
//stuff
@mysql_query( "SELECT id FROM topics WHERE id = '$_GET['id']'" )
or die( "could not select query" );
?>

Working...

 

The last MySQL Query doesnt work. Help please!

 

[revraz]

Remove your DB Name/PW from your post

[pocobueno1388]

I see a problem with it, but why are you suppressing the error with the @?

 

Change it to this

mysql_query( "SELECT id FROM topics WHERE id = '{$_GET['id']}'" )
or die(mysql_error());

 

EDIT: Also, it doesn't do you much good if you don't assign it to a variable.

 

$query = mysql_query( "SELECT id FROM topics WHERE id = '{$_GET['id']}'" )
or die(mysql_error());

[Vivid Lust]

ooops

[Vivid Lust]

It works thanks

[Vivid Lust]

Ok so how could i echo fields on that "id" row???

 

Thanks

[pocobueno1388]

<?php

$query = mysql_query( "SELECT id FROM topics WHERE id = '{$_GET['id']}'" )
or die(mysql_error());
$row = mysql_fetch_assoc($query);

echo $row['id'];

?>

 

If you expecting more than one result, then use a while loop

 

<?php

$query = mysql_query( "SELECT id FROM topics WHERE id = '{$_GET['id']}'" )
or die(mysql_error());

while ($row = mysql_fetch_assoc($query)){
   echo $row['id'].'<br>';
}

?>

 

[Vivid Lust]

It sort of works

 

i have a table like:

 

id    title  text

1    BLAH    BLAH

2  BLAH    BLAH

 

how can using the php GET also get the rest of the row? the loop thingy doesnt do it

 

[revraz]

Thats because you are only selecting id FROM topics.  If you want more, you have to SELECT more.

[Vivid Lust]

ok 

[DyslexicDog]

DON'T USE INCOMING CLIENT PROVIDED INFORMATION WITH OUT SANITIZING IT FIRST!

 

The SQL statment you are using is easily hacked. Please read about mysql_real_escape_string()

 

http://us.php.net/mysql_real_escape_string