PHP/Database issue
Posted on
16th Feb 2014 07:03 pm by
admin
My friend is helping me make a database where you go to a certain webpage of my site and the page will use code to pull information from a database and display it on the page in a formatted way.
Code: [Select]<?
function parse($content){
$string = $content;
/* Use <b> to split the string */
$tok = strtok($string, "<b>");
while ($tok !== false) {
$get = "SELECT Name FROM * WHERE Name = '$tok'";
$getsql = mysql_query($get);
if (!$getsql)
{
$type ="";
}
else {
$table = mysql_field_table($getsql);
$type = $table;
}
if (!$type){
$link = $tok;
}
elseif ($type == "quest"){
$link = "<a href='viewlocation.php?location_name=$tok'>$tok</a>";
}
elseif ($type == "item"){
$link = "<a href='viewlocation.php?location_name=$tok'>$tok</a>";
}
else {
$link = $tok;
}
echo $link;
$tok = strtok("</b>");
}}
?>
My friend explains the issue as follows:
QuoteBasically the script uses the tok to split the string up, then im trying to get it to check the whole database name fields for the split.
Then if it finds it, its supposed to get the table name its in and passes it to the if statement.
It splits the string into sections then searches the database for the sections by looking in a specific field over all tables
Then when its found it takes the table it found it in and get the name of the table which gets passed to the if statement which decides which link it will give to the end of the code which gets returned.
But its not doing the search in the database properly and not getting the table name to pass to the if statement to work out the link to give it.
No comments posted yet
Your Answer:
Login to answer
174
54
Other forums
Get relative path from absolute path
How would one go about getting the relative path to a file from its absolute path?
Giving the below syntax error
Dear Experts,
I have used 2 buttons in gui status as display and cjhange.When the user wi
need help with date function
i have following form for date
Code: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01
trim function issues
Hi guys, total noob here...
So I've been tinkering around with a html and am using php to em
Allowing ' and "
Hello everyone,
I am creating a form where users submit information to go into a database. I
Trouble verifying database password
Thankyou to everyone who responded to my last post (I can't find the posting, it has been buried). <
how can i make a .gif images for my site
Dear Friends ,
Pls solve my problem , I am starting making new site but i dont know how can i
Undefined Index Notice In Internet Explorer Only
I am getting the following notice:
QuoteNotice: Undefined index: jrox in /home/ycsn/public_h
First root of a number
Hi,
I can't find any function in php to give me the first root of a number.
Is there any
Sorting JTable on more than just the values listed in the columns
I have a collection of objects that store (among other things) two integer values. I only want to di