[Hello all, new to this need some guidance]

What you could do instead of adding a new column or a new table is have a column called "account type" or "account" for short. Make the data for each user either a 1 or a 2. If a user is a 1 they are a regular user, if a user is a 2 they are a premium user. That way you can just update their information when they become premium.

[INSERT SELECT WHERE]

I had to do an UPDATE not an insert. I ended up with UPDATE and INNER JOIN.

 

Thanks anyway,

[INSERT SELECT WHERE]

what about the where statement??

[INSERT SELECT WHERE]

Hey Guys,

 

I am having a hard time figuring out this mysql query. So I have two tables like this.

schools
----------------------------
school | town | county | full



years
----------------------------
dis | location

I need to insert `full` into `locations` where `school` equals `district`.

 

Make sense? Hints would be preferred rather than answers.  

[WordPress only for content]

Well I mean a good backend interface is what I am looking for. Any other suggestions for a better backend interface? Usability, simplicity and mobility are a plus!

[Hmm seemed to work for other pages....]

$query = "SELECT * FROM `comic_db`.`comic_db` WHERE `comic_name`='$data'";

 

Take out the first comic_db and the period.

[Code Inside Code Doesn't Work]

Of course you can.

What would you suggest then?

[WordPress only for content]

Sure, you could write code to query a WordPress DB and pull out the info you want. You just have to figure out what information you need and from which tables you get it.

That is what I thought. Would I have to use the WordPress php code or can I just use my own queries?

 

Is this a best practice? If not what is?

[WordPress only for content]

I think that I am having a hard time understanding the folder structure of a WordPress template. For example, I have your website home page that I would like to look different then my posts or inside pages. The content is different as well as the look and style.

 

Maybe I am researching for the wrong word or phrase? Like a multi-layout theme.

 

Sorry if I am conveying this poorly. I am doing multiple things at once right now.

[WordPress only for content]

In the past I have messed around with WordPress templates and their CSS modifications. I started to dabble in template creation and I was wondering if I could use WordPress strictly for content creation and management? Instead of creating a template with header.php and sidebar.php and all that crap, can I just query the WordPress database? Mainly, I just don't want to have to upload a template.

 

Any articles on this if possible? I Googled around in my spare time, but no in depth research.

 

Thanks

[How to get rid of white space]

What are all of these h4s and the one h1 wrapped in? It looks like they have an element around them. That needs to be relative or have no margin.

[How to get rid of white space]

To find a solution we would have to see the CSS. Immediately, just by looking at the thumbnail it obviously seems to be a margin or padding problem. You can also set the div that all of these headers are in to position: relative. That could help.

[Code Inside Code Doesn't Work]

 

There are a few alternatives mentioned in the comments section of XSS article (http://seancoates.com/blogs/xss-woes). My preferred method is to hard code the page name. So, if you're page is called "myform.php", the <form> tag might look like the following:

<form class="form_id"  class="appnitro" action="myform.php" method="post">

 

I always just name the file like this. Can't manipulate that.

[Code Inside Code Doesn't Work]

You need to clean up your code. First off, when you echo everything inside the echo is in double quotes and all of the quotes inside of the double quote are single quotes. Does that make sense? So like this.

echo "<div class='content-cotainer1'>"

Second you need to close your quote in your else statement. You have echo ' but you never close it. I think you want to close it here. 

<div class="updateerrorcell">

Then you open another PHP statement here.

<?php if($success["success"]) print "<div class="valid">" . $success["success"] . "</div>"; ?> 

get rid of the <?php in front of the if. There is not need for it.

 

If you can't get it to work, let me know and I will help you.

[PHP coding help .. ? query and if statements playing up]

You added a second mysql_query in there. Do this...

 $sqlinsert = "INSERT INTO reviews (`SHOWTITLE`, `SHOWREVIEW`) VALUES('$showtitle', '$showreview')";

$query = mysql_query($sqlinsert);
    
    if (!query) {
        echo "error inserting new record" . mysql_error(); 
    }

[PHP coding help .. ? query and if statements playing up]

Well while I look at it again, did you close this if statement like I told you to before??

if (!mysql_query($sqlinsert)) {
        die('error inserting new record'); 

}

You need that closing bracket on this one

[PHP coding help .. ? query and if statements playing up]

Are you still getting the index error? The index error means that there is nothing in the query to insert.

[PHP coding help .. ? query and if statements playing up]

You are missing the point. It doesnt have to do with the code right now. The form that you are submitting the information from either doesn't have any information in it or it is the wrong form. Put information in the form and hit submit.

[PHP coding help .. ? query and if statements playing up]

Ooo lol! It means that those two values don't have anything in them, so it can't insert anything. Put something in the input.

[PHP coding help .. ? query and if statements playing up]

Are you column names SHOWTITLE and SHOWREVIEW?? In the database.

[PHP coding help .. ? query and if statements playing up]

Ok, I can help explain this to you. So you have a query variable $sqlinsert, which is good. You if not statement is wrong though. It should something like this. 

 $sqlinsert = "INSERT INTO reviews (`SHOWTITLE`, `SHOWREVIEW`) VALUES('$showtitle', '$showreview')";

$query = mysql_query($sqlinsert);
    
    if (!query) {
        echo "error inserting new record" . mysql_error(); 
    }

I also added some backticks `` to your query for your column names. If there are any errors in your query now it will tell you.

[PHP coding help .. ? query and if statements playing up]

mysql_error() not mysql_error. Add the parentheses 

[PHP coding help .. ? query and if statements playing up]

You actually have to query the database...

$query = mysql_query($sqlinsert, $dbConn);

if (!$query) {
        die('error inserting new record'); 

}

ALSO, close your if bracket. You close your if isset, but not your if not query.

[PHP coding help .. ? query and if statements playing up]

The mysql_query() function goes mysql_query($string, $connection). It seems you have it backwards.

[Form to add multiple records to MySql]

You need to name a column in your query...

mysql_query("INSERT INTO appointments(column1, column2) VALUES ('', '$adate')");

I am not sure why you have an empty value that you are inserting into your database. I would drop that and column2 if they are unnecessary. Reference is below.

http://stackoverflow.com/questions/15011108/php-foreach-loop-inserting-into-database