[Resolved] stupid resource id's

Brad

Anyone know what the resource id #2 refers to? Im just trying to insert into a table and am getting this as the out put when I try and query the table.

suepahfly

You probibly have something like this in your code

$result = mysql_query("INSERT INTO table VALUES 'value'");
echo $result;

Well that just isn't going to work. When you insert data you will get an empty result back, since the database is not giving any data back.

If you want to get a result:

$result = mysql_query("SELECT something FROM table");
while( $row = mysql_fetch_row($result))
{
   print_r($row);
}

What i Just did:
1 query the database for some data. (mysql_query gives you a result identifier, meaning you can use a funtion on that result)
2 Convert the data i got to an array
3 looping over the result array and printing it.

Brad

Here is my insert statement
$query = "insert into links(link, about, post_by) values('".$link."', '".$about."', '".$post_by."')";

result = mysql_query($query);
if ($result)
{
header("Location: http://mylocation");
exit;
}
else
{
echo "Link Submission failed";
exit;
}

Now on retrieving the data I get the id #2 as the value of the link column that was inserted. Some where in my insert there is a problem that wont let the $link variable be inserted as anything other than the resource id #2. Does that help?

Brad

Nevemind. I didn't notice that the word link is a key word. Changing link to url worked like a charm thanks all.