PHP SELECT problem...

emptycup

I am a newbie who would be eternally grateful if someone could give a VERY basic example of a SELECT statement to pull a single cell from a MySQL database.

I keep getting a resource id instead of the actual results. I know that I need to use some other function, but I don't know which or how to apply it.

LordShryku

You need to fetch the results. Look in the manual under mysql_fetch_*. There's a couple of them like mysql_fetch_row, mysql_fetch_array, etc, etc...

emptycup

Thank you for replying so quickly.

Unfortunately, I have been to the links you provided and they didn't help. That is why I was hoping someone could break it down further.

Here is what I am trying...

<?
session_start();
$session_id = session_id();

// Attempt to connect to the MySQL database.
mysql_connect("localhost", "me", "whatever");

// ...attempt to select the database.
$select = mysql_select_db("promo");


    // ...attempt to query the database.
    $result = mysql_query ("SELECT amount_offer FROM amount")
    or die ("Invalid query: ".ysql_error());

    $num_rows = mysql_num_rows($result);

    echo "&order_total = $result ";

// 'order_total' is a dynamic text field in a flash movie

Thank you again!

LordShryku

You're still not fetching it. What are you doing if it returns more than one result? Here's how you would do only the last result. Any more than that and you'd need to loop through it.

$result = mysql_query ("SELECT amount_offer FROM amount")
or die ("Invalid query: ".mysql_error());
$row = mysql_fetch_array($result);
echo "&order_total = ".$row['amount_offer'];

emptycup

LordShryku - I REALLY appreciate your assistance.

I tried what you said. The results show up if I run the PHP from the browswer, but they are not showing up in my flash movie (I was getting the resourse error there before. I even changed it to guarantee just a single result and still nothing.

Here is what I tried...

<?
session_start();
$session_id = session_id();

// Attempt to connect to the MySQL database.
$link = mysql_connect("localhost", "me", "something");

// ...attempt to select the database.
$select = mysql_select_db("promo");


    // ...attempt to query the database.
      $result = mysql_query ("SELECT amount_offer FROM amount WHERE OID = 25")
	  or die ("Invalid query: ".mysql_error());
	  $row = mysql_fetch_array($result);

echo "&order_total = ".$row['amount_offer'];

emptycup

A simple space between echo "result and the equal sign was all that was keeping if from working. It works now.

Thank you very much!!!