Đang Thực Hiện

MySQL 5 Table JOIN

I have tried books and internet suggestions and nothing works for me to JOIN MySQL tables in PHP! I do have a working 2 table MySQL but it works like an array where the tables are numbered like this $row[16] rather than by names such as $row[background]

THIS, below, is the only JOIN that works! But I want NAMES not Numbers, and I need more than a 2-table join! I need to know how to JOIN 5 MySQL tables.

<?php

$userId = $_GET['userId'];

include("[url removed, login to view]");

$query = sprintf("select [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view] from userpageinfo p left join user u on p.userId=[url removed, login to view] where p.userId='%s'", mysql_real_escape_string($userId));

$info = mysql_query($query,$conn);

$row = MySQL_fetch_row( $info );

//echo $_SESSION['UserName'];

if($row)

{

echo "<style type='text/css'>";

echo "body {background-color: rgb(255, 255, 255);background-image: url('../../backgrounds/".$row[0]."');background-repeat: repeat;background-attachment: fixed;}";

echo "</style>";

?>

<?php

if($row[38] == "yes"){

include $SERVER ['[url removed, login to view]']."[url removed, login to view]";

}elseif($row[38] == "no"){

print("");

}else{

print("");

}

?>

<?php

echo "<div STYLE=\"display: block; position: absolute; top: 200px; right: 300px; z-index: 3;\">";

echo "<marquee behavior=\"scroll\" direction=\"left\" scrollamount=\"2\" loop=\"1\" style=\"position:relative; width:1000px; height:1000px;\">";

echo "<img src=\"$row[16] \">";

echo "</marquee>";

echo "</div>";

?>

<?php

echo "<div STYLE=\"display: block; position: absolute; top: 0px; left: -300px; z-index: 10;\">";

echo "<marquee behavior=\"scroll\" direction=\"down\" scrollamount=\"2\" loop=\"1\" style=\"position:relative; width:1000px; height:700px;\">";

echo "<img src=\"$row[22] \">";

echo "</marquee>";

echo "</div>";

echo "<div STYLE=\"display: block; position: absolute; top: 0px; left: 700px; z-index: 10;\">";

echo "<marquee behavior=\"scroll\" direction=\"down\" scrollamount=\"2\" loop=\"1\" style=\"position:relative; width:1000px; height:700px;\">";

echo "<img src=\"$row[22] \">";

echo "</marquee>";

echo "</div>";

?>

<?php

echo "<div STYLE=\"display: block; position: absolute; top: 0px; left: 100px; z-index: 10;\">";

echo "<marquee behavior=\"scroll\" direction=\"right\" scrollamount=\"2\" loop=\"1\" style=\"position:relative; width:535px; height:1100px;\">";

echo "<img src=\"$row[23] \">";

echo "</marquee>";

echo "</div>";

ETC...

XXXXXXXXXXX

Please do a 5 table join using names for the variables.

Please do it as Table1, Table2, Table3, Table4, Table5

Kỹ năng: MySQL, PHP

Xem thêm: php join tables, php mysql join table, mysql join table, mysql table join, u.s. p.s, top query, root info, mysql top 10, mysql 5.1, table, table top, rgb, query table, mysql index, join me, body works, img table, style background image, php text array, php table array, query loop, div style top, display mysql, css table scroll, image table

Về Bên Thuê:
( 10 nhận xét ) Sandy City, United States

Mã Dự Án: #1682965

Đã trao cho:

puckettgw

Hi, I am a web developer and database admin with several years of experience in MySQL. I would be happy to do this project for you.

$50 USD trong 1 ngày
(1 Đánh Giá)
1.5

7 freelancer đang chào giá trung bình $87 cho công việc này

neoconcepts

php/mysql team

$250 USD trong 2 ngày
(101 Đánh Giá)
7.2
dracco

hello sir, I can do this job in a short time. I have a lot of experience by doing similar projects and I can help you right away. Best regards. Dracco.

$50 USD trong 0 ngày
(130 Đánh Giá)
5.8
samitXI

I can do this. Thanks

$150 USD trong 2 ngày
(42 Đánh Giá)
5.8
MustafaSR

Hello Sir, please check PMB

$50 USD trong 1 ngày
(65 Đánh Giá)
5.5
arusdevelopers

Dear sir, I can help you in this. Please send me the table structure and i will create A query for you. It would be good if you send me table structure and data all together. regrds,

$50 USD trong 1 ngày
(15 Đánh Giá)
5.0
ElementalWarrior

I know what your problem is I can solve it.

$30 USD trong 0 ngày
(7 Đánh Giá)
3.1
kadimi

PHP/MYSQL expert, you will get quality at affordable price

$30 USD trong 1 ngày
(2 Đánh Giá)
2.1