![php maker connect two tables php maker connect two tables](https://www.xrisi.com/styles_lisisoft/imglisi/7/DatabaseandSQL/151745mycodefactory.png)
#PHP MAKER CONNECT TWO TABLES CODE#
as of now when I do this code it sats there is an error when I try to set the variable $videosname equal to mysql_result($result,$i,"email") and I dont know why. Open PHPMaker, go to the Database tab, enter the connection information. The connection script is named tunnel.php and can be found under the installation folder, e.g. For instance my email is and I have a video name saved into a table which has my email saved with it in the same row, I want the php code to display the videoname which is linked with the users email. Upload the connection script to your site. I want the code to find a match in the database that is the same as the users email and display a different field which is on the same row of the users email. $query="SELECT * FROM videos WHERE email='$user_email'"
![php maker connect two tables php maker connect two tables](https://i.stack.imgur.com/TNFw5.png)
$user_email= or die( "Unable to select database") Sorry I posted on the wrong forum and just didnt know what I was doing, disregard what I previously said, this is the code I have, I need to display the information from the database that holds my users account, I have this code which is suppose to display information from my database, but I want the code to display one section of the row which the code finds a match on, here is the code. I'm not quite sure what you trying to accomplish here.
#PHP MAKER CONNECT TWO TABLES PLUS#
Plus I also notice you post other questions relating to this. What is the code? So far I been reading you are asking for a code but you haven't provide any code to work on? The code that you post above is not really helping. simpan file php tersebut pada directory localhost anda. di sini saya membuat file dengan nama koneksi.php. caranya buatlah sebuah file php dengan nama nya terserah teman-teman. So for instance I log in as and go to my account page, then a php form will search the database which holds all the video information and find which videos have saved with them, and then display those results onto my account page. Setelah teman-teman selesai membuat database seperti yang saya intruksikan di atas, selanjutnya baru kita mulai membuat koneksi database php dan mysql. So I need the code to find the email of the current user logged in and search that email in the other database table, and then bring up the results onto the webpage. What I want to do is allow the users to go to a account page and have it display what videos they have uploaded. About this but I forgot to mention why I need the database tables to link, I have already created a login for when users visit my site, once these users are logged in they can upload videos, I have a table for the users when they login, and I have a table for when users upload videos, The table that uploads videos saves the video name given by the user, users email and the real videos name.