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

Need help with basic sql
Hi,

I am using oracle 10g, and having some small doubts related to sql , here goes the si

Reduce redundancies in switch functions?
Hello all! I somewhat new to PHP, and was wondering if anyone could give some suggestions on a swit

Sending UDP Raw socket
I truly need help on this. I am trying to write a test program that simulate a network environment

simple script won't work. Please help
I'm new to php, and I am having trouble displaying a simple script in my web browser. My php code ex

Create comparison matrix?
I want to create a comparison script for forum software and was wondering is there any tutorial or b

Weird MySQL error, why am I recieving this?
PHP Code:


<?php require "global_settings.php"; ?>
<titl

Help with usergroups? prolly really quick
So were coding our own forums for a game system we made an we have the users level setup but now I n

drop-down with sub-category appear
Hello,

i know how to build a simple dro-down list, im looking for a code when im gonna choose

PHP Programming error. Please help!
Hi there,

Am making a website for a friend and have encountered a problem that i need fixing

calendar dates and hours compare problem
i have a calendar in wordpress, everything works great except that i can make 2 meetings at the same