Ranom

[Forever_xxl]

How get? i have 3 tables:

1 table - "Name":
1 | Php
2 | Car
3 | Tree
4 | Stone
5 | Table
6 | Perl

2 table - "Text":
1 | Honda, mazda, ferrari
2 | Big, smole, very big
3 | programming language
4 | best programing language
5 | compiuter, books
6 | flower,

3 table - "Introduction":
1 | php | best programming language
2 | perl | compiuter, books
3 | Table | compiuter, books

How make script? If it possible only with mysql code
he get from 2 tables: Name and text random data (limit 1).
ex. Php | best programing language

and check with table 3 "Introduction". if row with Php and best programming language is in some line he get new data.

Ex. script can't get:
php | best programming language
perl | compiuter, books
Table | compiuter, books

because in 3 table this data egzist, but he can get php | flower, because in table "Introduction" no this row. It's possible get with mysql funcions?
(ex ... where text. name not like Introductions.text, ). Please help. Very need make this script or mysql sentence

[bpat1434]

I think I may perhaps understand what it is your asking. So I'll give it a shot:
Correct Me if I'm Wrong:
You want to randomly grab a row from table Names and table Text and then search through table Information to see if there is a matching row?

So I think you would want to use the mt_rand([int min, int max]) to generate a random number between 'int min' and 'int max'. Then just run the queries. I don't think it can be done in one query, but I'm not the most knowledgable guy on how to make things easier.

The link to my page below will print out the code and the output automatically.

Viewable Here

Hope that helps you out a bit.

~Brett

[Forever_xxl]

Very thanks, waiting. script not printing 😃. If you help

[bpat1434]

SOrry, kinda got side-tracked... it smells like no-body's business in my apartment cuz my room-mates are scuz bags.

Anyway, I've edited the file, and it works now.

The code pumps out on its own below the output of the script!!!

Viewable Here

Hope this works out for you...

~Brett

[Forever_xxl]

Vey thanks. One question if i have in tables "name" and "text" more data. And my data id (auto) have 1,2,3,6,7. Not have some numbers. How make? I now i can change it in mt_rand(). But I want what to me don't need count data. If i add new row it can get it from new row. And me don't need change script. If you understand me what i whant. 😃

[bpat1434]

I'm not quite sure how you would exclude certain numbers from that. I'm thinking that if the query fails, then the page will refresh automatically, but not sure.

There is the possibility to add an if() statement:

// Define the queries to run on the database(s)
$sql = "SELECT `Name` FROM `Name` WHERE id = ".$rand1." LIMIT 1";
$sql2 = "SELECT `Text` FROM `Text` WHERE id = ".$rand2." LIMIT 1";


$result = mysql_query($sql);
$result2 = mysql_query($sql2);

if(mysql_num_rows($result) < 1){
    header("Location: ".$_SERVER['PHP_SELF']);
}
if(mysql_num_rows($result2) < 1){
    header("Location: ".$_SERVER['PHP_SELF']);
}


$name = mysql_fetch_array($result);
$text = mysql_fetch_array($result2);

Perhaps someone else could be of more help in this situation.

~Brett

[Forever_xxl]

Very thanks for help.

to others if now how make this script please tell me.

Not try but not possible it make with mysql sentence?

[Forever_xxl]

very thanks. Now i know how make. I have change intoduction table.: where name = ".$name['Name']." and text = ".$text['Text'].". this is count rows how much is. If it null he show if not he reffresh. From name and text he get (order by rand() limit 1).