transfering variables?

toddmarx

Ok, newbie here. Here is the problem that I am having.

I am trying to feature a product on a website randomly. I can get mysql to pick the id (pivot/anchor for table). But how do I get php and mysql to query the rest of the info like the product code, description, pic, price, etc of that particular id?

I have already gotten php to capture the randomly generated id and assign it as a variable.

Thank you in advance for all your help! 😃

BuzzLY

SELECT * FROM products WHERE id ='$randomID'

... or am I not understanding your question correctly? Seems like a straightforward SQL query to me...

leetcrew

okay, this code might help you...


mysql_connect ( "localhost", "username", "password") || die ( mysql_error() )";

mysql_select_db ("my_database") || || die ( mysql_error() )";

$sql = "SELECT * FROM table1";

$result = mysql_query ( $sql );

while ( $row = mysql_fetch_array ( $result ) )
{
   echo $row['MY_QUOTES'];

}

mysql_close();

leatherback

..
Eerhh.

Where do you

capture the randomly generated id and assign it as a variable

Let's assume that

$row['MY_QUOTES'];

is your random number.

Then in your while:

$id = $row['MY_QUOTES'];

Use this subsequently in the query to get the details out (Assuming of course that the details are not in the same table, becaus then you can get them straight away from your $row[])

SELECT * FROM products WHERE id ='$id'

BuzzLY

... which is essentially what I told him. He did say that he already got the id number, so telling how to get the id number is a moot point. Once he has the id number, it's a simple matter of running the aforementioned query.

A lot of responses for such a simple question, if you ask me 😃

[edit] LOL... how appropriate is it that this post number is #404? :p [/edit]

toddmarx

Ok, we are getting close. I think the question is a little more complexed than what I originally posted.

Ok, all the info that I need is in the same table. what I have done so far is to get php to tell sql to get a random id and then assign a variable:

$randid = query string for getting random id from sql

Now, once I have the random id, i need to pass the rest of that info so that php will tell sql to go and get the 'description' ,'price', 'title' fields and stuff. I tried some of the scripts that you guys provided above, and i believe that we are on the right track. Not sure if I made sense when I asked the original question. Hope this makes it a little more clear! 😃 😕

toddmarx

Sorry to be such a pain. Never messed with sql and php that much. Trying to help a friend build his site. again, thanks in advance for all your help. 🙂

toddmarx

oh yea, one more thing. I dont know if this will help, but I am using dreamweaverMX and sqlyog.

toddmarx

nothing important to say here, just trying to rebump this thread so that maybe another shot can be taken at it.

BuzzLY

Since they are all in the same table, you should be able to pull not only the id, but all the data in the table. Why don't you post the SQL code you are using, and we can show you how to modify it to pull all the data you need.

Please don't bump threads. If someone has a solution, they'll post it for you. Bumping can get very annoying. You may want to read this.

toddmarx

Sorry about the bump. It wont happen again.🆒

as for the code, that is the problem. I have the code to get the id, assign it and all that stuff, just dont know how to take that assigned random id and get php to tell mysql to go and get the rest of the stuff. But, here is what I have so far....

//here is the binding of the query and all that other good stuff
mysql_select_db($database_mysqlconnect, $mysqlconnect);
$query_randomQuery = "SELECT id  FROM products  ORDER BY RAND() LIMIT 0,1;";
$randomQuery = mysql_query($query_randomQuery, $mysqlconnect) or die(mysql_error());
$row_randomQuery = mysql_fetch_assoc($randomQuery);
$totalRows_randomQuery = mysql_num_rows($randomQuery);

//And here is where I assigned the result a variable name

echo $row_randomQuery['id']; 
 $randid = $row_randomQuery['id'];

hope that this helps. Am I even going in the right direction?😕

BuzzLY

Aha... I gotcha now. VERY simple. Just use this SELECT query instead:

SELECT * FROM products ORDER BY RAND() LIMIT 0,1;

Now, at the end of your code, not only can you access the id, but also any other column:

$productid = $row_randomQuery['id'];
$prodcode = $row_randomQuery['procuct_code'];
$proddesc = $row_randomQuery['description'];
// etc, etc...

How's that for easy? 🙂

toddmarx

You are 'da man!

I was thinking that it had to be something really really easy and that I would feel really really stupid becauase it would be so simple. I guess I got hung up on all this "hard stuff" that I had been doing, that I forgot the "basics".

Thanks again!😃 🆒 :rolleyes: 😉 🙂