PHP Query

Anon

Php is new to me, but I am learning.

I just want to query certain items from a product database. Like the description,
cost, QOH, etc.

Here is what I have, but I'm a little lost.

// connect to server
$mysql_link = mysql_connect() or die ("Problem connecting to DataBase");

// select the databse
$select = mysql_select_db("products", $mysql_link);

// get data from table
$result = mysql_query("SELECT part_num FROM products WHERE part_num =043011") or die ("Query failed");

echo $result;

I know I'm missing something important, but what? Can someone tell me what codeing I need, to be able to pull data out from a database. Also, how I can specify the row and column, and the correct way to show the data or results of the query.

Anon

Did you not specify your database's host,user and pass on purpose because of the forum?

$dbhost = "localhost";
$dbuser = "user";
$dbpass = "pass";
$dbname = "database";

//connect
$db = mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("$dbname",$db);

//query
$sql = mysql_query(("SELECT * FROM products WHERE part_num ='$part_num'");

//get data and put in table
while($row=mysql_fetch_row($sql))
{
$part_num = $row[0];
$description = $row[1];
$cost = $row[2];
$qoh = $row[3];

print ("<table>\n");
print ("<tr>\n<td>$part_num</td>");
print ("<td>$description</td>");
print ("<td>$cost</td>");
print ("<td>$qoh</td>");
print ("</tr>\n</table>\n");

}

hth
scott d~

Anon

I just get a blank screen. No error messages. What is the problem?

Anon

Please copy the exact code that you used into the forum so I can have a look...as well as a list of your rows in the database.

scott d~

Anon

Here is what I tried first:

<?
$dbhost = "localhost";
$dbuser = "odbc";
$dbpass = "";
$dbname = "products";

//connect
$db = mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("$dbname",$db);

//query
$sql = mysql_query("SELECT * FROM products WHERE part_num ='$part_num'");

//get data and put in table
while($row=mysql_fetch_row($sql))
{
$part_num = $row[277082];
$description = $row[1];
$cost = $row[2];
$qoh = $row[3];

print ("<table>\n");
print ("<tr>\n<td>$part_num</td>");
print ("<td>$description</td>");
print ("<td>$cost</td>");
print ("<td>$qoh</td>");
print ("</tr>\n</table>\n");
}
?>

Then I tried this select command: "SELECT descr FROM products WHERE part_num = 277082." This gave an output of "Resource ID#2."

<?
$dbhost = "localhost";
$dbuser = "ODBC";
$dbpass = "";
$dbname = "products";

//connect
$db = mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("$dbname",$db);

//query
$sql = mysql_query("SELECT descr FROM products WHERE part_num ='$part_num'");

//get data and put in table
while($row=mysql_fetch_row($sql))

$part_num = $row[27700];

print ("<table>\n");
print ("<tr>\n<td>$sql</td>");
print ("<tr>\n<td>$row</td>");
print ("</tr>\n</table>\n");
?>

I am looking to get specific pieces of information from a certain product number (prod_num). Like the Description (desr), price (cost - which will have a percentage added to it), status (stock).

Here are all of the rows in the "products" database - I am not going to use all of the rows, I have marked useless ones with a star:
grp, cat,sub, vend_code, manu_part, part_num, descr, cost, retail, qty, list_price, eff_date, tech_fax, status, ups*

Thanks for all the help!!

Anon

Syed wrote: