0
votes
0answers
8 views
WebMatrix Multi-select
Hello it is my first question here, so hope that i do it allright : )
I'm making a wirtual art gallery in WebMatrix. For now i spend 4 hours about thinking how to make, multi select as i called. I ...
0
votes
1answer
30 views
User Log in page
I have posted similar code here recently but still couldn't get it working properly.
I have attempted to rewrite the script but it's still not working - all i am getting is a grey box in the top right ...
0
votes
2answers
38 views
Find if incoming data exists in sql table
I have a form where the user is supposed to input data (name, streetname, streetnumber) and then i want to check if that data exists in the table (name, streetname+streetnumber) so i can use that row ...
0
votes
2answers
34 views
Populating selection based on previous data
I have some PHP/SQL written to populate a selection list with data from a database with the option being populated based on a prior entry in a text box. At the moment i gave it a go but i really don't ...
2
votes
1answer
25 views
Filter records by date based on date ranges assigned in a table
I am setting up a scheduled cron job that launches a PHP script every other Monday.
My goal is to run a SQL query that returns work orders based on my company's pay period - each pay period ends on ...
0
votes
3answers
46 views
Parse error: syntax error, unexpected ''<td>'' (T_CONSTANT_ENCAPSED_STRING), expecting ',' or ';' in [closed]
I keep getting the error with the echo statement. Is it the quotes that are wrong? Should i add quotes around the $row statement
<?php
while($row = mysql_fetch_array($search))
{
...
-3
votes
2answers
32 views
Retrieve value database
Is it possible to retrieve a value from a database and use it as a value in the current form? For example i have a form with a field "family" which is a text box and is it possible to populate that ...
0
votes
3answers
52 views
Why is my code giving me an SQL error
My following SQL code is showing up an error. The error message that appears in phpMyAdmin is
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server ...
0
votes
1answer
41 views
SQL/PHP displaying data from table
I am trying to display two sets of data from a table. First set of data showing only the data where the field "choice1_offer" has the value "N" and the second set being the exact opposite in ...
0
votes
1answer
35 views
Data won't echo on Highcharts
I can't get my data to plot on the highchart but it shows up on the source, what am I doing wrong? I don't know if I am using the wrong syntax to echo my string from the hcdata.php. I have been having ...
-5
votes
1answer
57 views
Use of right syntax when crosschecking MySQL database [closed]
I have a PHP-script that is suppossed to check the MySQL database, here is the code:
$r_sql2 = "SELECT * FROM beta WHERE key='$r_beta'";
$r_query2 = mysql_query($r_sql2) or die(mysql_error());
...
-3
votes
4answers
55 views
Error in MySQL Statement? [closed]
I am trying to locate an error in a MySQL insert statement but cannot trace where this error exists. Are there any tools out there which would make this process easier?
My statement looks like:
...
0
votes
0answers
28 views
Radius aware tag search with Joins
I'm trying to write a tag based search which orders results by distance from a center lat long and also limits to within a radius. I dont know how to write the SQL that will join the necessary tables ...
0
votes
1answer
19 views
Magento: Can't save selected value of attribute (Country of Manufacture Attribute used in another attribute)
I created dropdown, and changed source_model column in SQL
catalog/product_attribute_source_countryofmanufacture
My new attribute shows country list in backend, but when I select country and save ...
0
votes
3answers
55 views
Inserting array element using foreach
Hi i am working on a simple script where i would like to output the result of a given SQL query into JSON.
This is what i have so far:
$player = $this->game->getPlayer(5);
$leaderboard= ...
