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

subtract 1 from value entered in text field
Hi

How do I subtract 1 from the vaue entered into a text field?

Thanks

Hits this week counter
I have a counter on my site that tracks hits, IP's, etc. into a mySQL database. It also includes the

Transform value 0 in no and 1 in yes help needed
Hello,
I have this in the table: "value" type int 0 to represent false and 1 to represe

Conditions of info record - Error
When i created GR (901) and PO create automatic my PBXX is obtain the net price of info record but

How to get exact 3 moths post date from today date using javascript
How to get exact 3 moths post date from today date using javascript
Please help

Code clarification
Hi

In the following code what could be the "search_print()" and where it could be

PECL uploadprogress for php5.2
Hey, I just installed PHP5 via .htaccess on my 1and1 Shared Hosting Account.

How would I exac

php + mysql count consecutive data
I have a database of values and I want to work out how to display them if the values match a consecu

Request for tunning the below query
Hi,

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

BB_Code error
I'm having a problem with a custom built function and keep getting this error:


Warning: M