Tagged Questions
0
votes
0answers
19 views
How do I display search results from URL query strings?
I am completely stumped on this one. It might be so simple that I am not seeing it.
I have a website that I am working on where I need to search external websites (only one for now) for files based ...
0
votes
2answers
20 views
MSSQL query not working after adding PHP variable to the LIMIT
This is a query that I have used successfully in a MySQL environment before. When I try it using MSSQL. It errors out on this statement:
$result = mssql_query("SELECT * FROM DriverAppInfo ORDER BY ...
1
vote
1answer
22 views
Replacing a plaintext user table with a view
We inherit things, some worse than others.
Recently inherited a user table that has plaintext passwords. Normally this isn't that big a deal but the table is connected to by many webapps -- Some of ...
1
vote
2answers
52 views
PHP and mySQL Dynamic Query
Im trying to create a dynamic query based upon any or all selections from option values selected by a user. Eg if they select a Project ID a query will return with the project ID, size and a lesson ...
-1
votes
1answer
21 views
Querying a second XML page with strings
Would anyone be willing to help me figure out how I can retrieve the franchise name from the second XML page using the franchise id?
I am working with two different pages. The first page will get me ...
0
votes
4answers
53 views
How to select rows where the ID exists in one table, but not another?
I have 2 tables:
1) An Order table (which has OrderNumber as the Id)
2) An Items table which can have multiple rows and also has an OrderNumber column tying each row to the ord er row above.
Most ...
-1
votes
3answers
29 views
PHP PDO sql query and results
I'm having issues implementing an SQL query using PDO.
$friend_emails = $pdo->prepare("SELECT DISTINCT User2
FROM members
WHERE User1 = '$user'
...
-1
votes
2answers
33 views
Show the result from query database php
i have a code like this:
$genre = 'jazz';
$what_genre = mysql_real_escape_string($genre);
$query = mysql_query("SELECT song.id, song.title, genre.genre FROM song INNER JOIN genre ON ...
-1
votes
3answers
67 views
Show the data with mysql_query php [closed]
I have 2 tables on database, table 'songs', and 'genre'.
Table 'songs' has 3 columns: id_song (PK), song_title, lyric, id_genre
Table 'genre' has 2 columns: id_genre (PK), genre
in table 'genre', ...
0
votes
3answers
46 views
Complex MySQL join with dynamic where
Here are my two tables that I'm trying to join...
name: notifications
-------------------------------------------
content | position | member | contentType
...
2
votes
1answer
42 views
Combining Three Tables Output using another to cross-reference
Background
Being the mySQL n00b I am, the best query I can come up with to match three tables, is run a comparison between two tables, output a variable, and then use that variable to select my ...
0
votes
1answer
33 views
error on every sql query with mysqli
I created a new empty php file with simple function for mysqli query, like this:
$dab = new mysqli($dbHost,$dbUser,$dbPassword,$dbDBName);
function dbq($sql) {
global $dab;
$wynik= ...
-1
votes
1answer
32 views
need assistance creating sql query with two IN statements
I need a query that has two IN() statements inside it.
Of course the following is totally wrong, but it's sort of what I'm looking for:
<?php
$query = mysql_query("SELECT 1.field1, 1.field3, ...
0
votes
1answer
53 views
mysql query selecting wrong field
$something_else = mysql_query('SELECT image_id FROM items p LEFT JOIN list up ON p.item_id = up.item_id WHERE up.UserID = "' . $user_id . '"');
while ($r=mysql_fetch_assoc($something_else)){
...
1
vote
4answers
46 views
Including *any* query string in my site URL causes a 404 [closed]
First I apologize if this has already been asked; I used the SO search & advanced search and even an hours' worth of GoogleFu, all to no avail.
The issue I'm having is that any time I try and use ...
