Re: Reading values from mysql

[Steve Spence]

OK, I'll try to clarify my request.

Here is the query I want to run (formatted for php, as that's what I'm familiar with):


$result = mysqli_query($con,"SELECT * FROM jobque ORDER BY jobID ASC LIMIT 1 ");

it will return:

$jobID = $row['jobID'];
$deviceID = $row['deviceID'];
$pinNum = $row['pinNum'];
$pinValue = $row['pinValue'];

If the deviceID doesn't match this unit, I want to ignore, so maybe I should add a where clause so it only pulls a job for this device. I want to set the physical pins equal to pinNum (say D3) to the pinValue (0 for off, 1 for on, or maybe a pwm value.)

I built a pseudo arduino in php that does all this (and more and it work perfectly. just need to migrate functionality to the arduino. Please help.