Shoutbox

code:

---

title_query($id)

---

code:

---

Database   ----->    title_query($id)
          <-----
          ------>  Output on the website

---

quote:

---

Originally posted by Lee Jeffery
i dont get why you need to insert it and get it back out again, if youre inserting it you obviously have it in a variable so why not just output it normally?

---

quote:

---

Originally posted by Ezra
That's not really what I mean, and yes I use MySql.

I'll try to explain better

In my database I type title_query(3), in my code I query the info from the database to the page, but before it ouputs the data to the website I want title_query($id) to be executed.

---

code:

---

$link = mysql_connect('mysql_host', 'mysql_user', 'mysql_password')
   or die('Could not connect: ' . mysql_error());
echo 'Connected successfully';
mysql_select_db('my_database') or die('Could not select database');
$query = 'SELECT * FROM my_table';
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
mysql_close($link);

---

code:

---

function title_query($id){
global $title;
$title = mysql_fetch_array(mysql_query("SELECT `title` FROM `imdb_data_title` WHERE id=".$id));
echo $title['0'];
}

---

code:

---

<?php
$id = $HTTP_GET_VARS['id'];
function query_db(){
global $id;
$query_q = mysql_query("SELECT * FROM imdb_data_title WHERE id = '$id'");
while($query_row = mysql_fetch_array($query_q)){
$output = ('<b>Title/b> <i>' . $query_row['title'] . '</i><b> Yearb> <i>' . $query_row['year'] . '</i>');
}
return $output;
}

echo('' . query_db() . '');

---