Re: World Weather Block

[Crip]

1 way to find out is, install the script..so I'll let you know..

Aku -?
this isn't not related to weather block..
Do you know PHPMYSQL fairly good?  .. I need to add a custom Table on my smf Themes Demo Viewer - [Theme=name Theme=ID]??

[akulion]

oh im terrible at that stuff
its best u ask jp, ja or thurnok

also be sure to check there arent similarlynamed tables :up:

[JPDeni]

What do you need, exactly, crip? I make new tables all the time.

[Crip]

Hi JP,
I really I'm not sure of the code or whatever, but maybe you can look at Gaia's SMF Theme viewer and see if you can tell by it..she was suppose to help me out..but, no pm yet..
http://mysmfthemes.com/theme_viewer.php

It's in Frames, a top.php and a theme_viewer.php -=- and a script to call theme;name;theme;id; ?
some code I think?

Code Select Expand

<?php

//
// This is the top of the demo
// Has a dropdown box of all the themes
// People can choose which theme they want to view
// And the theme changes in the bottom frame
//
// v1.0
// April 2006
//

include("mysql.php");

$result = mysql_query("SELECT demo_id,name FROM files ORDER BY id DESC") or die(mysql_error());

while ( $file = mysql_fetch_array($result) ) {
  
  $list .= '<option value="'.$file['demo_id'].'">'.$file['name'].'</option>';
  
}

mysql_close();

?>
I appericate any help.

[JPDeni]

Go to phpMyAdmin and select your database. You should have a list of all of your tables on the left side of your screen and a bunch of text tab things across the top on the right side, followed by another list of all of your tables. Scroll down to the very bottom of the list and you should see

Create a new table on database [the name of your database]

In the "Name" field, type files and in the "Number of fields" field, type 3.

Click the "Go" button that's to the far right of the screen.

Now you'll have three rows of input boxes.

In the first row, under "Field", type id. In the "Type" field, select INT. Go over to the "Extra" field and select auto_increment and then click in the radio button under the column that has the picture of the key in it. Leave the rest as they are.

In the second row, under "Field" type demo_id. In the "Type" field, select INT. You don't have to change anything else in the row.

In the third row, under "Field," type name and in the "Type" field, select tinytext. You don't have to change anything else in the row.

Those are the fields. Now you have to figure out what to put in them.

[Crip]

Thank you JP..
I'm going to try that now..if I have problems may i contact you for assistance?

[JPDeni]

You bet. I don't think you'll have a problem, but if you do, just holler.

[Crip]

Now do I click save or Go?

[Crip]

Save) i reckon..seems logical

[JPDeni]

Sorry. I forgot to continue with it.

Click "Save."

You figured it out.  "Go" would add another field