PHP Variables in SQL Statement not working

Question

I'm trying to create a SQL query with a PHP variable, which is a username. For some reason, nothing happens when it is executed. Any help would be much appreciated!

mysqli_query($dbcon, "ALTER TABLE ipList");
mysqli_query($dbcon, "ADD ".$userName." VARCHAR(30)");

Thanks!

~Carpetfizz

it should be in a single line, ALTER TABLE ipList ADD ".$userName." VARCHAR(30) — John Woo
– John Woo, Commented Sep 27, 2013 at 20:22

Amal · Accepted Answer · 2013-09-27 20:55:28Z

7

That's one command. Put it all in one call to query:

mysqli_query( $dbcon, "ALTER TABLE ipList ADD ".$userName." VARCHAR(30)" );

edited Sep 27, 2013 at 20:55

Amal

76.8k18 gold badges133 silver badges154 bronze badges

answered Sep 27, 2013 at 20:23

Galen

30.2k9 gold badges75 silver badges90 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Carpetfizz Over a year ago

Thank you very much! I will accept your answer as soon as it lets me.

Amal Over a year ago

I've updated the answer and changed it to mysqli but feel free to change it as your liking :)

Mike Grigorieff · Accepted Answer · 2013-09-27 20:38:51Z

1

Your query should look like:

mysqli_query($dbcon, "ALTER TABLE ipList ADD ".$userName." VARCHAR(30)");

But, it seems to me that your database structure is not entirely true.

Do you want each user to create a separate column?

answered Sep 27, 2013 at 20:38

Mike Grigorieff

661 silver badge5 bronze badges

1 Comment

Carpetfizz Over a year ago

Yeah, I'm essentially trying to accomplish what a graph db does in a relational database.

Collectives™ on Stack Overflow

PHP Variables in SQL Statement not working

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related