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.

Your Answer:

Login to answer

Other forums

private constructor
Hello,

Can we create a constructor as private? If yes, what is the use of it? If no, why can'

Request for tunning the below query
Hi,

Can any one help me on the below query while improving the performance,

error reporting
hey everyone

I have a production server in which I want error reporting but only on some page

need good snippet manager
Hi. as i am coding and learning more, it is becoming difficult to manage code snippets. how you mana

Multi-user card game
I'm writing a batch of games and such. Lottery is finished, Poker,blackjack,etc are next. They will

issues verifying if user is logged in
I am having issues when a user logs in via asp Login control, the IsAuthenticated still seems to com

help with image text
Hi ...

see i need the text of the name and number to start in the center and always be in the

Undefined variable when using $_SERVER['PHP_SELF']
Hi guyz, please suggest me something...
On first.php I have one input field NAME, and on posting

NOOB needs help with upload file
The intent of this form is to create a folder for a client and upload an image into another folder '

Calling All PHPFREAKS Blackberry Users
Are you a member of PHPFreaks and have a blackberry? Well RIM just recently released Blackberry Mes