conveting

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

gaogier
Forum Contributor
Posts: 391
Joined: Wed Mar 02, 2005 1:02 pm
Location: Portsmouth, UK
Contact:

conveting

Post by gaogier »

im not 100% sure on how i can do this, but i need to be able to convert one script, so it works the same way, but less info on it.

instead of
Quest Name:
Guide Written by:
Quest Description:
Quest Length:
Quest Difficulty:
Requirements:
Items:
Members?: Use Y or N only
Starting Location: Please be sure to get it exact.
Main Guide: When including, bold, italics, images etc. Please use HTML
Reward:
Sort Name: This is the name of the quest without spaces or the leading "The" if it has one.
it only needs
Quest Name:
Guide Written by:
Members?: Use Y or N only
Main Guide: When including, bold, italics, images etc. Please use HTML
the php code for the first one

Code: Select all

<?php
include('header.inc');

function questview($id) {

require_once ('../mysql_connect.php');//connect to db
 /* query for item */
    $query = "SELECT * FROM quest WHERE id=$id";
    $result = mysql_query ($query);
    
    /* if we get no results back, error out */
$numrtn = mysql_num_rows($result);

    if ($numrtn == 0) {
        echo "The quest guide requested cannot be found\n";
		echo $id;
        return;
    }
    $row = mysql_fetch_assoc($result);
    /* easier to read variables and 
     * striping out tags */
	$id = $row['id'];
    $name = $row['name'];
    $contributors = $row['contributors'];
    $guideby = $row['guideby'];
    $added = $row['added'];
    $location = $row['startinglocation'];
    $members = $row['members'];
    $description = $row['description'];
    $difficulty = $row['difficulty'];
    $requirements = $row['requirements'];
    $items = $row['items'];
	$reward = $row['reward'];
	$guide = $row['mainbody'];
	$length = $row['length'];
	$updated = $row['updated'];
	if ($members == "Y") {
		$mem = "members only quest</b>, so it can only be done on a <b>members</b> server.";
	}else{
		$mem = "non-members quest</b>.";
	}
	if ($updated == 0){
	$up = 'No-one has updated this quest guide';	
	}else{	
	$date2 = date("l jS of F Y @ H:i:s ", $updated);
	$up = 'It was last updated on '.$date2;
	}
	if ($contributors != ""){
	$con = 'Thanks also to <b>'.$contributors.'</b> for changes.';	
	}else{
	$con = 'No-one else has contributed to this quest guide.';
	}
	//$date = date("D M jS, Y g:i a", $added);
	$date = date("l jS of F Y @ H:i:s ", $added);
	
echo '
<div id="quest">
<p><span class="questheader"><center>'.$name.'</center></span></p>
<p class="text">This quest guide was written by <b>'.$guideby.'</b> for use on Runehints and entered into the database on '.$date.'. '.$up.'. '.$con.'  <br /></p>
<p><span class="text"><br />This quest is <b>'.$mem.'</span></p>
<p>
<span class="qtitle">Description: </span><span class="text">'.$description.'</span></p>
<p><span class="qtitle">Difficulty Level: </span><span class="text">'.$difficulty.'</span></p>
<p>
<span class="qtitle">Requirements: </span><span class="text">'.$requirements.'</span></p>

<p>
<span class="qtitle">Items Needed During Quest: </span><span class="text">'.$items.'</span></p>
<p>
<span class="qtitle">Starting Location: </span><span class="text">'.$location.'</span></p>
  <p><span class="qtitles">Quest Instructions:</span></p>
  <span class="text">
  <p>'.$guide.'</p>
  </span>

<p>
<span class="qtitle">Reward: </span><span class="text">'.$reward.'</span></p>
  </div> ';
}

function selectquest(){

require_once ('../mysql_connect.php');//connect to db
global $sitestyle;
	?>
    <table border="0" cellpadding="0" cellspacing="0" width="100%">
	<tr>
	<td bgcolor="#000000" align="center" border="0" cellpadding="0" cellspacing="0" valign="top">
	
	
  <table border="0" cellpadding="0" cellspacing="0" width="100%">
        <tr>
          <td background="images/<?php echo $sitestyle.'_'; ?>tabletopl.jpg" height="25" width="30"></td>
          <td background="images/<?php echo $sitestyle.'_'; ?>tabletopm.jpg" height="25"><div align="center"><font class="text"><b>Non-member's Quests</b></font></div></td>
          <td background="images/<?php echo $sitestyle.'_'; ?>tabletopr.jpg" height="25" width="30"></td>
           </tr>
      </table>
             <table border="0" cellpadding="0" cellspacing="0" width="100%">
        <tr>
          <td background="images/<?php echo $sitestyle.'_'; ?>tablemidl.jpg" width="16"></td>
          <td bgcolor="#000000" align="left" border="0" cellpadding="0" cellspacing="0">
		  <table border="0" cellpadding="0" cellspacing="0" width="100%">
		  <?php
		  
		      /* query for quests */
        $n_query = "SELECT id, name, guideby, members, sorter FROM quest WHERE members='n' ORDER BY sorter ASC";
    
        $n_result = mysql_query ($n_query);
	    while ($n_row = mysql_fetch_assoc($n_result)) {
        $n_name = $n_row['name'];  
		$n_guideby = $n_row['guideby'];
		$id = $n_row['id'];
        /* place table row data in 
         * easier to use variables.
         * & display the data */
       echo '<tr><td width=100%><b><a href="quest.php?flibble=questview&id='.$id.'&ic=1">'.$n_name.'</a></b></td><td><font class=small>'.$n_guideby.'</font></td></tr>'; 
    }
        /* finish up table*/
		?>
		</table>
		</td>
          <td background="images/<?php echo $sitestyle.'_'; ?>tablemidr.jpg" width="16"></td>
          </tr>
          </table>
      
      <table border="0" cellpadding="0" cellspacing="0" width="100%">
       <tr>
                          <td width="16"><img src="images/<?php echo $sitestyle.'_'; ?>tablebottoml.jpg" height="13" width="16"></td>
                          <td background="images/<?php echo $sitestyle.'_'; ?>tablebottomm.jpg" height="13"><img src="images/<?php echo $sitestyle.'_'; ?>tablebottomm.jpg" height="13" width="1"></td>
                          <td width="16"><img src="images/<?php echo $sitestyle.'_'; ?>tablebottomr.jpg" height="13" width="16"></td>
        </tr>
      </table>
	</td>  
	
	<td width="16"></td>
	
	<td bgcolor="#000000" align="center" border="0" cellpadding="0" cellspacing="0" valign="top">
	
  <table border="0" cellpadding="0" cellspacing="0" width="100%">
        <tr>
          <td background="images/<?php echo $sitestyle.'_'; ?>tabletopl.jpg" height="25" width="30"></td>
          <td background="images/<?php echo $sitestyle.'_'; ?>tabletopm.jpg" height="25"><div align="center"><font class="text"><b>Member's Quests</b></font></div></td>
          <td background="images/<?php echo $sitestyle.'_'; ?>tabletopr.jpg" height="25" width="30"></td>
           </tr>
      </table>
             <table border="0" cellpadding="0" cellspacing="0" width="100%">
        <tr>
          <td background="images/<?php echo $sitestyle.'_'; ?>tablemidl.jpg" width="16"></td>
          <td bgcolor="#000000" align="left" border="0" cellpadding="0" cellspacing="0">
		  <table border="0" cellpadding="0" cellspacing="0" width="100%">
		  <?php

    /* query for quests */
        $y_query = "SELECT id, name, guideby, members, sorter FROM quest WHERE members='y' ORDER BY sorter ASC";
    $y_result = mysql_query ($y_query);
	    while ($y_row = mysql_fetch_assoc($y_result)) {
        $y_name = $y_row['name'];  
		$y_guideby = $y_row['guideby'];
		$yid = $y_row['id'];

        /* place table row data in 
         * easier to use variables.
         * & display the data */

        echo '<tr><td width=100%><b><a href="quest.php?flibble=questview&id='.$yid.'&ic=1">'.$y_name.'</a></b></td><td><font class=small>'.$y_guideby.'</font><br /></td></tr>'; 
}

        /* finish up table*/?>
		</table>	
		</td>
          <td background="images/<?php echo $sitestyle.'_'; ?>tablemidr.jpg" width="16"></td>
          </tr>
          </table>
      
      <table border="0" cellpadding="0" cellspacing="0" width="100%">
       <tr>
                          <td width="16"><img src="images/<?php echo $sitestyle.'_'; ?>tablebottoml.jpg" height="13" width="16"></td>
                          <td background="images/<?php echo $sitestyle.'_'; ?>tablebottomm.jpg" height="13"><img src="images/<?php echo $sitestyle.'_'; ?>tablebottomm.jpg" height="13" width="1"></td>
                          <td width="16"><img src="images/<?php echo $sitestyle.'_'; ?>tablebottomr.jpg" height="13" width="16"></td>
        </tr>
      </table>
	  
	  
	  	  </td></tr></table>
		  <?php
	}
	
	
	switch($_GET['flibble']) {
    
	case 'selectquest':
		selectquest();
		break;
	case 'questview':
		questview($_GET['id']);
		break;		
    default:
        selectquest();
}
	
include('footer.inc');
	?>
would the second one work with this php?

Code: Select all

<?php
include('header.inc');
?>
<?

function skillview($id) {


require_once ('../mysql_connect.php');//connect to db
 /* query for item */
    $query = "SELECT * FROM skill WHERE id=$id";
    $result = mysql_query ($query);
    
    /* if we get no results back, error out */
$numrtn = mysql_num_rows($result);

    if ($numrtn == 0) {
        echo "The Skill guide requested cannot be found\n";
        echo $id;
        return;
    }
    $row = mysql_fetch_assoc($result);
    /* easier to read variables and 
     * striping out tags */
    $id = $row['id'];
    $name = $row['name'];
    $contributors = $row['contributors'];
    $guideby = $row['guideby'];
    $added = $row['added'];
    $members = $row['members'];
        $guide = $row['mainbody'];
    $updated = $row['updated'];
    if ($members == "Y") {
        $mem = "members only Skill</b>, so it can only be done on a <b>members</b> server.";
    }else{
        $mem = "non-members Skill</b>.";
    }
    if ($updated == 0){
    $up = 'No-one has updated this skill guide';    
    }else{    
    $date2 = date("l jS of F Y @ H:i:s ", $updated);
    $up = 'It was last updated on '.$date2;
    }
    if ($contributors != ""){
    $con = 'Thanks also to <b>'.$contributors.'</b> for changes.';    
    }else{
    $con = 'No-one else has contributed to this Skill guide.';
    }
    //$date = date("D M jS, Y g:i a", $added);
    $date = date("l jS of F Y @ H:i:s ", $added);
    
echo '

<div id="skill">
<p><span class="skillheader"><center>'.$name.'</center></span></p>
<p class="text">This skill guide was written by <b>'.$guideby.'</b> for use on Runehints and entered into the database on '.$date.'. '.$up.'. '.$con.'  <br /></p>
<p><span class="text"><br />This skill is <b>'.$mem.'</span></p>
<p>
  <p><span class="qtitles">Skill Guide:</span></p>
  <span class="text">
  <p>'.$guide.'</p>
  </span>

  </div> ';
}

function selectskill(){

require_once ('../mysql_connect.php');//connect to db
global $sitestyle;
    ?>
    <table border="0" cellpadding="0" cellspacing="0" width="100%">
    <tr>
    <td bgcolor="#000000" align="center" border="0" cellpadding="0" cellspacing="0" valign="top">
    
    
  <table border="0" cellpadding="0" cellspacing="0" width="100%">
        <tr>
          <td background="images/<?php echo $sitestyle.'_'; ?>tabletopl.jpg" height="25" width="30"></td>
          <td background="images/<?php echo $sitestyle.'_'; ?>tabletopm.jpg" height="25"><div align="center"><font class="text"><b>Non-member's Skills</b></font></div></td>
          <td background="images/<?php echo $sitestyle.'_'; ?>tabletopr.jpg" height="25" width="30"></td>
           </tr>
      </table>
             <table border="0" cellpadding="0" cellspacing="0" width="100%">
        <tr>
          <td background="images/<?php echo $sitestyle.'_'; ?>tablemidl.jpg" width="16"></td>
          <td bgcolor="#000000" align="left" border="0" cellpadding="0" cellspacing="0">
          <table border="0" cellpadding="0" cellspacing="0" width="100%">
          <?php
          
              /* query for skills */
        $n_query = "SELECT id, name, guideby, members, sorter FROM skill WHERE members='n' ORDER BY sorter ASC";
    
        $n_result = mysql_query ($n_query);
        while ($n_row = mysql_fetch_assoc($n_result)) {
        $n_name = $n_row['name'];  
        $n_guideby = $n_row['guideby'];
        $id = $n_row['id'];
        /* place table row data in 
         * easier to use variables.
         * & display the data */
       echo '<tr><td width=100%><b><a href="skills.php?flibble=skillview&id='.$id.'&ic=1">'.$n_name.'</a></b></td><td><font class=small>'.$n_guideby.'</font></td></tr>'; 
    }
        /* finish up table*/
        ?>
        </table>
        </td>
          <td background="images/<?php echo $sitestyle.'_'; ?>tablemidr.jpg" width="16"></td>
          </tr>
          </table>
      
      <table border="0" cellpadding="0" cellspacing="0" width="100%">
       <tr>
                          <td width="16"><img src="images/<?php echo $sitestyle.'_'; ?>tablebottoml.jpg" height="13" width="16"></td>
                          <td background="images/<?php echo $sitestyle.'_'; ?>tablebottomm.jpg" height="13"><img src="images/<?php echo $sitestyle.'_'; ?>tablebottomm.jpg" height="13" width="1"></td>
                          <td width="16"><img src="images/<?php echo $sitestyle.'_'; ?>tablebottomr.jpg" height="13" width="16"></td>
        </tr>
      </table>
    </td>  
    
    <td width="16"></td>
    
    <td bgcolor="#000000" align="center" border="0" cellpadding="0" cellspacing="0" valign="top">
    
  <table border="0" cellpadding="0" cellspacing="0" width="100%">
        <tr>
          <td background="images/<?php echo $sitestyle.'_'; ?>tabletopl.jpg" height="25" width="30"></td>
          <td background="images/<?php echo $sitestyle.'_'; ?>tabletopm.jpg" height="25"><div align="center"><font class="text"><b>Member's Skills</b></font></div></td>
          <td background="images/<?php echo $sitestyle.'_'; ?>tabletopr.jpg" height="25" width="30"></td>
           </tr>
      </table>
             <table border="0" cellpadding="0" cellspacing="0" width="100%">
        <tr>
          <td background="images/<?php echo $sitestyle.'_'; ?>tablemidl.jpg" width="16"></td>
          <td bgcolor="#000000" align="left" border="0" cellpadding="0" cellspacing="0">
          <table border="0" cellpadding="0" cellspacing="0" width="100%">
          <?php

    /* query for skills */
        $y_query = "SELECT id, name, guideby, members, sorter FROM skills WHERE members='y' ORDER BY sorter ASC";
    $y_result = mysql_query ($y_query);
        while ($y_row = mysql_fetch_assoc($y_result)) {
        $y_name = $y_row['name'];  
        $y_guideby = $y_row['guideby'];
        $yid = $y_row['id'];

        /* place table row data in 
         * easier to use variables.
         * & display the data */

        echo '<tr><td width=100%><b><a href="skills.php?flibble=skillview&id='.$yid.'&ic=1">'.$y_name.'</a></b></td><td><font class=small>'.$y_guideby.'</font><br /></td></tr>'; 
}

        /* finish up table*/?>
        </table>    
        </td>
          <td background="images/<?php echo $sitestyle.'_'; ?>tablemidr.jpg" width="16"></td>
          </tr>
          </table>
      
      <table border="0" cellpadding="0" cellspacing="0" width="100%">
       <tr>
                          <td width="16"><img src="images/<?php echo $sitestyle.'_'; ?>tablebottoml.jpg" height="13" width="16"></td>
                          <td background="images/<?php echo $sitestyle.'_'; ?>tablebottomm.jpg" height="13"><img src="images/<?php echo $sitestyle.'_'; ?>tablebottomm.jpg" height="13" width="1"></td>
                          <td width="16"><img src="images/<?php echo $sitestyle.'_'; ?>tablebottomr.jpg" height="13" width="16"></td>
        </tr>
      </table>
      
      
            </td></tr></table>
          <?php
    }
    
    
    switch($_GET['flibble']) {
    
    case 'selectskill':
        selectskill();
        break;
    case 'skillview':
        skillview($_GET['id']);
        break;        
    default:
        selectskill();
}
    
include('footer.inc');
    ?>

please not that the second one has not been connected to a database yet
Last edited by gaogier on Mon Mar 06, 2006 2:40 pm, edited 1 time in total.
septer 1
Forum Newbie
Posts: 2
Joined: Mon Mar 06, 2006 1:05 pm

Post by septer 1 »

The code gives this error:

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/gaogier/public_html/skills.php:1) in /home/gaogier/public_html/header.inc on line 3
gaogier
Forum Contributor
Posts: 391
Joined: Wed Mar 02, 2005 1:02 pm
Location: Portsmouth, UK
Contact:

Post by gaogier »

the error is now fix, got this error

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/gaogier/public_html/skills.php on line 142
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

throw some mysql_error() calls when the query fails to see what the deal is.
gaogier
Forum Contributor
Posts: 391
Joined: Wed Mar 02, 2005 1:02 pm
Location: Portsmouth, UK
Contact:

Post by gaogier »

the problem has now been fixed, accept, a few little things

Unknown column 'sorter' in 'field list'

January 1970 @ 01:00:00 (a guide was entered)

the heading is not the same as it should be big and have colour

the whole page should look like this

http://runehints.com/quest.php?flibble= ... id=72&ic=1

instead it looks like this

http://runehints.com/skills.php?flibble ... &id=1&ic=1
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

there are four references to "sorter" in your code, to three tables: skill, skills, and quest. Is it a column in each of those tables?
gaogier
Forum Contributor
Posts: 391
Joined: Wed Mar 02, 2005 1:02 pm
Location: Portsmouth, UK
Contact:

Post by gaogier »

where is the table "quest" i dont see it
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

they are both in the first php code you posted. $n_query and $y_query
gaogier
Forum Contributor
Posts: 391
Joined: Wed Mar 02, 2005 1:02 pm
Location: Portsmouth, UK
Contact:

Post by gaogier »

the first php code is the first script, which works fine, but i tried to use that script to make it so that i can modify it so it can be used for other guides which is what you can see in the second script, but now, i had come accross some problems,

which i need help on
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

post the table creation code that phpMyAdmin would run :idea:
gaogier
Forum Contributor
Posts: 391
Joined: Wed Mar 02, 2005 1:02 pm
Location: Portsmouth, UK
Contact:

Post by gaogier »

im confused
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

I would like to see the "create table blah blah" for each of the tables involved.
gaogier
Forum Contributor
Posts: 391
Joined: Wed Mar 02, 2005 1:02 pm
Location: Portsmouth, UK
Contact:

Post by gaogier »

i think you mean

Code: Select all

<table border="0" cellpadding="0" cellspacing="0" width="100%">
    <tr>
    <td bgcolor="#000000" align="center" border="0" cellpadding="0" cellspacing="0" valign="top">
    
    
  <table border="0" cellpadding="0" cellspacing="0" width="100%">
        <tr>
          <td background="images/<?php echo $sitestyle.'_'; ?>tabletopl.jpg" height="25" width="30"></td>
          <td background="images/<?php echo $sitestyle.'_'; ?>tabletopm.jpg" height="25"><div align="center"><font class="text"><b>Non-member's Skills</b></font></div></td>
          <td background="images/<?php echo $sitestyle.'_'; ?>tabletopr.jpg" height="25" width="30"></td>
           </tr>
      </table>
             <table border="0" cellpadding="0" cellspacing="0" width="100%">
        <tr>
          <td background="images/<?php echo $sitestyle.'_'; ?>tablemidl.jpg" width="16"></td>
          <td bgcolor="#000000" align="left" border="0" cellpadding="0" cellspacing="0">
          <table border="0" cellpadding="0" cellspacing="0" width="100%">
          <?php
          
              /* query for skills */
        $n_query = "SELECT id, name, guideby, members, sorter FROM skill WHERE members='n' ORDER BY sorter ASC";
    
        $n_result = mysql_query ($n_query);
        while ($n_row = mysql_fetch_assoc($n_result)) {
        $n_name = $n_row['name'];  
        $n_guideby = $n_row['guideby'];
        $id = $n_row['id'];
        /* place table row data in 
         * easier to use variables.
         * & display the data */
       echo '<tr><td width=100%><b><a href="skills.php?flibble=skillview&id='.$id.'&ic=1">'.$n_name.'</a></b></td><td><font class=small>'.$n_guideby.'</font></td></tr>'; 
    }
        /* finish up table*/
        ?>
        </table>
        </td>
          <td background="images/<?php echo $sitestyle.'_'; ?>tablemidr.jpg" width="16"></td>
          </tr>
          </table>
      
      <table border="0" cellpadding="0" cellspacing="0" width="100%">
       <tr>
                          <td width="16"><img src="images/<?php echo $sitestyle.'_'; ?>tablebottoml.jpg" height="13" width="16"></td>
                          <td background="images/<?php echo $sitestyle.'_'; ?>tablebottomm.jpg" height="13"><img src="images/<?php echo $sitestyle.'_'; ?>tablebottomm.jpg" height="13" width="1"></td>
                          <td width="16"><img src="images/<?php echo $sitestyle.'_'; ?>tablebottomr.jpg" height="13" width="16"></td>
        </tr>
      </table>
    </td>  
    
    <td width="16"></td>
    
    <td bgcolor="#000000" align="center" border="0" cellpadding="0" cellspacing="0" valign="top">
    
  <table border="0" cellpadding="0" cellspacing="0" width="100%">
        <tr>
          <td background="images/<?php echo $sitestyle.'_'; ?>tabletopl.jpg" height="25" width="30"></td>
          <td background="images/<?php echo $sitestyle.'_'; ?>tabletopm.jpg" height="25"><div align="center"><font class="text"><b>Member's Skills</b></font></div></td>
          <td background="images/<?php echo $sitestyle.'_'; ?>tabletopr.jpg" height="25" width="30"></td>
           </tr>
      </table>
             <table border="0" cellpadding="0" cellspacing="0" width="100%">
        <tr>
          <td background="images/<?php echo $sitestyle.'_'; ?>tablemidl.jpg" width="16"></td>
          <td bgcolor="#000000" align="left" border="0" cellpadding="0" cellspacing="0">
          <table border="0" cellpadding="0" cellspacing="0" width="100%">
          <?php

    /* query for skills */
        $y_query = "SELECT id, name, guideby, members, sorter FROM skills WHERE members='y' ORDER BY sorter ASC";
    $y_result = mysql_query ($y_query);
        while ($y_row = mysql_fetch_assoc($y_result)) {
        $y_name = $y_row['name'];  
        $y_guideby = $y_row['guideby'];
        $yid = $y_row['id'];

        /* place table row data in 
         * easier to use variables.
         * & display the data */

        echo '<tr><td width=100%><b><a href="skills.php?flibble=skillview&id='.$yid.'&ic=1">'.$y_name.'</a></b></td><td><font class=small>'.$y_guideby.'</font><br /></td></tr>'; 
}

        /* finish up table*/?>
        </table>    
        </td>
          <td background="images/<?php echo $sitestyle.'_'; ?>tablemidr.jpg" width="16"></td>
          </tr>
          </table>
      
      <table border="0" cellpadding="0" cellspacing="0" width="100%">
       <tr>
                          <td width="16"><img src="images/<?php echo $sitestyle.'_'; ?>tablebottoml.jpg" height="13" width="16"></td>
                          <td background="images/<?php echo $sitestyle.'_'; ?>tablebottomm.jpg" height="13"><img src="images/<?php echo $sitestyle.'_'; ?>tablebottomm.jpg" height="13" width="1"></td>
                          <td width="16"><img src="images/<?php echo $sitestyle.'_'; ?>tablebottomr.jpg" height="13" width="16"></td>
        </tr>
      </table>
      
      
            </td></tr></table>
it may have some php in it, but its all there and it could have one or 2 many tags
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

I meant exactly as I said it, I want to see the CREATE TABLE SQL code.
gaogier
Forum Contributor
Posts: 391
Joined: Wed Mar 02, 2005 1:02 pm
Location: Portsmouth, UK
Contact:

Post by gaogier »

this?

SELECT * FROM `skill` WHERE 1`id`, `name`, `added`, `guideby`, `contributors`, `members`, `mainbody`, `updated`, `sorter`

or you want how the code actualy creates the table?

if so, can you explain on how i do this?
Post Reply