How to use mysql_fetch_row()

yoni

Atfer getting out from the "do...While" i'm jumping into the mysql_fetch_row() 🙂

Can someone post me a little exemple i would adapt ?

ps : btw, why can't i post anymore in my previous discussion ?

stolzyboy

$query = "select * from tablename;";
$result = mysql_query($query);

how 'bout checking the manual on mysql_fetch_row

yoni

I have managed to make work the exemple given (13-Sep-2000 06:06) on a seperate page.

But i can't make it work AT ALL with the page i got and the code issued from Dreamweaver...

If think the probleme is even in the query.

The exemple :

mysql_select_db ('database_name') 
or die (); 
$query = "SELECT * FROM table_name";

My code

mysql_select_db($database_Israelfr, $Israelfr);
$query = sprintf("SELECT * FROM adr_data WHERE categorie = '%s' AND pays = '%s'", $colcategorie_query,$colpays_query);

What is sprintf for ?

If someone want to suggest me to forget Dreamweaver help and try to write down ALL THE PHP CODE, I can argue that with my level it take me weeks to do somethings as simple... I know, not everybody is a programmer ! 🙂

boxmonkey

People who aren't programmers probably should not try to program, it won't get them anywhere.

Considering that you are not a programmer, sprintf is going to be over your head, not to mention that it's completely unnecessary in PHP.

$query = "SELECT * FROM adr_data WHERE categorie = '$colcategorie_query' AND pays = '$colpays_query'";

Should have the same effect. You may or may not need slashes in front of your single quote marks ('), I can't remember.

yoni

People who aren't programmers probably should not try to program, it won't get them anywhere

Well boxmonkey, i'll tried to prove you wrong ! 🙂

I will get back to my books, your advices and work more harder.

I hope i get back very soon with some others questions.

I'm may be not a programmer but i don't like to loose ! 🙂