I like to use * and get an associative array I can work with from mysql_fetch_array but that's just me. Connect and try something like this:

$lequery = mysql_query("SELECT * FROM commentTable WHERE id='$idnum'");
while($therow = mysql_fetch_array($lequery)){
$name = $therow['name'];
$message = $therow['message'];
// Etc. but this grabs a row yay! And stores our crap in variables we can shoot out!
}

Then close your connection.

ok i think your getting js and php confused here...

you have to use the tables primary key function to really be able to grab a specific row...

usually every table has a row id header which is +1 each row...

using this statement can grab the row id you are after


$row_id = 2;
$sql = mysql_query("SELECT * FROM `table` WHERE `id` = '$row_id' LIMIT 1");


but then you'd have to somehow grab the info from that table... i use mysql_fetch_object(); but there are a few others.. some people don't recommend fetch_object but you can also use

mysql_fetch_array();
mysql_fetch_row();

then use a while loop to get the info


while($r=mysql_fetch_object($sql)){
echo $r->rowheader;
}




Last Edit: Sept 5, 2006 1:00:29 GMT by Llanilek

$sql = mysql_query("SELECT * FROM `table` WHERE `id` = '$row_id' LIMIT 1);

Forgot an ending quote.

just testing you moosey

o...k....

That went right over my head. I'll read some of those tutorials that you posted, phoenix, and see if I can figure it out

you see thats why you really shouldn't jump in at the deep end to learn php unless you have some basic knowledge of either flat file or mysql.

let us no how it goes yeh?

It also helps to have a good understanding of JavaScript before PHP. Knowing JavaScript helped me cut a lot of corners.

JS is method based, PHP is more function based (before OOP anyway).

Also, .length isn't a property for PHP arrays. Its count($array) (if I remember correctly).

thats the reason why i said he was confusing php and js

Oh... I thought that I saw .length on a PHP tutorial

This may take a while...

well its taken me two years to get where i am now lol

Well, for my code database, I just used:


$query="SELECT * FROM Codes WHERE category='$code_cat' ORDER BY code_name";
$result=mysql_query($query);
$num=mysql_numrows($result);
$i=0;
$final_code = '<ul>';

while($i<$num){
$db_url= mysql_result($result,$i,"thread_url");
$db_name= mysql_result($result,$i,"code_name");
$i++;
}


It'll return everything that fits the specification. If you use WHERE field='$field', you'll probably get only one result.

~Artemis

Artemis, I hope to got you validated $code_cat....