retreiving mysql data

[lelandmyrick]

I'm trying to pull from a mysql data using the following:

mysql_select_db("dbsnugtuck");
$result = mysql_query("select * from temp where sessionid = $sessionid");
while($query_data = mysql_fetch_row($result))

But when I browse the page I get:

Warning: Supplied argument is not a valid MySQL result resource in /virtualhosts/snugtuckpillow.com/www/pages/addcart.php on line 125

Line 125 is the line that starts $result =...

I know a field called sessionid exists, and $sessionid is a variable on page. What am I doing wrong? I'm new to php and mysql, so any help is greatly appreciated.

Thanks,
Leland Myrick

[Anon]

Do you have a connection command?? You will need to make the connection then use that is your query command. the mysql_query is best used with the query then the connection command.

Mark.

[lelandmyrick]

It's connecting fine. If I take out the code:
"where sessionid = $sessionid" it pulls the data from the table. But I need to pull only the data associated with the current shopper ($sessionid). That's the part that seems to be making it error.

[Anon]

i'd like to ask conection command with oracle

mark wrote:

Do you have a connection command?? You will need to make the connection then use that is your query command. the mysql_query is best used with the query then the connection command.

Mark.

[Anon]

i'm waiting

[khaine]

After a second look I think I have spotted the problem you are missing a set of single quotes. Try rewriting your select to.

$result = mysql_query("select * from temp where sessionid = '$sessionid'");

That should fix it.

Mark.

[khaine]

The oracle connection command is ocilogon(username, password, database).

Mark.