1. Home
2. mysql - Correct way of putting an SQL SELECT statement into a PHP variabe with another PHP variable as the WHERE

44 votes

1 answers

mysql - Correct way of putting an SQL SELECT statement into a PHP variabe with another PHP variable as the WHERE

Get the solution ↓↓↓

I'm trying to add in a PHP variable into a select statement. The SQL is:

SELECT Nichename 
from niche 
INNER JOIN broker on broker.Niche_NicheID = niche.NicheID 
WHERE BrokerID= (another variable) 
Copy code

It works in PHPMyAdmin as a select when I enter theBrokerID, the correctNichename shows up. It's a PHP page inside a Wordpress site so I used this code:

$nichename = $wpdb->get_results('
    SELECT Nichename 
    from niche 
    INNER JOIN broker on broker.Niche_NicheID = niche.NicheID 
    WHERE BrokerID
  ')==$broker_id;
Copy code

There is no output when I put this:

<?php echo  $nichename ?> 
Copy code

It would like theNichename (e.g. "Travel Insurance") but I get nothing.

I've verified if I do an<?php echo $broker_id ?> I get the correctBrokerID so I don't know what I am doing wrong.

Undefined asked

2021-09-2

Write your answer

---

351

votes

Answer

Solution:

I fixed it thanks to @waterloomatt for pointing me in the right direction, it was a Wordpress specific format I was looking for.

global $wpdb;
$nichename = $wpdb->get_var('
    SELECT Nichename 
    from niche 
    INNER JOIN broker on broker.Niche_NicheID = niche.NicheID 
    WHERE BrokerID = ' . $broker_id
);
Copy code

Write your answer

---

Share solution ↓

Additional Information:

Date the issue was resolved:

2021-09-2

Link To Source
Link To Answer People are also looking for solutions of the problem: a non well formed numeric value encountered

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

---

Similar questions

Find the answer in similar questions on our website.

678 php - Check if a variable has been set with the name of the value of another variable

548 jquery - execute php/javascript function after a certain amount of time has passed

860 PHP + SQL - Using SQL Server 'Create To' scripts to create tables through PHP

895 php - Use mysql_fetch_array() with foreach() instead of while()

590 php,mysql,html - Display SQL query(conjunction) properly in HTML

923 php - Cakephp 2.8.4 ignoring hasMany

1 php - More efficient way to grab MySQL row populated with single value

668 php - Database Error mysqli_init()

597 linux - Safest way to write into /etc from php application?

52 apache - PHP - how to do GET request when username password is asked in a popup?

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

About the technologies asked in this question

PHP

PHP (from the English Hypertext Preprocessor - hypertext preprocessor) is a scripting programming language for developing web applications. Supported by most hosting providers, it is one of the most popular tools for creating dynamic websites. The PHP scripting language has gained wide popularity due to its processing speed, simplicity, cross-platform, functionality and distribution of source codes under its own license.
https://www.php.net/

MySQL

DBMS is a database management system. It is designed to change, search, add and delete information in the database. There are many DBMSs designed for similar purposes with different features. One of the most popular is MySQL. It is a software tool designed to work with relational SQL databases. It is easy to learn even for site owners who are not professional programmers or administrators. MySQL DBMS also allows you to export and import data, which is convenient when moving large amounts of information.
https://www.mysql.com/