Posts by PixelStores

382 posts
  • Had an item that became a weekly top seller
  • Elite Author: Sold more than $75,000 on Envato Market
  • Has sold $125,000+ on Envato Market
  • Located in New Zealand
+6 more
PixelStores
says

Hey,

I recently came across some bookmarks regarding custom_metabox for Wordpress that i found very useful.

http://www.delicious.com/thecorkboard/custom_metabox

Matt :)

382 posts
  • Had an item that became a weekly top seller
  • Elite Author: Sold more than $75,000 on Envato Market
  • Has sold $125,000+ on Envato Market
  • Located in New Zealand
+6 more
PixelStores
says

Yes i get this to, its the opening and closing of the php tags, i’m surprised no one has mentioned this before.

@ivanov Hey man, i like your theme, Plastic. Why has it got such a low rating I think it deserves alot better :)

382 posts
  • Had an item that became a weekly top seller
  • Elite Author: Sold more than $75,000 on Envato Market
  • Has sold $125,000+ on Envato Market
  • Located in New Zealand
+6 more
PixelStores
says

Hey,

Cheers guys for the help :) originally i was going to create a new table for each submission if you like, but over time there will be alot of tables, i also realized you can pull rows from a MYSQL table using’ SELECT ’ and ‘WHERE’ this leads to my next question…

So i have created a table with different columns and i want to display a row using this code:

$result = mysql_query("SELECT Name, Surname, Item_1, Item_2 FROM mytable WHERE Name ='Peter';") 
or die(mysql_error());  

echo "<table border="1">";
echo "<tr> <th>Name</th> <th>Surname</th> <th>Item 1</th> <th>Item 2</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
    // Print out the contents of each row into a table
    echo "<tr><td>"; 
    echo $row['Name'];
    echo "</td><td>";
        echo $row['Surname'];
    echo "</td><td>"; 
        echo $row['Item_1'];
    echo "</td><td>"; 
    echo $row['Item_2'];
    echo "</td></tr>"; 
} 
echo "</table>";

Ok, so the code above works well, however some of the columns such as Item_2 will be empty, how do i display the table without the column if the field is empty and show if something is there?

Hope this makes sense :)

Look forward to your reply.

382 posts
  • Had an item that became a weekly top seller
  • Elite Author: Sold more than $75,000 on Envato Market
  • Has sold $125,000+ on Envato Market
  • Located in New Zealand
+6 more
PixelStores
says

Hello,

I know this code can create a table named “mytable” in the database:

mysql_query("CREATE TABLE mytable(
id INT NOT NULL AUTO_INCREMENT, 
PRIMARY KEY(id),
 name VARCHAR(30), 
 size VARCHAR(30), 
 age INT)")
 or die(mysql_error());  

echo "Table Created!";

I was wondering if i can use a variable to replace “mytable” in the code above, like this:


$var_name ="mytable";

mysql_query("CREATE TABLE $var_name(
id INT NOT NULL AUTO_INCREMENT, 
PRIMARY KEY(id),
 name VARCHAR(30), 
 size VARCHAR(30), 
 age INT)")
 or die(mysql_error());  

echo "Table Created!";

Will this work?

Cheers

382 posts
  • Had an item that became a weekly top seller
  • Elite Author: Sold more than $75,000 on Envato Market
  • Has sold $125,000+ on Envato Market
  • Located in New Zealand
+6 more
PixelStores
says

Yep, sorry guys a bit hard to explain.

I’m using this code, the one with the hover state:

http://www.noobcube.com/wp-content/uploads/demos/073109-cssimagemaps/demo/

What i’m trying to accomplish is when a user clicks on the certain part of the map, the continent stays highlighted.

Any ideas? :)

382 posts
  • Had an item that became a weekly top seller
  • Elite Author: Sold more than $75,000 on Envato Market
  • Has sold $125,000+ on Envato Market
  • Located in New Zealand
+6 more
PixelStores
says

Hey,

I have a list in HTML and some CSS that displays images, the images use one image and simply changes the background position for the hover state.

I want to know if when a user clicks one of the list items the hover state would be set to selected.

I know in form fields you can set the focus, can this be done with a list of links that are images with HTML and CSS .

Perhaps some jquery is involved, some direction would be grateful. :)

Thanks.

382 posts
  • Had an item that became a weekly top seller
  • Elite Author: Sold more than $75,000 on Envato Market
  • Has sold $125,000+ on Envato Market
  • Located in New Zealand
+6 more
PixelStores
says

ThemeForest has helped me travel around Australia for the last nine months, Thankyou TF :)

382 posts
  • Had an item that became a weekly top seller
  • Elite Author: Sold more than $75,000 on Envato Market
  • Has sold $125,000+ on Envato Market
  • Located in New Zealand
+6 more
PixelStores
says
Constantin, you screwed the whole comments display (i.e. your name, text, report, etc.) with your bold message :D

Bug!!! Arrhhhhggghhh!!!

382 posts
  • Had an item that became a weekly top seller
  • Elite Author: Sold more than $75,000 on Envato Market
  • Has sold $125,000+ on Envato Market
  • Located in New Zealand
+6 more
PixelStores
says

There has been alot of talk about the Envato gear, so maybe a marketplace for custom t-shirts, hats, mugs e.t.c.

That would be cool! :sunglasses:

382 posts
  • Had an item that became a weekly top seller
  • Elite Author: Sold more than $75,000 on Envato Market
  • Has sold $125,000+ on Envato Market
  • Located in New Zealand
+6 more
PixelStores
says

What is wordpress?

by
by
by
by
by
by