quick one

[itworks]

this passes the "cod" variable in the URL to another page:

<a href=\"index.php?page=product&cod=".mysql_result($rs, $n, "cod")."\">

i want to pass two more values from the database query, "model" and "price" besides "cod".

how to put this together?!

[harlowhair]

Are the results all in the same row within your db table? What I mean is, can you not pass the id of the row through the querystring, and then select the row with that id on the next page, getting all of the info

[itworks]

it's way to complicated, that piece of code is inside a query function called from a script, and i need those variables passed to that script 'cause there i have a button to submit them by using a function to another script that calls another function to store the values in another table in the database. (sorry if i confused you).

just need to fill in that piece of code 2 more variables like it is with "cod".

[itworks]

ok i figured it out finally

this is what i have to do:

<a href=\"index.php?page=product&model=".mysql_result($rs, $n, "model")."&cod=".mysql_result($rs, $n, "cod")."&price=".mysql_result($rs, $n, "price")."\">".mysql_result($rs, $n, "model")."

thanks anyway!

[diego25]

Check the mysql_fetch_array (and the others mysql_Fetch_* functiosn too); it would have made your code look much shorter...and not to mention they are faster than mysql_result 🙂

Diego

[itworks]

thanks a lot for the tip 😉

but since i've been trying to figure this out for a lot of time now, and it's working will stick with it 'cause i don't wanna mess a working code to try it. at least not to change to something i'm not sure i understood.

anyway thanks!