[KeYBLeR]

Hello everyone,
I have setup a MySQL database with 5 feilds. I have made the primiry key thing a number. Is there anyway to do a php command, simlar to INCLUDE. That would include the 5 database feilds into a viewable format with HTML.

Basicly Grabing certain information using a number.

Is this possible?

Thanks Keith

[NoMercy]

Can you add a little more detail for what your asking. I dont' really know what your asking. Do you just want to display information from your MySQL database? I don't really understand what you want.

[KeYBLeR]

PHP Code:

echo("<tr><td align=center width=55px><font class=textsmall>$row[id]</font></td><td width=250px><font class=textsmall>$row[product_name]</font></td><td width=300px><font class=textsmall>$row[product_description]</font></td><td width=100px><font class=textsmall>$row[product_price]</font></td><td width=100px><font class=textsmall>$row[product_weight]</font></td>"); 

Thats how I display information in a database.

Do you see the $row[id]

Is there anyway I can do something like this,

PHP Code:

include("$row[id]"); 

and that will then pull all the values?

Basicly I have a product database, I just add products to the list. I would like to be able to call on a certain product with a number.

Does that make more sense?
Thanks for your time, Keith

[Wuiqed]

I assume that each product in the database has a unique id, then you can pull the product from the database with a WHERE clause in the query:

PHP Code:

$query  = "SELECT * FROM  product WHERE id=1";

 $result = mysql_query($query) or die(mysql_error() ."<br />". $query);

 $row    = mysql_fetch_assoc($result); 

The product with id#1 would the be found in the $row array.

[KeYBLeR]

Ok, I'm at about here with this,

PHP Code:

include("config_settings.php");

$query  = "SELECT * FROM `list` WHERE id=2"; 

$result = mysql_query($query) or die(mysql_error() ."<br />". $query); 

$row    = mysql_fetch_assoc($result); 

Then I've tryed to echo the $result with no luck

When I echo $row it just says ARRAY

Am I missing something to display the information, or is this mysql script, not pulling information correctly.

Thanks for your time. Keith


PS, Something I just thought of, Someone gave me this code along time ago to SEARCH for a value in the database,

I would use a HTML from to type in the ID number, then submit it to this part of the script.

PHP Code:

$id = $_POST['id'];

$result = mysql_query("SELECT * FROM list WHERE id='$id'");

if(mysql_num_rows($result) == 0){echo("No Matches Found");}

while ($row = mysql_fetch_assoc($result)) { 

$id = "$row[id]";

$name = "$row[name]";

$email = "$row[email]";

echo("<table align=left cellpadding=0 cellspacing=0><tr><td align=\"center\" width=\"50px\"><font class=textsmall>$row[id]</font></td><td width=\"300px\"><font class=textsmall>$name</font></td><td width=\"350px\"><a href=\"?page=sendemail&sendemail=single&email=$email\"><font class=textsmall>$email</font></a></td><td width=\"100px\"><font class=textsmall><a href=?page=members&members=edit&id=$row[id]>Edit</a> | <a href=?page=members&members=delete&id=$row[id] onClick=\"return confirm('Are you sure to delete $email from the list?');\">Delete</a></font></td></tr></table><BR>");

} 

is this bascily the same thing? Could I use this script I already have.

Thanks again, Keith

[DAL]

nearly there instead of just echo $row you need to say what you want to echo. that like saying echo database (well more or less)

echo $row['name'];

would echo what you have queried.

hope this helps

[KeYBLeR]

Thanks everyone, I got this now. I had the answer in front of my face!

Thanks again!
Keith

[KeYBLeR]

Another small question, not worth starting another topic over.

I'm having trouble editing my PRIMARY KEY . Everything will edit just fine in the database, execpt the primary key. I was just wondering if its possible to change the primary key?

Thanks keith